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.

[Home] [Help]

APPS.IEX_WF_BAN_STATUS_PUB dependencies on IEX_BANKRUPTCIES

Line 18: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

14:
15:
16: cursor c_get_party_status(c_party_id number, c_date date) Is
17:
18: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
19: where party_id = c_party_id
20: and nvl(attribute15,'A') <> 'ACCOUNT'
21: and trunc(creation_date) <= c_date
22: and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')

Line 26: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

22: and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')
23:
24: UNION
25:
26: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
27: where party_id = c_party_id
28: and nvl(attribute15,'A') <> 'ACCOUNT'
29: and trunc(creation_date) <= c_date
30: and nvl(disposition_code,'A') = 'DISMISSED'

Line 35: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

31: and trunc(nvl(dismissal_date,last_update_date)) > c_date
32:
33: UNION
34:
35: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
36: where party_id = c_party_id
37: and nvl(attribute15,'A') <> 'ACCOUNT'
38: and trunc(creation_date) <= c_date
39: and nvl(disposition_code,'A') = 'WITHDRAWN'

Line 47: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

43:
44:
45: cursor c_get_acct_status (c_party_id number,c_cust_account_id number,c_date date) Is
46:
47: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
48: where party_id = c_party_id
49: and nvl(cust_account_id,-1) = c_cust_account_id
50: and nvl(attribute15,'A') = 'ACCOUNT'
51: and trunc(creation_date) <= c_date

Line 56: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

52: and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')
53:
54: UNION
55:
56: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
57: where party_id = c_party_id
58: and nvl(cust_account_id,-1) = c_cust_account_id
59: and nvl(attribute15,'A') = 'ACCOUNT'
60: and trunc(creation_date) <= c_date

Line 66: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

62: and trunc(nvl(dismissal_date,last_update_date)) > c_date
63:
64: UNION
65:
66: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
67: where party_id = c_party_id
68: and nvl(cust_account_id,-1) = c_cust_account_id
69: and nvl(attribute15,'A') = 'ACCOUNT'
70: and trunc(creation_date) <= c_date

Line 153: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

149: p_cust_account_id IN NUMBER,
150: p_date IN DATE) RETURN VARCHAR2 AS
151:
152: cursor c_get_flag(c_party_id number, c_cust_account_id number,c_date date) Is
153: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
154: where party_id = c_party_id
155: and nvl(cust_account_id,c_cust_account_id) = c_cust_account_id
156: and trunc(creation_date) <= c_date
157: and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')

Line 159: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

155: and nvl(cust_account_id,c_cust_account_id) = c_cust_account_id
156: and trunc(creation_date) <= c_date
157: and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')
158: UNION
159: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
160: where party_id = c_party_id
161: and nvl(cust_account_id,c_cust_account_id) = c_cust_account_id
162: and trunc(creation_date) <= c_date
163: and nvl(disposition_code,'A') = 'DISMISSED'

Line 166: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

162: and trunc(creation_date) <= c_date
163: and nvl(disposition_code,'A') = 'DISMISSED'
164: and trunc(nvl(dismissal_date,last_update_date)) > c_date
165: UNION
166: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
167: where party_id = c_party_id
168: and nvl(cust_account_id,c_cust_account_id) = c_cust_account_id
169: and trunc(creation_date) <= c_date
170: and nvl(disposition_code,'A') = 'WITHDRAWN'

Line 173: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

169: and trunc(creation_date) <= c_date
170: and nvl(disposition_code,'A') = 'WITHDRAWN'
171: and trunc(nvl(withdraw_date,last_update_date)) > c_date
172: UNION
173: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
174: where party_id = c_party_id
175: and trunc(creation_date) <= c_date
176: and nvl(attribute15,'A') = 'PARTY'
177: and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')

Line 179: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

175: and trunc(creation_date) <= c_date
176: and nvl(attribute15,'A') = 'PARTY'
177: and nvl(disposition_code,'A') not in ('DISMISSED' , 'WITHDRAWN')
178: UNION
179: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
180: where party_id = c_party_id
181: and trunc(creation_date) <= c_date
182: and nvl(attribute15,'A') = 'PARTY'
183: and nvl(disposition_code,'A') = 'DISMISSED'

Line 186: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies

182: and nvl(attribute15,'A') = 'PARTY'
183: and nvl(disposition_code,'A') = 'DISMISSED'
184: and trunc(nvl(dismissal_date,last_update_date)) > c_date
185: UNION
186: select bankruptcy_id,turn_off_invoicing_yn from iex_bankruptcies
187: where party_id = c_party_id
188: and trunc(creation_date) <= c_date
189: and nvl(attribute15,'A') = 'PARTY'
190: and NVL(disposition_code,'A') = 'WITHDRAWN'

Line 361: from iex_delinquencies d, iex_bankruptcies b

357: end;
358: /*
359: select b.bankruptcy_id bankruptcy_id
360: into l_bankruptcy_id
361: from iex_delinquencies d, iex_bankruptcies b
362: where d.delinquency_id = b.delinquency_id
363: and d.delinquency_id = p_delinquency_id;
364: */
365: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 372: from iex_bankruptcies

368:
369: /*
370: select bankruptcy_id bankruptcy_id
371: into l_bankruptcy_id
372: from iex_bankruptcies
373: where party_id= p_party_id
374: and DISPOSITION_CODE is NULL;
375: */
376:

