1: PACKAGE JAI_AR_TRX_LINES_PKG AS
2: /* $Header: jai_ar_trx_lines.pls 120.0.12020000.2 2013/03/19 00:29:44 vkaranam noship $ */
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: ------------------------------------------------------------------------------------------------------------
1: PACKAGE JAI_AR_TRX_LINES_PKG AS
2: /* $Header: jai_ar_trx_lines.pls 120.0.12020000.2 2013/03/19 00:29:44 vkaranam noship $ */
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: ------------------------------------------------------------------------------------------------------------
6: Sl.No. Date Developer BugNo Version Remarks
10: --------------------------------------------------------------------------------------------------------------*/
11:
12: t_rec RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE;
13: lc_modvat_tax CONSTANT VARCHAR2(15) := 'Modvat Recovery';
14: t_jai_rec JAI_AR_TRX_LINES%ROWTYPE;
15:
16: CURSOR c_get_address_details(cp_cust_trx_id ra_customer_trx_lines_all.customer_trx_id%TYPE) IS
17: SELECT bill_to_customer_id,
18: bill_to_site_use_id,
54: pr_new t_rec%type,
55: pv_action varchar2,
56: pv_return_code out NOCOPY varchar2,
57: pv_return_message out NOCOPY varchar2);
58: END JAI_AR_TRX_LINES_PKG;