APPS.JAI_AP_TDS_GENERATION_PKG dependencies on AP_HOLDS_ALL

Line 696: cursor c_ap_holds_all(p_invoice_id number) is

692: and section_type = p_section_type; */
693:
694:
695:
696: cursor c_ap_holds_all(p_invoice_id number) is
697: select count(invoice_id)
698: from ap_holds_all
699: where invoice_id = p_invoice_id
700: and release_reason is null;

Line 698: from ap_holds_all

694:
695:
696: cursor c_ap_holds_all(p_invoice_id number) is
697: select count(invoice_id)
698: from ap_holds_all
699: where invoice_id = p_invoice_id
700: and release_reason is null;
701:
702:

Line 762: open c_ap_holds_all(p_invoice_id);

758: end if;
759:
760: -- if p_match_status_flag is not null then /*commented by mmurtuza for bug 16016037 */
761: /* Scenarios other than holds release */
762: open c_ap_holds_all(p_invoice_id);
763: fetch c_ap_holds_all into ln_no_of_holds;
764: close c_ap_holds_all;
765:
766: if nvl(ln_no_of_holds, 0) > 0 then

Line 763: fetch c_ap_holds_all into ln_no_of_holds;

759:
760: -- if p_match_status_flag is not null then /*commented by mmurtuza for bug 16016037 */
761: /* Scenarios other than holds release */
762: open c_ap_holds_all(p_invoice_id);
763: fetch c_ap_holds_all into ln_no_of_holds;
764: close c_ap_holds_all;
765:
766: if nvl(ln_no_of_holds, 0) > 0 then
767: p_is_invoice_validated := 'N';

Line 764: close c_ap_holds_all;

760: -- if p_match_status_flag is not null then /*commented by mmurtuza for bug 16016037 */
761: /* Scenarios other than holds release */
762: open c_ap_holds_all(p_invoice_id);
763: fetch c_ap_holds_all into ln_no_of_holds;
764: close c_ap_holds_all;
765:
766: if nvl(ln_no_of_holds, 0) > 0 then
767: p_is_invoice_validated := 'N';
768: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */