DBA Data[Home] [Help]

APPS.CTO_CONFIG_COST_PK dependencies on CST_COST_TYPES

Line 1065: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;

1061: lBuyCostType varchar2(30);
1062:
1063: CTO_MRP_ASSIGNMENT_SET exception;
1064:
1065: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
1066: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1067: v_buy_cost number ;
1068: c_line_id bom_cto_src_orgs.line_id%type ;
1069: c_model_item_id bom_cto_src_orgs.model_item_id%type ;

Line 1066: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;

1062:
1063: CTO_MRP_ASSIGNMENT_SET exception;
1064:
1065: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
1066: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1067: v_buy_cost number ;
1068: c_line_id bom_cto_src_orgs.line_id%type ;
1069: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1070: c_config_item_id bom_cto_src_orgs.model_item_id%type ;

Line 1190: v_cto_cost_type_name cst_cost_types.cost_type%type;

1186: v_org varchar2(2000) ;
1187: v_model_name varchar2(2000) ;
1188:
1189:
1190: v_cto_cost_type_name cst_cost_types.cost_type%type;
1191:
1192: l_cost_data_exists Varchar2(1) := 'N'; -- Bug Fix 4867460
1193: l_cost_update_required varchar2(1) := 'N'; --Bugfix 6717614
1194:

Line 1279: from cst_cost_types

1275: /* commented for bug 4057651
1276: begin
1277:
1278: select cost_type_id into v_cto_cost_type_id
1279: from cst_cost_types
1280: where cost_type = 'CTO' ;
1281:
1282:
1283:

Line 1306: from cst_cost_types

1302: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
1303: begin
1304:
1305: select cost_type_id into v_cto_cost_type_id
1306: from cst_cost_types
1307: where cost_type = 'CTO' ;
1308:
1309: exception
1310: when no_data_found then

Line 1321: from cst_cost_types

1317: v_cto_cost_type_id := 7 ;
1318:
1319: begin
1320: select cost_type into v_cto_cost_type_name
1321: from cst_cost_types
1322: where cost_type_id = v_cto_cost_type_id ;
1323:
1324: IF PG_DEBUG <> 0 THEN
1325: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||

Line 1363: from cst_cost_types

1359:
1360: if( lBuyCostType is not null ) then
1361: begin
1362: select cost_type_id into v_buy_cost_type_id
1363: from cst_cost_types
1364: where cost_type = lBuyCostType ;
1365:
1366: IF PG_DEBUG <> 0 THEN
1367: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type id ::'

Line 1976: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;

1972: lBuyCostType varchar2(30);
1973:
1974: CTO_MRP_ASSIGNMENT_SET exception;
1975:
1976: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
1977: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1978: v_buy_cost number ;
1979: c_line_id bom_cto_src_orgs.line_id%type ;
1980: c_model_item_id bom_cto_src_orgs.model_item_id%type ;

Line 1977: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;

1973:
1974: CTO_MRP_ASSIGNMENT_SET exception;
1975:
1976: v_cto_cost_type_id cst_cost_types.cost_type_id%type ;
1977: v_buy_cost_type_id cst_cost_types.cost_type_id%type ;
1978: v_buy_cost number ;
1979: c_line_id bom_cto_src_orgs.line_id%type ;
1980: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1981: c_config_item_id bom_cto_src_orgs.model_item_id%type ;

Line 2100: v_cto_cost_type_name cst_cost_types.cost_type%type;

2096: v_po_validation_org varchar2(2000) ;
2097: v_org varchar2(2000) ;
2098: v_model_name varchar2(2000) ;
2099:
2100: v_cto_cost_type_name cst_cost_types.cost_type%type;
2101: cst_sc_list_count number; --bug 4867460
2102:
2103: l_cost_update_required varchar2(1) := 'N'; --bug 6717614
2104:

Line 2175: from cst_cost_types

2171:
2172: if( lBuyCostType is not null ) then
2173: begin
2174: select cost_type_id into v_buy_cost_type_id
2175: from cst_cost_types
2176: where cost_type = lBuyCostType ;
2177:
2178: IF PG_DEBUG <> 0 THEN
2179: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type id ::'

Line 2494: from cst_cost_types

2490: /* commented for bug 4057651
2491: begin
2492:
2493: select cost_type_id into v_cto_cost_type_id
2494: from cst_cost_types
2495: where cost_type = 'CTO' ;
2496:
2497:
2498: if( lBuyCostType is null ) then

Line 2529: from cst_cost_types

2525: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
2526: begin
2527:
2528: select cost_type_id into v_cto_cost_type_id
2529: from cst_cost_types
2530: where cost_type = 'CTO' ;
2531:
2532:
2533: exception

Line 2545: from cst_cost_types

2541: v_cto_cost_type_id := 7 ;
2542:
2543: begin
2544: select cost_type into v_cto_cost_type_name
2545: from cst_cost_types
2546: where cost_type_id = v_cto_cost_type_id ;
2547:
2548: IF PG_DEBUG <> 0 THEN
2549: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||