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.33.12010000.7 2009/01/21 20:26:00 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 978: PROCEDURE CREATE_AR_INVOICES(P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,

974: | 03-28-2006 karamach Pass the taxable_flag 'N' in trx line and billing_date = due_date in trx header for bug5124908
975: | 01-01-2004 scherkas Created
976: |
977: *=======================================================================*/
978: PROCEDURE CREATE_AR_INVOICES(P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,
979: P_LINES_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.BILL_LINES_TBL)
980: IS
981:
982: /*-----------------------------------------------------------------------+

Line 979: P_LINES_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.BILL_LINES_TBL)

975: | 01-01-2004 scherkas Created
976: |
977: *=======================================================================*/
978: PROCEDURE CREATE_AR_INVOICES(P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,
979: P_LINES_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.BILL_LINES_TBL)
980: IS
981:
982: /*-----------------------------------------------------------------------+
983: | Local Variable Declarations and initializations |

Line 1051: l_new_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

1047: l_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
1048: l_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
1049: l_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
1050: l_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
1051: l_new_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
1052:
1053: /*-----------------------------------------------------------------------+
1054: | Cursor Declarations |
1055: +-----------------------------------------------------------------------*/

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

2267: | Date Author Description of Changes
2268: | 01-01-2004 scherkas Created
2269: |
2270: *=======================================================================*/
2271: PROCEDURE CREATE_AR_CM(P_REVERSE_TBL IN OUT NOCOPY LNS_BILLING_BATCH_PUB.REVERSE_TBL)
2272: IS
2273:
2274: /*-----------------------------------------------------------------------+
2275: | Local Variable Declarations and initializations |

Line 3508: P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,

3504: P_API_VERSION IN NUMBER,
3505: P_INIT_MSG_LIST IN VARCHAR2,
3506: P_COMMIT IN VARCHAR2,
3507: P_VALIDATION_LEVEL IN NUMBER,
3508: P_LOAN_REC IN OUT NOCOPY LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC,
3509: X_STATEMENT_XML OUT NOCOPY CLOB,
3510: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3511: X_MSG_COUNT OUT NOCOPY NUMBER,
3512: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 3540: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

3536: l_floating_flag varchar2(1);
3537:
3538: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3539: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3540: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3541: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
3542:
3543: /*-----------------------------------------------------------------------+
3544: | Cursor Declarations |

Line 3662: LNS_BILLING_BATCH_PUB.PREBILL_SINGLE_LOAN(

3658: close do_billing_cur;
3659:
3660: if l_do_billing > 0 then
3661:
3662: LNS_BILLING_BATCH_PUB.PREBILL_SINGLE_LOAN(
3663: P_API_VERSION => 1.0,
3664: P_INIT_MSG_LIST => FND_API.G_TRUE,
3665: P_COMMIT => FND_API.G_FALSE,
3666: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

Line 4137: P_LOAN_NEXT_DD_REC IN LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC,

4133: P_API_VERSION IN NUMBER,
4134: P_INIT_MSG_LIST IN VARCHAR2,
4135: P_COMMIT IN VARCHAR2,
4136: P_VALIDATION_LEVEL IN NUMBER,
4137: P_LOAN_NEXT_DD_REC IN LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC,
4138: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4139: X_MSG_COUNT OUT NOCOPY NUMBER,
4140: X_MSG_DATA OUT NOCOPY VARCHAR2)
4141: IS

Line 4722: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;

4718: l_end date;
4719: l_start1 date;
4720: l_end1 date;
4721:
4722: l_loans_to_bill_tbl LNS_BILLING_BATCH_PUB.LOANS_TO_BILL_TBL;
4723:
4724: /*-----------------------------------------------------------------------+
4725: | Cursor Declarations |
4726: +-----------------------------------------------------------------------*/

Line 5111: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;

5107: l_next_payment_due_date date;
5108: l_end date;
5109: l_start date;
5110:
5111: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
5112:
5113: /*-----------------------------------------------------------------------+
5114: | Cursor Declarations |
5115: +-----------------------------------------------------------------------*/

Line 5320: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;

5316: l_ORG_ID number;
5317: l_last_rate_id number;
5318: l_rate_type varchar2(30);
5319:
5320: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
5321: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
5322: l_INSTALLMENT_REC LNS_CUSTOM_PUB.custom_sched_type;
5323: l_principal NUMBER;
5324: l_interest NUMBER;

Line 5321: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;

5317: l_last_rate_id number;
5318: l_rate_type varchar2(30);
5319:
5320: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
5321: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
5322: l_INSTALLMENT_REC LNS_CUSTOM_PUB.custom_sched_type;
5323: l_principal NUMBER;
5324: l_interest NUMBER;
5325:

Line 5743: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;

5739: l_loan_number varchar2(60);
5740: l_due_date date;
5741: l_ORG_ID number;
5742:
5743: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
5744: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
5745:
5746:
5747: /*-----------------------------------------------------------------------+

Line 5744: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;

5740: l_due_date date;
5741: l_ORG_ID number;
5742:
5743: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
5744: l_loans_next_dd_rec LNS_BILLING_BATCH_PUB.LOAN_NEXT_DD_REC;
5745:
5746:
5747: /*-----------------------------------------------------------------------+
5748: | Cursor Declarations |

Line 5998: P_BILL_HEADER_REC IN LNS_BILLING_BATCH_PUB.BILL_HEADER_REC,

5994: P_API_VERSION IN NUMBER,
5995: P_INIT_MSG_LIST IN VARCHAR2,
5996: P_COMMIT IN VARCHAR2,
5997: P_VALIDATION_LEVEL IN NUMBER,
5998: P_BILL_HEADER_REC IN LNS_BILLING_BATCH_PUB.BILL_HEADER_REC,
5999: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
6000: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6001: X_MSG_COUNT OUT NOCOPY NUMBER,
6002: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 5999: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,

5995: P_INIT_MSG_LIST IN VARCHAR2,
5996: P_COMMIT IN VARCHAR2,
5997: P_VALIDATION_LEVEL IN NUMBER,
5998: P_BILL_HEADER_REC IN LNS_BILLING_BATCH_PUB.BILL_HEADER_REC,
5999: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
6000: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6001: X_MSG_COUNT OUT NOCOPY NUMBER,
6002: X_MSG_DATA OUT NOCOPY VARCHAR2)
6003: IS

Line 6016: l_loan_rec LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC;

6012: l_msg_data VARCHAR2(32767);
6013: l_Count NUMBER;
6014: l_prin_balance number;
6015:
6016: l_loan_rec LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC;
6017: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
6018:
6019: /*-----------------------------------------------------------------------+
6020: | Cursor Declarations |

Line 6017: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

6013: l_Count NUMBER;
6014: l_prin_balance number;
6015:
6016: l_loan_rec LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC;
6017: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
6018:
6019: /*-----------------------------------------------------------------------+
6020: | Cursor Declarations |
6021: +-----------------------------------------------------------------------*/

Line 6410: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,

6406: P_API_VERSION IN NUMBER,
6407: P_INIT_MSG_LIST IN VARCHAR2,
6408: P_COMMIT IN VARCHAR2,
6409: P_VALIDATION_LEVEL IN NUMBER,
6410: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
6411: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
6412: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6413: X_MSG_COUNT OUT NOCOPY NUMBER,
6414: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 6411: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,

6407: P_INIT_MSG_LIST IN VARCHAR2,
6408: P_COMMIT IN VARCHAR2,
6409: P_VALIDATION_LEVEL IN NUMBER,
6410: P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
6411: P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
6412: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6413: X_MSG_COUNT OUT NOCOPY NUMBER,
6414: X_MSG_DATA OUT NOCOPY VARCHAR2)
6415: IS

