[Home] [Help]
4409:
4410: /*******************************************************************
4411: ** Update cst_layer_cost_details if i_no_update_qty is not set. **
4412: ** Since CQL quantity before this transaction is still needed by **
4413: ** CSTPAVCP.update_mmt, CQL quantity and cost information will be **
4414: ** updated later. **
4415: ********************************************************************/
4416: -- get the total layer quantity from cil
4417: select sum(cil.layer_quantity)
4506: else
4507: l_txfr_txn_id := -1;
4508: end if;
4509:
4510: CSTPAVCP.update_mmt(
4511: i_org_id,
4512: i_txn_id,
4513: l_txfr_txn_id,
4514: i_layer_id,
4617: l_stmt_num := 50;
4618:
4619: -- Bug 2401323 - propagation bug for bugfix 2306923
4620: -- Bug 2306923: l_mandatory_update should be zero even if project is not enabled
4621: -- This change was made to function calls (CSTPAVCP.update_item_cost) for
4622: -- average costing as part of bug 1756613.
4623: -- In 11i.2, the cost group model has been enhanced, so that
4624: -- multiple cost groups can exist in a non project manufacturing organization,
4625: -- depending on the set of accounts. Hence updating item cost and item cost details
4639: */
4640:
4641: l_mandatory_update := 0;
4642:
4643: CSTPAVCP.update_item_cost(
4644: i_org_id,
4645: i_txn_id,
4646: i_layer_id,
4647: i_cost_type,
4685: ** inventory valuation. **
4686: ** MTL_CST_LAYER_ACT_COST_DETAILS will be populated and the other **
4687: ** cost tables (CILCD, CIL, CLCD, CQL, CICD, CIC) will be updated **
4688: ** accordingly with the new cost information. **
4689: ** This function is duplicated from CSTPAVCP.average_cost_update. **
4690: ** **
4691: ** HISTORY **
4692: ** 12-MAY-2000 Dieu-Thuong Le Creation **
4693: ** **