[Home] [Help]
52:
53: /*----------------------------------------------------------+
54: | Process CFM |
55: | |
56: | Create a new row in WIP_PERIOD_BALANCES |
57: | if the row does not exist for a certain acct_period_id, |
58: | wip_entity_id, org_id. |
59: | Also, create new rows in WIP_PERIOD_BALANCES |
60: | for other accounting periods that has not been created |
55: | |
56: | Create a new row in WIP_PERIOD_BALANCES |
57: | if the row does not exist for a certain acct_period_id, |
58: | wip_entity_id, org_id. |
59: | Also, create new rows in WIP_PERIOD_BALANCES |
60: | for other accounting periods that has not been created |
61: | yet for a certain wip_entity_id and org_id. |
62: +-----------------------------------------------------------*/
63: where_num := 100;
63: where_num := 100;
64:
65: debug(where_num);
66:
67: INSERT INTO wip_period_balances
68: (acct_period_id, wip_entity_id,
69: repetitive_schedule_id, last_update_date,
70: last_updated_by, creation_date,
71: created_by, last_update_login,
99: AND oap.acct_period_id >= i_acct_period_id
100: AND oap.organization_id = i_org_id
101: AND oap.acct_period_id >
102: (SELECT nvl(max(acct_period_id),0)
103: FROM wip_period_balances
104: WHERE organization_id = i_org_id
105: AND wip_entity_id = i_wip_entity_id)
106: AND NOT EXISTS
107: (SELECT 'x' FROM wip_period_balances
103: FROM wip_period_balances
104: WHERE organization_id = i_org_id
105: AND wip_entity_id = i_wip_entity_id)
106: AND NOT EXISTS
107: (SELECT 'x' FROM wip_period_balances
108: WHERE organization_id = i_org_id
109: AND acct_period_id = i_acct_period_id
110: AND wip_entity_id = i_wip_entity_id);
111:
211: i_prog_id,
212: SYSDATE
213: FROM
214: cst_cost_elements cce,
215: wip_period_balances wpb
216: WHERE
217: wpb.wip_entity_id = i_wip_entity_id AND
218: wpb.organization_id = i_org_id AND
219: cce.cost_element_id <> 2
274: i_prog_id,
275: SYSDATE
276: FROM
277: cst_cost_elements cce,
278: wip_period_balances wpb
279: WHERE
280: wpb.wip_entity_id = i_wip_entity_id AND
281: wpb.organization_id = i_org_id
282: GROUP BY
434: i_prog_id,
435: SYSDATE
436: FROM
437: cst_cost_elements cce,
438: wip_period_balances wpb
439: WHERE
440: wpb.wip_entity_id = i_wip_entity_id AND
441: wpb.organization_id = i_org_id AND
442: cce.cost_element_id <> 2
497: i_prog_id,
498: SYSDATE
499: FROM
500: cst_cost_elements cce,
501: wip_period_balances wpb
502: WHERE
503: wpb.wip_entity_id = i_wip_entity_id AND
504: wpb.organization_id = i_org_id
505: GROUP BY
599: select count(*)
600: into
601: l_rowcount
602: from
603: wip_period_balances
604: where
605: wip_entity_id = i_wip_entity_id and
606: acct_period_id = i_acct_period_id;
607:
687: cce.cost_element_id,
688: NULL, NULL, NULL, NULL, NULL,
689: i_request_id,i_prog_appl_id,i_prog_id,SYSDATE
690: FROM
691: wip_period_balances wpb,
692: wip_flow_schedules wdj,
693: cst_cost_elements cce
694: WHERE
695: wpb.wip_entity_id = wdj.wip_entity_id and
763: cce.cost_element_id,
764: NULL, NULL, NULL, NULL, NULL,
765: i_request_id,i_prog_appl_id,i_prog_id,SYSDATE
766: FROM
767: wip_period_balances wpb,
768: wip_flow_schedules wfs,
769: cst_cost_elements cce
770: WHERE
771: wpb.wip_entity_id = wfs.wip_entity_id and
780: -- Update WPB
781:
782: stmt_num := 40;
783: /*Substraction By current Variance is removed for the Bug#1784535*/
784: UPDATE WIP_PERIOD_BALANCES wpb
785: SET (LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
786: PL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR,
787: PL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_VAR,
788: PL_OVERHEAD_VAR, TL_MATERIAL_VAR,
808: NVL(TL_OUTSIDE_PROCESSING_IN,0)
809: - NVL(TL_OUTSIDE_PROCESSING_OUT,0),
810: NVL(TL_OVERHEAD_IN,0)
811: - NVL(TL_OVERHEAD_OUT,0)
812: FROM WIP_PERIOD_BALANCES wpb2
813: WHERE wpb2.wip_entity_id = wpb.wip_entity_id
814: AND wpb2.acct_period_id = wpb.acct_period_id)
815: WHERE
816: wpb.wip_entity_id = i_wip_entity_id AND