APPS.LNS_LOAN_LINE_PUB dependencies on LNS_UTILITY_PUB

Line 92: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

88: SET REC_ADJUSTMENT_NUMBER = p_rec_adjustment_number,
89: REC_ADJUSTMENT_ID = p_rec_adjustment_id,
90: PAYMENT_SCHEDULE_ID = p_payment_schedule_id,
91: INSTALLMENT_NUMBER = p_installment_number,
92: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
93: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
94: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
95: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
96: ADJUSTMENT_DATE = p_adjustment_date,

Line 93: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,

89: REC_ADJUSTMENT_ID = p_rec_adjustment_id,
90: PAYMENT_SCHEDULE_ID = p_payment_schedule_id,
91: INSTALLMENT_NUMBER = p_installment_number,
92: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
93: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
94: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
95: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
96: ADJUSTMENT_DATE = p_adjustment_date,
97: STATUS = 'APPROVED',

Line 94: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

90: PAYMENT_SCHEDULE_ID = p_payment_schedule_id,
91: INSTALLMENT_NUMBER = p_installment_number,
92: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
93: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
94: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
95: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
96: ADJUSTMENT_DATE = p_adjustment_date,
97: STATUS = 'APPROVED',
98: ORIGINAL_FLAG = p_original_flag,

Line 99: APPR_REJECT_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

95: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
96: ADJUSTMENT_DATE = p_adjustment_date,
97: STATUS = 'APPROVED',
98: ORIGINAL_FLAG = p_original_flag,
99: APPR_REJECT_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
100: APPR_REJECT_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
101: WHERE LOAN_LINE_ID = p_loan_line_id
102: AND LOAN_ID = p_loan_id;
103:

Line 100: APPR_REJECT_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

96: ADJUSTMENT_DATE = p_adjustment_date,
97: STATUS = 'APPROVED',
98: ORIGINAL_FLAG = p_original_flag,
99: APPR_REJECT_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
100: APPR_REJECT_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
101: WHERE LOAN_LINE_ID = p_loan_line_id
102: AND LOAN_ID = p_loan_id;
103:
104: --Call to record history

Line 373: l_user_id := LNS_UTILITY_PUB.created_by;

369: l_party_id := p_primary_borrower_id;
370: l_currency_code := p_currency_code;
371: l_org_id := p_org_id;
372: l_loan_product_id := p_loan_product_id;
373: l_user_id := LNS_UTILITY_PUB.created_by;
374: l_login_id := LNS_UTILITY_PUB.last_update_login;
375: l_date := sysdate;
376: l_loan_line_exists := 'N';
377:

Line 374: l_login_id := LNS_UTILITY_PUB.last_update_login;

370: l_currency_code := p_currency_code;
371: l_org_id := p_org_id;
372: l_loan_product_id := p_loan_product_id;
373: l_user_id := LNS_UTILITY_PUB.created_by;
374: l_login_id := LNS_UTILITY_PUB.last_update_login;
375: l_date := sysdate;
376: l_loan_line_exists := 'N';
377:
378: open c_check_existing_line(l_loan_id);