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.JAI_AP_TDS_CANCELLATION_PKG dependencies on AP_INVOICES_ALL

Line 44: (1) Added org_id in cursor c_ap_invoices_all

40: and also commented the update for tax_amount
41: (2)Also raised exception if P_TOKEN is not null
42:
43: 5. 23-Aug-2005 Bug4559756. Added by Lakshmi Gopalsami version 120.3
44: (1) Added org_id in cursor c_ap_invoices_all
45: (2) Fetched the same before calling ap_utilities_pkg
46: and passed the same the package call.
47: To get the period name and date.
48:

Line 153: cursor c_ap_invoices_all(p_invoice_id number) is

149: /* Bug 4559756. Added by Lakshmi Gopalsami
150: Added org_id for passing it to ap_utilities_pkg
151:
152: */
153: cursor c_ap_invoices_all(p_invoice_id number) is
154: select invoice_id,
155: cancelled_date,
156: payment_status_flag,
157: invoice_amount,

Line 161: from ap_invoices_all

157: invoice_amount,
158: set_of_books_id,
159: invoice_num,
160: org_id
161: from ap_invoices_all
162: where invoice_id = p_invoice_id;
163:
164: cursor c_get_parent_inv_dtls(p_invoice_id number) is
165: select set_of_books_id,

Line 168: from ap_invoices_all

164: cursor c_get_parent_inv_dtls(p_invoice_id number) is
165: select set_of_books_id,
166: invoice_currency_code,
167: exchange_rate
168: from ap_invoices_all
169: where invoice_id = p_invoice_id;
170:
171:
172: cursor c_jai_ap_tds_inv_taxes(p_invoice_id number,cp_section_type jai_ap_tds_inv_taxes.section_type%type) is--rchandan for bug#4428980

Line 204: CURSOR get_dist_gl_date( cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)

200: | Changed the source of ld_accounting_date to refer to
201: | ap_invoice_distributions_all.accounting_date instead of
202: | gl_date on headers.
203: */
204: CURSOR get_dist_gl_date( cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)
205: IS
206: SELECT accounting_date
207: FROM ap_invoice_distributions_all
208: WHERE invoice_id = cp_invoice_id

Line 215: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)

211: -- hard coded the distribution line number to 1.
212:
213: /*Bug 8830302 - Get Accounting Date from AP_INVOICE_LINES_ALL.
214: This is fail safe if Distributions does not have accounting date*/
215: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)
216: IS
217: SELECT accounting_date
218: FROM ap_invoice_lines_all
219: WHERE invoice_id = cp_invoice_id

Line 259: r_ap_invoices_all c_ap_invoices_all%rowtype;

255: -------------------------------------------------------------------------------
256: -- Added by Jia for FP Bug#7312295, End
257:
258: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
259: r_ap_invoices_all c_ap_invoices_all%rowtype;
260: r_get_parent_inv_dtls c_get_parent_inv_dtls%rowtype;
261: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
262:
263: lv_code_path VARCHAR2(1996);

Line 288: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;

284:
285: ld_accounting_date date; --File.Sql.35 Cbabu := sysdate;
286: lv_open_period ap_invoice_distributions_all.period_name%type;
287:
288: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
289: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
290: ln_threshold_trx_id number;
291:
292: ln_taxable_amount number;

Line 289: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;

285: ld_accounting_date date; --File.Sql.35 Cbabu := sysdate;
286: lv_open_period ap_invoice_distributions_all.period_name%type;
287:
288: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
289: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
290: ln_threshold_trx_id number;
291:
292: ln_taxable_amount number;
293: ln_exchange_rate ap_invoices_all.exchange_rate%type;

Line 293: ln_exchange_rate ap_invoices_all.exchange_rate%type;

289: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
290: ln_threshold_trx_id number;
291:
292: ln_taxable_amount number;
293: ln_exchange_rate ap_invoices_all.exchange_rate%type;
294: lv_codepath VARCHAR2(1996);
295: ln_start_threshold_trx_id number;
296: ln_threshold_grp_id number;
297: ln_threshold_grp_audit_id number;

Line 344: open c_ap_invoices_all(p_invoice_id);

