[Home] [Help]
4431:
4432: /*******************************************************************
4433: ** Update cst_layer_cost_details if i_no_update_qty is not set. **
4434: ** Since CQL quantity before this transaction is still needed by **
4435: ** CSTPAVCP.update_mmt, CQL quantity and cost information will be **
4436: ** updated later. **
4437: ********************************************************************/
4438: -- get the total layer quantity from cil
4439: select sum(cil.layer_quantity)
4610: else
4611: l_txfr_txn_id := -1;
4612: end if;
4613:
4614: CSTPAVCP.update_mmt(
4615: i_org_id,
4616: i_txn_id,
4617: l_txfr_txn_id,
4618: i_layer_id,
4721: l_stmt_num := 50;
4722:
4723: -- Bug 2401323 - propagation bug for bugfix 2306923
4724: -- Bug 2306923: l_mandatory_update should be zero even if project is not enabled
4725: -- This change was made to function calls (CSTPAVCP.update_item_cost) for
4726: -- average costing as part of bug 1756613.
4727: -- In 11i.2, the cost group model has been enhanced, so that
4728: -- multiple cost groups can exist in a non project manufacturing organization,
4729: -- depending on the set of accounts. Hence updating item cost and item cost details
4743: */
4744:
4745: l_mandatory_update := 0;
4746:
4747: CSTPAVCP.update_item_cost(
4748: i_org_id,
4749: i_txn_id,
4750: i_layer_id,
4751: i_cost_type,
4789: ** inventory valuation. **
4790: ** MTL_CST_LAYER_ACT_COST_DETAILS will be populated and the other **
4791: ** cost tables (CILCD, CIL, CLCD, CQL, CICD, CIC) will be updated **
4792: ** accordingly with the new cost information. **
4793: ** This function is duplicated from CSTPAVCP.average_cost_update. **
4794: ** **
4795: ** HISTORY **
4796: ** 12-MAY-2000 Dieu-Thuong Le Creation **
4797: ** **