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_DUNNING_PVT dependencies on IEX_DELINQUENCIES

Line 1302: from iex_delinquencies_all

1298: acc_site.cust_account_id = cust.cust_account_id;
1299:
1300: cursor c_get_party_from_del(p_delinquency_id number) is
1301: select party_cust_id, customer_site_use_id
1302: from iex_delinquencies_all
1303: where delinquency_id = p_delinquency_id;
1304:
1305: begin
1306:

Line 1512: from iex_delinquencies_all

1508: l_dispute_id number;
1509:
1510: cursor c_get_del_info(p_delinquency_id number) is
1511: select party_cust_id, cust_account_id, customer_site_use_id
1512: from iex_delinquencies_all
1513: where delinquency_id = p_delinquency_id;
1514:
1515: cursor c_get_acct_info(p_cust_account_id number) is
1516: select party_id

Line 1977: FROM iex_delinquencies

1973: )
1974: IS
1975: CURSOR C_GET_Del (IN_del_ID NUMBER) IS
1976: SELECT delinquency_id
1977: FROM iex_delinquencies
1978: WHERE delinquency_ID = IN_del_ID;
1979: --
1980: l_delinquency_id NUMBER;
1981:

Line 2996: FROM IEX_DELINQUENCIES

2992:
2993: IS
2994: CURSOR C_GET_DEL (IN_del_ID NUMBER) IS
2995: SELECT delinquency_ID
2996: FROM IEX_DELINQUENCIES
2997: WHERE delinquency_ID = in_del_ID;
2998: --
2999: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
3000: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS

Line 3038: from iex_delinquencies d

3034: -- cursor for checking if the number of delinquencies NOT disputed
3035: /*
3036: CURSOR C_DISPUTED_AMOUNT(P_PARTY_ID NUMBER, P_CUST_ACCOUNT_ID NUMBER, P_SITE_USE_ID NUMBER ) IS
3037: select sum(a.amount_in_dispute) - sum(a.amount_due_remaining)
3038: from iex_delinquencies d
3039: ,ar_payment_schedules a
3040: where a.payment_schedule_id = d.payment_schedule_id
3041: and d.party_cust_id = nvl(p_party_id, d.party_cust_id)
3042: and d.cust_account_id = nvl(P_CUST_ACCOUNT_ID, d.cust_account_id )

Line 3048: from iex_delinquencies d

3044: and d.status IN ('DELINQUENT', 'PREDELINQUENT');
3045: */
3046: CURSOR C_DISPUTED_AMOUNT_PARTY(P_PARTY_ID NUMBER) IS
3047: select sum(a.amount_in_dispute) - sum(a.amount_due_remaining)
3048: from iex_delinquencies d
3049: ,ar_payment_schedules a
3050: where a.payment_schedule_id = d.payment_schedule_id
3051: and d.party_cust_id = p_party_id
3052: and d.status IN ('DELINQUENT', 'PREDELINQUENT');

Line 3056: from iex_delinquencies d

3052: and d.status IN ('DELINQUENT', 'PREDELINQUENT');
3053:
3054: CURSOR C_DISPUTED_AMOUNT_ACCOUNT(P_CUST_ACCOUNT_ID NUMBER) IS
3055: select sum(a.amount_in_dispute) - sum(a.amount_due_remaining)
3056: from iex_delinquencies d
3057: ,ar_payment_schedules a
3058: where a.payment_schedule_id = d.payment_schedule_id
3059: and d.cust_account_id = P_CUST_ACCOUNT_ID
3060: and d.status IN ('DELINQUENT', 'PREDELINQUENT');

Line 3064: from iex_delinquencies d

3060: and d.status IN ('DELINQUENT', 'PREDELINQUENT');
3061:
3062: CURSOR C_DISPUTED_AMOUNT_BILLTO(P_SITE_USE_ID NUMBER ) IS
3063: select sum(a.amount_in_dispute) - sum(a.amount_due_remaining)
3064: from iex_delinquencies d
3065: ,ar_payment_schedules a
3066: where a.payment_schedule_id = d.payment_schedule_id
3067: and d.customer_site_use_id = p_site_use_id
3068: and d.status IN ('DELINQUENT', 'PREDELINQUENT');

