APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_ST_INVOICE_REVERSAL

Line 153: FROM JAI_ST_INVOICE_REVERSAL jsir

149: AND aid.accounting_date <= cp_as_of_date
150: AND aid.accounting_date >= cp_accrual_date
151: AND NOT EXISTS(
152: SELECT 1
153: FROM JAI_ST_INVOICE_REVERSAL jsir
154: WHERE jsir.invoice_id = apa.invoice_id
155: AND jsir.line_num = jail.invoice_line_number
156: AND jsir.source = 'AP'
157: )

Line 214: FROM JAI_ST_INVOICE_REVERSAL jsir

210: AND aid.accounting_date <= cp_as_of_date
211: AND aid.accounting_date >= cp_accrual_date
212: AND NOT EXISTS(
213: SELECT 1
214: FROM JAI_ST_INVOICE_REVERSAL jsir
215: WHERE jsir.invoice_id = apa.invoice_id
216: AND jsir.line_num = line.line_number
217: AND jsir.source = 'AP'
218: )

Line 272: FROM JAI_ST_INVOICE_REVERSAL jsir

268: AND plla.line_location_id = cl.po_line_location_id
269: -- Added by qiong for bug 13435306 end
270: AND NOT EXISTS(
271: SELECT 1
272: FROM JAI_ST_INVOICE_REVERSAL jsir
273: WHERE jsir.invoice_id = apa.invoice_id
274: AND jsir.line_num = line.line_number
275: AND jsir.source = 'AP'
276: )ORDER BY accounting_date,vendor_id, invoice_num ;

Line 328: FROM JAI_ST_INVOICE_REVERSAL jsir

324: AND rctgl.gl_date <= cp_as_of_date
325: AND rctgl.gl_date >= cp_accrual_date
326: AND NOT EXISTS(
327: SELECT 1
328: FROM JAI_ST_INVOICE_REVERSAL jsir
329: WHERE jsir.invoice_id = jict1.customer_trx_id
330: AND jsir.line_num = jatl1.line_number
331: AND jsir.source = 'AR'
332: )

Line 506: r_reversal_gt JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE;

502: ln_tax_to_be_adjusted NUMBER;
503: ln_un_applied_amt NUMBER;
504: lv_reversal_flag VARCHAR2(1) := 'Y';
505: ln_reg_id number;
506: r_reversal_gt JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE;
507: r_standard_ap c_standard_ap%ROWTYPE;
508: r_matched_ap c_matched_ap%ROWTYPE;
509: r_ar c_ar%ROWTYPE;
510: r_ar_rc_st_amount c_ar_rc_st_amount%ROWTYPE;

Line 878: PROCEDURE insert_trxs (r_reversal_trx JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE) IS

874: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
875: jai_cmn_debug_contexts_pkg.print_stack;
876: END extract_reversal_trxs;
877:
878: PROCEDURE insert_trxs (r_reversal_trx JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE) IS
879: BEGIN
880: INSERT INTO JAI_ST_INVOICE_REVERSAL_GT(
881: SERIAL_NUM
882: ,INVOICE_NUM

Line 880: INSERT INTO JAI_ST_INVOICE_REVERSAL_GT(

876: END extract_reversal_trxs;
877:
878: PROCEDURE insert_trxs (r_reversal_trx JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE) IS
879: BEGIN
880: INSERT INTO JAI_ST_INVOICE_REVERSAL_GT(
881: SERIAL_NUM
882: ,INVOICE_NUM
883: ,LINE_NUMBER
884: ,match_type