DBA Data[Home] [Help]

APPS.LNS_LOAN_LINE_PUB dependencies on LNS_UTILITY_PUB

Line 90: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

86: SET REC_ADJUSTMENT_NUMBER = p_rec_adjustment_number,
87: REC_ADJUSTMENT_ID = p_rec_adjustment_id,
88: PAYMENT_SCHEDULE_ID = p_payment_schedule_id,
89: INSTALLMENT_NUMBER = p_installment_number,
90: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
91: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
92: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
93: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
94: WHERE LOAN_LINE_ID = p_loan_line_id

Line 91: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,

87: REC_ADJUSTMENT_ID = p_rec_adjustment_id,
88: PAYMENT_SCHEDULE_ID = p_payment_schedule_id,
89: INSTALLMENT_NUMBER = p_installment_number,
90: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
91: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
92: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
93: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
94: WHERE LOAN_LINE_ID = p_loan_line_id
95: AND LOAN_ID = p_loan_id;

Line 92: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

88: PAYMENT_SCHEDULE_ID = p_payment_schedule_id,
89: INSTALLMENT_NUMBER = p_installment_number,
90: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
91: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
92: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
93: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
94: WHERE LOAN_LINE_ID = p_loan_line_id
95: AND LOAN_ID = p_loan_id;
96:

Line 366: l_user_id := LNS_UTILITY_PUB.created_by;

362: l_party_id := p_primary_borrower_id;
363: l_currency_code := p_currency_code;
364: l_org_id := p_org_id;
365: l_loan_product_id := p_loan_product_id;
366: l_user_id := LNS_UTILITY_PUB.created_by;
367: l_login_id := LNS_UTILITY_PUB.last_update_login;
368: l_date := sysdate;
369: l_loan_line_exists := 'N';
370:

Line 367: l_login_id := LNS_UTILITY_PUB.last_update_login;

363: l_currency_code := p_currency_code;
364: l_org_id := p_org_id;
365: l_loan_product_id := p_loan_product_id;
366: l_user_id := LNS_UTILITY_PUB.created_by;
367: l_login_id := LNS_UTILITY_PUB.last_update_login;
368: l_date := sysdate;
369: l_loan_line_exists := 'N';
370:
371: open c_check_existing_line(l_loan_id);