DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on EAM_WORKFLOW_EVENT_S

Line 139: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

135:
136:
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();

Line 190: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

186: 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' )
187: ))
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();

Line 253: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

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

Line 11302: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

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

Line 12037: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

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

Line 12641: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL

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