15: IS
16: BEGIN
17:
18: IF (p_FEE_ASSIGNMENT_rec.begin_installment_number IS NULL) THEN
19: p_FEE_ASSIGNMENT_rec.begin_installment_number := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_FEE_ASSIGNMENT_REC.loan_id);
20: END IF;
21:
22: IF (p_FEE_ASSIGNMENT_rec.end_installment_number IS NULL) THEN
23: p_FEE_ASSIGNMENT_rec.end_installment_number := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_FEE_ASSIGNMENT_REC.loan_id);
19: p_FEE_ASSIGNMENT_rec.begin_installment_number := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_FEE_ASSIGNMENT_REC.loan_id);
20: END IF;
21:
22: IF (p_FEE_ASSIGNMENT_rec.end_installment_number IS NULL) THEN
23: p_FEE_ASSIGNMENT_rec.end_installment_number := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_FEE_ASSIGNMENT_REC.loan_id);
24: END IF;
25:
26: IF (p_FEE_ASSIGNMENT_rec.phase IS NULL) THEN
27: p_FEE_ASSIGNMENT_rec.phase := 'TERM';
817: 'SUBMIT_FOR_APPROVAL',0,
818: 'AD_HOC',0,
819: 'TERM_CONVERSION',0,
820: 'BILL_WITH_INSTALLMENT',1,
821: (decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(LnsLoanHeaders.LOAN_ID) ,
822: -1 , 0 , LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(LnsLoanHeaders.LOAN_ID)) + 1 )
823: ) BEGIN_INSTALLMENT_NUMBER,
824: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
825: 'SUBMIT_FOR_APPROVAL',0,
818: 'AD_HOC',0,
819: 'TERM_CONVERSION',0,
820: 'BILL_WITH_INSTALLMENT',1,
821: (decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(LnsLoanHeaders.LOAN_ID) ,
822: -1 , 0 , LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(LnsLoanHeaders.LOAN_ID)) + 1 )
823: ) BEGIN_INSTALLMENT_NUMBER,
824: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
825: 'SUBMIT_FOR_APPROVAL',0,
826: 'AD_HOC',0,
1090: LnsFees.RATE_TYPE,
1091: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1092: 'SUBMIT_FOR_APPROVAL',0,
1093: 'BILL_WITH_INSTALLMENT',1,
1094: (decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id )) ,
1095: -1 , 0 , LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id ))) + 1 )
1096: ) BEGIN_INSTALLMENT_NUMBER,
1097: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1098: 'SUBMIT_FOR_APPROVAL',0,
1091: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1092: 'SUBMIT_FOR_APPROVAL',0,
1093: 'BILL_WITH_INSTALLMENT',1,
1094: (decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id )) ,
1095: -1 , 0 , LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id ))) + 1 )
1096: ) BEGIN_INSTALLMENT_NUMBER,
1097: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1098: 'SUBMIT_FOR_APPROVAL',0,
1099: 'BILL_WITH_INSTALLMENT',1,