DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on EAM_WORKFLOW_EVENT_S

Line 142: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

138:
139:
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();

Line 193: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

189: AND (p_old_eam_wo_rec.user_defined_status_id <>p_eam_wo_rec.user_defined_status_id OR NVL(p_old_eam_wo_rec.pending_flag,'N')='Y' )
190: ))
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();

Line 256: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

252: l_cost_estimate := 0;
253: END;
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();

Line 11923: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

11919: l_cost_estimate := 0;
11920: END;
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();

Line 12689: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

12685:
12686: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
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();

Line 13311: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

13307: from wip_operation_networks won
13308: where won.wip_entity_id = l_eam_op_comp_rec.wip_entity_id and
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();