DBA Data[Home] [Help]

APPS.CTO_CONFIG_COST_PK dependencies on CST_COST_TYPES

Line 1084: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;

1080: lBuyCostType varchar2(30);
1081:
1082: CTO_MRP_ASSIGNMENT_SET exception;
1083:
1084: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
1085: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1086: v_buy_cost number ;
1087: c_line_id bom_cto_src_orgs.line_id%type ;
1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;

Line 1085: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;

1081:
1082: CTO_MRP_ASSIGNMENT_SET exception;
1083:
1084: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
1085: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1086: v_buy_cost number ;
1087: c_line_id bom_cto_src_orgs.line_id%type ;
1088: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1089: c_config_item_id bom_cto_src_orgs.model_item_id%type ;

Line 1209: v_cto_cost_type_name cst_cost_types.cost_type%type;

1205: v_org varchar2(2000) ;
1206: v_model_name varchar2(2000) ;
1207:
1208:
1209: v_cto_cost_type_name cst_cost_types.cost_type%type;
1210:
1211: l_cost_data_exists Varchar2(1) := 'N'; -- Bug Fix 4867460
1212: l_cost_update_required varchar2(1) := 'N'; --Bugfix 6717614
1213:

Line 1311: from cst_cost_types

1307: /* commented for bug 4057651
1308: begin
1309:
1310: select cost_type_id into v_cto_cost_type_id
1311: from cst_cost_types
1312: where cost_type = 'CTO' ;
1313:
1314:
1315:

Line 1338: from cst_cost_types

1334: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
1335: begin
1336:
1337: select cost_type_id into v_cto_cost_type_id
1338: from cst_cost_types
1339: where cost_type = 'CTO' ;
1340:
1341: exception
1342: when no_data_found then

Line 1353: from cst_cost_types

1349: v_cto_cost_type_id := 7 ;
1350:
1351: begin
1352: select cost_type into v_cto_cost_type_name
1353: from cst_cost_types
1354: where cost_type_id = v_cto_cost_type_id ;
1355:
1356: IF PG_DEBUG <> 0 THEN
1357: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||

Line 1395: from cst_cost_types

1391:
1392: if( lBuyCostType is not null ) then
1393: begin
1394: select cost_type_id into v_buy_cost_type_id
1395: from cst_cost_types
1396: where cost_type = lBuyCostType ;
1397:
1398: IF PG_DEBUG <> 0 THEN
1399: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type id ::'

Line 2097: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;

2093: lBuyCostType varchar2(30);
2094:
2095: CTO_MRP_ASSIGNMENT_SET exception;
2096:
2097: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
2098: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
2099: v_buy_cost number ;
2100: c_line_id bom_cto_src_orgs.line_id%type ;
2101: c_model_item_id bom_cto_src_orgs.model_item_id%type ;

Line 2098: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;

2094:
2095: CTO_MRP_ASSIGNMENT_SET exception;
2096:
2097: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
2098: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
2099: v_buy_cost number ;
2100: c_line_id bom_cto_src_orgs.line_id%type ;
2101: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
2102: c_config_item_id bom_cto_src_orgs.model_item_id%type ;

Line 2221: v_cto_cost_type_name cst_cost_types.cost_type%type;

2217: v_po_validation_org varchar2(2000) ;
2218: v_org varchar2(2000) ;
2219: v_model_name varchar2(2000) ;
2220:
2221: v_cto_cost_type_name cst_cost_types.cost_type%type;
2222: cst_sc_list_count number; --bug 4867460
2223:
2224: l_cost_update_required varchar2(1) := 'N'; --bug 6717614
2225:

Line 2300: from cst_cost_types

2296:
2297: if( lBuyCostType is not null ) then
2298: begin
2299: select cost_type_id into v_buy_cost_type_id
2300: from cst_cost_types
2301: where cost_type = lBuyCostType ;
2302:
2303: IF PG_DEBUG <> 0 THEN
2304: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type id ::'

Line 2619: from cst_cost_types

2615: /* commented for bug 4057651
2616: begin
2617:
2618: select cost_type_id into v_cto_cost_type_id
2619: from cst_cost_types
2620: where cost_type = 'CTO' ;
2621:
2622:
2623: if( lBuyCostType is null ) then

Line 2654: from cst_cost_types

2650: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
2651: begin
2652:
2653: select cost_type_id into v_cto_cost_type_id
2654: from cst_cost_types
2655: where cost_type = 'CTO' ;
2656:
2657:
2658: exception

Line 2670: from cst_cost_types

2666: v_cto_cost_type_id := 7 ;
2667:
2668: begin
2669: select cost_type into v_cto_cost_type_name
2670: from cst_cost_types
2671: where cost_type_id = v_cto_cost_type_id ;
2672:
2673: IF PG_DEBUG <> 0 THEN
2674: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||