APPS.CTO_UTILITY_PK dependencies on CST_ITEM_COST_DETAILS

Line 4984: delete from cst_item_cost_details

4980:
4981: lStmtNumber := 2;
4982:
4983:
4984: delete from cst_item_cost_details
4985: where inventory_item_id = p_config_item_id
4986: and organization_id = p_organization_id
4987: and cost_type_id = p_dest_cost_type_id ;
4988:

Line 5122: Insert rows into the cst_item_cost_details table

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
5123: +-----------------------------------------------------*/
5124:
5125: lStmtNumber := 230;
5126:

Line 5127: insert into cst_item_cost_details

5123: +-----------------------------------------------------*/
5124:
5125: lStmtNumber := 230;
5126:
5127: insert into cst_item_cost_details
5128: (inventory_item_id,
5129: cost_type_id,
5130: last_update_date,
5131: last_updated_by,

Line 5217: cst_item_cost_details C

5213: C.attribute13,
5214: C.attribute14,
5215: C.attribute15
5216: from
5217: cst_item_cost_details C
5218: where C.inventory_item_id = p_config_item_id
5219: and C.organization_id = p_organization_id
5220: and C.cost_type_id = p_src_cost_type_id ;
5221:

Line 5223: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details',2);

5219: and C.organization_id = p_organization_id
5220: and C.cost_type_id = p_src_cost_type_id ;
5221:
5222: IF PG_DEBUG <> 0 THEN
5223: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details',2);
5224:
5225: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
5226: END IF;
5227:

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

5221:
5222: IF PG_DEBUG <> 0 THEN
5223: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details',2);
5224:
5225: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
5226: END IF;
5227:
5228:
5229: exception