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 1722: AND ORG_ID = FND_PROFILE.VALUE('ORG_ID');

1718: FORALL I IN l_cust_account_id_1.first..l_cust_account_id_1.last
1719: UPDATE AR_TRX_BAL_SUMMARY ARS
1720: SET REFERENCE_1 = '1'
1721: WHERE CUST_ACCOUNT_ID = l_cust_account_id_1(I)
1722: AND ORG_ID = FND_PROFILE.VALUE('ORG_ID');
1723: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1724: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = 1');
1725: END IF;
1726: END IF;

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

1947: x_del_id_tbl.DELETE ;
1948: End IF ;
1949:
1950: Select
1951: --fnd_profile.value('ORG_ID'), --Commneted for MOAC
1952: NVL(fnd_profile.value('USER_ID'), -1),
1953: sysdate
1954: into
1955: --v_org_id , --Commneted for MOAC

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

1948: End IF ;
1949:
1950: Select
1951: --fnd_profile.value('ORG_ID'), --Commneted for MOAC
1952: NVL(fnd_profile.value('USER_ID'), -1),
1953: sysdate
1954: into
1955: --v_org_id , --Commneted for MOAC
1956: v_user_id ,

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

2206: /*
2207: SELECT score_object_id,
2208: score_value
2209: BULK COLLECT INTO
2210: LIMIT NVL(FND_PROFILE.VALUE('IEX_BATCH_SIZE'), 1000)
2211: FROM iex_del_buffers
2212: WHERE request_id = p_request_id;
2213: */
2214: -- IF PG_DEBUG < 10 THEN

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

2367: end if;
2368:
2369: -- set number of days
2370: if P_NO_DAYS is null then
2371: l_days := to_number(nvl(fnd_profile.value('IEX_UWQ_DEFAULT_PENDING_DAYS'), '0'));
2372: else
2373: l_days := P_NO_DAYS;
2374: end if;
2375: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2440: FROM iex_delinquencies_all
2441: WHERE party_cust_id = sum.party_id
2442: AND status IN('DELINQUENT', 'PREDELINQUENT')
2443: AND(uwq_status = 'COMPLETE'
2444: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2445: ),
2446: sum.pending_delinquencies =
2447: (SELECT 1
2448: FROM dual

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

2483: FROM iex_delinquencies_all
2484: WHERE cust_account_id = sum.cust_account_id
2485: AND status IN('DELINQUENT', 'PREDELINQUENT')
2486: AND(uwq_status = 'COMPLETE'
2487: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2488: ),
2489: sum.pending_delinquencies =
2490: (SELECT 1
2491: FROM dual

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

2526: FROM iex_delinquencies_all
2527: WHERE customer_site_use_id = sum.site_use_id
2528: AND status IN('DELINQUENT', 'PREDELINQUENT')
2529: AND(uwq_status = 'COMPLETE'
2530: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
2531: ),
2532: sum.pending_delinquencies =
2533: (SELECT 1
2534: FROM dual

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

2919: -- clchang added 10/28/04 to fix gscc warning
2920: BEGIN
2921:
2922: G_USER_ID := FND_GLOBAL.User_Id;
2923: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
2924: v_line := '--------------------------------------------------------------' ;
2925: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2926:
2927: END IEX_DELINQUENCY_PUB;