[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
264: --Added by Xiao for Open Interface ER bug#11683927 on 16-Feb-2011, begin
265: --------------------------------------------------------------------------------------
266: CURSOR get_external_flag_cur IS
267: SELECT COUNT(lines.customer_trx_id)
268: FROM jai_ar_trx_lines lines,
269: jai_interface_lines_all intfs
270: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
271: AND lines.customer_trx_id = v_customer_trx_id
272: AND lines.interface_flag = 'Y'
278: WHERE customer_trx_id = v_customer_trx_id;
279:
280: CURSOR get_open_source_cur IS
281: SELECT COUNT(interface_flag)
282: FROM jai_ar_trx_lines
283: WHERE customer_trx_id = v_customer_trx_id
284: AND interface_flag = 'Y';
285:
286: ln_external_flag NUMBER;
366:
367: 11. 2005/01/28 ssumaith - bug#4136981
368:
369: IN call to the ja_in_register_txn_entry procedure , passing the customer_Trx_line_id instead of customer_trx_id
370: Because , this procedure gets called from individual line in the JAI_AR_TRX_LINES table
371: when 'COMPLETE' action is done.
372:
373: 12. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
374: DB Entity as required for CASE COMPLAINCE. Version 116.2