APPS.JAI_AP_OI_PROCESSING_PKG dependencies on AP_INVOICES_ALL

Line 9: cursor c_ap_invoices_all(p_invoice_id number) is

5: (
6: p_invoice_id in number
7: )return varchar2
8: is
9: cursor c_ap_invoices_all(p_invoice_id number) is
10: select vendor_id,
11: vendor_site_id,
12: org_id
13: from ap_invoices_all

Line 13: from ap_invoices_all

9: cursor c_ap_invoices_all(p_invoice_id number) is
10: select vendor_id,
11: vendor_site_id,
12: org_id
13: from ap_invoices_all
14: where invoice_id = p_invoice_id;
15:
16: cursor c_ja_in_po_vendor_sites(p_vendor_id number, p_vendor_site_id number) is
17: select nvl( approved_tds_flag, 'N' ) approved_invoice_flag

Line 22: r_ap_invoices_all c_ap_invoices_all%rowtype;

18: from JAI_CMN_VENDOR_SITES
19: where vendor_id = p_vendor_id
20: and vendor_site_id = p_vendor_site_id;
21:
22: r_ap_invoices_all c_ap_invoices_all%rowtype;
23: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_tds_flag%type;
24: begin
25:
26: open c_ap_invoices_all(p_invoice_id);

Line 26: open c_ap_invoices_all(p_invoice_id);

22: r_ap_invoices_all c_ap_invoices_all%rowtype;
23: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_tds_flag%type;
24: begin
25:
26: open c_ap_invoices_all(p_invoice_id);
27: fetch c_ap_invoices_all into r_ap_invoices_all;
28: close c_ap_invoices_all;
29:
30: /* Check for vendor and site */

Line 27: fetch c_ap_invoices_all into r_ap_invoices_all;

23: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_tds_flag%type;
24: begin
25:
26: open c_ap_invoices_all(p_invoice_id);
27: fetch c_ap_invoices_all into r_ap_invoices_all;
28: close c_ap_invoices_all;
29:
30: /* Check for vendor and site */
31: open c_ja_in_po_vendor_sites(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_id);

Line 28: close c_ap_invoices_all;

24: begin
25:
26: open c_ap_invoices_all(p_invoice_id);
27: fetch c_ap_invoices_all into r_ap_invoices_all;
28: close c_ap_invoices_all;
29:
30: /* Check for vendor and site */
31: open c_ja_in_po_vendor_sites(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_id);
32: fetch c_ja_in_po_vendor_sites into lv_approved_invoice_flag;

Line 31: open c_ja_in_po_vendor_sites(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_id);

27: fetch c_ap_invoices_all into r_ap_invoices_all;
28: close c_ap_invoices_all;
29:
30: /* Check for vendor and site */
31: open c_ja_in_po_vendor_sites(r_ap_invoices_all.vendor_id, r_ap_invoices_all.vendor_site_id);
32: fetch c_ja_in_po_vendor_sites into lv_approved_invoice_flag;
33: close c_ja_in_po_vendor_sites;
34:
35:

Line 38: open c_ja_in_po_vendor_sites(r_ap_invoices_all.vendor_id, 0);

34:
35:
36: if nvl(lv_approved_invoice_flag, 'N') <> 'Y' then
37: /* Pre-approved TDS invoice is not set for vendor and site, Check for vendor and null site */
38: open c_ja_in_po_vendor_sites(r_ap_invoices_all.vendor_id, 0);
39: fetch c_ja_in_po_vendor_sites into lv_approved_invoice_flag;
40: close c_ja_in_po_vendor_sites;
41: end if;
42:

Line 63: from ap_invoices_all

59: and line_number = cp_line_number;
60:
61: CURSOR c_invs( cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE) IS
62: Select *
63: from ap_invoices_all
64: where invoice_id = cp_invoice_id;
65:
66: Cursor c_match_tax
67: ( cp_match_type VARCHAR2,

Line 107: invs_rec ap_invoices_all%rowtype;

103: ln_shipment_line_id NUMBER;
104: ln_shipment_header_id NUMBER;
105: lv_shipment_num rcv_headers_interface.shipment_num%type;
106: lb_result BOOLEAN := FALSE ;
107: invs_rec ap_invoices_all%rowtype;
108: inv_lines_rec ap_invoice_lines_all%rowtype;
109: ln_vendor_id NUMBER;
110: ln_index number := 1;
111: l_tax_line_tbl jai_ap_match_tax_proc_pkg.l_tax_line_tbl_type;

Line 216: pr_rec AP_INVOICES_ALL%ROWTYPE,

212:
213: PROCEDURE PROCESS_INVOICE
214: (
215: pv_action VARCHAR2,
216: pr_rec AP_INVOICES_ALL%ROWTYPE,
217: pv_return_code OUT NOCOPY VARCHAR2,
218: pv_return_message OUT NOCOPY VARCHAR2
219: ) IS
220:

Line 277: update AP_INVOICES_ALL

273:
274: IF ( pr_rec.source = 'INDIA TDS') THEN
275: IF pr_rec.attribute1 IS NOT NULL THEN
276: if ( auto_approval_inv(pr_rec.attribute1) = 'Y') then
277: update AP_INVOICES_ALL
278: SET WFAPPROVAL_STATUS = 'NOT REQUIRED'
279: WHERE INVOICE_ID = pr_rec.invoice_id;
280: end if;
281: END IF;