APPS.EAM_COMPLETION dependencies on DUAL

Line 117: from dual;

113:
114: -- prepare the data to insert into MTL_MATERIAL_TRANSACTIONS_TEMP,
115: -- MTL_SERIAL_NUMBERS_TEMP, and MTL_TRANSACTION_LOTS_TEMP
116: select mtl_material_transactions_s.nextval into i_transaction_header_id
117: from dual;
118:
119: l_statement := 1;
120: x_statement := l_statement;
121:

Line 407: SELECT eam_asset_status_history_s.nextval INTO i_asset_status_id FROM dual;

403:
404: i_asset_status_id NUMBER;
405: BEGIN
406: -- get the asset_status_id from eam_asset_status_history_s sequence
407: SELECT eam_asset_status_history_s.nextval INTO i_asset_status_id FROM dual;
408:
409: -- Enhancement Bug 3852846
410: UPDATE eam_asset_status_history
411: SET enable_flag = 'N'

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;

Line 1106: FROM dual

1102:
1103: begin
1104: SELECT '1'
1105: INTO network_child_job_var
1106: FROM dual
1107: WHERE EXISTS (SELECT '1'
1108: FROM wip_discrete_jobs
1109: WHERE wip_entity_id IN
1110: (

Line 1160: FROM dual

1156: -- Bug no 3735589
1157: begin
1158: SELECT '1'
1159: INTO sibling_parent_job_var
1160: FROM dual
1161: WHERE EXISTS (SELECT '1'
1162: FROM wip_discrete_jobs
1163: WHERE wip_entity_id IN
1164: (

Line 1250: FROM DUAL;

1246:
1247:
1248: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1249: INTO l_wf_event_seq
1250: FROM DUAL;
1251:
1252: l_parameter_list := wf_parameter_list_t();
1253: l_event_name := l_status_pending_event;
1254:

Line 1383: FROM dual

1379: -- for bug #2414513.
1380: begin
1381: SELECT '1'
1382: INTO child_job_var
1383: FROM dual
1384: WHERE EXISTS (SELECT '1'
1385: FROM wip_discrete_jobs wdj, wip_entities we
1386: WHERE wdj.wip_entity_id = we.wip_entity_id
1387: AND wdj.parent_wip_entity_id = x_wip_entity_id

Line 1791: FROM DUAL;

1787: ) THEN
1788:
1789: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1790: INTO l_wf_event_seq
1791: FROM DUAL;
1792:
1793: l_parameter_list := wf_parameter_list_t();
1794: l_event_name := l_status_changed_event;
1795: