APPS.CST_PACEAMCOST_GRP dependencies on CST_PAC_EAM_WO_EST_STATUSES

Line 12: -- |-- Insert into CST_PAC_EAM_WO_EST_STATUSES all WIP entities not yet

8: -- API name : Estimate_PAC_WipJobs
9: -- Type : Public.
10: -- Function : This API is called from SRS to estimate eAM WorkOrders in PAC
11: -- Flow:
12: -- |-- Insert into CST_PAC_EAM_WO_EST_STATUSES all WIP entities not yet
13: -- | estimated for the given cost type.
14: -- |-- For the job/Jobs to be estimated for the given cost type.
15: -- | |-- Update est flag to a -ve no for the jobs to be processed.
16: -- | |-- Call Delete_PAC_EamPerBal to delete prior estimation columns

Line 236: INSERT INTO CST_PAC_EAM_WO_EST_STATUSES es

232:
233: l_stmt_num := 25;
234:
235:
236: INSERT INTO CST_PAC_EAM_WO_EST_STATUSES es
237: ( legal_entity_id,
238: cost_group_id,
239: wip_entity_id,
240: organization_id,

Line 271: FROM CST_PAC_EAM_WO_EST_STATUSES es1

267: AND wdj.organization_id = ccga.organization_id
268: AND ccga.cost_group_id = p_cost_group_id
269: AND we.entity_type = 6
270: AND NOT EXISTS ( SELECT 'Not existing jobs'
271: FROM CST_PAC_EAM_WO_EST_STATUSES es1
272: WHERE es1.wip_entity_id = wdj.wip_entity_id
273: AND es1.legal_entity_id = p_legal_entity_id
274: AND es1.cost_type_id = p_cost_type_id
275: AND es1.cost_group_id = p_cost_group_id

Line 288: UPDATE CST_PAC_EAM_WO_EST_STATUSES es

284: );
285:
286: l_stmt_num := 30;
287:
288: UPDATE CST_PAC_EAM_WO_EST_STATUSES es
289: SET es.estimation_status = l_estimation_group_id,
290: es.last_update_date = SYSDATE,
291: es.last_updated_by = l_user_id,
292: es.last_estimation_req_id = l_request_id

Line 322: INSERT INTO CST_PAC_EAM_WO_EST_STATUSES es

318: ELSIF p_job_option=2 then
319:
320: l_stmt_num := 40;
321:
322: INSERT INTO CST_PAC_EAM_WO_EST_STATUSES es
323: ( legal_entity_id,
324: cost_group_id,
325: wip_entity_id,
326: organization_id,

Line 353: FROM CST_PAC_EAM_WO_EST_STATUSES es1

349: WHERE wdj.wip_entity_id = we.wip_entity_id
350: AND we.entity_type = 6
351: AND NOT EXISTS
352: ( SELECT 'Not existing jobs'
353: FROM CST_PAC_EAM_WO_EST_STATUSES es1
354: WHERE es1.wip_entity_id = p_wip_entity_id
355: AND es1.legal_entity_id = p_legal_entity_id
356: AND es1.cost_type_id = p_cost_type_id
357: AND es1.cost_group_id = p_cost_group_id

Line 365: UPDATE CST_PAC_EAM_WO_EST_STATUSES es

361: AND wdj.wip_entity_id = p_wip_entity_id );
362:
363: l_stmt_num := 45;
364:
365: UPDATE CST_PAC_EAM_WO_EST_STATUSES es
366: SET es.estimation_status = l_estimation_group_id,
367: es.last_update_date = SYSDATE,
368: es.last_updated_by = l_user_id,
369: es.last_estimation_req_id = l_request_id

Line 580: UPDATE CST_PAC_EAM_WO_EST_STATUSES

576: RAISE PROCESS_ERROR;
577: END IF;
578:
579: -- set the status of successfully estimated job to to 7(complete)
580: UPDATE CST_PAC_EAM_WO_EST_STATUSES
581: SET estimation_status = 7,
582: last_estimation_date = SYSDATE,
583: last_estimation_req_id = l_request_id,
584: last_update_date = SYSDATE

Line 609: UPDATE CST_PAC_EAM_WO_EST_STATUSES

605:
606: ROLLBACK TO Estimate_PAC_WipJobs_PUB;
607:
608: -- set the status of job for which estimation failed to 3(error)
609: UPDATE CST_PAC_EAM_WO_EST_STATUSES
610: SET estimation_status = 3,
611: last_update_date = SYSDATE,
612: last_estimation_date = SYSDATE,
613: last_estimation_req_id = l_request_id

Line 680: UPDATE CST_PAC_EAM_WO_EST_STATUSES

676: ROLLBACK TO Estimate_PAC_WipJobs_PUB;
677:
678: -- Change status of unprocessed jobs to 1 (Pending) so that they can be processed next time.
679: FORALL l_index IN l_wip_entity_id_tab.FIRST..l_wip_entity_id_tab.LAST
680: UPDATE CST_PAC_EAM_WO_EST_STATUSES
681: SET estimation_status = 1,
682: last_update_date = SYSDATE,
683: last_estimation_date = SYSDATE,
684: last_estimation_req_id = l_request_id