[Home] [Help]
231: --------------------------------------------------------------------------------
232: -- Copy data from previous period to current period of the following tables : --
233: -- 1. cst_pac_item_costs --
234: -- 2. cst_pac_item_cost_details --
235: -- 3. cst_pac_quantity_layers --
236: -- New cost_layer_id and quantity_layer_id are generated for every rows --
237: -- inserted. --
238: --------------------------------------------------------------------------------
239: -------------------------------------------
378: AND cpic2.cost_group_id = cpic1.cost_group_id
379: AND cpic2.inventory_item_id = cpic1.inventory_item_id;
380:
381: ------------------------------------------------
382: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --
383: ------------------------------------------------
384: l_stmt_num := 50;
385: INSERT INTO cst_pac_quantity_layers (
386: quantity_layer_id,
381: ------------------------------------------------
382: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --
383: ------------------------------------------------
384: l_stmt_num := 50;
385: INSERT INTO cst_pac_quantity_layers (
386: quantity_layer_id,
387: cost_layer_id,
388: pac_period_id,
389: cost_group_id,
399: program_id,
400: program_update_date,
401: last_update_login)
402: SELECT
403: cst_pac_quantity_layers_s.nextval,
404: cpic.cost_layer_id,
405: i_pac_period_id,
406: cpql.cost_group_id,
407: cpql.inventory_item_id,
415: i_prog_app_id,
416: i_prog_id,
417: SYSDATE,
418: i_login_id
419: FROM cst_pac_quantity_layers cpql,
420: cst_pac_item_costs cpic
421: WHERE cpql.pac_period_id = i_prior_pac_period_id
422: AND cpic.pac_period_id = i_pac_period_id
423: AND cpic.cost_group_id = i_cost_group_id
482: i_prog_id,
483: sysdate
484: FROM cst_pac_item_costs cpic,
485: cst_pac_item_cost_details cpicd,
486: cst_pac_quantity_layers cpql
487: WHERE cpic.cost_group_id = i_cost_group_id
488: AND cpic.pac_period_id = i_pac_period_id
489: AND cpicd.cost_layer_id = cpic.cost_layer_id
490: AND cpql.cost_layer_id = cpic.cost_layer_id