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 865: FND_PROFILE.VALUE('MRP_OLD_SO_CUTOFF_DAYS')), 99999);

861: if ( g_om_installed IS NULL ) then
862: g_om_installed := oe_install.get_active_product ;
863: end if;
864: var_old_so_cutoff_days := NVL(TO_NUMBER(
865: FND_PROFILE.VALUE('MRP_OLD_SO_CUTOFF_DAYS')), 99999);
866:
867: IF g_om_installed = 'OE' THEN
868:
869: LOOP

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

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

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

933: /*2285868*/
934:
935: var_first_time :=nvl(FND_PROFILE.VALUE('MRP_PLNG_MGR_FIRST_TIME'),'Y');
936:
937: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
938: /*
939: mrp_print_pk.mrprint('First time : '|| var_first_time,
940: arg_request_id, arg_user_id);
941:

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

1839:
1840: ELSE
1841: -- Set the profile option MRP Planning Manager
1842: -- First Time to No.
1843: pvalue := fnd_profile.save('MRP_PLNG_MGR_FIRST_TIME', 'N', 'SITE');
1844: END IF;
1845: COMMIT;
1846:
1847: END compute_sales_order_changes;