Line 3100: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE

3096: l_msg_data VARCHAR2(32767);
3097: errmsg VARCHAR2(32767);
3098: --
3099: nIdx NUMBER := 0;
3100: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
3101: INDEX BY BINARY_INTEGER;
3102: Del_Tbl Del_ID_TBL_TYPE;
3103: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
3104: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 3746: FROM IEX_DELINQUENCIES

3742: party_cust_id,
3743: cust_account_id,
3744: customer_site_use_id,
3745: score_value
3746: FROM IEX_DELINQUENCIES
3747: WHERE delinquency_ID = in_del_ID;
3748: --
3749: CURSOR C_GET_SCORE (IN_ID NUMBER) IS
3750: SELECT a.score_value

Line 3782: --iex_delinquencies_all del

3778: cursor c_amount (IN_ID number) is
3779: select ps.amount_due_remaining,
3780: ps.invoice_currency_code
3781: from ar_payment_schedules_all ps,
3782: --iex_delinquencies_all del
3783: iex_delinquencies del
3784: where ps.payment_schedule_id (+)= del.payment_schedule_id
3785: and del.delinquency_id = in_id;
3786: --

Line 3783: iex_delinquencies del

3779: select ps.amount_due_remaining,
3780: ps.invoice_currency_code
3781: from ar_payment_schedules_all ps,
3782: --iex_delinquencies_all del
3783: iex_delinquencies del
3784: where ps.payment_schedule_id (+)= del.payment_schedule_id
3785: and del.delinquency_id = in_id;
3786: --
3787:

Line 3817: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE

3813: l_msg_data VARCHAR2(32767);
3814: errmsg VARCHAR2(32767);
3815: --
3816: nIdx NUMBER := 0;
3817: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
3818: INDEX BY BINARY_INTEGER;
3819: Del_Tbl Del_ID_TBL_TYPE;
3820: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
3821: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 4393: FROM IEX_DELINQUENCIES

4389:
4390: IS
4391: CURSOR C_GET_DEL (IN_del_ID NUMBER) IS
4392: SELECT delinquency_ID
4393: FROM IEX_DELINQUENCIES
4394: WHERE delinquency_ID = in_del_ID;
4395: --
4396: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
4397: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS

Line 4457: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE

4453: l_msg_data VARCHAR2(32767);
4454: errmsg VARCHAR2(32767);
4455: --
4456: nIdx NUMBER := 0;
4457: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
4458: INDEX BY BINARY_INTEGER;
4459: Del_Tbl Del_ID_TBL_TYPE;
4460: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
4461: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 5090: FROM IEX_DELINQUENCIES

5086: party_cust_id,
5087: cust_account_id,
5088: customer_site_use_id,
5089: score_value
5090: FROM IEX_DELINQUENCIES
5091: WHERE delinquency_ID = in_del_ID;
5092: --
5093: CURSOR C_GET_SCORE (IN_ID NUMBER) IS
5094: SELECT a.score_value

Line 5127: --iex_delinquencies_all del

5123: cursor c_amount (IN_ID number) is
5124: select ps.amount_due_remaining,
5125: ps.invoice_currency_code
5126: from ar_payment_schedules_all ps,
5127: --iex_delinquencies_all del
5128: iex_delinquencies del
5129: where ps.payment_schedule_id (+)= del.payment_schedule_id
5130: and del.delinquency_id = in_id;
5131: --

Line 5128: iex_delinquencies del

5124: select ps.amount_due_remaining,
5125: ps.invoice_currency_code
5126: from ar_payment_schedules_all ps,
5127: --iex_delinquencies_all del
5128: iex_delinquencies del
5129: where ps.payment_schedule_id (+)= del.payment_schedule_id
5130: and del.delinquency_id = in_id;
5131: --
5132:

Line 5160: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE

