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 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;

Line 1103: FROM dual

1099:
1100: begin
1101: SELECT '1'
1102: INTO network_child_job_var
1103: FROM dual
1104: WHERE EXISTS (SELECT '1'
1105: FROM wip_discrete_jobs
1106: WHERE wip_entity_id IN
1107: (

Line 1138: FROM dual

1134: -- Bug no 3735589
1135: begin
1136: SELECT '1'
1137: INTO sibling_parent_job_var
1138: FROM dual
1139: WHERE EXISTS (SELECT '1'
1140: FROM wip_discrete_jobs
1141: WHERE wip_entity_id IN
1142: (

Line 1209: FROM DUAL;

1205:
1206:
1207: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1208: INTO l_wf_event_seq
1209: FROM DUAL;
1210:
1211: l_parameter_list := wf_parameter_list_t();
1212: l_event_name := l_status_pending_event;
1213:

Line 1342: FROM dual

1338: -- for bug #2414513.
1339: begin
1340: SELECT '1'
1341: INTO child_job_var
1342: FROM dual
1343: WHERE EXISTS (SELECT '1'
1344: FROM wip_discrete_jobs wdj, wip_entities we
1345: WHERE wdj.wip_entity_id = we.wip_entity_id
1346: AND wdj.parent_wip_entity_id = x_wip_entity_id

Line 1744: FROM DUAL;

1740: ) THEN
1741:
1742: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1743: INTO l_wf_event_seq
1744: FROM DUAL;
1745:
1746: l_parameter_list := wf_parameter_list_t();
1747: l_event_name := l_status_changed_event;
1748: