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.LNS_PARTICIPANTS_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 160: P_TABLE_NAME => 'LNS_LOAN_HEADERS_ALL');

156: X_MSG_DATA => l_msg_data,
157: X_RETURN_STATUS => l_return_status,
158: P_COL_ID => l_loan_id,
159: P_COL_NAME => 'LOAN_ID',
160: P_TABLE_NAME => 'LNS_LOAN_HEADERS_ALL');
161: --dbms_output.put_line('output');
162:
163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
164: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

Line 386: from lns_loan_products_all prod, lns_loan_headers_all loan

382:
383: CURSOR c_get_credit_info(p_loan_id number) IS
384: select loan.party_type, loan.credit_review_flag, prod.credit_review_type,
385: prod.guarantor_review_type, loan.loan_status, loan.secondary_status
386: from lns_loan_products_all prod, lns_loan_headers_all loan
387: where loan.loan_id = p_loan_id
388: and prod.loan_product_id = loan.product_id;
389:
390: CURSOR c_get_party_type(p_party_id number) IS

Line 764: LNS_LOAN_HEADERS_ALL

760:
761: CURSOR C_GET_LOAN_OVN(pLoanId Number) IS
762: SELECT OBJECT_VERSION_NUMBER
763: FROM
764: LNS_LOAN_HEADERS_ALL
765: WHERE LOAN_ID = pLoanId;
766:
767: BEGIN
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

Line 912: from lns_loan_headers_all

908: l_credit_classification varchar2(30);
909:
910: CURSOR c_get_loan_info(p_loan_id NUMBER) IS
911: select org_id,credit_review_flag,loan_number,requested_amount,loan_currency,loan_description,loan_status,secondary_status
912: from lns_loan_headers_all
913: where loan_id = p_loan_id;
914:
915: BEGIN
916:

Line 1176: LNS_LOAN_HEADERS_ALL

1172:
1173: CURSOR C_GET_LOAN_OVN(pLoanId Number) IS
1174: SELECT OBJECT_VERSION_NUMBER
1175: FROM
1176: LNS_LOAN_HEADERS_ALL
1177: WHERE LOAN_ID = pLoanId;
1178:
1179: BEGIN
1180: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

Line 1266: LNS_LOAN_HEADERS_ALL

1262:
1263: CURSOR C_GET_LOAN_OVN(pLoanId Number) IS
1264: SELECT OBJECT_VERSION_NUMBER
1265: FROM
1266: LNS_LOAN_HEADERS_ALL
1267: WHERE LOAN_ID = pLoanId;
1268:
1269: l_primary_credit_request_id number;
1270: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

Line 1369: from lns_loan_headers_all

1365: l_api_name CONSTANT VARCHAR2(30) := 'CASE_FOLDER_UPDATE';
1366:
1367: CURSOR check_loan_sec_status(pLoanId Number) is
1368: select secondary_status
1369: from lns_loan_headers_all
1370: where loan_id = pLoanId;
1371:
1372: CURSOR check_case_folder_complete(pLoanId Number) is
1373: select count(case.case_folder_id)

Line 1438: p_table_name => 'LNS_LOAN_HEADERS_ALL'

1434: --Call to record history
1435: LNS_LOAN_HISTORY_PUB.log_record_pre(
1436: p_id => p_loan_id,
1437: p_primary_key_name => 'LOAN_ID',
1438: p_table_name => 'LNS_LOAN_HEADERS_ALL'
1439: );
1440:
1441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_loan_headers_all to update new secondary status');

Line 1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_loan_headers_all to update new secondary status');

1438: p_table_name => 'LNS_LOAN_HEADERS_ALL'
1439: );
1440:
1441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_loan_headers_all to update new secondary status');
1443: END IF;
1444:
1445: UPDATE LNS_LOAN_HEADERS_ALL
1446: SET SECONDARY_STATUS = 'CREDIT_REVIEW_COMPLETE',

Line 1445: UPDATE LNS_LOAN_HEADERS_ALL

1441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_loan_headers_all to update new secondary status');
1443: END IF;
1444:
1445: UPDATE LNS_LOAN_HEADERS_ALL
1446: SET SECONDARY_STATUS = 'CREDIT_REVIEW_COMPLETE',
1447: LAST_UPDATED_BY = l_user_id,
1448: LAST_UPDATE_LOGIN = l_login_id,
1449: LAST_UPDATE_DATE = l_date,

Line 1455: WHERE loan_id = LNS_LOAN_HEADERS_ALL.loan_id and hz_party_id = LNS_LOAN_HEADERS_ALL.primary_borrower_id);

1451: WHERE LOAN_ID = p_loan_id
1452: AND SECONDARY_STATUS = 'IN_CREDIT_REVIEW'
1453: AND EXISTS (SELECT case_folder_id
1454: FROM LNS_PARTICIPANTS
1455: WHERE loan_id = LNS_LOAN_HEADERS_ALL.loan_id and hz_party_id = LNS_LOAN_HEADERS_ALL.primary_borrower_id);
1456:
1457: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_loan_headers_all to update new secondary status');
1459: END IF;

Line 1458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_loan_headers_all to update new secondary status');

1454: FROM LNS_PARTICIPANTS
1455: WHERE loan_id = LNS_LOAN_HEADERS_ALL.loan_id and hz_party_id = LNS_LOAN_HEADERS_ALL.primary_borrower_id);
1456:
1457: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_loan_headers_all to update new secondary status');
1459: END IF;
1460:
1461: --Call to record history
1462: LNS_LOAN_HISTORY_PUB.log_record_post(

Line 1465: p_table_name => 'LNS_LOAN_HEADERS_ALL',

1461: --Call to record history
1462: LNS_LOAN_HISTORY_PUB.log_record_post(
1463: p_id => p_loan_id,
1464: p_primary_key_name => 'LOAN_ID',
1465: p_table_name => 'LNS_LOAN_HEADERS_ALL',
1466: p_loan_id => p_loan_id
1467: );
1468:
1469: COMMIT WORK;

Line 1529: LNS_LOAN_HEADERS_ALL

1525:
1526: CURSOR C_GET_LOAN_OVN(pLoanId Number) IS
1527: SELECT OBJECT_VERSION_NUMBER
1528: FROM
1529: LNS_LOAN_HEADERS_ALL
1530: WHERE LOAN_ID = pLoanId;
1531:
1532: BEGIN
1533: