DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on CST_COST_TYPES

Line 6259: v_cto_cost_type_name cst_cost_types.cost_type%type;

6255: v_overhead_cost cst_item_costs.overhead_cost%type := 0 ;
6256:
6257:
6258: v_item_cost cst_item_costs.item_cost%type := 0 ;
6259: v_cto_cost_type_name cst_cost_types.cost_type%type;
6260: v_item_cost_frozen cst_item_costs.item_cost%type; --Bugfix 6363308
6261: l_cost_update number; --Bugfix 6363308
6262:
6263: --Bugfix 6363308

Line 6812: from cst_cost_types

6808: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
6809: begin
6810:
6811: select cost_type_id into l_cto_cost_type_id
6812: from cst_cost_types
6813: where cost_type = 'CTO' ;
6814:
6815: exception
6816: when no_data_found then

Line 6827: from cst_cost_types

6823: l_cto_cost_type_id := 7 ;
6824:
6825: begin
6826: select cost_type into v_cto_cost_type_name
6827: from cst_cost_types
6828: where cost_type_id = l_cto_cost_type_id ;
6829:
6830: IF PG_DEBUG <> 0 THEN
6831: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || l_cto_cost_type_id ||