DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on CST_QUANTITY_LAYERS

Line 652: for using in insert to cst_quantity_layers

648: begin
649:
650: /*--------------------------------------------+
651: This is a function to get cost_group_id
652: for using in insert to cst_quantity_layers
653: +---------------------------------------------*/
654:
655: select nvl(costing_group_id,1)
656: into l_cst_grp

Line 6227: from cst_quantity_layers

6223: and msi.organization_id = mp1.organization_id
6224: and MP1.Primary_cost_method = 2 -- Create only in Avg costing org
6225: and NOT EXISTS
6226: (select NULL
6227: from cst_quantity_layers
6228: where inventory_item_id = pConfigId
6229: and organization_id = mp1.organization_id);
6230: */
6231: from mtl_parameters mp1,

Line 6246: from cst_quantity_layers

6242: (mp1.organization_id = mp2.master_organization_id))
6243: and MP1.Primary_cost_method = 2 -- Create only in Avg costing org
6244: and NOT EXISTS
6245: (select NULL
6246: from cst_quantity_layers
6247: where inventory_item_id = pConfigId
6248: and organization_id = mp1.organization_id);
6249:
6250:

Line 7434: -- This costing API will insert a row into cst_quantity_layers

7430: FOR v_layer in c_layer
7431: LOOP
7432:
7433: --
7434: -- This costing API will insert a row into cst_quantity_layers
7435: -- for a unique layer_id and the given parameters.
7436: -- It will return 0 if failed, layer_id if succeeded
7437: --
7438: l_layer_id := cstpaclm.create_layer (

Line 7469: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_quantity_layers ',2);

7465: END LOOP;
7466: END IF; /* End bugfix 1573941 */
7467:
7468: IF PG_DEBUG <> 0 THEN
7469: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_quantity_layers ',2);
7470: END IF;
7471:
7472:
7473: /*--------------------------------------------------------+