APPS.CTO_UTILITY_PK dependencies on CST_ITEM_COSTS

Line 5016: delete from cst_item_costs

5012:
5013: lStmtNumber := 20 ;
5014:
5015:
5016: delete from cst_item_costs
5017: where inventory_item_id = p_config_item_id
5018: and organization_id = p_organization_id
5019: and cost_type_id = p_dest_cost_type_id ;
5020:

Line 5025: Insert a row into the cst_item_costs_table

5021:
5022:
5023:
5024: /*-------------------------------------------------------+
5025: Insert a row into the cst_item_costs_table
5026: +------------------------------------------------------- */
5027:
5028: lStmtNumber := 220;
5029:

Line 5030: insert into CST_ITEM_COSTS

5026: +------------------------------------------------------- */
5027:
5028: lStmtNumber := 220;
5029:
5030: insert into CST_ITEM_COSTS
5031: (inventory_item_id,
5032: organization_id,
5033: cost_type_id,
5034: last_update_date,

Line 5134: cst_item_costs C

5130: C.attribute13,
5131: C.attribute14,
5132: C.attribute15
5133: from
5134: cst_item_costs C
5135: where C.inventory_item_id = p_config_item_id
5136: and C.organization_id = p_organization_id
5137: and C.cost_type_id = p_src_cost_type_id;
5138:

Line 5140: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS',2);

5136: and C.organization_id = p_organization_id
5137: and C.cost_type_id = p_src_cost_type_id;
5138:
5139: IF PG_DEBUG <> 0 THEN
5140: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS',2);
5141:
5142: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
5143: END IF;
5144:

Line 5142: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);

5138:
5139: IF PG_DEBUG <> 0 THEN
5140: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS',2);
5141:
5142: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
5143: END IF;
5144:
5145: /*------ ----------------------------------------------+
5146: Insert rows into the cst_item_cost_details table