DBA Data[Home] [Help]

APPS.EAM_COMPLETION dependencies on EAM_JOB_COMPLETION_TXNS_S

Line 1007: -- get transaction_id from sequence eam_job_completion_txns_s

1003:
1004: l_statement := 25;
1005: x_statement := l_statement;
1006:
1007: -- get transaction_id from sequence eam_job_completion_txns_s
1008: select eam_job_completion_txns_s.nextval into i_transaction_id from dual;
1009:
1010: if(x_request_id is not null and x_application_id is not null and
1011: x_program_id is not null) then

Line 1008: select eam_job_completion_txns_s.nextval into i_transaction_id from dual;

1004: l_statement := 25;
1005: x_statement := l_statement;
1006:
1007: -- get transaction_id from sequence eam_job_completion_txns_s
1008: select eam_job_completion_txns_s.nextval into i_transaction_id from dual;
1009:
1010: if(x_request_id is not null and x_application_id is not null and
1011: x_program_id is not null) then
1012: i_program_update_date := sysdate;