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 2012: lv_res_avail_before_sysdate := nvl(TO_NUMBER(FND_PROFILE.VAlUE('MSC_RES_AVAIL_BEFORE_SYSDAT')),1);

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

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

3985: MSC_CL_COLLECTION.INITIALIZE( pINSTANCE_ID);
3986: MSC_CL_COLLECTION.v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;
3987:
3988:
3989: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
3990: INTO lv_control_flag
3991: FROM dual;
3992:
3993: BEGIN

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

3990: INTO lv_control_flag
3991: FROM dual;
3992:
3993: BEGIN
3994: lv_msc_tp_coll_window := NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);
3995: EXCEPTION
3996: WHEN OTHERS THEN
3997: lv_msc_tp_coll_window := 0;
3998: END;