Expense Report: Master Detail(1)

작업 절차

• Expense Report 생성 (#41, #42, #43)
• SEQUENCE 생성: EXPENSE_REPORT_SEQ
• Process 등록: set pk with seq
• FORM Page Item 수정
• 리포트 생성

Expense Report 생성

• Start Page Number: 41
• Type: Master Detail - Side by Side

SEQUENCE 생성

• APEX Workspace SQL Workshop Object Browser
• Sequence 이름: EXPENSE_REPORT_SEQ

Process 등록: set pk with seq

declare 
V_REPORT_ID number(9);
begin
select EXPENSE_REPORT_SEQ.nextval into V_REPORT_ID from dual;
:P42_EXPENSE_REPORT_ID := V_REPORT_ID;
end;

• Server Sdie Condition 설정

Form Page Item 수정