APPS.JAI_AP_DTC_GENERATION_PKG dependencies on AP_HOLDS_ALL

Line 1223: cursor c_ap_holds_all(p_invoice_id number) is

1219: and section_type = p_section_type; */
1220:
1221:
1222:
1223: cursor c_ap_holds_all(p_invoice_id number) is
1224: select count(invoice_id)
1225: from ap_holds_all
1226: where invoice_id = p_invoice_id
1227: and release_reason is null;

Line 1225: from ap_holds_all

1221:
1222:
1223: cursor c_ap_holds_all(p_invoice_id number) is
1224: select count(invoice_id)
1225: from ap_holds_all
1226: where invoice_id = p_invoice_id
1227: and release_reason is null;
1228:
1229:

Line 1290: open c_ap_holds_all(p_invoice_id);

1286: end if;
1287:
1288: if p_match_status_flag is not null then
1289: /* Scenarios other than holds release */
1290: open c_ap_holds_all(p_invoice_id);
1291: fetch c_ap_holds_all into ln_no_of_holds;
1292: close c_ap_holds_all;
1293:
1294: if nvl(ln_no_of_holds, 0) > 0 then

Line 1291: fetch c_ap_holds_all into ln_no_of_holds;

1287:
1288: if p_match_status_flag is not null then
1289: /* Scenarios other than holds release */
1290: open c_ap_holds_all(p_invoice_id);
1291: fetch c_ap_holds_all into ln_no_of_holds;
1292: close c_ap_holds_all;
1293:
1294: if nvl(ln_no_of_holds, 0) > 0 then
1295: p_is_invoice_validated := 'N';

Line 1292: close c_ap_holds_all;

1288: if p_match_status_flag is not null then
1289: /* Scenarios other than holds release */
1290: open c_ap_holds_all(p_invoice_id);
1291: fetch c_ap_holds_all into ln_no_of_holds;
1292: close c_ap_holds_all;
1293:
1294: if nvl(ln_no_of_holds, 0) > 0 then
1295: p_is_invoice_validated := 'N';
1296: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */