eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_DELINQUENCY_PUB dependencies on FND_PROFILE

Line 11: --G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));

7:
8: --
9: -- Begin - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
10: --
11: --G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
12: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
13: --
14: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
15: --

Line 12: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));

8: --
9: -- Begin - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
10: --
11: --G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
12: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
13: --
14: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
15: --
16:

Line 41: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

37: ||
38: || Major Modifications: when who what
39: || 03/15/02 3:29:PM raverma created
40: */
41: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
42: --Added this function for bug#7133605 by schekuri on 17-Jun-2008 -- Added by PNAVEENK
43: FUNCTION isRefreshProgramsRunning RETURN BOOLEAN IS
44: CURSOR C1 IS
45: select request_id

Line 546: l_enable_business_events := FND_PROFILE.VALUE('IEX_ENABLE_CUST_STATUS_EVENT') ;

542:
543:
544:
545: l_source_module := 'IEX_SCORE_NEW_PVT' ;
546: l_enable_business_events := FND_PROFILE.VALUE('IEX_ENABLE_CUST_STATUS_EVENT') ;
547:
548: -- IF PG_DEBUG < 10 THEN
549: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
550: IEX_DEBUG_PUB.LOGMESSAGE('MANAGE_DELINQUENCIES: ' || v_line);

Line 636: Select --fnd_profile.value('ORG_ID'), --Commneted for MOAC

632: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
633: IEX_DEBUG_PUB.LOGMESSAGE('MANAGE_DELINQUENCIES: ' || 'Score Id = ' || v_score || ' Object Code = ' || v_object);
634: END IF;
635:
636: Select --fnd_profile.value('ORG_ID'), --Commneted for MOAC
637: fnd_profile.value('USER_ID'),
638: fnd_profile.value('IEX_DEBUG_LEVEL'),
639: sysdate
640: into --v_org_id, --Commneted for MOAC

Line 637: fnd_profile.value('USER_ID'),

633: IEX_DEBUG_PUB.LOGMESSAGE('MANAGE_DELINQUENCIES: ' || 'Score Id = ' || v_score || ' Object Code = ' || v_object);
634: END IF;
635:
636: Select --fnd_profile.value('ORG_ID'), --Commneted for MOAC
637: fnd_profile.value('USER_ID'),
638: fnd_profile.value('IEX_DEBUG_LEVEL'),
639: sysdate
640: into --v_org_id, --Commneted for MOAC
641: v_user_id,

Line 638: fnd_profile.value('IEX_DEBUG_LEVEL'),

634: END IF;
635:
636: Select --fnd_profile.value('ORG_ID'), --Commneted for MOAC
637: fnd_profile.value('USER_ID'),
638: fnd_profile.value('IEX_DEBUG_LEVEL'),
639: sysdate
640: into --v_org_id, --Commneted for MOAC
641: v_user_id,
642: v_debug_level,

Line 1878: --fnd_profile.value('ORG_ID'), --Commneted for MOAC

1874: x_del_id_tbl.DELETE ;
1875: End IF ;
1876:
1877: Select
1878: --fnd_profile.value('ORG_ID'), --Commneted for MOAC
1879: NVL(fnd_profile.value('USER_ID'), -1),
1880: sysdate
1881: into
1882: --v_org_id , --Commneted for MOAC

Line 1879: NVL(fnd_profile.value('USER_ID'), -1),

1875: End IF ;
1876:
1877: Select
1878: --fnd_profile.value('ORG_ID'), --Commneted for MOAC
1879: NVL(fnd_profile.value('USER_ID'), -1),
1880: sysdate
1881: into
1882: --v_org_id , --Commneted for MOAC
1883: v_user_id ,

Line 2133: LIMIT NVL(FND_PROFILE.VALUE('IEX_BATCH_SIZE'), 1000)

2129: /*
2130: SELECT score_object_id,
2131: score_value
2132: BULK COLLECT INTO
2133: LIMIT NVL(FND_PROFILE.VALUE('IEX_BATCH_SIZE'), 1000)
2134: FROM iex_del_buffers
2135: WHERE request_id = p_request_id;
2136: */
2137: -- IF PG_DEBUG < 10 THEN

Line 2294: l_days := to_number(nvl(fnd_profile.value('IEX_UWQ_DEFAULT_PENDING_DAYS'), '0'));

2290: end if;
2291:
2292: -- set number of days
2293: if P_NO_DAYS is null then
2294: l_days := to_number(nvl(fnd_profile.value('IEX_UWQ_DEFAULT_PENDING_DAYS'), '0'));
2295: else
2296: l_days := P_NO_DAYS;
2297: end if;
2298: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2367: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

2363: FROM iex_delinquencies_all
2364: WHERE party_cust_id = sum.party_id
2365: AND status IN('DELINQUENT', 'PREDELINQUENT')
2366: AND(uwq_status = 'COMPLETE'
2367: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2368: ),
2369: sum.pending_delinquencies =
2370: (SELECT 1
2371: FROM dual

Line 2410: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

2406: FROM iex_delinquencies_all
2407: WHERE cust_account_id = sum.cust_account_id
2408: AND status IN('DELINQUENT', 'PREDELINQUENT')
2409: AND(uwq_status = 'COMPLETE'
2410: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2411: ),
2412: sum.pending_delinquencies =
2413: (SELECT 1
2414: FROM dual

Line 2453: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

2449: FROM iex_delinquencies_all
2450: WHERE customer_site_use_id = sum.site_use_id
2451: AND status IN('DELINQUENT', 'PREDELINQUENT')
2452: AND(uwq_status = 'COMPLETE'
2453: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2454: ),
2455: sum.pending_delinquencies =
2456: (SELECT 1
2457: FROM dual

Line 2827: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));

2823: -- clchang added 10/28/04 to fix gscc warning
2824: BEGIN
2825:
2826: G_USER_ID := FND_GLOBAL.User_Id;
2827: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
2828: v_line := '--------------------------------------------------------------' ;
2829: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2830:
2831: END IEX_DELINQUENCY_PUB;