DBA Data[Home] [Help]

APPS.LNS_PAYOFF_PUB dependencies on LNS_LOAN_HEADER_PUB

Line 128: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header

124: l_receipt_amount_from number; -- in receipt currency
125: l_trans_to_receipt_rate number;
126: l_bool_match boolean;
127:
128: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
129:
130: cursor c_receipt_number(p_cash_receipt_id number) is
131: select receipt_number, currency_code
132: from ar_cash_receipts

Line 2323: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header

2319: l_precision number;
2320: l_disable_billing varchar2(1);
2321: l_version_number number;
2322: l_description varchar2(30);
2323: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
2324:
2325: CURSOR precision_cur(P_LOAN_ID number) IS
2326: select curr.precision
2327: from fnd_currencies curr,

Line 2557: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

2553: l_loan_header_rec.loan_id := P_LOAN_ID;
2554: l_loan_header_rec.DISABLE_BILLING_FLAG := 'Y';
2555:
2556: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
2557: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
2558: P_LOAN_HEADER_REC => l_loan_header_rec,
2559: P_INIT_MSG_LIST => FND_API.G_FALSE,
2560: X_RETURN_STATUS => l_return_status,
2561: X_MSG_COUNT => l_msg_count,

Line 2647: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header

2643: l_TRX_DATE date;
2644:
2645: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
2646: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
2647: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
2648: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;
2649: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
2650: l_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;
2651:

Line 2935: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

2931:
2932: l_loan_header_rec.loan_id := l_loan_id;
2933: l_loan_header_rec.DISABLE_BILLING_FLAG := 'N';
2934:
2935: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
2936: P_LOAN_HEADER_REC => l_loan_header_rec,
2937: P_INIT_MSG_LIST => FND_API.G_FALSE,
2938: X_RETURN_STATUS => l_return_status,
2939: X_MSG_COUNT => l_msg_count,

Line 3118: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

3114: l_loan_header_rec.SECONDARY_STATUS := FND_API.G_MISS_CHAR;
3115: l_loan_header_rec.DISABLE_BILLING_FLAG := 'N';
3116:
3117: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
3118: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
3119: P_LOAN_HEADER_REC => l_loan_header_rec,
3120: P_INIT_MSG_LIST => FND_API.G_FALSE,
3121: X_RETURN_STATUS => l_return_status,
3122: X_MSG_COUNT => l_msg_count,

Line 3182: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header

3178: l_msg_data VARCHAR2(32767);
3179: l_loan_id number;
3180: l_version_number number;
3181:
3182: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
3183:
3184: CURSOR loan_version_cur(p_LOAN_CANCELLATION_ID number) IS
3185: select loan.LOAN_ID, loan.OBJECT_VERSION_NUMBER
3186: from LNS_LOAN_HEADERS loan, LNS_LOAN_CANCELLATIONS cncl

Line 3245: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

3241: l_loan_header_rec.loan_id := l_loan_id;
3242: l_loan_header_rec.DISABLE_BILLING_FLAG := 'N';
3243:
3244: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
3245: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
3246: P_LOAN_HEADER_REC => l_loan_header_rec,
3247: P_INIT_MSG_LIST => FND_API.G_FALSE,
3248: X_RETURN_STATUS => l_return_status,
3249: X_MSG_COUNT => l_msg_count,