APPS.JAI_CMN_ST_FORMS_PKG dependencies on AP_INVOICES_ALL

Line 60: from ap_invoices_all

56:
57:
58: cursor c_get_ven_info(p_invoice_id number) is
59: select vendor_id, vendor_site_id, org_id
60: from ap_invoices_all
61: where invoice_id = p_invoice_id;
62:
63: cursor c_get_st_hdr_id(p_stform_type varchar2, p_vendor_id number, p_vendor_site_id number, p_org_id number) is
64: select st_hdr_id

Line 133: v_vendor_id ap_invoices_all.vendor_id%type;

129: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
130: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
131: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
132:
133: v_vendor_id ap_invoices_all.vendor_id%type;
134: v_vendor_site_id ap_invoices_all.vendor_site_id%type;
135: v_org_id ap_invoices_all.org_id%type;
136:
137: /*

Line 134: v_vendor_site_id ap_invoices_all.vendor_site_id%type;

130: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
131: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
132:
133: v_vendor_id ap_invoices_all.vendor_id%type;
134: v_vendor_site_id ap_invoices_all.vendor_site_id%type;
135: v_org_id ap_invoices_all.org_id%type;
136:
137: /*
138: Variable declaration changed by aiyer for the bug #3249375.

Line 135: v_org_id ap_invoices_all.org_id%type;

131: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
132:
133: v_vendor_id ap_invoices_all.vendor_id%type;
134: v_vendor_site_id ap_invoices_all.vendor_site_id%type;
135: v_org_id ap_invoices_all.org_id%type;
136:
137: /*
138: Variable declaration changed by aiyer for the bug #3249375.
139: Changed the variable declaration from reference to ja_in_po_st_forms_hdr.form_issue_id to JAI_CMN_STFORM_HDRS_ALL.st_hdr_id.

Line 205: v_set_of_books_id ap_invoices_all.set_of_books_id%type;

201: v_precedence_non_0 number;
202:
203: v_tax_base_amt number;
204:
205: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
206: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
207: v_exchange_date ap_invoices_all.exchange_date%type;
208: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
209: v_exchange_rate ap_invoices_all.exchange_rate%type;

Line 206: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

202:
203: v_tax_base_amt number;
204:
205: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
206: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
207: v_exchange_date ap_invoices_all.exchange_date%type;
208: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
209: v_exchange_rate ap_invoices_all.exchange_rate%type;
210:

Line 207: v_exchange_date ap_invoices_all.exchange_date%type;

203: v_tax_base_amt number;
204:
205: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
206: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
207: v_exchange_date ap_invoices_all.exchange_date%type;
208: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
209: v_exchange_rate ap_invoices_all.exchange_rate%type;
210:
211: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;

Line 208: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;

204:
205: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
206: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
207: v_exchange_date ap_invoices_all.exchange_date%type;
208: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
209: v_exchange_rate ap_invoices_all.exchange_rate%type;
210:
211: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
212:

Line 209: v_exchange_rate ap_invoices_all.exchange_rate%type;

205: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
206: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
207: v_exchange_date ap_invoices_all.exchange_date%type;
208: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
209: v_exchange_rate ap_invoices_all.exchange_rate%type;
210:
211: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
212:
213: v_line_number ap_invoice_lines_all.line_number%type ;

Line 217: from ap_invoices_all

213: v_line_number ap_invoice_lines_all.line_number%type ;
214:
215: cursor c_get_invoice_currency_dtl is
216: select set_of_books_id, invoice_currency_code,exchange_date, exchange_rate_type, exchange_rate
217: from ap_invoices_all
218: where invoice_id = p_invoice_id;
219:
220: /* uptake of ap_invoice_lines_all */
221: cursor c_get_inv_dist_details is

Line 462: from ap_invoices_all a

458:
459: for c_invoices in
460: (
461: select invoice_id, invoice_num, cancelled_date
462: from ap_invoices_all a
463: where invoice_date between trunc(p_invoice_from_date) and trunc(p_invoice_to_date)
464: and ( (p_org_id is null) or (p_org_id is not null and org_id = p_org_id) )
465: and ( (p_vendor_id is null) or (p_vendor_id is not null and vendor_id = p_vendor_id) )
466: and ( (p_vendor_site_id is null)