340:
341: /* bug 4559756. Added by Lakshmi Gopalsami
342: Fetch the org_id
343: */
344: open c_ap_invoices_all(p_invoice_id);
345: fetch c_ap_invoices_all into r_ap_invoices_all;
346: close c_ap_invoices_all;
347:
348:

Line 345: fetch c_ap_invoices_all into r_ap_invoices_all;

341: /* bug 4559756. Added by Lakshmi Gopalsami
342: Fetch the org_id
343: */
344: open c_ap_invoices_all(p_invoice_id);
345: fetch c_ap_invoices_all into r_ap_invoices_all;
346: close c_ap_invoices_all;
347:
348:
349: --Removed the code from here by Lakshmi Gopalsami for Bug#5131075(5193852)

Line 346: close c_ap_invoices_all;

342: Fetch the org_id
343: */
344: open c_ap_invoices_all(p_invoice_id);
345: fetch c_ap_invoices_all into r_ap_invoices_all;
346: close c_ap_invoices_all;
347:
348:
349: --Removed the code from here by Lakshmi Gopalsami for Bug#5131075(5193852)
350:

Line 430: r_ap_invoices_all := null;

426: lv_tds_credit_memo_flag := null;
427: lv_tds_credit_memo_message := null;
428:
429: /* Get the details of the Invoice to TDS authority */
430: r_ap_invoices_all := null;
431: open c_ap_invoices_all(cur_rec.invoice_to_tds_authority_id);
432: fetch c_ap_invoices_all into r_ap_invoices_all;
433: close c_ap_invoices_all;
434:

Line 431: open c_ap_invoices_all(cur_rec.invoice_to_tds_authority_id);

427: lv_tds_credit_memo_message := null;
428:
429: /* Get the details of the Invoice to TDS authority */
430: r_ap_invoices_all := null;
431: open c_ap_invoices_all(cur_rec.invoice_to_tds_authority_id);
432: fetch c_ap_invoices_all into r_ap_invoices_all;
433: close c_ap_invoices_all;
434:
435: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami

Line 432: fetch c_ap_invoices_all into r_ap_invoices_all;

428:
429: /* Get the details of the Invoice to TDS authority */
430: r_ap_invoices_all := null;
431: open c_ap_invoices_all(cur_rec.invoice_to_tds_authority_id);
432: fetch c_ap_invoices_all into r_ap_invoices_all;
433: close c_ap_invoices_all;
434:
435: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami
436: * Derivced the accounting_date of the original distribution

Line 433: close c_ap_invoices_all;

429: /* Get the details of the Invoice to TDS authority */
430: r_ap_invoices_all := null;
431: open c_ap_invoices_all(cur_rec.invoice_to_tds_authority_id);
432: fetch c_ap_invoices_all into r_ap_invoices_all;
433: close c_ap_invoices_all;
434:
435: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami
436: * Derivced the accounting_date of the original distribution
437: * as this value is also getting passed for Threshold adjustments if the

Line 453: if r_ap_invoices_all.payment_status_flag <> 'N' then

449: CLOSE c_get_lines_acct_date;
450: end if;
451:
452: /* Check if the TDS invoice is paid, no processing is required if it is already paid. */
453: if r_ap_invoices_all.payment_status_flag <> 'N' then
454: lv_codepath := jai_general_pkg.plot_codepath(4, lv_codepath); /* 4 */
455: lv_tds_invoice_flag := 'X';
456: lv_tds_invoice_message := 'Invoice to TDS Authority is already paid.';
457: lv_tds_credit_memo_flag := 'X';

Line 465: if r_ap_invoices_all.cancelled_date is not null then

461:
462: /* Check if the invoice to TDS authority is already canccelled,
463: if yes, no need to do the cancel processing of the invoice */
464: lv_codepath := jai_general_pkg.plot_codepath(5, lv_codepath); /* 5 */
465: if r_ap_invoices_all.cancelled_date is not null then
466: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath); /* 6 */
467: lv_tds_invoice_flag := 'X';
468: lv_tds_invoice_message := ' Invoice to TDS Authority is already Cancelled.';
469: goto credit_memo_processing;

