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_ALL

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 1510: from iex_delinquencies_all

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

Line 2896: update iex_delinquencies_all

2892: END IF;
2893:
2894: /*
2895: if p_dunning_mode <> 'DRAFT' then
2896: update iex_delinquencies_all
2897: set staged_dunning_level = i
2898: where delinquency_id = l_delinquency_id;
2899: end if;
2900: */

Line 2968: update iex_delinquencies_all

2964: END IF;
2965:
2966: /*
2967: if p_dunning_mode <> 'DRAFT' then
2968: update iex_delinquencies_all
2969: set staged_dunning_level = i
2970: where delinquency_id = l_delinquency_id;
2971: end if;
2972: */

Line 3081: update iex_delinquencies_all

3077: END IF;
3078:
3079: /*
3080: if p_dunning_mode <> 'DRAFT' then
3081: update iex_delinquencies_all
3082: set staged_dunning_level = i
3083: where delinquency_id = l_delinquency_id;
3084: end if;
3085: */

Line 3168: update iex_delinquencies_all

3164: END IF;
3165:
3166: /*
3167: if p_dunning_mode <> 'DRAFT' then
3168: update iex_delinquencies_all
3169: set staged_dunning_level = i
3170: where delinquency_id = l_delinquency_id;
3171: end if;
3172: */

Line 4091: FROM ar_payment_schedules_all ps, iex_delinquencies_all del

4087:
4088: -- Start for the bug#8408162 by PNAVEENK on 7-4-2009
4089: cursor c_fully_promised_party(p_party_id number) is
4090: SELECT count(1)
4091: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
4092: WHERE del.party_cust_id=p_party_id
4093: AND ps.payment_schedule_id = del.payment_schedule_id
4094: AND ps.status = 'OP'
4095: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 4104: FROM ar_payment_schedules_all ps, iex_delinquencies_all del

4100: group by pd.delinquency_id
4101: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);
4102: cursor c_fully_promised_account(p_cust_account_id number) is
4103: SELECT count(1)
4104: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
4105: WHERE del.cust_account_id=p_cust_account_id
4106: AND ps.payment_schedule_id = del.payment_schedule_id
4107: AND ps.status = 'OP'
4108: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 4117: FROM ar_payment_schedules_all ps, iex_delinquencies_all del

4113: group by pd.delinquency_id
4114: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);
4115: cursor c_fully_promised_billto(p_site_use_id number) is
4116: SELECT count(1)
4117: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
4118: WHERE del.customer_site_use_id= p_site_use_id
4119: AND ps.payment_schedule_id = del.payment_schedule_id
4120: AND ps.status = 'OP'
4121: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')

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

4154: l_msg_data VARCHAR2(32767);
4155: errmsg VARCHAR2(32767);
4156: --
4157: nIdx NUMBER := 0;
4158: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
4159: INDEX BY BINARY_INTEGER;
4160: Del_Tbl Del_ID_TBL_TYPE;
4161: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
4162: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 4243: from ar_payment_schedules_all aps,iex_delinquencies_all dd,hz_cust_accounts hzca

