5004:
5005: lStmtNumber := 2;
5006:
5007:
5008: delete from cst_item_cost_details
5009: where inventory_item_id = p_config_item_id
5010: and organization_id = p_organization_id
5011: and cost_type_id = p_dest_cost_type_id ;
5012:
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
5147: +-----------------------------------------------------*/
5148:
5149: lStmtNumber := 230;
5150:
5147: +-----------------------------------------------------*/
5148:
5149: lStmtNumber := 230;
5150:
5151: insert into cst_item_cost_details
5152: (inventory_item_id,
5153: cost_type_id,
5154: last_update_date,
5155: last_updated_by,
5237: C.attribute13,
5238: C.attribute14,
5239: C.attribute15
5240: from
5241: cst_item_cost_details C
5242: where C.inventory_item_id = p_config_item_id
5243: and C.organization_id = p_organization_id
5244: and C.cost_type_id = p_src_cost_type_id ;
5245:
5243: and C.organization_id = p_organization_id
5244: and C.cost_type_id = p_src_cost_type_id ;
5245:
5246: IF PG_DEBUG <> 0 THEN
5247: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details',2);
5248:
5249: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
5250: END IF;
5251:
5245:
5246: IF PG_DEBUG <> 0 THEN
5247: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details',2);
5248:
5249: oe_debug_pub.add('copy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
5250: END IF;
5251:
5252:
5253: exception