[Home] [Help]
85: v_opt_unit Number; --2001/05/04 Vijay,Subbu.
86: v_bill_to_customer_id Number; --2001/05/04 Vijay,Subbu.
87: v_bill_to_site_use_id Number; --2001/05/04 Vijay,Subbu.
88: --Added the below 3 variables by Anujsax for Bug#5636544
89: lv_excise_invoice_no jai_ar_trx_lines.excise_invoice_no%TYPE;
90: req_id NUMBER;
91: result BOOLEAN;
92: ---ended by Anujsax for Bug#5636544
93: Cursor complete_info_cur IS
116: SELECT customer_trx_line_id line_id, payment_register, inventory_item_id,
117: quantity quantity_invoiced,unit_selling_price,unit_code,
118: excise_invoice_no, excise_invoice_date, assessable_value,
119: customer_trx_line_id, excise_exempt_type
120: FROM JAI_AR_TRX_LINES
121: WHERE customer_trx_id = v_customer_trx_id;
122: CURSOR REG_BALANCE_CUR(p_org_id IN Number,
123: p_loc_id IN Number) IS
124: SELECT nvl(rg23a_balance,0) rg23a_balance ,nvl(rg23c_balance,0) rg23c_balance,
234: IS
235: SELECT
236: sum(jrcttl.func_tax_amount) cess_amount
237: FROM
238: jai_ar_trx_lines jrctl ,
239: jai_ar_trx_tax_lines jrcttl ,
240: jai_cmn_taxes_all jtc
241: WHERE
242: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
251: IS
252: SELECT
253: sum(jrcttl.func_tax_amount) sh_cess_amount
254: FROM
255: jai_ar_trx_lines jrctl,
256: jai_ar_trx_tax_lines jrcttl,
257: jai_cmn_taxes_all jtc
258: WHERE
259: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
340:
341: 11. 2005/01/28 ssumaith - bug#4136981
342:
343: IN call to the ja_in_register_txn_entry procedure , passing the customer_Trx_line_id instead of customer_trx_id
344: Because , this procedure gets called from individual line in the JAI_AR_TRX_LINES table
345: when 'COMPLETE' action is done.
346:
347: 12. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
348: DB Entity as required for CASE COMPLAINCE. Version 116.2