APPS.MSC_CL_SETUP_ODS_LOAD dependencies on FND_PROFILE

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

145: lvs_request_id NumTblTyp := NumTblTyp(0);
146: lv_out NUMBER;
147: BEGIN
148:
149: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
150: INTO lv_control_flag
151: FROM dual;
152:
153: /* for bug: 2605884, added this piece of code to set the so_tbl_status to NO */

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

430:
431: lv_sql_stmt VARCHAR2(5000);
432: lv_sql_ins VARCHAR2(5000);
433: lb_FetchComplete Boolean;
434: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
435:
436:
437: TYPE CharTblTyp IS TABLE OF VARCHAR2(250);
438: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 2007: lv_res_avail_before_sysdate := nvl(TO_NUMBER(FND_PROFILE.VAlUE('MSC_RES_AVAIL_BEFORE_SYSDAT')),1);

2003: lv_instance_code
2004: FROM MSC_APPS_INSTANCES
2005: WHERE INSTANCE_ID=MSC_CL_COLLECTION.v_instance_id;
2006:
2007: lv_res_avail_before_sysdate := nvl(TO_NUMBER(FND_PROFILE.VAlUE('MSC_RES_AVAIL_BEFORE_SYSDAT')),1);
2008: IF MSC_CL_COLLECTION.v_instance_type <> MSC_UTIL.G_INS_OTHER THEN
2009: lv_sql_stmt:= 'SELECT nvl(mar.LRD,sysdate)- '||lv_res_avail_before_sysdate
2010: ||' FROM MRP_AP_APPS_INSTANCES_ALL'||lv_dblink||' mar'
2011: ||' WHERE INSTANCE_ID = '||MSC_CL_COLLECTION.v_instance_id

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

3975: MSC_CL_COLLECTION.INITIALIZE( pINSTANCE_ID);
3976: MSC_CL_COLLECTION.v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;
3977:
3978:
3979: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
3980: INTO lv_control_flag
3981: FROM dual;
3982:
3983: BEGIN

Line 3984: lv_msc_tp_coll_window := NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);

3980: INTO lv_control_flag
3981: FROM dual;
3982:
3983: BEGIN
3984: lv_msc_tp_coll_window := NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);
3985: EXCEPTION
3986: WHEN OTHERS THEN
3987: lv_msc_tp_coll_window := 0;
3988: END;