[Home] [Help]
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
260: l_user_id,
261: l_request_id,
262: SYSDATE
263: FROM wip_discrete_jobs wdj,
264: wip_entities we,
265: cst_cost_group_assignments ccga
266: WHERE wdj.wip_entity_id = we.wip_entity_id
267: AND wdj.organization_id = ccga.organization_id
268: AND ccga.cost_group_id = p_cost_group_id
277: AND wdj.status_type IN (1,3,4,6,17)
278: AND p_job_option = 1
279: AND p_entity_type = 6
280: AND EXISTS ( SELECT 'X'
281: FROM wip_entities we
282: WHERE we.wip_entity_id = wdj.wip_entity_id
283: AND we.entity_type = p_entity_type)
284: );
285:
296: AND p_job_option = 1
297: AND p_entity_type = 6
298: AND NVL(es.estimation_status,1) <> 7 -- for all jobs do not re-estimate
299: AND EXISTS ( SELECT 'X'
300: FROM wip_entities we
301: WHERE we.wip_entity_id = es.wip_entity_id
302: AND we.entity_type = p_entity_type
303: )
304: AND NVL(es.estimation_status,1) > 0
344: SYSDATE,
345: l_user_id,
346: l_request_id,
347: SYSDATE
348: FROM wip_discrete_jobs wdj, wip_entities we
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'
1568: SELECT entity_type,
1569: organization_id
1570: INTO l_entity_type,
1571: l_organization_id
1572: FROM wip_entities we
1573: WHERE we.wip_entity_id = p_wip_entity_id;
1574:
1575: l_stmt_num := 205;
1576: