DBA Data[Home] [Help]

APPS.EAM_COMPLETION dependencies on EAM_JOB_COMPLETION_TXNS_S

Line 1005: -- get transaction_id from sequence eam_job_completion_txns_s

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

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

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