DBA Data[Home] [Help]

APPS.MRP_MANAGER_PK dependencies on FND_PROFILE

Line 213: var_expl := NVL(TO_NUMBER(FND_PROFILE.VALUE('MRP_FC_EXPLOSION')), SYS_YES);

209: 'TABLE',
210: 'mrp_form_query(1:'||to_char(var_batch_id)||')',
211: 'N');
212:
213: var_expl := NVL(TO_NUMBER(FND_PROFILE.VALUE('MRP_FC_EXPLOSION')), SYS_YES);
214: var_batch_size := NVL(TO_NUMBER(FND_PROFILE.VALUE(
215: 'MRP_SCHED_MGR_BATCH_SIZE')), SYS_YES);
216:
217: --

Line 214: var_batch_size := NVL(TO_NUMBER(FND_PROFILE.VALUE(

210: 'mrp_form_query(1:'||to_char(var_batch_id)||')',
211: 'N');
212:
213: var_expl := NVL(TO_NUMBER(FND_PROFILE.VALUE('MRP_FC_EXPLOSION')), SYS_YES);
214: var_batch_size := NVL(TO_NUMBER(FND_PROFILE.VALUE(
215: 'MRP_SCHED_MGR_BATCH_SIZE')), SYS_YES);
216:
217: --
218: -- Insert the following into MRP_FORM_QUERY:

Line 862: FND_PROFILE.VALUE('MRP_OLD_SO_CUTOFF_DAYS')), 99999);

858:
859: BEGIN
860:
861: var_old_so_cutoff_days := NVL(TO_NUMBER(
862: FND_PROFILE.VALUE('MRP_OLD_SO_CUTOFF_DAYS')), 99999);
863:
864: /* -- bug16239252
865: if ( g_om_installed IS NULL ) then
866: g_om_installed := oe_install.get_active_product ;

Line 939: var_first_time :=nvl(FND_PROFILE.VALUE('MRP_PLNG_MGR_FIRST_TIME'),'Y');

935: -- Determine whether this is the first time the planning manager is run.
936:
937: /*2285868*/
938:
939: var_first_time :=nvl(FND_PROFILE.VALUE('MRP_PLNG_MGR_FIRST_TIME'),'Y');
940:
941: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
942: /*
943: mrp_print_pk.mrprint('First time : '|| var_first_time,

Line 941: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

937: /*2285868*/
938:
939: var_first_time :=nvl(FND_PROFILE.VALUE('MRP_PLNG_MGR_FIRST_TIME'),'Y');
940:
941: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
942: /*
943: mrp_print_pk.mrprint('First time : '|| var_first_time,
944: arg_request_id, arg_user_id);
945:

Line 1848: pvalue := fnd_profile.save('MRP_PLNG_MGR_FIRST_TIME', 'N', 'SITE');

1844:
1845: ELSE
1846: -- Set the profile option MRP Planning Manager
1847: -- First Time to No.
1848: pvalue := fnd_profile.save('MRP_PLNG_MGR_FIRST_TIME', 'N', 'SITE');
1849: END IF;
1850: COMMIT;
1851:
1852: END compute_sales_order_changes;