DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on CST_QUANTITY_LAYERS

Line 577: for using in insert to cst_quantity_layers

573: begin
574:
575: /*--------------------------------------------+
576: This is a function to get cost_group_id
577: for using in insert to cst_quantity_layers
578: +---------------------------------------------*/
579:
580: select nvl(costing_group_id,1)
581: into l_cst_grp

Line 6042: from cst_quantity_layers

6038: and msi.organization_id = mp1.organization_id
6039: and MP1.Primary_cost_method = 2 -- Create only in Avg costing org
6040: and NOT EXISTS
6041: (select NULL
6042: from cst_quantity_layers
6043: where inventory_item_id = pConfigId
6044: and organization_id = mp1.organization_id);
6045: */
6046: from mtl_parameters mp1,

Line 6061: from cst_quantity_layers

6057: (mp1.organization_id = mp2.master_organization_id))
6058: and MP1.Primary_cost_method = 2 -- Create only in Avg costing org
6059: and NOT EXISTS
6060: (select NULL
6061: from cst_quantity_layers
6062: where inventory_item_id = pConfigId
6063: and organization_id = mp1.organization_id);
6064:
6065:

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

7245: FOR v_layer in c_layer
7246: LOOP
7247:
7248: --
7249: -- This costing API will insert a row into cst_quantity_layers
7250: -- for a unique layer_id and the given parameters.
7251: -- It will return 0 if failed, layer_id if succeeded
7252: --
7253: l_layer_id := cstpaclm.create_layer (

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

7280: END LOOP;
7281: END IF; /* End bugfix 1573941 */
7282:
7283: IF PG_DEBUG <> 0 THEN
7284: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_quantity_layers ',2);
7285: END IF;
7286:
7287:
7288: /*--------------------------------------------------------+