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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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