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_FUNDING_PUB dependencies on LNS_LOAN_HEADER_PUB

Line 5101: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

5097: l_loan_status VARCHAR2(30);
5098: l_submit_disb varchar2(1);
5099: l_status_code varchar2(10);
5100: l_funds_reserved_flag varchar2(1);
5101: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5102: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5103:
5104: /*-----------------------------------------------------------------------+
5105: | Cursor Declarations |

Line 5355: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,

5351: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
5352: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
5353: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary status: ' || l_loan_header_rec.SECONDARY_STATUS);
5354:
5355: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
5356: P_LOAN_HEADER_REC => l_loan_header_rec,
5357: P_INIT_MSG_LIST => FND_API.G_FALSE,
5358: X_RETURN_STATUS => l_return_status,
5359: X_MSG_COUNT => l_msg_count,

Line 5504: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

5500: l_agreement_reason varchar2(500);
5501:
5502: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5503: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5504: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5505: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5506: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5507: l_event_table lns_distributions_pub.acc_event_tbl;
5508: l_funded_lines_count number;

Line 6100: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,

6096: LogMessage(FND_LOG.LEVEL_STATEMENT, 'funded_amount: ' || l_loan_header_rec.funded_amount);
6097: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
6098: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary_status: ' || l_loan_header_rec.secondary_status);
6099:
6100: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
6101: P_LOAN_HEADER_REC => l_loan_header_rec,
6102: P_INIT_MSG_LIST => FND_API.G_FALSE,
6103: X_RETURN_STATUS => l_return_status,
6104: X_MSG_COUNT => l_msg_count,

Line 6142: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,

6138: LogMessage(FND_LOG.LEVEL_STATEMENT, 'funded_amount: ' || l_loan_header_rec.funded_amount);
6139: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
6140: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary_status: ' || l_loan_header_rec.secondary_status);
6141:
6142: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
6143: P_LOAN_HEADER_REC => l_loan_header_rec,
6144: P_INIT_MSG_LIST => FND_API.G_FALSE,
6145: X_RETURN_STATUS => l_return_status,
6146: X_MSG_COUNT => l_msg_count,

Line 6265: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,

6261: LogMessage(FND_LOG.LEVEL_STATEMENT, 'funded_amount: ' || l_loan_header_rec.funded_amount);
6262: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
6263: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary status: ' || l_loan_header_rec.SECONDARY_STATUS);
6264:
6265: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
6266: P_LOAN_HEADER_REC => l_loan_header_rec,
6267: P_INIT_MSG_LIST => FND_API.G_FALSE,
6268: X_RETURN_STATUS => l_return_status,
6269: X_MSG_COUNT => l_msg_count,

Line 7193: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

7189: l_loan_version number;
7190: l_submitted_disb_count number;
7191: l_current_phase varchar2(30);
7192:
7193: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
7194: l_event_table lns_distributions_pub.acc_event_tbl;
7195:
7196: /*-----------------------------------------------------------------------+
7197: | Cursor Declarations |

Line 7313: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,

7309: LogMessage(FND_LOG.LEVEL_STATEMENT, 'loan_id: ' || l_loan_header_rec.loan_id);
7310: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
7311: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary status: ' || l_loan_header_rec.SECONDARY_STATUS);
7312:
7313: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
7314: P_LOAN_HEADER_REC => l_loan_header_rec,
7315: P_INIT_MSG_LIST => FND_API.G_FALSE,
7316: X_RETURN_STATUS => l_return_status,
7317: X_MSG_COUNT => l_msg_count,

Line 7446: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

7442: l_msg_count NUMBER;
7443: l_msg_data VARCHAR2(32767);
7444: l_loan_version number;
7445:
7446: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
7447:
7448: /*-----------------------------------------------------------------------+
7449: | Cursor Declarations |
7450: +-----------------------------------------------------------------------*/

Line 7517: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,

7513: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
7514: LogMessage(FND_LOG.LEVEL_STATEMENT, 'loan_id: ' || l_loan_header_rec.loan_id);
7515: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
7516:
7517: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
7518: P_LOAN_HEADER_REC => l_loan_header_rec,
7519: P_INIT_MSG_LIST => FND_API.G_FALSE,
7520: X_RETURN_STATUS => l_return_status,
7521: X_MSG_COUNT => l_msg_count,

Line 7633: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

7629: l_msg_data VARCHAR2(32767);
7630: l_loan_version number;
7631: l_approve_flag varchar2(1);
7632:
7633: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
7634:
7635: /*-----------------------------------------------------------------------+
7636: | Cursor Declarations |
7637: +-----------------------------------------------------------------------*/

Line 7699: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,

7695: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
7696: LogMessage(FND_LOG.LEVEL_STATEMENT, 'loan_id: ' || l_loan_header_rec.loan_id);
7697: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
7698:
7699: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
7700: P_LOAN_HEADER_REC => l_loan_header_rec,
7701: P_INIT_MSG_LIST => FND_API.G_FALSE,
7702: X_RETURN_STATUS => l_return_status,
7703: X_MSG_COUNT => l_msg_count,

Line 8737: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

8733: l_msg_count NUMBER;
8734: l_msg_data VARCHAR2(32767);
8735: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8736: l_loan_version number;
8737: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8738: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;
8739: l_BANK_ACC_USE_ID number;
8740: l_funding_advice_id number;
8741: l_loan_class varchar2(80);

Line 8939: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

8935: l_request_status boolean;
8936: l_do_billing number;
8937:
8938: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
8939: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8940: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
8941:
8942: /*-----------------------------------------------------------------------+
8943: | Cursor Declarations |

Line 9275: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

9271: l_found boolean;
9272:
9273: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
9274: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
9275: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
9276: l_ids_tbl DBMS_SQL.NUMBER_TABLE;
9277:
9278: /*-----------------------------------------------------------------------+
9279: | Cursor Declarations |

Line 9528: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

9524: l_loan_status varchar2(30);
9525: l_SECONDARY_STATUS varchar2(30);
9526: l_current_phase varchar2(30);
9527:
9528: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
9529:
9530: /*-----------------------------------------------------------------------+
9531: | Cursor Declarations |
9532: +-----------------------------------------------------------------------*/

Line 9621: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,

9617:
9618: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
9619: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary status: ' || l_loan_header_rec.SECONDARY_STATUS);
9620:
9621: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
9622: P_LOAN_HEADER_REC => l_loan_header_rec,
9623: P_INIT_MSG_LIST => FND_API.G_FALSE,
9624: X_RETURN_STATUS => l_return_status,
9625: X_MSG_COUNT => l_msg_count,