DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on DUAL

Line 144: FROM DUAL;

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

Line 195: FROM DUAL;

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

Line 258: FROM DUAL;

254:
255:
256: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
257: INTO l_wf_event_seq
258: FROM DUAL;
259:
260: l_parameter_list := wf_parameter_list_t();
261: l_event_name := l_status_pending_event;
262:

Line 11925: FROM DUAL;

11921:
11922:
11923: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
11924: INTO l_wf_event_seq
11925: FROM DUAL;
11926:
11927: l_parameter_list := wf_parameter_list_t();
11928: l_event_name := l_status_pending_event;
11929:

Line 12691: FROM DUAL;

12687: ) THEN
12688:
12689: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
12690: INTO l_wf_event_seq
12691: FROM DUAL;
12692:
12693: l_parameter_list := wf_parameter_list_t();
12694: l_event_name := l_status_changed_event;
12695:

Line 13313: FROM DUAL;

13309: won.prior_operation = l_eam_op_comp_rec.operation_seq_num;
13310:
13311: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
13312: INTO l_wf_event_seq
13313: FROM DUAL;
13314:
13315: l_parameter_list := wf_parameter_list_t();
13316:
13317: l_event_key := TO_CHAR(l_wf_event_seq);