1: package body CTO_CONFIG_COST_PK as
2: /* $Header: CTOCSTRB.pls 120.9 2011/12/30 13:36:18 kupradha ship $ */
3: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
4:
5: --Bugfix 6717614: Added this new function
6: function cost_update_required (p_config_item_id number,
7: p_organization_id number,
1258: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'lRollupId::'||to_char(lRollupId), 2);
1259: END IF;
1260:
1261: lStmtNumber := 20;
1262: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
1263:
1264: IF lMrpAssignmentSet is null THEN
1265: IF PG_DEBUG <> 0 THEN
1266: oe_debug_pub.add('Cost_Roll_Up_ML '
1281: -- Getting the Currency Conversion Type from profile
1282: -- "INV:Inter-organization currency conversion"
1283: --
1284: lStmtNumber := 25;
1285: lConversionType := FND_PROFILE.VALUE('CURRENCY_CONVERSION_TYPE');
1286:
1287:
1288: IF PG_DEBUG <> 0 THEN
1289: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Currency Conversion Type ::'
1380: CTO BUY cost type id will be defaulted to CTO cost type if it is null.
1381: */
1382:
1383: lStmtNumber := 27;
1384: lBuyCostType := FND_PROFILE.VALUE('CTO_BUY_COST_TYPE');
1385: IF PG_DEBUG <> 0 THEN
1386: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type ::'|| lBuyCostType , 2);
1387: END IF;
1388:
2253: oe_debug_pub.add('Cost_Rollup_ML: ' || 'lRollupId::'||to_char(lRollupId), 2);
2254: END IF;
2255:
2256: lStmtNumber := 20;
2257: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
2258:
2259: IF lMrpAssignmentSet is null THEN
2260: IF PG_DEBUG <> 0 THEN
2261: oe_debug_pub.add('Cost_Rollup_ML: '
2276: -- Getting the Currency Conversion Type from profile
2277: -- "INV:Inter-organization currency conversion"
2278: --
2279: lStmtNumber := 25;
2280: lConversionType := FND_PROFILE.VALUE('CURRENCY_CONVERSION_TYPE');
2281:
2282:
2283: IF PG_DEBUG <> 0 THEN
2284: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Currency Conversion Type ::'
2285: ||lConversionType, 2);
2286: END IF;
2287:
2288: lStmtNumber := 27;
2289: lBuyCostType := FND_PROFILE.VALUE('CTO_BUY_COST_TYPE');
2290: IF PG_DEBUG <> 0 THEN
2291: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type ::'|| lBuyCostType , 2);
2292: END IF;
2293: