DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on DUAL

Line 141: FROM DUAL;

137: --if workorder created and create event enabled
138: IF(p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_CREATE AND (WF_EVENT.TEST(l_create_event) <> 'NONE')) THEN
139: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
140: INTO l_wf_event_seq
141: FROM DUAL;
142:
143: l_parameter_list := wf_parameter_list_t();
144: l_event_name := l_create_event;
145:

Line 192: FROM DUAL;

188: AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
189: ) THEN
190: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
191: INTO l_wf_event_seq
192: FROM DUAL;
193:
194: l_parameter_list := wf_parameter_list_t();
195: l_event_name := l_status_changed_event;
196:

Line 255: FROM DUAL;

251:
252:
253: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
254: INTO l_wf_event_seq
255: FROM DUAL;
256:
257: l_parameter_list := wf_parameter_list_t();
258: l_event_name := l_status_pending_event;
259:

Line 11304: FROM DUAL;

11300:
11301:
11302: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
11303: INTO l_wf_event_seq
11304: FROM DUAL;
11305:
11306: l_parameter_list := wf_parameter_list_t();
11307: l_event_name := l_status_pending_event;
11308:

Line 12039: FROM DUAL;

12035: ) THEN
12036:
12037: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
12038: INTO l_wf_event_seq
12039: FROM DUAL;
12040:
12041: l_parameter_list := wf_parameter_list_t();
12042: l_event_name := l_status_changed_event;
12043:

Line 12643: FROM DUAL;

12639: won.prior_operation = l_eam_op_comp_rec.operation_seq_num;
12640:
12641: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
12642: INTO l_wf_event_seq
12643: FROM DUAL;
12644:
12645: l_parameter_list := wf_parameter_list_t();
12646:
12647: l_event_key := TO_CHAR(l_wf_event_seq);