APPS.MSC_CL_ITEM_ODS_LOAD dependencies on FND_PROFILE

Line 9: -- G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');

5: lv_sql_stmt1 VARCHAR2(4000);
6: v_sub_str VARCHAR2(4000);
7: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed
8:
9: -- G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
10: -- To collect SRP Data when this profile is set to Yes neds to be deleted
11: -- v_is_cont_refresh BOOLEAN; -- 2 be changed
12: v_chr9 VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(9);
13: -- v_chr10 VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);

Line 470: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

466: TYPE NumTblTyp IS TABLE OF NUMBER;
467: TYPE dateTblTyp IS TABLE OF DATE;
468:
469: lb_FetchComplete Boolean;
470: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
471:
472: lb_HIGHER_ITEM_ID NumTblTyp;
473: lb_LOWER_ITEM_ID NumTblTyp;
474: lb_RECIPROCAL_FLAG NumTblTyp;

Line 1091: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

1087: lv_tbl VARCHAR2(30);
1088: lv_sql_stmt VARCHAR2(5000);
1089: lv_sql_ins VARCHAR2(5000);
1090: lb_FetchComplete Boolean;
1091: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
1092:
1093:
1094: TYPE CharTblTyp IS TABLE OF VARCHAR2(250);
1095: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 1530: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)

1526: -- MSC_CL_SETUP_COLLECTION.GET_COLL_PARAM (pINSTANCE_ID); -- 2 be changed
1527:
1528: MSC_CL_COLLECTION.INITIALIZE( pINSTANCE_ID);
1529:
1530: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
1531: INTO lv_control_flag
1532: FROM dual;
1533:
1534: begin

Line 3375: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

3371: lv_tbl VARCHAR2(30);
3372: lv_sql_stmt VARCHAR2(7500);
3373: lv_sql_ins vARCHAR2(8000);
3374: lb_FetchComplete Boolean;
3375: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
3376: lv_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), MSC_UTIL.G_CONF_APS);
3377:
3378: TYPE CharTblTyp IS TABLE OF VARCHAR2(270);
3379: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 3376: lv_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), MSC_UTIL.G_CONF_APS);

3372: lv_sql_stmt VARCHAR2(7500);
3373: lv_sql_ins vARCHAR2(8000);
3374: lb_FetchComplete Boolean;
3375: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
3376: lv_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), MSC_UTIL.G_CONF_APS);
3377:
3378: TYPE CharTblTyp IS TABLE OF VARCHAR2(270);
3379: TYPE NumTblTyp IS TABLE OF NUMBER;
3380: TYPE dateTblTyp IS TABLE OF DATE;