4239: where dunning_plan_id = p_dunn_plan_id;
4240:
4241: cursor c_cust_acct_amt_due_rem(p_party_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
4242: select nvl(sum(aps.acctd_amount_due_remaining),0)
4243: from ar_payment_schedules_all aps,iex_delinquencies_all dd,hz_cust_accounts hzca
4244: where dd.payment_schedule_id = aps.payment_schedule_id
4245: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
4246: and aps.status='OP'
4247: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 5264: FROM IEX_DELINQUENCIES_ALL

5260:
5261: IS
5262: CURSOR C_GET_DEL (IN_del_ID NUMBER) IS
5263: SELECT delinquency_ID
5264: FROM IEX_DELINQUENCIES_ALL
5265: WHERE delinquency_ID = in_del_ID;
5266: --
5267: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
5268: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS

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

5378: l_msg_data VARCHAR2(32767);
5379: errmsg VARCHAR2(32767);
5380: --
5381: nIdx NUMBER := 0;
5382: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
5383: INDEX BY BINARY_INTEGER;
5384: Del_Tbl Del_ID_TBL_TYPE;
5385: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
5386: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 6976: --iex_delinquencies_all del

6972: cursor c_amount (IN_ID number) is
6973: select nvl(ps.amount_due_remaining,0),
6974: nvl(ps.invoice_currency_code,'USD')
6975: from ar_payment_schedules_all ps,
6976: --iex_delinquencies_all del
6977: iex_delinquencies del
6978: where ps.payment_schedule_id (+)= del.payment_schedule_id
6979: and del.delinquency_id = in_id;
6980: --

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

7029: l_msg_data VARCHAR2(32767);
7030: errmsg VARCHAR2(32767);
7031: --
7032: nIdx NUMBER := 0;
7033: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
7034: INDEX BY BINARY_INTEGER;
7035: Del_Tbl Del_ID_TBL_TYPE;
7036: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
7037: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 7154: from iex_delinquencies_all

7150: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_type: '|| l_del_object_type);
7151:
7152: if l_del_object_type = 'IEX_INVOICES' then
7153: select payment_schedule_id into l_del_object_id
7154: from iex_delinquencies_all
7155: where delinquency_id = l_delinquency_id;
7156: elsif l_del_object_type = 'IEX_DELINQUENCY' then
7157: l_del_object_id := l_delinquency_id;
7158: end if;

Line 7191: FROM ar_payment_schedules_all ps, iex_delinquencies_all del

7187: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - '||l_score);
7188: -- Start for the bug#8408162 by PNAVEENK
7189: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Start Fully Promise Check');
7190: SELECT count(1) into l_fully_promised
7191: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
7192: WHERE del.delinquency_id= l_delinquency_id
7193: AND ps.payment_schedule_id = del.payment_schedule_id
7194: AND ps.status = 'OP'
7195: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')

Line 8022: --iex_delinquencies_all del

8018: cursor c_amount (IN_ID number) is
8019: select ps.amount_due_remaining,
8020: ps.invoice_currency_code
8021: from ar_payment_schedules_all ps,
8022: --iex_delinquencies_all del
8023: iex_delinquencies del
8024: where ps.payment_schedule_id (+)= del.payment_schedule_id
8025: and del.delinquency_id = in_id;
8026: --

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

8053: l_msg_data VARCHAR2(32767);
8054: errmsg VARCHAR2(32767);
8055: --
8056: nIdx NUMBER := 0;
8057: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
8058: INDEX BY BINARY_INTEGER;
8059: Del_Tbl Del_ID_TBL_TYPE;
8060: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
8061: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 8364: from iex_delinquencies_all

8360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_type: '|| l_del_object_type);
8361:
8362: if l_del_object_type = 'IEX_INVOICES' then
8363: select payment_schedule_id into l_del_object_id
8364: from iex_delinquencies_all
8365: where delinquency_id = l_delinquency_id;
8366: elsif l_del_object_type = 'IEX_DELINQUENCY' then
8367: l_del_object_id := l_delinquency_id;
8368: end if;

Line 8863: update iex_delinquencies_all

8859: END IF;
8860:
8861: /*
8862: if p_dunning_mode <> 'DRAFT' then
8863: update iex_delinquencies_all
8864: set staged_dunning_level = l_stage
8865: where delinquency_id = l_delinquency_id;
8866: end if;
8867: */

Line 9204: from ar_payment_schedules_all aps,iex_delinquencies_all dd,hz_cust_accounts hzca

9200: where dunning_id = p_dunning_id;
9201:
9202: cursor c_cust_acct_amt_due_rem(p_party_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
9203: select nvl(sum(aps.acctd_amount_due_remaining),0)
9204: from ar_payment_schedules_all aps,iex_delinquencies_all dd,hz_cust_accounts hzca
9205: where dd.payment_schedule_id = aps.payment_schedule_id
9206: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
9207: and aps.status='OP'
9208: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

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

9250: l_msg_data VARCHAR2(32767);
9251: errmsg VARCHAR2(32767);
9252: --
9253: nIdx NUMBER := 0;
9254: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
9255: INDEX BY BINARY_INTEGER;
9256: Del_Tbl Del_ID_TBL_TYPE;
9257: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
9258: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

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

10297: l_msg_data VARCHAR2(32767);
10298: errmsg VARCHAR2(32767);
10299: --
10300: nIdx NUMBER := 0;
10301: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
10302: INDEX BY BINARY_INTEGER;
10303: Del_Tbl Del_ID_TBL_TYPE;
10304: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
10305: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 11229: --iex_delinquencies_all del

11225: cursor c_amount (IN_ID number) is
11226: select ps.amount_due_remaining,
11227: ps.invoice_currency_code
11228: from ar_payment_schedules_all ps,
11229: --iex_delinquencies_all del
11230: iex_delinquencies del
11231: where ps.payment_schedule_id (+)= del.payment_schedule_id
11232: and del.delinquency_id = in_id;
11233: --

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

11263: l_msg_data VARCHAR2(32767);
11264: errmsg VARCHAR2(32767);
11265: --
11266: nIdx NUMBER := 0;
11267: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
11268: INDEX BY BINARY_INTEGER;
11269: Del_Tbl Del_ID_TBL_TYPE;
11270: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
11271: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

Line 12022: --iex_delinquencies_all del

12018: cursor c_amount (IN_ID number) is
12019: select ps.amount_due_remaining,
12020: ps.invoice_currency_code
12021: from ar_payment_schedules_all ps,
12022: --iex_delinquencies_all del
12023: iex_delinquencies del
12024: where ps.payment_schedule_id (+)= del.payment_schedule_id
12025: and del.delinquency_id = in_id;
12026: --

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

12051: l_msg_data VARCHAR2(32767);
12052: errmsg VARCHAR2(32767);
12053: --
12054: nIdx NUMBER := 0;
12055: TYPE Del_ID_TBL_type is Table of IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
12056: INDEX BY BINARY_INTEGER;
12057: Del_Tbl Del_ID_TBL_TYPE;
12058: l_bind_tbl IEX_DUNNING_PVT.FULFILLMENT_BIND_TBL;
12059: l_bind_rec IEX_DUNNING_PVT.FULFILLMENT_BIND_REC;

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

16577: ||' and ref.object_id=dun.dunning_id'
16578: ||' and dun.dunning_level='''||p_running_level||'''';
16579:
16580: IF (p_running_level = 'CUSTOMER') THEN
16581: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
16582: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
16583: ||' and dun.dunning_object_id=del.party_cust_id)';
16584: ELSIF(p_running_level = 'ACCOUNT') THEN
16585: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

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

16581: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
16582: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
16583: ||' and dun.dunning_object_id=del.party_cust_id)';
16584: ELSIF(p_running_level = 'ACCOUNT') THEN
16585: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
16586: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
16587: ||' and dun.dunning_object_id=del.cust_account_id)';
16588: ELSIF(p_running_level = 'BILL_TO') THEN
16589: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

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

16585: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
16586: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
16587: ||' and dun.dunning_object_id=del.cust_account_id)';
16588: ELSIF(p_running_level = 'BILL_TO') THEN
16589: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
16590: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
16591: ||' and dun.dunning_object_id=del.customer_site_use_id)';
16592: ELSE
16593: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '

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

16589: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
16590: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
16591: ||' and dun.dunning_object_id=del.customer_site_use_id)';
16592: ELSE
16593: l_task_query:=l_task_query||' and not exists(select 1 from iex_delinquencies_all del '
16594: ||' where del.status in (''DELINQUENT'',''PREDELINQUENT'') '
16595: ||' and dun.dunning_object_id=del.delinquency_id)';
16596: END IF;
16597: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Query: '||l_task_query);

Line 17566: --iex_delinquencies_all del

17562: IS
17563: cursor c_amount (IN_ID number) is
17564: select ps.invoice_currency_code
17565: from ar_payment_schedules_all ps,
17566: --iex_delinquencies_all del
17567: iex_delinquencies del
17568: where ps.payment_schedule_id (+)= del.payment_schedule_id
17569: and del.cust_account_id = in_id;
17570: l_code VARCHAR2(15);

Line 17647: --iex_delinquencies_all del

17643: IS
17644: cursor c_amount (IN_ID number) is
17645: select sum(ps.acctd_amount_due_remaining)
17646: from ar_payment_schedules_all ps,
17647: --iex_delinquencies_all del
17648: iex_delinquencies del
17649: where ps.payment_schedule_id (+)= del.payment_schedule_id
17650: and del.cust_account_id = in_id;
17651: l_sum number;

Line 17984: 'iex_delinquencies_all del, ' ||

17980: 'hz_parties p, ' ||
17981: 'iex_dunnings id, ' ||
17982: 'XDO_TEMPLATES_B xtb, ' ||
17983: 'XDO_TEMPLATES_TL xtvl, ' ||
17984: 'iex_delinquencies_all del, ' ||
17985: 'ar_payment_schedules_all aps ' ||
17986: 'where id.dunning_object_id = del.delinquency_id ' ||
17987: 'and del.payment_Schedule_id = aps.payment_Schedule_id ' ||
17988: 'and del.party_cust_id = p.party_id ' ||