APPS.IEX_WF_BAN_STATUS_PUB dependencies on IEX_BANKRUPTCIES

Line 146: from iex_delinquencies d, iex_bankruptcies b

142: end;
143: /*
144: select b.bankruptcy_id bankruptcy_id
145: into l_bankruptcy_id
146: from iex_delinquencies d, iex_bankruptcies b
147: where d.delinquency_id = b.delinquency_id
148: and d.delinquency_id = p_delinquency_id;
149: */
150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 157: from iex_bankruptcies

153:
154: /*
155: select bankruptcy_id bankruptcy_id
156: into l_bankruptcy_id
157: from iex_bankruptcies
158: where party_id= p_party_id
159: and DISPOSITION_CODE is NULL;
160: */
161:

Line 473: update IEX_BANKRUPTCIES

469:
470: iex_debug_pub.logmessage('IEX-Reject Bankruptcy partyid ..'||l_party_id);
471: -- fixed a bug 5261811
472: begin
473: update IEX_BANKRUPTCIES
474: set DISPOSITION_CODE = 'WITHDRAWN'
475: where party_id = l_party_id
476: --and delinquency_id = l_delinquency_id
477: and disposition_code is null;

Line 838: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;

834: l_del_id NUMBER;
835: l_del_count NUMBER;
836: l_ban_id NUMBER;
837:
838: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;
839: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type
840: INDEX BY BINARY_INTEGER;
841: bankruptcy_TBL bankruptcy_Tbl_Type;
842:

Line 839: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type

835: l_del_count NUMBER;
836: l_ban_id NUMBER;
837:
838: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;
839: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type
840: INDEX BY BINARY_INTEGER;
841: bankruptcy_TBL bankruptcy_Tbl_Type;
842:
843: BEGIN

Line 921: IEX_BANKRUPTCIES_PVT.Create_bankruptcy(

917: bankruptcy_REC.Cas_id := l_cas_id;
918: bankruptcy_REC.delinquency_id := l_del_id;
919: bankruptcy_REC.party_id := l_party_id;
920:
921: IEX_BANKRUPTCIES_PVT.Create_bankruptcy(
922: P_Api_Version_Number => l_api_version_number,
923: P_Init_Msg_List => l_init_msg_list,
924: P_Commit => l_commit,
925: p_validation_level => l_validation_level,

Line 1024: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;

1020: l_del_id NUMBER;
1021: l_del_count NUMBER;
1022: l_ban_id NUMBER;
1023:
1024: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;
1025: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type
1026: INDEX BY BINARY_INTEGER;
1027: bankruptcy_TBL bankruptcy_Tbl_Type;
1028:

Line 1025: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type

1021: l_del_count NUMBER;
1022: l_ban_id NUMBER;
1023:
1024: bankruptcy_REC IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type;
1025: TYPE bankruptcy_Tbl_Type IS TABLE OF IEX_BANKRUPTCIES_PVT.bankruptcy_Rec_Type
1026: INDEX BY BINARY_INTEGER;
1027: bankruptcy_TBL bankruptcy_Tbl_Type;
1028:
1029: P_ObjectType VARCHAR2(30);

Line 1110: IEX_BANKRUPTCIES_PVT.Create_bankruptcy(

1106: bankruptcy_REC.Cas_id := l_cas_id;
1107: bankruptcy_REC.delinquency_id := l_del_id;
1108: bankruptcy_REC.party_id := l_party_id;
1109:
1110: IEX_BANKRUPTCIES_PVT.Create_bankruptcy(
1111: P_Api_Version_Number => l_api_version_number,
1112: P_Init_Msg_List => l_init_msg_list,
1113: P_Commit => l_commit,
1114: p_validation_level => l_validation_level,

Line 1234: from iex_bankruptcies

1230: */
1231:
1232: select disposition_code
1233: into l_disposition_code
1234: from iex_bankruptcies
1235: where bankruptcy_id = p_bankruptcy_id;
1236:
1237: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1238: IEX_DEBUG_PUB.logMessage('Create_Strategy : l_disposition_code := ' ||l_disposition_code);