Line 498: P_Org_Id => r_ap_invoices_all.org_id);

494: */
495: --Check if the given date is in current open period
496: lv_open_period:= ap_utilities_pkg.get_current_gl_date
497: (P_Date => ld_accounting_date,
498: P_Org_Id => r_ap_invoices_all.org_id);
499: if lv_open_period is null then
500:
501: lv_codepath := jai_general_pkg.plot_codepath(1.1, lv_codepath); /* 1.1 */
502:

Line 508: P_Org_Id => r_ap_invoices_all.org_id

504: (
505: p_date => ld_accounting_date, /* In date */
506: p_period_name => lv_open_period, /* out Period */
507: p_gl_date => ld_ret_accounting_date, --ld_accounting_date, /* out date */ /* Modified for bug 14185477 */
508: P_Org_Id => r_ap_invoices_all.org_id
509: );
510:
511: if lv_open_period is null then
512: lv_codepath := jai_general_pkg.plot_codepath(1.2, lv_codepath); /* 1.2 */

Line 536: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || r_ap_invoices_all.org_id);

532: */
533:
534: /*Added set_policy_context call to implement MOAC - Bug 8475540*/
535:
536: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || r_ap_invoices_all.org_id);
537: mo_global.set_policy_context('S', r_ap_invoices_all.org_id);
538:
539: lb_return_value :=
540: ap_cancel_pkg.ap_cancel_single_invoice

Line 537: mo_global.set_policy_context('S', r_ap_invoices_all.org_id);

533:
534: /*Added set_policy_context call to implement MOAC - Bug 8475540*/
535:
536: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || r_ap_invoices_all.org_id);
537: mo_global.set_policy_context('S', r_ap_invoices_all.org_id);
538:
539: lb_return_value :=
540: ap_cancel_pkg.ap_cancel_single_invoice
541: (

Line 545: --P_set_of_books_id => r_ap_invoices_all.set_of_books_id ,

541: (
542: P_invoice_id => cur_rec.invoice_to_tds_authority_id ,
543: P_last_updated_by => fnd_global.user_id ,
544: P_last_update_login => fnd_global.login_id ,
545: --P_set_of_books_id => r_ap_invoices_all.set_of_books_id ,
546: P_accounting_date => ld_accounting_date ,
547: --P_period_name => lv_open_period ,
548: P_message_name => lv_out_message_name ,
549: P_invoice_amount => ln_out_invoice_amount ,

Line 579: update ap_invoices_all

575:
576: /* Bug4523064. Added by Lakshmi Gopalsami
577: Commented the tax_amount update */
578:
579: update ap_invoices_all
580: set invoice_amount = ln_out_invoice_amount ,
581: base_amount = ln_out_base_amount ,
582: --tax_amount = ln_out_tax_amount ,
583: temp_cancelled_amount = ln_out_temp_cancelled_amount ,

Line 601: r_ap_invoices_all := null;

597:
598:
599: << credit_memo_processing >>
600: /* Get the details of the Credit memo to the supplier for TDS */
601: r_ap_invoices_all := null;
602: open c_ap_invoices_all(cur_rec.invoice_to_vendor_id);
603: fetch c_ap_invoices_all into r_ap_invoices_all;
604: close c_ap_invoices_all;
605:

Line 602: open c_ap_invoices_all(cur_rec.invoice_to_vendor_id);

598:
599: << credit_memo_processing >>
600: /* Get the details of the Credit memo to the supplier for TDS */
601: r_ap_invoices_all := null;
602: open c_ap_invoices_all(cur_rec.invoice_to_vendor_id);
603: fetch c_ap_invoices_all into r_ap_invoices_all;
604: close c_ap_invoices_all;
605:
606: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami

Line 603: fetch c_ap_invoices_all into r_ap_invoices_all;

599: << credit_memo_processing >>
600: /* Get the details of the Credit memo to the supplier for TDS */
601: r_ap_invoices_all := null;
602: open c_ap_invoices_all(cur_rec.invoice_to_vendor_id);
603: fetch c_ap_invoices_all into r_ap_invoices_all;
604: close c_ap_invoices_all;
605:
606: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami
607: * Derivced the accounting_date of the original distribution

Line 604: close c_ap_invoices_all;

600: /* Get the details of the Credit memo to the supplier for TDS */
601: r_ap_invoices_all := null;
602: open c_ap_invoices_all(cur_rec.invoice_to_vendor_id);
603: fetch c_ap_invoices_all into r_ap_invoices_all;
604: close c_ap_invoices_all;
605:
606: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami
607: * Derivced the accounting_date of the original distribution
608: * as this value is also getting passed for Threshold adjustments if the

Line 626: if r_ap_invoices_all.cancelled_date is not null then

622:
623: /* Check if the Credit memo to the supplier for TDS already canccelled,
624: if yes, no need to cancel it again here */
625:
626: if r_ap_invoices_all.cancelled_date is not null then
627: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath); /* 10 */
628: lv_tds_credit_memo_flag := 'X';
629: lv_tds_credit_memo_message := 'Credit memo to the supplier for TDS is already Cancelled.';
630: goto Continue_with_next_record;

Line 636: if r_ap_invoices_all.payment_status_flag = 'N' then

632:
633: /* Check if the Credit memo to the supplier for TDS is paid,
634: if yes a separate invoice needs to be generated, or else the same credit memo can be cancelled */
635:
636: if r_ap_invoices_all.payment_status_flag = 'N' then
637: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath); /* 11 */
638: /* Credit memo not paid, can cancel the same */
639: lv_tds_credit_memo_flag := 'Y';
640: lv_tds_credit_memo_message := 'Cancelling Credit memo to the supplier for TDS as it is not paid ';

Line 666: P_Org_Id => r_ap_invoices_all.org_id);

662: */
663: --Check if the given date is in current open period
664: lv_open_period:= ap_utilities_pkg.get_current_gl_date
665: (P_Date => ld_accounting_date,
666: P_Org_Id => r_ap_invoices_all.org_id);
667:
668:
669: if lv_open_period is null then
670:

Line 678: P_Org_Id => r_ap_invoices_all.org_id

674: (
675: p_date => ld_accounting_date, /* In date */
676: p_period_name => lv_open_period, /* out Period */
677: p_gl_date => ld_ret_accounting_date , --ld_accounting_date, /* out date */ /* Modified for bug 14185477 */
678: P_Org_Id => r_ap_invoices_all.org_id
679: );
680:
681: if lv_open_period is null then
682: lv_codepath := jai_general_pkg.plot_codepath(1.2, lv_codepath); /* 1.2 */

Line 707: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || r_ap_invoices_all.org_id);

703: */
704:
705: /*Added set_policy_context call to implement MOAC - Bug 8475540*/
706:
707: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || r_ap_invoices_all.org_id);
708: mo_global.set_policy_context('S', r_ap_invoices_all.org_id);
709:
710: lb_return_value :=
711: ap_cancel_pkg.ap_cancel_single_invoice

Line 708: mo_global.set_policy_context('S', r_ap_invoices_all.org_id);

