APPS.CTO_UTILITY_PK dependencies on CST_ITEM_COSTS

Line 4992: delete from cst_item_costs

4988:
4989: lStmtNumber := 20 ;
4990:
4991:
4992: delete from cst_item_costs
4993: where inventory_item_id = p_config_item_id
4994: and organization_id = p_organization_id
4995: and cost_type_id = p_dest_cost_type_id ;
4996:

Line 5001: Insert a row into the cst_item_costs_table

4997:
4998:
4999:
5000: /*-------------------------------------------------------+
5001: Insert a row into the cst_item_costs_table
5002: +------------------------------------------------------- */
5003:
5004: lStmtNumber := 220;
5005:

Line 5006: insert into CST_ITEM_COSTS

5002: +------------------------------------------------------- */
5003:
5004: lStmtNumber := 220;
5005:
5006: insert into CST_ITEM_COSTS
5007: (inventory_item_id,
5008: organization_id,
5009: cost_type_id,
5010: last_update_date,

Line 5110: cst_item_costs C

5106: C.attribute13,
5107: C.attribute14,
5108: C.attribute15
5109: from
5110: cst_item_costs C
5111: where C.inventory_item_id = p_config_item_id
5112: and C.organization_id = p_organization_id
5113: and C.cost_type_id = p_src_cost_type_id;
5114:

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

5112: and C.organization_id = p_organization_id
5113: and C.cost_type_id = p_src_cost_type_id;
5114:
5115: IF PG_DEBUG <> 0 THEN
5116: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS',2);
5117:
5118: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
5119: END IF;
5120:

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

5114:
5115: IF PG_DEBUG <> 0 THEN
5116: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS',2);
5117:
5118: oe_debug_pub.add('copy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
5119: END IF;
5120:
5121: /*------ ----------------------------------------------+
5122: Insert rows into the cst_item_cost_details table