Line 380: where exists (select 1 from iex_bankruptcies bk where bankruptcy_id = p_bankruptcy_id

376:
377: -- bug 15935804 begin...
378: begin
379: select account_number into l_account_number from hz_cust_accounts hc
380: where exists (select 1 from iex_bankruptcies bk where bankruptcy_id = p_bankruptcy_id
381: and attribute15 = 'ACCOUNT' and hc.cust_account_id = bk.cust_account_id);
382: exception
383: when others then null;
384: end;

Line 661: update IEX_BANKRUPTCIES set approval_date = sysdate

657: result := 'COMPLETE';
658:
659: -- bug 14637604
660: begin
661: update IEX_BANKRUPTCIES set approval_date = sysdate
662: where bankruptcy_id = l_bankruptcy_id;
663:
664: commit;
665: exception

Line 733: select attribute15,cust_account_id into l_att15,l_cust_account_id from iex_bankruptcies where bankruptcy_id = l_bankruptcy_id;

729: aname => 'BANKRUPTCY_ID');
730:
731: -- bug 14637604
732: begin
733: select attribute15,cust_account_id into l_att15,l_cust_account_id from iex_bankruptcies where bankruptcy_id = l_bankruptcy_id;
734: exception
735: when others then
736: iex_debug_pub.logmessage('IEX-Rejct Attribute15 Exception....');
737: end;

Line 743: update IEX_BANKRUPTCIES set DISPOSITION_CODE = 'WITHDRAWN',WITHDRAW_DATE = sysdate

739: begin
740: iex_debug_pub.logmessage('IEX-Reject Bankruptcy partyid ..'||l_party_id);
741: -- bug 14637604
742: if (l_att15 is not null and l_cust_account_id is not null) then
743: update IEX_BANKRUPTCIES set DISPOSITION_CODE = 'WITHDRAWN',WITHDRAW_DATE = sysdate
744: where bankruptcy_id = l_bankruptcy_id;
745: else
746: update IEX_BANKRUPTCIES
747: set DISPOSITION_CODE = 'WITHDRAWN',WITHDRAW_DATE = sysdate

Line 746: update IEX_BANKRUPTCIES

742: if (l_att15 is not null and l_cust_account_id is not null) then
743: update IEX_BANKRUPTCIES set DISPOSITION_CODE = 'WITHDRAWN',WITHDRAW_DATE = sysdate
744: where bankruptcy_id = l_bankruptcy_id;
745: else
746: update IEX_BANKRUPTCIES
747: set DISPOSITION_CODE = 'WITHDRAWN',WITHDRAW_DATE = sysdate
748: where party_id = l_party_id;
749: -- bug 14637604 and disposition_code is null;
750: end if;

Line 1112: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;

1108: l_del_id NUMBER;
1109: l_del_count NUMBER;
1110: l_ban_id NUMBER;
1111:
1112: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;
1113: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type
1114: INDEX BY BINARY_INTEGER;
1115: bankruptcy_TBL bankruptcy_Tbl_Type;
1116:

Line 1113: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type

1109: l_del_count NUMBER;
1110: l_ban_id NUMBER;
1111:
1112: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;
1113: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type
1114: INDEX BY BINARY_INTEGER;
1115: bankruptcy_TBL bankruptcy_Tbl_Type;
1116:
1117: BEGIN

Line 1195: IEX_BANKRUPTCIES_PVT.Create_bankruptcy(

1191: bankruptcy_REC.Cas_id := l_cas_id;
1192: bankruptcy_REC.delinquency_id := l_del_id;
1193: bankruptcy_REC.party_id := l_party_id;
1194:
1195: IEX_BANKRUPTCIES_PVT.Create_bankruptcy(
1196: P_Api_Version_Number => l_api_version_number,
1197: P_Init_Msg_List => l_init_msg_list,
1198: P_Commit => l_commit,
1199: p_validation_level => l_validation_level,

Line 1298: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;

1294: l_del_id NUMBER;
1295: l_del_count NUMBER;
1296: l_ban_id NUMBER;
1297:
1298: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;
1299: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type
1300: INDEX BY BINARY_INTEGER;
1301: bankruptcy_TBL bankruptcy_Tbl_Type;
1302:

Line 1299: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type

1295: l_del_count NUMBER;
1296: l_ban_id NUMBER;
1297:
1298: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;
1299: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type
1300: INDEX BY BINARY_INTEGER;
1301: bankruptcy_TBL bankruptcy_Tbl_Type;
1302:
1303: P_ObjectType VARCHAR2(30);

Line 1384: IEX_BANKRUPTCIES_PVT.Create_bankruptcy(

1380: bankruptcy_REC.Cas_id := l_cas_id;
1381: bankruptcy_REC.delinquency_id := l_del_id;
1382: bankruptcy_REC.party_id := l_party_id;
1383:
1384: IEX_BANKRUPTCIES_PVT.Create_bankruptcy(
1385: P_Api_Version_Number => l_api_version_number,
1386: P_Init_Msg_List => l_init_msg_list,
1387: P_Commit => l_commit,
1388: p_validation_level => l_validation_level,

Line 1508: from iex_bankruptcies

1504: */
1505:
1506: select disposition_code
1507: into l_disposition_code
1508: from iex_bankruptcies
1509: where bankruptcy_id = p_bankruptcy_id;
1510:
1511: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1512: IEX_DEBUG_PUB.logMessage('Create_Strategy : l_disposition_code := ' ||l_disposition_code);

Line 1756: SELECT nvl(TURN_OFF_INVOICING_YN,'N') FROM iex_bankruptcies

1752: l_bankruptcy_id number;
1753: l_notify VARCHAR2(1);
1754:
1755: CURSOR c_notify(p_bankruptcy_id NUMBER) IS
1756: SELECT nvl(TURN_OFF_INVOICING_YN,'N') FROM iex_bankruptcies
1757: WHERE bankruptcy_id = p_bankruptcy_id;
1758:
1759: BEGIN
1760: