APPS.MSC_CL_MISCELLANEOUS dependencies on FND_PROFILE

Line 30: lv_pbs number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

26: t_ins_sr_org_id number_arr;
27: t_ins_supp_id number_arr;
28: t_ins_supp_site_id number_arr;
29:
30: lv_pbs number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
31: c_count number := 0;
32: G_START_SH number := nvl(TO_NUMBER(FND_PROFILE.VALUE('MSC_START_SOURCING_HISTORY')),-1);
33:
34: PROCEDURE load_sourcing_history

Line 32: G_START_SH number := nvl(TO_NUMBER(FND_PROFILE.VALUE('MSC_START_SOURCING_HISTORY')),-1);

28: t_ins_supp_site_id number_arr;
29:
30: lv_pbs number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
31: c_count number := 0;
32: G_START_SH number := nvl(TO_NUMBER(FND_PROFILE.VALUE('MSC_START_SOURCING_HISTORY')),-1);
33:
34: PROCEDURE load_sourcing_history
35: ( arg_instance_id IN NUMBER,
36: arg_refresh_number IN NUMBER,

Line 317: SELECT TO_NUMBER(FND_PROFILE.VALUE('MSC_START_SOURCING_HISTORY'))

313: For enfore sourcing splits
314: This profile will control the start date of Sourcing History calculation
315: for those transactions that are not calculated anytime before in the Destination*/
316:
317: SELECT TO_NUMBER(FND_PROFILE.VALUE('MSC_START_SOURCING_HISTORY'))
318: into start_date_offset
319: from dual;
320:
321: IF (start_date_offset IS NOT NULL) THEN