APPS.CTO_CONFIG_BOM_PK dependencies on FND_PROFILE

Line 213: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);

209: -- Bug 2222518 Declaring Global variable to hold the value of Estimated Release Date
210:
211: g_EstRelDate Date;
212:
213: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
214:
215: -- 3222932 setting global replacement of null disable dates
216:
217: g_futuredate DATE := to_date('01/01/2099 00:00:00','MM/DD/YYYY HH24:MI:SS');

Line 616: lOpseqProfile := FND_PROFILE.Value('BOM:CONFIG_INHERIT_OP_SEQ');

612: Open : As in prev releases, this does not cover non-ATPable SMCs because
613: they are not in oe_order_lines. Do we need to ?
614: +--------------------------------------------------------------------------*/
615:
616: lOpseqProfile := FND_PROFILE.Value('BOM:CONFIG_INHERIT_OP_SEQ');
617:
618: IF PG_DEBUG <> 0 THEN
619: oe_debug_pub.add ('create_bom_ml: ' || 'Config_inherit_op_seq is ' || lOpseqProfile, 2);
620: END IF;

Line 1262: lcreate_item := nvl(FND_PROFILE.VALUE('CTO_CONFIG_EXCEPTION'), 1);

1258: lStmtNum := 51;
1259:
1260: BEGIN
1261:
1262: lcreate_item := nvl(FND_PROFILE.VALUE('CTO_CONFIG_EXCEPTION'), 1);
1263:
1264: IF PG_DEBUG <> 0 THEN
1265: oe_debug_pub.add ('Config exception profile '||lcreate_item, 1);
1266: END IF;

Line 2732: p_seq_increment := fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT');

2728:
2729: --
2730: -- Get item sequence increment
2731: --
2732: p_seq_increment := fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT');
2733: IF PG_DEBUG <> 0 THEN
2734: oe_debug_pub.add('create_bom_data_ml: ' || 'Item Seq Increment::'||to_char(p_seq_increment), 1);
2735: END IF;
2736:

Line 5001: from fnd_profile_option_values val,fnd_profile_options op

4997: delimiter varchar2(10);
4998: profile_setting varchar2(30);
4999: CURSOR profile_check IS
5000: select nvl(substr(profile_option_value,1,30),'N')
5001: from fnd_profile_option_values val,fnd_profile_options op
5002: where op.application_id = 401
5003: and op.profile_option_name = 'USE_NAME_ICG_DESC'
5004: and val.level_id = 10001 /* This is for site level */
5005: and val.application_id = op.application_id