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_UWQ_POP_SUM_TBL_PVT dependencies on FND_PROFILE

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

4: g_pkg_name constant VARCHAR2(30) := 'IEX_UWQ_POP_SUM_TBL_PVT';
5: g_file_name constant VARCHAR2(12) := 'iexvuwpb.pls';
6: G_LOG_ENABLED varchar2(5);
7: G_MSG_LEVEL NUMBER;
8: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
9:
10: /*deadlock_detected EXCEPTION;
11: PRAGMA EXCEPTION_INIT(deadlock_detected, -60);*/
12:

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

188: WHERE customer_site_use_id = trx_summ.site_use_id
189: AND status IN('DELINQUENT', 'PREDELINQUENT')
190: AND org_id = trx_summ.org_id
191: AND(uwq_status = 'COMPLETE'
192: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
193: )
194: complete_delinquencies,
195: (SELECT 1
196: FROM dual

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

273: WHERE pro.cust_account_id = trx_summ.cust_account_id
274: and del.customer_site_use_id = TRX_SUMM.site_use_ID
275: AND pro.state = 'BROKEN_PROMISE'
276: AND(pro.uwq_status = 'COMPLETE'
277: AND(TRUNC(pro.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
278: )
279: ) complete_promises,
280:
281: (SELECT 1 FROM dual WHERE EXISTS

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

451: WHERE customer_site_use_id = trx_summ.site_use_id
452: AND status IN('DELINQUENT', 'PREDELINQUENT')
453: AND org_id = trx_summ.org_id
454: AND(uwq_status = 'COMPLETE'
455: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
456: )
457: complete_delinquencies,
458: (SELECT 1
459: FROM dual

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

536: WHERE pro.cust_account_id = trx_summ.cust_account_id
537: and del.customer_site_use_id = TRX_SUMM.site_use_ID
538: AND pro.state = 'BROKEN_PROMISE'
539: AND(pro.uwq_status = 'COMPLETE'
540: AND(TRUNC(pro.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
541: )
542: ) complete_promises,
543:
544: (SELECT 1 FROM dual WHERE EXISTS

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

718: WHERE cust_account_id = trx_summ.cust_account_id
719: AND status IN('DELINQUENT', 'PREDELINQUENT')
720: AND org_id = trx_summ.org_id
721: AND(uwq_status = 'COMPLETE'
722: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
723: )
724: complete_delinquencies,
725: (SELECT 1
726: FROM dual

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

801: FROM iex_promise_details
802: WHERE cust_account_id = trx_summ.cust_account_id
803: AND state = 'BROKEN_PROMISE'
804: AND(uwq_status = 'COMPLETE'
805: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
806: )
807: ) complete_promises,
808:
809: (SELECT 1 FROM dual WHERE EXISTS

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

976: WHERE cust_account_id = trx_summ.cust_account_id
977: AND status IN('DELINQUENT', 'PREDELINQUENT')
978: AND org_id = trx_summ.org_id
979: AND(uwq_status = 'COMPLETE'
980: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
981: )
982: complete_delinquencies,
983: (SELECT 1
984: FROM dual

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

1059: FROM iex_promise_details
1060: WHERE cust_account_id = trx_summ.cust_account_id
1061: AND state = 'BROKEN_PROMISE'
1062: AND(uwq_status = 'COMPLETE'
1063: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1064: )
1065: ) complete_promises,
1066:
1067: (SELECT 1 FROM dual WHERE EXISTS

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

1241: WHERE party_cust_id = party.party_id
1242: AND status IN('DELINQUENT', 'PREDELINQUENT')
1243: AND org_id = trx_summ.org_id
1244: AND(uwq_status = 'COMPLETE'
1245: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1246: )
1247: complete_delinquencies,
1248: (SELECT 1
1249: FROM dual

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

1306: WHERE b.party_id = party.party_id
1307: AND pd.cust_account_id = b.cust_account_id
1308: AND pd.state = 'BROKEN_PROMISE'
1309: AND(pd.uwq_status = 'COMPLETE'
1310: AND(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1311: )
1312: complete_promises,
1313: (SELECT 1
1314: FROM dual

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

1481: WHERE party_cust_id = party.party_id
1482: AND status IN('DELINQUENT', 'PREDELINQUENT')
1483: AND org_id = trx_summ.org_id
1484: AND(uwq_status = 'COMPLETE'
1485: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1486: )
1487: complete_delinquencies,
1488: (SELECT 1
1489: FROM dual

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

1546: WHERE b.party_id = party.party_id
1547: AND pd.cust_account_id = b.cust_account_id
1548: AND pd.state = 'BROKEN_PROMISE'
1549: AND(pd.uwq_status = 'COMPLETE'
1550: AND(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1551: )
1552: complete_promises,
1553: (SELECT 1
1554: FROM dual

Line 1889: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));

1885:
1886: l_from_date := to_date(substr(FROM_DATE, 1, 10), 'YYYY/MM/DD');
1887: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Input FROM_DATE = ' || l_from_date);
1888:
1889: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
1890: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Batch size = ' || l_max_fetches);
1891:
1892: OPEN c_get_level;
1893: FETCH c_get_level INTO l_level;

Line 3684: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,

3680: cursor c_billto_del is
3681: select del.CUSTOMER_SITE_USE_ID,
3682: count(1) number_of_delinquencies,
3683: max(decode(uwq_status,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_delinquencies,
3684: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
3685: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies
3686: from iex_delinquencies_all del,
3687: iex_pop_uwq_summ_gt temp
3688: WHERE del.customer_site_use_id = temp.object_id AND

Line 3696: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,

3692:
3693: cursor c_billto_pro is
3694: select del.CUSTOMER_SITE_USE_ID,
3695: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
3696: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,
3697: max(decode(pd.uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_promises
3698: from iex_promise_details pd,
3699: IEX_DELINQUENCIES_ALL DEL,
3700: iex_pop_uwq_summ_gt temp

Line 3780: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,

3776: select del.customer_site_use_id,
3777: sum(decode(del.status,'DELINQUENT',1,'PREDELINQUENT',1,0)) number_of_delinquencies,
3778: sum(decode(del.status,'DELINQUENT',ps.acctd_amount_due_remaining,'PREDELINQUENT',ps.acctd_amount_due_remaining,0)) past_due_inv_value,
3779: max(decode(uwq_status,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_delinquencies,
3780: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
3781: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies,
3782: del.org_id org_id
3783: from iex_delinquencies del,
3784: ar_payment_schedules ps

Line 3795: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));

3791: group by del.customer_site_use_id, del.org_id;
3792:
3793: BEGIN
3794:
3795: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
3796: if p_mode='DLN' then
3797: LogMessage(FND_LOG.LEVEL_STATEMENT,'Starting..');
3798: -- Start Bug #6251657 bibeura 25-OCT-2007
3799: BEGIN

Line 4912: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,

4908: cursor c_account_del is
4909: select del.cust_account_id,
4910: count(1) number_of_delinquencies,
4911: max(decode(uwq_status,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_delinquencies,
4912: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
4913: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies
4914: from iex_delinquencies_all del,
4915: iex_pop_uwq_summ_gt temp
4916: WHERE del.cust_account_id = temp.object_id AND

Line 4924: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,

4920:
4921: cursor c_account_pro is
4922: select del.cust_account_id,
4923: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
4924: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,
4925: max(decode(pd.uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_promises
4926: from iex_promise_details pd,
4927: IEX_DELINQUENCIES_ALL DEL,
4928: iex_pop_uwq_summ_gt temp

Line 5005: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,

5001: select del.cust_account_id,
5002: sum(decode(del.status,'DELINQUENT',1,'PREDELINQUENT',1,0)) number_of_delinquencies,
5003: sum(decode(del.status,'DELINQUENT',ps.acctd_amount_due_remaining,'PREDELINQUENT',ps.acctd_amount_due_remaining,0)) past_due_inv_value,
5004: max(decode(uwq_status,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_delinquencies,
5005: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
5006: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies,
5007: del.org_id org_id
5008: from iex_delinquencies del,
5009: ar_payment_schedules ps

Line 5020: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));

5016: group by del.cust_account_id, del.org_id;
5017:
5018:
5019: BEGIN
5020: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
5021: if p_mode='DLN' then
5022: LogMessage(FND_LOG.LEVEL_STATEMENT,'Starting..');
5023: -- Start Bug #6251657 bibeura 25-OCT-2007
5024: BEGIN

Line 6132: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,

6128: cursor c_customer_del is
6129: select del.party_cust_id,
6130: count(1) number_of_delinquencies,
6131: max(decode(uwq_status,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_delinquencies,
6132: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
6133: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies
6134: from iex_delinquencies_all del,
6135: iex_pop_uwq_summ_gt temp
6136: WHERE del.party_cust_id = temp.object_id AND

Line 6144: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,

6140:
6141: cursor c_customer_pro is
6142: select del.party_cust_id,
6143: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
6144: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,
6145: max(decode(pd.uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_promises
6146: from iex_promise_details pd,
6147: IEX_DELINQUENCIES_ALL DEL,
6148: iex_pop_uwq_summ_gt temp

Line 6227: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,

6223: select del.party_cust_id,
6224: sum(decode(del.status,'DELINQUENT',1,'PREDELINQUENT',1,0)) number_of_delinquencies,
6225: sum(decode(del.status,'DELINQUENT',ps.acctd_amount_due_remaining,'PREDELINQUENT',ps.acctd_amount_due_remaining,0)) past_due_inv_value,
6226: max(decode(uwq_status,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_delinquencies,
6227: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
6228: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies,
6229: del.org_id org_id
6230: from iex_delinquencies del,
6231: ar_payment_schedules ps

Line 6241: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));

6237: and del1.org_id=del.org_id)
6238: group by del.party_cust_id, del.org_id;
6239:
6240: BEGIN
6241: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
6242: if p_mode='DLN' then
6243: LogMessage(FND_LOG.LEVEL_STATEMENT,'Starting..');
6244: -- Start Bug #6251657 bibeura 25-OCT-2007
6245: BEGIN

Line 7112: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');

7108: G_LOG_ENABLED := 'N';
7109: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
7110:
7111: /* getting msg logging info */
7112: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
7113: if (G_LOG_ENABLED = 'N') then
7114: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
7115: else
7116: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

Line 7116: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

7112: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
7113: if (G_LOG_ENABLED = 'N') then
7114: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
7115: else
7116: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
7117: end if;
7118:
7119: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
7120: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);