5156: l_msg_data VARCHAR2(32767);
5157: errmsg VARCHAR2(32767);
5158: --
5159: nIdx NUMBER := 0;
5160: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
5161: INDEX BY BINARY_INTEGER;
5162: Del_Tbl Del_ID_TBL_TYPE;
5163: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
5164: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 5711: in send_dunning, aging_bucket_line_id is not from iex_delinquencies;

5707: END Resend_Dunning;
5708:
5709: /* clchang added (for 11.5.9)
5710: no iex aging in 11.5.9;
5711: in send_dunning, aging_bucket_line_id is not from iex_delinquencies;
5712: we need to get by ourselves;
5713:
5714: updated for 11.5.11 - 11/22/04
5715: dunning support aging in 11.5.11 at all levels.

Line 5737: FROM iex_delinquencies del,

5733: IS
5734: -- begin bug 4914799, add max function and check del status
5735: CURSOR C_GET_PARTY_DAYS (in_party_id number) IS
5736: SELECT max(sysdate - ar.due_date) days
5737: FROM iex_delinquencies del,
5738: ar_payment_schedules ar
5739: WHERE del.party_cust_id = in_party_id
5740: AND del.payment_schedule_id = ar.payment_schedule_id
5741: and del.status in ('DELINQUENT', 'PREDELINQUENT');

Line 5745: FROM iex_delinquencies del,

5741: and del.status in ('DELINQUENT', 'PREDELINQUENT');
5742: --
5743: CURSOR C_GET_ACCT_DAYS (in_acct_id number) IS
5744: SELECT max(sysdate - ar.due_date) days
5745: FROM iex_delinquencies del,
5746: ar_payment_schedules ar
5747: WHERE del.cust_account_id = in_acct_id
5748: AND del.payment_schedule_id = ar.payment_schedule_id
5749: and del.status in ('DELINQUENT', 'PREDELINQUENT');

Line 5753: FROM iex_delinquencies del,

5749: and del.status in ('DELINQUENT', 'PREDELINQUENT');
5750: --
5751: CURSOR C_GET_SITE_DAYS (in_site_id number) IS
5752: SELECT max(sysdate - ar.due_date) days
5753: FROM iex_delinquencies del,
5754: ar_payment_schedules ar
5755: WHERE del.customer_site_use_id = in_site_id
5756: AND del.payment_schedule_id = ar.payment_schedule_id
5757: and del.status in ('DELINQUENT', 'PREDELINQUENT');

Line 5761: FROM iex_delinquencies del,

5757: and del.status in ('DELINQUENT', 'PREDELINQUENT');
5758: --
5759: CURSOR C_GET_DAYS (IN_DEL_ID NUMBER) IS
5760: SELECT (sysdate - ar.due_date) days
5761: FROM iex_delinquencies del,
5762: ar_payment_schedules ar
5763: WHERE delinquency_ID = in_DEL_ID
5764: AND del.payment_schedule_id = ar.payment_schedule_id
5765: and del.status in ('DELINQUENT', 'PREDELINQUENT');

Line 8588: FROM IEX_DELINQUENCIES d

8584: AND to_char(callback_date, 'YYYYMMDD') <= to_char(sysdate,'YYYYMMDD');
8585: --
8586: CURSOR C_CHK_DEL (IN_del_ID NUMBER) IS
8587: SELECT 1
8588: FROM IEX_DELINQUENCIES d
8589: WHERE d.delinquency_ID = in_del_ID
8590: AND STATUS in ('DELINQUENT', 'PREDELINQUENT');
8591: --
8592: CURSOR C_CHK_ACCOUNT (IN_ACCT_ID NUMBER) IS

Line 8594: FROM IEX_DELINQUENCIES d

8590: AND STATUS in ('DELINQUENT', 'PREDELINQUENT');
8591: --
8592: CURSOR C_CHK_ACCOUNT (IN_ACCT_ID NUMBER) IS
8593: SELECT 1
8594: FROM IEX_DELINQUENCIES d
8595: WHERE d.cust_account_ID = in_ACCT_ID
8596: AND STATUS in ('DELINQUENT', 'PREDELINQUENT');
8597: --
8598: CURSOR C_CHK_CUSTOMER (IN_PARTY_ID NUMBER) IS

Line 8600: FROM IEX_DELINQUENCIES d

8596: AND STATUS in ('DELINQUENT', 'PREDELINQUENT');
8597: --
8598: CURSOR C_CHK_CUSTOMER (IN_PARTY_ID NUMBER) IS
8599: SELECT 1
8600: FROM IEX_DELINQUENCIES d
8601: WHERE d.party_cust_id = in_party_id
8602: AND STATUS in ('DELINQUENT', 'PREDELINQUENT');
8603: --
8604: CURSOR C_CHK_SITE (IN_SITE_ID NUMBER) IS

Line 8606: FROM IEX_DELINQUENCIES d

8602: AND STATUS in ('DELINQUENT', 'PREDELINQUENT');
8603: --
8604: CURSOR C_CHK_SITE (IN_SITE_ID NUMBER) IS
8605: SELECT 1
8606: FROM IEX_DELINQUENCIES d
8607: WHERE d.customer_site_use_id = in_SITE_ID
8608: AND STATUS in ('DELINQUENT', 'PREDELINQUENT');
8609: --
8610: l_DUNNING_id NUMBER;

Line 8894: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

8890: ||' and ref.object_id=dun.dunning_id'
8891: ||' and dun.dunning_level='''||p_running_level||'''';
8892:
8893: IF (p_running_level = 'CUSTOMER') THEN
8894: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
8895: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
8896: ||' and dun.dunning_object_id=del.party_cust_id)';
8897: ELSIF(p_running_level = 'ACCOUNT') THEN
8898: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

Line 8898: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

8894: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
8895: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
8896: ||' and dun.dunning_object_id=del.party_cust_id)';
8897: ELSIF(p_running_level = 'ACCOUNT') THEN
8898: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
8899: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
8900: ||' and dun.dunning_object_id=del.cust_account_id)';
8901: ELSIF(p_running_level = 'BILL_TO') THEN
8902: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

Line 8902: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

8898: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
8899: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
8900: ||' and dun.dunning_object_id=del.cust_account_id)';
8901: ELSIF(p_running_level = 'BILL_TO') THEN
8902: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
8903: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
8904: ||' and dun.dunning_object_id=del.customer_site_use_id)';
8905: ELSE
8906: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

Line 8906: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

8902: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
8903: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
8904: ||' and dun.dunning_object_id=del.customer_site_use_id)';
8905: ELSE
8906: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
8907: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
8908: ||' and dun.dunning_object_id=del.delinquency_id)';
8909: END IF;
8910: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Query: '||l_task_query);

Line 9010: FROM IEX_DELINQUENCIES d,

9006: d.customer_site_use_id,
9007: ar.trx_number,
9008: ar.payment_schedule_id,
9009: h.party_name
9010: FROM IEX_DELINQUENCIES d,
9011: HZ_PARTIES h,
9012: HZ_CUST_ACCOUNTS a,
9013: AR_PAYMENT_SCHEDULES ar
9014: WHERE d.delinquency_ID = in_del_ID

Line 9026: FROM IEX_DELINQUENCIES d,

9022: d.cust_account_id,
9023: a.account_number,
9024: d.customer_site_use_id,
9025: h.party_name
9026: FROM IEX_DELINQUENCIES d,
9027: HZ_PARTIES h,
9028: HZ_CUST_ACCOUNTS a
9029: WHERE d.customer_site_use_id = in_SITE_ID
9030: AND h.party_id = d.party_cust_id

Line 9038: FROM IEX_DELINQUENCIES d,

9034: SELECT d.party_cust_id,
9035: d.cust_account_id,
9036: a.account_number,
9037: h.party_name
9038: FROM IEX_DELINQUENCIES d,
9039: HZ_PARTIES h,
9040: HZ_CUST_ACCOUNTS a
9041: WHERE d.cust_account_ID = in_ACCT_ID
9042: AND h.party_id = d.party_cust_id

Line 9048: FROM IEX_DELINQUENCIES d,

9044: --
9045: CURSOR C_GET_CUSTOMER (IN_PARTY_ID NUMBER) IS
9046: SELECT d.party_cust_id,
9047: h.party_name
9048: FROM IEX_DELINQUENCIES d,
9049: HZ_PARTIES h
9050: WHERE d.party_cust_id = in_party_id
9051: AND h.party_id = d.party_cust_id;
9052: --

Line 9832: iex_delinquencies del

9828: IS
9829: cursor c_amount (IN_ID number) is
9830: select ps.invoice_currency_code
9831: from ar_payment_schedules_all ps,
9832: iex_delinquencies del
9833: where ps.payment_schedule_id (+)= del.payment_schedule_id
9834: and del.party_cust_id = in_id;
9835: l_code VARCHAR2(15);
9836: BEGIN

Line 9859: --iex_delinquencies_all del

9855: IS
9856: cursor c_amount (IN_ID number) is
9857: select ps.invoice_currency_code
9858: from ar_payment_schedules_all ps,
9859: --iex_delinquencies_all del
9860: iex_delinquencies del
9861: where ps.payment_schedule_id (+)= del.payment_schedule_id
9862: and del.cust_account_id = in_id;
9863: l_code VARCHAR2(15);

Line 9860: iex_delinquencies del

9856: cursor c_amount (IN_ID number) is
9857: select ps.invoice_currency_code
9858: from ar_payment_schedules_all ps,
9859: --iex_delinquencies_all del
9860: iex_delinquencies del
9861: where ps.payment_schedule_id (+)= del.payment_schedule_id
9862: and del.cust_account_id = in_id;
9863: l_code VARCHAR2(15);
9864: BEGIN

Line 9887: iex_delinquencies del

9883: IS
9884: cursor c_amount (IN_ID number) is
9885: select ps.invoice_currency_code
9886: from ar_payment_schedules_all ps,
9887: iex_delinquencies del
9888: where ps.payment_schedule_id (+)= del.payment_schedule_id
9889: and del.customer_site_use_id = in_id;
9890:
9891: l_code VARCHAR2(15);

Line 9916: iex_delinquencies del

9912: IS
9913: cursor c_amount (IN_ID number) is
9914: select sum(ps.acctd_amount_due_remaining)
9915: from ar_payment_schedules_all ps,
9916: iex_delinquencies del
9917: where ps.payment_schedule_id (+)= del.payment_schedule_id
9918: and del.party_cust_id = in_id;
9919: l_sum number;
9920: BEGIN

Line 9943: --iex_delinquencies_all del

9939: IS
9940: cursor c_amount (IN_ID number) is
9941: select sum(ps.acctd_amount_due_remaining)
9942: from ar_payment_schedules_all ps,
9943: --iex_delinquencies_all del
9944: iex_delinquencies del
9945: where ps.payment_schedule_id (+)= del.payment_schedule_id
9946: and del.cust_account_id = in_id;
9947: l_sum number;

Line 9944: iex_delinquencies del

9940: cursor c_amount (IN_ID number) is
9941: select sum(ps.acctd_amount_due_remaining)
9942: from ar_payment_schedules_all ps,
9943: --iex_delinquencies_all del
9944: iex_delinquencies del
9945: where ps.payment_schedule_id (+)= del.payment_schedule_id
9946: and del.cust_account_id = in_id;
9947: l_sum number;
9948: BEGIN

Line 9971: iex_delinquencies del

9967: IS
9968: cursor c_amount (IN_ID number) is
9969: select sum(ps.acctd_amount_due_remaining)
9970: from ar_payment_schedules_all ps,
9971: iex_delinquencies del
9972: where ps.payment_schedule_id (+)= del.payment_schedule_id
9973: and del.customer_site_use_id = in_id;
9974: l_sum number;
9975: --

Line 10000: from iex_delinquencies del

9996: FUNCTION get_party_id(p_account_id NUMBER) RETURN NUMBER
9997: IS
9998: cursor c_party (IN_ID number) is
9999: select del.party_cust_id
10000: from iex_delinquencies del
10001: where del.cust_account_id = in_id;
10002: l_party number;
10003: BEGIN
10004: WriteLog('get_party_id');