[Home] [Help]
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');
614: Open : As in prev releases, this does not cover non-ATPable SMCs because
615: they are not in oe_order_lines. Do we need to ?
616: +--------------------------------------------------------------------------*/
617:
618: lOpseqProfile := FND_PROFILE.Value('BOM:CONFIG_INHERIT_OP_SEQ');
619:
620: IF PG_DEBUG <> 0 THEN
621: oe_debug_pub.add ('create_bom_ml: ' || 'Config_inherit_op_seq is ' || lOpseqProfile, 2);
622: END IF;
1284: lStmtNum := 51;
1285:
1286: BEGIN
1287:
1288: lcreate_item := nvl(FND_PROFILE.VALUE('CTO_CONFIG_EXCEPTION'), 1);
1289:
1290: IF PG_DEBUG <> 0 THEN
1291: oe_debug_pub.add ('Config exception profile '||lcreate_item, 1);
1292: END IF;
2788:
2789: --
2790: -- Get item sequence increment
2791: --
2792: p_seq_increment := fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT');
2793: IF PG_DEBUG <> 0 THEN
2794: oe_debug_pub.add('create_bom_data_ml: ' || 'Item Seq Increment::'||to_char(p_seq_increment), 1);
2795: END IF;
2796:
5309: delimiter varchar2(10);
5310: profile_setting varchar2(30);
5311: CURSOR profile_check IS
5312: select nvl(substr(profile_option_value,1,30),'N')
5313: from fnd_profile_option_values val,fnd_profile_options op
5314: where op.application_id = 401
5315: and op.profile_option_name = 'USE_NAME_ICG_DESC'
5316: and val.level_id = 10001 /* This is for site level */
5317: and val.application_id = op.application_id