eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_BILLING_BATCH_PUB

Line 1: PACKAGE BODY LNS_BILLING_BATCH_PUB as

1: PACKAGE BODY LNS_BILLING_BATCH_PUB as
2: /* $Header: LNS_BILLING_B.pls 120.74.12020000.4 2012/10/17 12:59:35 scherkas ship $ */
3:
4:
5: /*=======================================================================+

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_BILLING_BATCH_PUB';

4:
5: /*=======================================================================+
6: | Package Global Constants
7: +=======================================================================*/
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_BILLING_BATCH_PUB';
9: G_LOG_ENABLED varchar2(5);
10: G_MSG_LEVEL NUMBER;
11: g_org_id number;
12: g_batch_source_id number;

Line 985: PROCEDURE CREATE_AR_INVOICES(P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,

981: | 03-28-2006 karamach Pass the taxable_flag 'N' in trx line and billing_date = due_date in trx header for bug5124908
982: | 01-01-2004 scherkas Created
983: |
984: *=======================================================================*/
985: PROCEDURE CREATE_AR_INVOICES(P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,
986: P_LINES_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.BILL_LINES_TBL)
987: IS
988:
989: /*-----------------------------------------------------------------------+

Line 986: P_LINES_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.BILL_LINES_TBL)

982: | 01-01-2004 scherkas Created
983: |
984: *=======================================================================*/
985: PROCEDURE CREATE_AR_INVOICES(P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,
986: P_LINES_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.BILL_LINES_TBL)
987: IS
988:
989: /*-----------------------------------------------------------------------+
990: | Local Variable Declarations and initializations |

Line 1067: l_new_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

1063: l_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
1064: l_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
1065: l_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
1066: l_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
1067: l_new_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
1068:
1069: /*-----------------------------------------------------------------------+
1070: | Cursor Declarations |
1071: +-----------------------------------------------------------------------*/

Line 2441: PROCEDURE CREATE_AR_CM(P_REVERSE_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.REVERSE_TBL)

2437: | Date Author Description of Changes
2438: | 01-01-2004 scherkas Created
2439: |
2440: *=======================================================================*/
2441: PROCEDURE CREATE_AR_CM(P_REVERSE_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.REVERSE_TBL)
2442: IS
2443:
2444: /*-----------------------------------------------------------------------+
2445: | Local Variable Declarations and initializations |

Line 3826: P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,

3822: P_API_VERSION IN NUMBER,
3823: P_INIT_MSG_LIST IN VARCHAR2,
3824: P_COMMIT IN VARCHAR2,
3825: P_VALIDATION_LEVEL IN NUMBER,
3826: P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,
3827: X_STATEMENT_XML OUT NOCOPY CLOB,
3828: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3829: X_MSG_COUNT OUT NOCOPY NUMBER,
3830: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 3860: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

3856: l_profile_name VARCHAR2(240);
3857:
3858: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3859: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3860: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3861: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
3862: l_is_disable_bill varchar2(1);
3863:
3864: /*-----------------------------------------------------------------------+

Line 3985: LNS_BILLING_BATCH_PUB.PREBILL_SINGLE_LOAN(

3981: close do_billing_cur;
3982:
3983: if l_do_billing > 0 then
3984:
3985: LNS_BILLING_BATCH_PUB.PREBILL_SINGLE_LOAN(
3986: P_API_VERSION => 1.0,
3987: P_INIT_MSG_LIST => FND_API.G_TRUE,
3988: P_COMMIT => FND_API.G_FALSE,
3989: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

Line 4454: P_LOAN_NEXT_DD_REC IN LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC,

4450: P_API_VERSION IN NUMBER,
4451: P_INIT_MSG_LIST IN VARCHAR2,
4452: P_COMMIT IN VARCHAR2,
4453: P_VALIDATION_LEVEL IN NUMBER,
4454: P_LOAN_NEXT_DD_REC IN LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC,
4455: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4456: X_MSG_COUNT OUT NOCOPY NUMBER,
4457: X_MSG_DATA OUT NOCOPY VARCHAR2)
4458: IS

Line 5009: P_LOANS_TO_BILL_TBL IN LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL,

5005: P_API_VERSION IN NUMBER,
5006: P_INIT_MSG_LIST IN VARCHAR2,
5007: P_COMMIT IN VARCHAR2,
5008: P_VALIDATION_LEVEL IN NUMBER,
5009: P_LOANS_TO_BILL_TBL IN LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL,
5010: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5011: X_MSG_COUNT OUT NOCOPY NUMBER,
5012: X_MSG_DATA OUT NOCOPY VARCHAR2)
5013: IS

Line 5036: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;

5032: l_end date;
5033: l_start1 date;
5034: l_end1 date;
5035:
5036: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;
5037:
5038: /*-----------------------------------------------------------------------+
5039: | Cursor Declarations |
5040: +-----------------------------------------------------------------------*/

Line 5317: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;

5313: l_end1 date;
5314: l_type_id number;
5315: l_product_id number;
5316:
5317: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;
5318:
5319: /*-----------------------------------------------------------------------+
5320: | Cursor Declarations |
5321: +-----------------------------------------------------------------------*/

Line 5725: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;

5721: l_next_payment_due_date date;
5722: l_end date;
5723: l_start date;
5724:
5725: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
5726:
5727: /*-----------------------------------------------------------------------+
5728: | Cursor Declarations |
5729: +-----------------------------------------------------------------------*/

Line 5934: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;

5930: l_ORG_ID number;
5931: l_last_rate_id number;
5932: l_rate_type varchar2(30);
5933:
5934: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
5935: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
5936: l_INSTALLMENT_REC LNS_CUSTOM_PUB.custom_sched_type;
5937: l_principal NUMBER;
5938: l_interest NUMBER;

Line 5935: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;

5931: l_last_rate_id number;
5932: l_rate_type varchar2(30);
5933:
5934: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
5935: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
5936: l_INSTALLMENT_REC LNS_CUSTOM_PUB.custom_sched_type;
5937: l_principal NUMBER;
5938: l_interest NUMBER;
5939:

Line 6364: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;

6360: l_loan_number varchar2(60);
6361: l_due_date date;
6362: l_ORG_ID number;
6363:
6364: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
6365: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
6366:
6367:
6368: /*-----------------------------------------------------------------------+

Line 6365: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;

6361: l_due_date date;
6362: l_ORG_ID number;
6363:
6364: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
6365: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
6366:
6367:
6368: /*-----------------------------------------------------------------------+
6369: | Cursor Declarations |

Line 6619: P_BILL_HEADER_REC IN LNS_BILLING_BATCH_PUB.BILL_HEADER_REC,

6615: P_API_VERSION IN NUMBER,
6616: P_INIT_MSG_LIST IN VARCHAR2,
6617: P_COMMIT IN VARCHAR2,
6618: P_VALIDATION_LEVEL IN NUMBER,
6619: P_BILL_HEADER_REC IN LNS_BILLING_BATCH_PUB.BILL_HEADER_REC,
6620: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
6621: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6622: X_MSG_COUNT OUT NOCOPY NUMBER,
6623: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 6620: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,

6616: P_INIT_MSG_LIST IN VARCHAR2,
6617: P_COMMIT IN VARCHAR2,
6618: P_VALIDATION_LEVEL IN NUMBER,
6619: P_BILL_HEADER_REC IN LNS_BILLING_BATCH_PUB.BILL_HEADER_REC,
6620: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
6621: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6622: X_MSG_COUNT OUT NOCOPY NUMBER,
6623: X_MSG_DATA OUT NOCOPY VARCHAR2)
6624: IS

Line 6639: l_loan_rec LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC;

6635: l_prin_balance number;
6636: l_funded_amount number;
6637:
6638: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
6639: l_loan_rec LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC;
6640: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
6641:
6642: /*-----------------------------------------------------------------------+
6643: | Cursor Declarations |

Line 6640: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

6636: l_funded_amount number;
6637:
6638: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
6639: l_loan_rec LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC;
6640: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
6641:
6642: /*-----------------------------------------------------------------------+
6643: | Cursor Declarations |
6644: +-----------------------------------------------------------------------*/

Line 7036: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,

7032: P_API_VERSION IN NUMBER,
7033: P_INIT_MSG_LIST IN VARCHAR2,
7034: P_COMMIT IN VARCHAR2,
7035: P_VALIDATION_LEVEL IN NUMBER,
7036: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
7037: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
7038: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7039: X_MSG_COUNT OUT NOCOPY NUMBER,
7040: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 7037: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,

7033: P_INIT_MSG_LIST IN VARCHAR2,
7034: P_COMMIT IN VARCHAR2,
7035: P_VALIDATION_LEVEL IN NUMBER,
7036: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
7037: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
7038: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7039: X_MSG_COUNT OUT NOCOPY NUMBER,
7040: X_MSG_DATA OUT NOCOPY VARCHAR2)
7041: IS

Line 7055: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

7051: l_msg_data VARCHAR2(32767);
7052: l_Count NUMBER;
7053: l_Count1 NUMBER;
7054: l_Count2 NUMBER;
7055: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7056:
7057: BEGIN
7058:
7059: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 7248: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;

7244: l_REVERSED_FLAG varchar2(1);
7245: l_TRX_NUMBER varchar2(20);
7246: l_ORG_ID number;
7247:
7248: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
7249: l_lns_status LNS_LOAN_HEADERS_ALL.loan_status%TYPE;
7250:
7251: /*-----------------------------------------------------------------------+
7252: | Cursor Declarations |

Line 7913: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;

7909:
7910:
7911: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
7912: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
7913: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
7914: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7915:
7916: /*-----------------------------------------------------------------------+
7917: | Cursor Declarations |

Line 7914: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

7910:
7911: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
7912: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
7913: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
7914: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7915:
7916: /*-----------------------------------------------------------------------+
7917: | Cursor Declarations |
7918: +-----------------------------------------------------------------------*/

Line 8110: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');

8106: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');
8107:
8108: END LOOP;
8109:
8110: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');
8111:
8112: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
8113: P_API_VERSION => 1.0,
8114: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 8112: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(

8108: END LOOP;
8109:
8110: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');
8111:
8112: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
8113: P_API_VERSION => 1.0,
8114: P_INIT_MSG_LIST => FND_API.G_TRUE,
8115: P_COMMIT => FND_API.G_FALSE,
8116: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

Line 8608: | This procedure returns next installment to be billed in LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL format

8604: /*========================================================================
8605: | PUBLIC PROCEDURE GET_NEXT_INSTAL_TO_BILL
8606: |
8607: | DESCRIPTION
8608: | This procedure returns next installment to be billed in LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL format
8609: |
8610: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
8611: | None
8612: |

Line 8623: | X_INVOICES_TBL OUT NOCOPY LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL,

8619: | P_INIT_MSG_LIST IN Standard in parameter
8620: | P_COMMIT IN Standard in parameter
8621: | P_VALIDATION_LEVEL IN Standard in parameter
8622: | P_LOAN_ID IN Loan ID
8623: | X_INVOICES_TBL OUT NOCOPY LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL,
8624: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
8625: | X_MSG_COUNT OUT NOCOPY Standard out parameter
8626: | X_MSG_DATA OUT NOCOPY Standard out parameter
8627: |

Line 8646: X_INVOICES_TBL OUT NOCOPY LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL,

8642: P_INIT_MSG_LIST IN VARCHAR2,
8643: P_COMMIT IN VARCHAR2,
8644: P_VALIDATION_LEVEL IN NUMBER,
8645: P_LOAN_ID IN NUMBER,
8646: X_INVOICES_TBL OUT NOCOPY LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL,
8647: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
8648: X_MSG_COUNT OUT NOCOPY NUMBER,
8649: X_MSG_DATA OUT NOCOPY VARCHAR2)
8650: IS

Line 8675: l_invoices_tbl LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL;

8671: l_term_id number;
8672:
8673: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
8674: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
8675: l_invoices_tbl LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL;
8676:
8677: /*-----------------------------------------------------------------------+
8678: | Cursor Declarations |
8679: +-----------------------------------------------------------------------*/

Line 9010: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL

9006: | P_INIT_MSG_LIST IN Standard in parameter
9007: | P_COMMIT IN Standard in parameter
9008: | P_VALIDATION_LEVEL IN Standard in parameter
9009: | P_LOAN_ID IN Loan ID
9010: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL
9011: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
9012: | X_MSG_COUNT OUT NOCOPY Standard out parameter
9013: | X_MSG_DATA OUT NOCOPY Standard out parameter
9014: |

Line 9033: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,

9029: P_INIT_MSG_LIST IN VARCHAR2,
9030: P_COMMIT IN VARCHAR2,
9031: P_VALIDATION_LEVEL IN NUMBER,
9032: P_LOAN_ID IN NUMBER,
9033: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,
9034: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
9035: X_MSG_COUNT OUT NOCOPY NUMBER,
9036: X_MSG_DATA OUT NOCOPY VARCHAR2)
9037: IS

Line 9050: l_am_sched_tbl LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL;

9046: l_msg_count NUMBER;
9047: l_msg_data VARCHAR2(32767);
9048: l_Count1 NUMBER;
9049:
9050: l_am_sched_tbl LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL;
9051: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;
9052:
9053: /*-----------------------------------------------------------------------+
9054: | Cursor Declarations |

Line 9051: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;

9047: l_msg_data VARCHAR2(32767);
9048: l_Count1 NUMBER;
9049:
9050: l_am_sched_tbl LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL;
9051: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;
9052:
9053: /*-----------------------------------------------------------------------+
9054: | Cursor Declarations |
9055: +-----------------------------------------------------------------------*/

Line 9279: | P_AM_SCHED_TBL IN LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL,

9275: | P_INIT_MSG_LIST IN Standard in parameter
9276: | P_COMMIT IN Standard in parameter
9277: | P_VALIDATION_LEVEL IN Standard in parameter
9278: | P_LOAN_ID IN Loan ID
9279: | P_AM_SCHED_TBL IN LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL,
9280: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL
9281: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
9282: | X_MSG_COUNT OUT NOCOPY Standard out parameter
9283: | X_MSG_DATA OUT NOCOPY Standard out parameter

Line 9280: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL

9276: | P_COMMIT IN Standard in parameter
9277: | P_VALIDATION_LEVEL IN Standard in parameter
9278: | P_LOAN_ID IN Loan ID
9279: | P_AM_SCHED_TBL IN LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL,
9280: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL
9281: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
9282: | X_MSG_COUNT OUT NOCOPY Standard out parameter
9283: | X_MSG_DATA OUT NOCOPY Standard out parameter
9284: |

Line 9303: P_AM_SCHED_TBL IN LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL,

9299: P_INIT_MSG_LIST IN VARCHAR2,
9300: P_COMMIT IN VARCHAR2,
9301: P_VALIDATION_LEVEL IN NUMBER,
9302: P_LOAN_ID IN NUMBER,
9303: P_AM_SCHED_TBL IN LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL,
9304: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,
9305: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
9306: X_MSG_COUNT OUT NOCOPY NUMBER,
9307: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 9304: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,

9300: P_COMMIT IN VARCHAR2,
9301: P_VALIDATION_LEVEL IN NUMBER,
9302: P_LOAN_ID IN NUMBER,
9303: P_AM_SCHED_TBL IN LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL,
9304: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,
9305: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
9306: X_MSG_COUNT OUT NOCOPY NUMBER,
9307: X_MSG_DATA OUT NOCOPY VARCHAR2)
9308: IS

Line 9345: l_INVOICE_REC LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_REC;

9341: l_rc_count number;
9342: l_error varchar2(32767);
9343: l_total_applied_amount number;
9344:
9345: l_INVOICE_REC LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_REC;
9346: L_INVOICES_TBL LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL;
9347: l_order_tbl DBMS_SQL.VARCHAR2_TABLE;
9348: l_CASH_RECEIPTS_TBL LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL;
9349:

Line 9346: L_INVOICES_TBL LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL;

9342: l_error varchar2(32767);
9343: l_total_applied_amount number;
9344:
9345: l_INVOICE_REC LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_REC;
9346: L_INVOICES_TBL LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL;
9347: l_order_tbl DBMS_SQL.VARCHAR2_TABLE;
9348: l_CASH_RECEIPTS_TBL LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL;
9349:
9350: /*-----------------------------------------------------------------------+

Line 9348: l_CASH_RECEIPTS_TBL LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL;

9344:
9345: l_INVOICE_REC LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_REC;
9346: L_INVOICES_TBL LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL;
9347: l_order_tbl DBMS_SQL.VARCHAR2_TABLE;
9348: l_CASH_RECEIPTS_TBL LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL;
9349:
9350: /*-----------------------------------------------------------------------+
9351: | Cursor Declarations |
9352: +-----------------------------------------------------------------------*/

Line 9807: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;

9803: l_return BOOLEAN;
9804: l_value varchar2(1);
9805: l_is_disable_bill VARCHAR2(1);
9806:
9807: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
9808:
9809: /*-----------------------------------------------------------------------+
9810: | Cursor Declarations |
9811: +-----------------------------------------------------------------------*/

Line 9935: | This procedure returns already billed installment in LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL format

9931: /*========================================================================
9932: | PUBLIC PROCEDURE GET_BILLED_INSTALLMENT
9933: |
9934: | DESCRIPTION
9935: | This procedure returns already billed installment in LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL format
9936: |
9937: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
9938: | None
9939: |

Line 9951: | X_INVOICES_TBL OUT NOCOPY LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL,

9947: | P_COMMIT IN Standard in parameter
9948: | P_VALIDATION_LEVEL IN Standard in parameter
9949: | P_LOAN_ID IN Loan ID
9950: | P_AM_SCHED_ID IN Amortization sched ID
9951: | X_INVOICES_TBL OUT NOCOPY LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL,
9952: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
9953: | X_MSG_COUNT OUT NOCOPY Standard out parameter
9954: | X_MSG_DATA OUT NOCOPY Standard out parameter
9955: |

Line 9975: X_INVOICES_TBL OUT NOCOPY LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL,

9971: P_COMMIT IN VARCHAR2,
9972: P_VALIDATION_LEVEL IN NUMBER,
9973: P_LOAN_ID IN NUMBER,
9974: P_AM_SCHED_ID IN NUMBER,
9975: X_INVOICES_TBL OUT NOCOPY LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL,
9976: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
9977: X_MSG_COUNT OUT NOCOPY NUMBER,
9978: X_MSG_DATA OUT NOCOPY VARCHAR2)
9979: IS

Line 9992: l_invoice_rec LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_REC;

9988: l_msg_count NUMBER;
9989: l_msg_data VARCHAR2(32767);
9990: i number;
9991:
9992: l_invoice_rec LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_REC;
9993:
9994: /*-----------------------------------------------------------------------+
9995: | Cursor Declarations |
9996: +-----------------------------------------------------------------------*/

Line 10150: | P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,

10146: | P_INIT_MSG_LIST IN Standard in parameter
10147: | P_COMMIT IN Standard in parameter
10148: | P_VALIDATION_LEVEL IN Standard in parameter
10149: | P_LOAN_ID IN Loan ID
10150: | P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
10151: | P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
10152: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL
10153: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
10154: | X_MSG_COUNT OUT NOCOPY Standard out parameter

Line 10151: | P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,

10147: | P_COMMIT IN Standard in parameter
10148: | P_VALIDATION_LEVEL IN Standard in parameter
10149: | P_LOAN_ID IN Loan ID
10150: | P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
10151: | P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
10152: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL
10153: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
10154: | X_MSG_COUNT OUT NOCOPY Standard out parameter
10155: | X_MSG_DATA OUT NOCOPY Standard out parameter

Line 10152: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL

10148: | P_VALIDATION_LEVEL IN Standard in parameter
10149: | P_LOAN_ID IN Loan ID
10150: | P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
10151: | P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
10152: | P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL
10153: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
10154: | X_MSG_COUNT OUT NOCOPY Standard out parameter
10155: | X_MSG_DATA OUT NOCOPY Standard out parameter
10156: |

Line 10175: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,

10171: P_INIT_MSG_LIST IN VARCHAR2,
10172: P_COMMIT IN VARCHAR2,
10173: P_VALIDATION_LEVEL IN NUMBER,
10174: P_LOAN_ID IN NUMBER,
10175: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
10176: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
10177: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,
10178: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
10179: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 10176: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,

10172: P_COMMIT IN VARCHAR2,
10173: P_VALIDATION_LEVEL IN NUMBER,
10174: P_LOAN_ID IN NUMBER,
10175: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
10176: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
10177: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,
10178: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
10179: X_MSG_COUNT OUT NOCOPY NUMBER,
10180: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 10177: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,

10173: P_VALIDATION_LEVEL IN NUMBER,
10174: P_LOAN_ID IN NUMBER,
10175: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
10176: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
10177: P_CASH_RECEIPTS_TBL IN LNS_BILLING_BATCH_PUB.CASH_RECEIPT_TBL,
10178: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
10179: X_MSG_COUNT OUT NOCOPY NUMBER,
10180: X_MSG_DATA OUT NOCOPY VARCHAR2)
10181: IS

Line 10196: l_am_scheds_tbl LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL;

10192: l_last_am_id NUMBER;
10193: l_new_am_id NUMBER;
10194: i NUMBER;
10195:
10196: l_am_scheds_tbl LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL;
10197: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;
10198:
10199: /*-----------------------------------------------------------------------+
10200: | Cursor Declarations |

Line 10197: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;

10193: l_new_am_id NUMBER;
10194: i NUMBER;
10195:
10196: l_am_scheds_tbl LNS_BILLING_BATCH_PUB.AMORTIZATION_SCHED_TBL;
10197: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;
10198:
10199: /*-----------------------------------------------------------------------+
10200: | Cursor Declarations |
10201: +-----------------------------------------------------------------------*/

Line 10264: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(

10260: l_last_am_id := 0;
10261: end if;
10262:
10263: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Calling CREATE_OFFCYCLE_BILLS...');
10264: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
10265: P_API_VERSION => 1.0,
10266: P_INIT_MSG_LIST => FND_API.G_TRUE,
10267: P_COMMIT => FND_API.G_FALSE,
10268: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

Line 10424: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;

10420: l_tot_fee_amt NUMBER;
10421: l_loan_start_date DATE;
10422: l_current_phase varchar2(30);
10423:
10424: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
10425: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
10426: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
10427: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
10428: l_fee_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

Line 10425: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

10421: l_loan_start_date DATE;
10422: l_current_phase varchar2(30);
10423:
10424: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
10425: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
10426: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
10427: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
10428: l_fee_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
10429: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

Line 10629: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');

10625: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'SubmitForApproval Fee Amount = 0. Nothing to bill.');
10626: return;
10627: END IF;
10628:
10629: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');
10630:
10631: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
10632: P_API_VERSION => 1.0,
10633: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 10631: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(

10627: END IF;
10628:
10629: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');
10630:
10631: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
10632: P_API_VERSION => 1.0,
10633: P_INIT_MSG_LIST => FND_API.G_TRUE,
10634: P_COMMIT => FND_API.G_FALSE,
10635: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,