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(32767);
6: v_sub_str VARCHAR2(32767);
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 1094: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

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

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

1530: /*uncommenting the above call -- bug12711539*/
1531:
1532: MSC_CL_COLLECTION.INITIALIZE( pINSTANCE_ID);
1533:
1534: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
1535: INTO lv_control_flag
1536: FROM dual;
1537:
1538: begin

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

3378: lv_tbl VARCHAR2(30);
3379: lv_sql_stmt VARCHAR2(7500);
3380: lv_sql_ins vARCHAR2(8000);
3381: lb_FetchComplete Boolean;
3382: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
3383: lv_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), MSC_UTIL.G_CONF_APS);
3384:
3385: TYPE CharTblTyp IS TABLE OF VARCHAR2(270);
3386: TYPE NumTblTyp IS TABLE OF NUMBER;

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

3379: lv_sql_stmt VARCHAR2(7500);
3380: lv_sql_ins vARCHAR2(8000);
3381: lb_FetchComplete Boolean;
3382: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
3383: lv_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), MSC_UTIL.G_CONF_APS);
3384:
3385: TYPE CharTblTyp IS TABLE OF VARCHAR2(270);
3386: TYPE NumTblTyp IS TABLE OF NUMBER;
3387: TYPE dateTblTyp IS TABLE OF DATE;