Line 6429: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

6425: l_msg_data VARCHAR2(32767);
6426: l_Count NUMBER;
6427: l_Count1 NUMBER;
6428: l_Count2 NUMBER;
6429: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
6430:
6431: BEGIN
6432:
6433: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 6622: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;

6618: l_REVERSED_FLAG varchar2(1);
6619: l_TRX_NUMBER varchar2(20);
6620: l_ORG_ID number;
6621:
6622: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
6623:
6624: /*-----------------------------------------------------------------------+
6625: | Cursor Declarations |
6626: +-----------------------------------------------------------------------*/

Line 7267: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;

7263:
7264:
7265: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
7266: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
7267: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
7268: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7269:
7270: /*-----------------------------------------------------------------------+
7271: | Cursor Declarations |

Line 7268: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

7264:
7265: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
7266: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
7267: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
7268: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7269:
7270: /*-----------------------------------------------------------------------+
7271: | Cursor Declarations |
7272: +-----------------------------------------------------------------------*/

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

7449: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');
7450:
7451: END LOOP;
7452:
7453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');
7454:
7455: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
7456: P_API_VERSION => 1.0,
7457: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 7455: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(

7451: END LOOP;
7452:
7453: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');
7454:
7455: LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS(
7456: P_API_VERSION => 1.0,
7457: P_INIT_MSG_LIST => FND_API.G_TRUE,
7458: P_COMMIT => FND_API.G_FALSE,
7459: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,