704:
705: /*Added set_policy_context call to implement MOAC - Bug 8475540*/
706:
707: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || r_ap_invoices_all.org_id);
708: mo_global.set_policy_context('S', r_ap_invoices_all.org_id);
709:
710: lb_return_value :=
711: ap_cancel_pkg.ap_cancel_single_invoice
712: (

Line 716: --P_set_of_books_id => r_ap_invoices_all.set_of_books_id ,

712: (
713: P_invoice_id => cur_rec.invoice_to_vendor_id ,
714: P_last_updated_by => fnd_global.user_id ,
715: P_last_update_login => fnd_global.login_id ,
716: --P_set_of_books_id => r_ap_invoices_all.set_of_books_id ,
717: P_accounting_date => ld_accounting_date ,
718: --P_period_name => lv_open_period ,
719: P_message_name => lv_out_message_name ,
720: P_invoice_amount => ln_out_invoice_amount ,

Line 748: update ap_invoices_all

744: End if;
745:
746: /*Bug4523064. Added by Lakshmi Gopalsami
747: Commented the tax_amount update */
748: update ap_invoices_all
749: set invoice_amount = ln_out_invoice_amount ,
750: base_amount = ln_out_base_amount ,
751: -- tax_amount = ln_out_tax_amount ,
752: temp_cancelled_amount = ln_out_temp_cancelled_amount ,

Line 772: pv_invoice_num_to_vendor_can => r_ap_invoices_all.invoice_num,

768:
769: jai_ap_tds_generation_pkg.generate_tds_invoices
770: (
771: pn_invoice_id => p_invoice_id ,
772: pv_invoice_num_to_vendor_can => r_ap_invoices_all.invoice_num,
773: pn_taxable_amount => cur_rec.taxable_amount ,
774: pn_tax_amount => cur_rec.tax_amount ,
775: pn_tax_id => cur_rec.tax_id ,
776: pd_accounting_date => ld_accounting_date ,

Line 906: r_ap_invoices_all := NULL;

902: IF lv_process_flag = 'E' THEN
903: goto end_of_main_loop;
904: END IF;
905:
906: r_ap_invoices_all := NULL;
907:
908: OPEN c_ap_invoices_all(p_invoice_id);
909: FETCH c_ap_invoices_all into r_ap_invoices_all;
910: CLOSE c_ap_invoices_all;

Line 908: OPEN c_ap_invoices_all(p_invoice_id);

904: END IF;
905:
906: r_ap_invoices_all := NULL;
907:
908: OPEN c_ap_invoices_all(p_invoice_id);
909: FETCH c_ap_invoices_all into r_ap_invoices_all;
910: CLOSE c_ap_invoices_all;
911: /*Uncommeneted by mmurtuza for bug 13561970 */
912: jai_ap_tds_generation_pkg.process_threshold_rollback(

Line 909: FETCH c_ap_invoices_all into r_ap_invoices_all;

905:
906: r_ap_invoices_all := NULL;
907:
908: OPEN c_ap_invoices_all(p_invoice_id);
909: FETCH c_ap_invoices_all into r_ap_invoices_all;
910: CLOSE c_ap_invoices_all;
911: /*Uncommeneted by mmurtuza for bug 13561970 */
912: jai_ap_tds_generation_pkg.process_threshold_rollback(
913: p_invoice_id => p_invoice_id,

Line 910: CLOSE c_ap_invoices_all;

906: r_ap_invoices_all := NULL;
907:
908: OPEN c_ap_invoices_all(p_invoice_id);
909: FETCH c_ap_invoices_all into r_ap_invoices_all;
910: CLOSE c_ap_invoices_all;
911: /*Uncommeneted by mmurtuza for bug 13561970 */
912: jai_ap_tds_generation_pkg.process_threshold_rollback(
913: p_invoice_id => p_invoice_id,
914: p_before_threshold_type => lv_threshold_type_before, /*Bug 13561970*/

Line 919: p_org_id => r_ap_invoices_all.org_id,

915: p_after_threshold_type => lv_after_threshold_type,
916: p_before_threshold_slab_id => ln_threshold_slab_id,
917: p_after_threshold_slab_id => ln_after_threshold_slab_id,
918: p_threshold_grp_id => cur_rec.threshold_grp_id,
919: p_org_id => r_ap_invoices_all.org_id,
920: p_accounting_date => ld_accounting_date,
921: p_process_flag => lv_process_flag,
922: p_process_message => lv_process_message,
923: p_codepath => lv_codepath);

Line 989: open c_ap_invoices_all(tds_id.invoice_to_tds_authority_id);

985: end if;
986: for tds_id in (select invoice_to_tds_authority_id from jai_ap_tds_thhold_trxs where invoice_id = r_threshold_breach.invoice_id)
987: loop
988:
989: open c_ap_invoices_all(tds_id.invoice_to_tds_authority_id);
990: fetch c_ap_invoices_all into r_ap_invoices_all;
991: close c_ap_invoices_all;
992: if r_ap_invoices_all.payment_status_flag <> 'N' and lv_payment = 'N' then
993: lv_payment :='Y';

Line 990: fetch c_ap_invoices_all into r_ap_invoices_all;

986: for tds_id in (select invoice_to_tds_authority_id from jai_ap_tds_thhold_trxs where invoice_id = r_threshold_breach.invoice_id)
987: loop
988:
989: open c_ap_invoices_all(tds_id.invoice_to_tds_authority_id);
990: fetch c_ap_invoices_all into r_ap_invoices_all;
991: close c_ap_invoices_all;
992: if r_ap_invoices_all.payment_status_flag <> 'N' and lv_payment = 'N' then
993: lv_payment :='Y';
994: end if;

Line 991: close c_ap_invoices_all;

987: loop
988:
989: open c_ap_invoices_all(tds_id.invoice_to_tds_authority_id);
990: fetch c_ap_invoices_all into r_ap_invoices_all;
991: close c_ap_invoices_all;
992: if r_ap_invoices_all.payment_status_flag <> 'N' and lv_payment = 'N' then
993: lv_payment :='Y';
994: end if;
995: end loop;

Line 992: if r_ap_invoices_all.payment_status_flag <> 'N' and lv_payment = 'N' then

988:
989: open c_ap_invoices_all(tds_id.invoice_to_tds_authority_id);
990: fetch c_ap_invoices_all into r_ap_invoices_all;
991: close c_ap_invoices_all;
992: if r_ap_invoices_all.payment_status_flag <> 'N' and lv_payment = 'N' then
993: lv_payment :='Y';
994: end if;
995: end loop;
996: end loop;

Line 1110: r_ap_invoices_all := NULL;

1106: IF lv_process_flag = 'E' THEN
1107: goto end_of_outer_loop;
1108: END IF;
1109:
1110: r_ap_invoices_all := NULL;
1111:
1112: OPEN c_ap_invoices_all(p_invoice_id);
1113: FETCH c_ap_invoices_all into r_ap_invoices_all;
1114: CLOSE c_ap_invoices_all;

Line 1112: OPEN c_ap_invoices_all(p_invoice_id);

1108: END IF;
1109:
1110: r_ap_invoices_all := NULL;
1111:
1112: OPEN c_ap_invoices_all(p_invoice_id);
1113: FETCH c_ap_invoices_all into r_ap_invoices_all;
1114: CLOSE c_ap_invoices_all;
1115: /*Uncommented by mmurtuza for bug 13561970 */
1116: jai_ap_tds_generation_pkg.process_threshold_rollback(

Line 1113: FETCH c_ap_invoices_all into r_ap_invoices_all;

1109:
1110: r_ap_invoices_all := NULL;
1111:
1112: OPEN c_ap_invoices_all(p_invoice_id);
1113: FETCH c_ap_invoices_all into r_ap_invoices_all;
1114: CLOSE c_ap_invoices_all;
1115: /*Uncommented by mmurtuza for bug 13561970 */
1116: jai_ap_tds_generation_pkg.process_threshold_rollback(
1117: p_invoice_id => p_invoice_id,

Line 1114: CLOSE c_ap_invoices_all;

1110: r_ap_invoices_all := NULL;
1111:
1112: OPEN c_ap_invoices_all(p_invoice_id);
1113: FETCH c_ap_invoices_all into r_ap_invoices_all;
1114: CLOSE c_ap_invoices_all;
1115: /*Uncommented by mmurtuza for bug 13561970 */
1116: jai_ap_tds_generation_pkg.process_threshold_rollback(
1117: p_invoice_id => p_invoice_id,
1118: p_before_threshold_type => lv_threshold_type_before, /*Bug 13561970*/

Line 1123: p_org_id => r_ap_invoices_all.org_id,

1119: p_after_threshold_type => lv_after_threshold_type,
1120: p_before_threshold_slab_id => ln_threshold_slab_id,
1121: p_after_threshold_slab_id => ln_after_threshold_slab_id,
1122: p_threshold_grp_id => cur_rec.threshold_grp_id,
1123: p_org_id => r_ap_invoices_all.org_id,
1124: p_accounting_date => sysdate, --modified ld_accounting_date to sysdate by Bgowrava for bug#8682951
1125: p_process_flag => lv_process_flag,
1126: p_process_message => lv_process_message,
1127: p_codepath => lv_codepath);