[Home] [Help]
838: IF PG_DEBUG <> 0 THEN
839: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'Inserting records in csc and cec',2);
840: END IF;
841:
842: INSERT INTO cst_standard_costs
843: (cost_update_id,
844: organization_id,
845: inventory_item_id,
846: last_update_date,
847: last_updated_by,
848: creation_date,
849: created_by,
850: last_update_login,
851: standard_cost_revision_date,
852: standard_cost
853: )
854: SELECT
855: l_cost_update,
848: creation_date,
849: created_by,
850: last_update_login,
851: standard_cost_revision_date,
852: standard_cost
853: )
854: SELECT
855: l_cost_update,
856: p_organization_id,
868: AND inventory_item_id = p_config_item_id
869: AND cost_type_id = 1;
870:
871: IF PG_DEBUG <> 0 THEN
872: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_standard_costs ' || sql%rowcount ,2);
873: END IF;
874:
875: lStmtNumber := 260;
876:
883: last_updated_by,
884: creation_date,
885: created_by,
886: last_update_login,
887: standard_cost
888: )
889: SELECT
890: l_cost_update,
891: p_organization_id,
1814: End if;
1815: /*
1816: **
1817: ** Costs need to be copied from simulation cost to frozen cost in case of
1818: ** standard costing organization
1819: **
1820: */
1821:
1822:
1822:
1823:
1824:
1825: lStmtNumber := 80;
1826: /* update Frozen cost with CTO Cost in case of standard costing organizations */
1827:
1828:
1829: for i in p_cfg_itm_tbl.FIRST..p_cfg_itm_tbl.LAST
1830:
2020: /* 3116778 */
2021: /*
2022: BUG 3931290
2023: The original cursor c_frozen_cost_update was using a union (organization_id , rcv_org_id )
2024: to determine organizations where standard cost update needs to be performed.
2025: The organizations where standard cost update will be performed will now be determined using organization_id.
2026: This will eliminate the 2nd sql statement (rcv_org_id) in the union and there will be no need for a union.
2027: A distinct clause has been added to the statement.
2028: */
2021: /*
2022: BUG 3931290
2023: The original cursor c_frozen_cost_update was using a union (organization_id , rcv_org_id )
2024: to determine organizations where standard cost update needs to be performed.
2025: The organizations where standard cost update will be performed will now be determined using organization_id.
2026: This will eliminate the 2nd sql statement (rcv_org_id) in the union and there will be no need for a union.
2027: A distinct clause has been added to the statement.
2028: */
2029: cursor c_frozen_cost_update(c_cto_cost_type_id number )
2376: -- insert into CST_SC_LISTS rows for all config items in all possible
2377: -- src orgs, where ->
2378: -- 1. cost has not been calculated yet (cost_rollup = Y)
2379: -- 2. costing_enabled_flag = Y
2380: -- 3. primary_cost_method = 1 (standard)
2381: --
2382: IF PG_DEBUG <> 0 THEN
2383: oe_debug_pub.add('Cost_Rollup_ML: ' || 'inserting into cst_sc_lists', 2);
2384: END IF;
2737:
2738: /*
2739: **
2740: ** Costs need to be copied from simulation cost to frozen cost in case of
2741: ** standard costing organization
2742: **
2743: */
2744:
2745:
2753: oe_debug_pub.add('***No need to do frozen cost update as no rollup has been done' , 1);
2754: END IF;
2755:
2756: else
2757: /*update Frozen cost with CTO Cost in case of standard costing organizations */
2758: lStmtNumber := 90;
2759:
2760: open c_frozen_cost_update ( v_cto_cost_type_id ) ;
2761: