DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on CST_COST_TYPES

Line 6074: v_cto_cost_type_name cst_cost_types.cost_type%type;

6070: v_overhead_cost cst_item_costs.overhead_cost%type := 0 ;
6071:
6072:
6073: v_item_cost cst_item_costs.item_cost%type := 0 ;
6074: v_cto_cost_type_name cst_cost_types.cost_type%type;
6075: v_item_cost_frozen cst_item_costs.item_cost%type; --Bugfix 6363308
6076: l_cost_update number; --Bugfix 6363308
6077:
6078: --Bugfix 6363308

Line 6627: from cst_cost_types

6623: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
6624: begin
6625:
6626: select cost_type_id into l_cto_cost_type_id
6627: from cst_cost_types
6628: where cost_type = 'CTO' ;
6629:
6630: exception
6631: when no_data_found then

Line 6642: from cst_cost_types

6638: l_cto_cost_type_id := 7 ;
6639:
6640: begin
6641: select cost_type into v_cto_cost_type_name
6642: from cst_cost_types
6643: where cost_type_id = l_cto_cost_type_id ;
6644:
6645: IF PG_DEBUG <> 0 THEN
6646: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || l_cto_cost_type_id ||