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.AP_APPROVAL_PKG dependencies on AP_INVOICES

Line 15: org_id ap_invoices_all.org_id%type);

11: TYPE g_org_holds_rec IS RECORD(
12: hold_lookup_code ap_holds_all.hold_lookup_code%type,
13: holds_placed NUMBER,
14: holds_released NUMBER,
15: org_id ap_invoices_all.org_id%type);
16:
17: TYPE g_org_holds_tab IS TABLE OF g_org_holds_rec
18: INDEX BY BINARY_INTEGER;
19:

Line 92: invoice_id ap_invoices_all.invoice_id%type,

88: G_OPTIONS_TABLE Options_Table;
89: ---
90:
91: TYPE Invoice_Rec IS RECORD(
92: invoice_id ap_invoices_all.invoice_id%type,
93: invoice_num ap_invoices_all.invoice_num%type,
94: org_id ap_invoices_all.org_id%type,
95: invoice_amount ap_invoices_all.invoice_amount%type,
96: base_amount ap_invoices_all.base_amount%type,

Line 93: invoice_num ap_invoices_all.invoice_num%type,

89: ---
90:
91: TYPE Invoice_Rec IS RECORD(
92: invoice_id ap_invoices_all.invoice_id%type,
93: invoice_num ap_invoices_all.invoice_num%type,
94: org_id ap_invoices_all.org_id%type,
95: invoice_amount ap_invoices_all.invoice_amount%type,
96: base_amount ap_invoices_all.base_amount%type,
97: exchange_rate ap_invoices_all.exchange_rate%type,

Line 94: org_id ap_invoices_all.org_id%type,

90:
91: TYPE Invoice_Rec IS RECORD(
92: invoice_id ap_invoices_all.invoice_id%type,
93: invoice_num ap_invoices_all.invoice_num%type,
94: org_id ap_invoices_all.org_id%type,
95: invoice_amount ap_invoices_all.invoice_amount%type,
96: base_amount ap_invoices_all.base_amount%type,
97: exchange_rate ap_invoices_all.exchange_rate%type,
98: invoice_currency_code ap_invoices_all.invoice_currency_code%type,

Line 95: invoice_amount ap_invoices_all.invoice_amount%type,

91: TYPE Invoice_Rec IS RECORD(
92: invoice_id ap_invoices_all.invoice_id%type,
93: invoice_num ap_invoices_all.invoice_num%type,
94: org_id ap_invoices_all.org_id%type,
95: invoice_amount ap_invoices_all.invoice_amount%type,
96: base_amount ap_invoices_all.base_amount%type,
97: exchange_rate ap_invoices_all.exchange_rate%type,
98: invoice_currency_code ap_invoices_all.invoice_currency_code%type,
99: invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type,

Line 96: base_amount ap_invoices_all.base_amount%type,

92: invoice_id ap_invoices_all.invoice_id%type,
93: invoice_num ap_invoices_all.invoice_num%type,
94: org_id ap_invoices_all.org_id%type,
95: invoice_amount ap_invoices_all.invoice_amount%type,
96: base_amount ap_invoices_all.base_amount%type,
97: exchange_rate ap_invoices_all.exchange_rate%type,
98: invoice_currency_code ap_invoices_all.invoice_currency_code%type,
99: invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type,
100: hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type,

Line 97: exchange_rate ap_invoices_all.exchange_rate%type,

93: invoice_num ap_invoices_all.invoice_num%type,
94: org_id ap_invoices_all.org_id%type,
95: invoice_amount ap_invoices_all.invoice_amount%type,
96: base_amount ap_invoices_all.base_amount%type,
97: exchange_rate ap_invoices_all.exchange_rate%type,
98: invoice_currency_code ap_invoices_all.invoice_currency_code%type,
99: invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type,
100: hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type,
101: invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type,

Line 98: invoice_currency_code ap_invoices_all.invoice_currency_code%type,

94: org_id ap_invoices_all.org_id%type,
95: invoice_amount ap_invoices_all.invoice_amount%type,
96: base_amount ap_invoices_all.base_amount%type,
97: exchange_rate ap_invoices_all.exchange_rate%type,
98: invoice_currency_code ap_invoices_all.invoice_currency_code%type,
99: invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type,
100: hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type,
101: invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type,
102: exchange_date ap_invoices_all.exchange_date%type,

Line 101: invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type,

97: exchange_rate ap_invoices_all.exchange_rate%type,
98: invoice_currency_code ap_invoices_all.invoice_currency_code%type,
99: invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type,
100: hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type,
101: invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type,
102: exchange_date ap_invoices_all.exchange_date%type,
103: exchange_rate_type ap_invoices_all.exchange_rate_type%type,
104: vendor_id ap_invoices_all.vendor_id%type,
105: invoice_date ap_invoices_all.invoice_date%type,

Line 102: exchange_date ap_invoices_all.exchange_date%type,

98: invoice_currency_code ap_invoices_all.invoice_currency_code%type,
99: invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type,
100: hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type,
101: invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type,
102: exchange_date ap_invoices_all.exchange_date%type,
103: exchange_rate_type ap_invoices_all.exchange_rate_type%type,
104: vendor_id ap_invoices_all.vendor_id%type,
105: invoice_date ap_invoices_all.invoice_date%type,
106: disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type,

Line 103: exchange_rate_type ap_invoices_all.exchange_rate_type%type,

99: invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type,
100: hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type,
101: invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type,
102: exchange_date ap_invoices_all.exchange_date%type,
103: exchange_rate_type ap_invoices_all.exchange_rate_type%type,
104: vendor_id ap_invoices_all.vendor_id%type,
105: invoice_date ap_invoices_all.invoice_date%type,
106: disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type,
107: exclude_freight_from_discount ap_invoices_all.exclude_freight_from_discount%type,

Line 104: vendor_id ap_invoices_all.vendor_id%type,

100: hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type,
101: invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type,
102: exchange_date ap_invoices_all.exchange_date%type,
103: exchange_rate_type ap_invoices_all.exchange_rate_type%type,
104: vendor_id ap_invoices_all.vendor_id%type,
105: invoice_date ap_invoices_all.invoice_date%type,
106: disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type,
107: exclude_freight_from_discount ap_invoices_all.exclude_freight_from_discount%type,
108: tolerance_id ap_supplier_sites_all.tolerance_id%type,

Line 105: invoice_date ap_invoices_all.invoice_date%type,

101: invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type,
102: exchange_date ap_invoices_all.exchange_date%type,
103: exchange_rate_type ap_invoices_all.exchange_rate_type%type,
104: vendor_id ap_invoices_all.vendor_id%type,
105: invoice_date ap_invoices_all.invoice_date%type,
106: disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type,
107: exclude_freight_from_discount ap_invoices_all.exclude_freight_from_discount%type,
108: tolerance_id ap_supplier_sites_all.tolerance_id%type,
109: services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type);

Line 106: disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type,

102: exchange_date ap_invoices_all.exchange_date%type,
103: exchange_rate_type ap_invoices_all.exchange_rate_type%type,
104: vendor_id ap_invoices_all.vendor_id%type,
105: invoice_date ap_invoices_all.invoice_date%type,
106: disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type,
107: exclude_freight_from_discount ap_invoices_all.exclude_freight_from_discount%type,
108: tolerance_id ap_supplier_sites_all.tolerance_id%type,
109: services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type);
110:

Line 107: exclude_freight_from_discount ap_invoices_all.exclude_freight_from_discount%type,

103: exchange_rate_type ap_invoices_all.exchange_rate_type%type,
104: vendor_id ap_invoices_all.vendor_id%type,
105: invoice_date ap_invoices_all.invoice_date%type,
106: disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type,
107: exclude_freight_from_discount ap_invoices_all.exclude_freight_from_discount%type,
108: tolerance_id ap_supplier_sites_all.tolerance_id%type,
109: services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type);
110:
111: TYPE Invoices_Table IS TABLE OF Invoice_Rec

Line 215: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

211: p_release_count IN OUT NOCOPY COUNTARRAY,
212: p_calling_sequence IN VARCHAR2);
213:
214: PROCEDURE Check_Insufficient_Line_Data(
215: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
216: p_system_user IN NUMBER,
217: p_holds IN OUT NOCOPY HOLDSARRAY,
218: p_holds_count IN OUT NOCOPY COUNTARRAY,
219: p_release_count IN OUT NOCOPY COUNTARRAY,

Line 233: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

229: p_invoice_currency IN VARCHAR2,
230: p_exchange_rate IN NUMBER,
231: p_exchange_rate_type IN VARCHAR2,
232: p_exchange_date IN DATE,
233: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
234: p_system_user IN NUMBER,
235: p_holds IN OUT NOCOPY HOLDSARRAY,
236: p_holds_count IN OUT NOCOPY COUNTARRAY,
237: p_release_count IN OUT NOCOPY COUNTARRAY,

Line 253: P_Invoice_Line_Rec IN AP_INVOICES_PKG.r_invoice_line_rec,

249:
250: --Bugfix:4673607
251: FUNCTION Gen_Dists_From_Registration(
252: P_Batch_Id IN NUMBER,
253: P_Invoice_Line_Rec IN AP_INVOICES_PKG.r_invoice_line_rec,
254: P_Registration_Api IN VARCHAR2,
255: P_Registration_View IN VARCHAR2,
256: P_Generate_Permanent IN VARCHAR2,
257: X_Error_Code OUT NOCOPY VARCHAR2,

Line 291: P_INVOICE_ID IN AP_INVOICES.INVOICE_ID%TYPE,

287: RETURN NUMBER;
288:
289: --Start 8691645
290: PROCEDURE CHECK_CCR_VENDOR(
291: P_INVOICE_ID IN AP_INVOICES.INVOICE_ID%TYPE,
292: P_VENDOR_ID IN AP_INVOICES.VENDOR_ID%TYPE,
293: P_VENDOR_SITE_ID IN AP_INVOICES.VENDOR_SITE_ID%TYPE,
294: P_REMIT_TO_SUPPLIER_SITE_ID IN AP_INVOICES.REMIT_TO_SUPPLIER_SITE_ID%TYPE,
295: P_SYSTEM_USER IN NUMBER,

Line 292: P_VENDOR_ID IN AP_INVOICES.VENDOR_ID%TYPE,

288:
289: --Start 8691645
290: PROCEDURE CHECK_CCR_VENDOR(
291: P_INVOICE_ID IN AP_INVOICES.INVOICE_ID%TYPE,
292: P_VENDOR_ID IN AP_INVOICES.VENDOR_ID%TYPE,
293: P_VENDOR_SITE_ID IN AP_INVOICES.VENDOR_SITE_ID%TYPE,
294: P_REMIT_TO_SUPPLIER_SITE_ID IN AP_INVOICES.REMIT_TO_SUPPLIER_SITE_ID%TYPE,
295: P_SYSTEM_USER IN NUMBER,
296: P_HOLDS IN OUT NOCOPY HOLDSARRAY,

Line 293: P_VENDOR_SITE_ID IN AP_INVOICES.VENDOR_SITE_ID%TYPE,

289: --Start 8691645
290: PROCEDURE CHECK_CCR_VENDOR(
291: P_INVOICE_ID IN AP_INVOICES.INVOICE_ID%TYPE,
292: P_VENDOR_ID IN AP_INVOICES.VENDOR_ID%TYPE,
293: P_VENDOR_SITE_ID IN AP_INVOICES.VENDOR_SITE_ID%TYPE,
294: P_REMIT_TO_SUPPLIER_SITE_ID IN AP_INVOICES.REMIT_TO_SUPPLIER_SITE_ID%TYPE,
295: P_SYSTEM_USER IN NUMBER,
296: P_HOLDS IN OUT NOCOPY HOLDSARRAY,
297: P_HOLDS_COUNT IN OUT NOCOPY COUNTARRAY,

Line 294: P_REMIT_TO_SUPPLIER_SITE_ID IN AP_INVOICES.REMIT_TO_SUPPLIER_SITE_ID%TYPE,

290: PROCEDURE CHECK_CCR_VENDOR(
291: P_INVOICE_ID IN AP_INVOICES.INVOICE_ID%TYPE,
292: P_VENDOR_ID IN AP_INVOICES.VENDOR_ID%TYPE,
293: P_VENDOR_SITE_ID IN AP_INVOICES.VENDOR_SITE_ID%TYPE,
294: P_REMIT_TO_SUPPLIER_SITE_ID IN AP_INVOICES.REMIT_TO_SUPPLIER_SITE_ID%TYPE,
295: P_SYSTEM_USER IN NUMBER,
296: P_HOLDS IN OUT NOCOPY HOLDSARRAY,
297: P_HOLDS_COUNT IN OUT NOCOPY COUNTARRAY,
298: P_RELEASE_COUNT IN OUT NOCOPY COUNTARRAY,

Line 303: PROCEDURE UPDATE_SCHEDULES(P_INVOICE_ID IN AP_INVOICES.INVOICE_ID%TYPE,

299: P_VENDOR_SITE_REG_EXPIRED OUT NOCOPY VARCHAR2,
300: P_CALLING_SEQUENCE IN VARCHAR2);
301:
302:
303: PROCEDURE UPDATE_SCHEDULES(P_INVOICE_ID IN AP_INVOICES.INVOICE_ID%TYPE,
304: P_CALLING_SEQUENCE IN VARCHAR2);
305:
306: PROCEDURE BATCH_APPROVAL_FOR_VENDOR(P_VENDOR_ID IN AP_INVOICES.VENDOR_ID%TYPE,
307: P_CALLING_SEQUENCE IN VARCHAR2);

Line 306: PROCEDURE BATCH_APPROVAL_FOR_VENDOR(P_VENDOR_ID IN AP_INVOICES.VENDOR_ID%TYPE,

302:
303: PROCEDURE UPDATE_SCHEDULES(P_INVOICE_ID IN AP_INVOICES.INVOICE_ID%TYPE,
304: P_CALLING_SEQUENCE IN VARCHAR2);
305:
306: PROCEDURE BATCH_APPROVAL_FOR_VENDOR(P_VENDOR_ID IN AP_INVOICES.VENDOR_ID%TYPE,
307: P_CALLING_SEQUENCE IN VARCHAR2);
308: --End 8691645
309:
310: --GTAS Project Bug#13464635 Begin