DBA Data[Home] [Help]

APPS.LNS_FUNDING_PUB dependencies on LNS_LOAN_HEADER_PUB

Line 4865: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

4861: l_loan_status VARCHAR2(30);
4862: l_submit_disb varchar2(1);
4863: l_status_code varchar2(10);
4864: l_funds_reserved_flag varchar2(1);
4865: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4866: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
4867:
4868: /*-----------------------------------------------------------------------+
4869: | Cursor Declarations |

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

5093: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
5094: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
5095: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary status: ' || l_loan_header_rec.SECONDARY_STATUS);
5096:
5097: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
5098: P_LOAN_HEADER_REC => l_loan_header_rec,
5099: P_INIT_MSG_LIST => FND_API.G_FALSE,
5100: X_RETURN_STATUS => l_return_status,
5101: X_MSG_COUNT => l_msg_count,

Line 5221: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

5217:
5218:
5219: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5220: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5221: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5222: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5223: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5224: l_event_table lns_distributions_pub.acc_event_tbl;
5225: l_funded_lines_count number;

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

5622: LogMessage(FND_LOG.LEVEL_STATEMENT, 'funded_amount: ' || l_loan_header_rec.funded_amount);
5623: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
5624: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary_status: ' || l_loan_header_rec.secondary_status);
5625:
5626: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
5627: P_LOAN_HEADER_REC => l_loan_header_rec,
5628: P_INIT_MSG_LIST => FND_API.G_FALSE,
5629: X_RETURN_STATUS => l_return_status,
5630: X_MSG_COUNT => l_msg_count,

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

5730: LogMessage(FND_LOG.LEVEL_STATEMENT, 'funded_amount: ' || l_loan_header_rec.funded_amount);
5731: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
5732: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary_status: ' || l_loan_header_rec.secondary_status);
5733:
5734: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
5735: P_LOAN_HEADER_REC => l_loan_header_rec,
5736: P_INIT_MSG_LIST => FND_API.G_FALSE,
5737: X_RETURN_STATUS => l_return_status,
5738: X_MSG_COUNT => l_msg_count,

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

5940: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OPEN_MATURITY_DATE: ' || l_loan_header_rec.OPEN_MATURITY_DATE);
5941: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE: ' || l_loan_header_rec.loan_start_date);
5942: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MATURITY_DATE: ' || l_loan_header_rec.loan_maturity_date);
5943:
5944: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
5945: P_LOAN_HEADER_REC => l_loan_header_rec,
5946: P_INIT_MSG_LIST => FND_API.G_FALSE,
5947: X_RETURN_STATUS => l_return_status,
5948: X_MSG_COUNT => l_msg_count,

Line 6736: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

6732: l_disb_header_id number;
6733: l_loan_version number;
6734: l_submitted_disb_count number;
6735:
6736: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
6737: l_event_table lns_distributions_pub.acc_event_tbl;
6738:
6739: /*-----------------------------------------------------------------------+
6740: | Cursor Declarations |

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

6830: LogMessage(FND_LOG.LEVEL_STATEMENT, 'loan_id: ' || l_loan_header_rec.loan_id);
6831: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
6832: LogMessage(FND_LOG.LEVEL_STATEMENT, 'secondary status: ' || l_loan_header_rec.SECONDARY_STATUS);
6833:
6834: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
6835: P_LOAN_HEADER_REC => l_loan_header_rec,
6836: P_INIT_MSG_LIST => FND_API.G_FALSE,
6837: X_RETURN_STATUS => l_return_status,
6838: X_MSG_COUNT => l_msg_count,

Line 6965: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

6961: l_msg_count NUMBER;
6962: l_msg_data VARCHAR2(32767);
6963: l_loan_version number;
6964:
6965: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
6966:
6967: /*-----------------------------------------------------------------------+
6968: | Cursor Declarations |
6969: +-----------------------------------------------------------------------*/

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

7032: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
7033: LogMessage(FND_LOG.LEVEL_STATEMENT, 'loan_id: ' || l_loan_header_rec.loan_id);
7034: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
7035:
7036: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
7037: P_LOAN_HEADER_REC => l_loan_header_rec,
7038: P_INIT_MSG_LIST => FND_API.G_FALSE,
7039: X_RETURN_STATUS => l_return_status,
7040: X_MSG_COUNT => l_msg_count,

Line 7152: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

7148: l_msg_data VARCHAR2(32767);
7149: l_loan_version number;
7150: l_approve_flag varchar2(1);
7151:
7152: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
7153:
7154: /*-----------------------------------------------------------------------+
7155: | Cursor Declarations |
7156: +-----------------------------------------------------------------------*/

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

7214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
7215: LogMessage(FND_LOG.LEVEL_STATEMENT, 'loan_id: ' || l_loan_header_rec.loan_id);
7216: LogMessage(FND_LOG.LEVEL_STATEMENT, 'status: ' || l_loan_header_rec.LOAN_STATUS);
7217:
7218: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_loan_version,
7219: P_LOAN_HEADER_REC => l_loan_header_rec,
7220: P_INIT_MSG_LIST => FND_API.G_FALSE,
7221: X_RETURN_STATUS => l_return_status,
7222: X_MSG_COUNT => l_msg_count,

Line 8235: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

8231: l_msg_count NUMBER;
8232: l_msg_data VARCHAR2(32767);
8233: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8234: l_loan_version number;
8235: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8236: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;
8237: l_BANK_ACC_USE_ID number;
8238: l_funding_advice_id number;
8239: l_loan_class varchar2(80);

Line 8437: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

8433: l_request_status boolean;
8434: l_do_billing number;
8435:
8436: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
8437: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8438: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
8439:
8440: /*-----------------------------------------------------------------------+
8441: | Cursor Declarations |