DBA Data[Home] [Help]

APPS.ZX_PO_REC_PKG dependencies on PO_HEADERS_ALL

Line 24: TYPE trx_date_tbl IS TABLE OF PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

20: PROCEDURE get_rec_info(
21: x_return_status OUT NOCOPY VARCHAR2);
22:
23: TYPE tax_code_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
24: TYPE trx_date_tbl IS TABLE OF PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
25: TYPE code_combination_id_tbl IS TABLE OF PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE vendor_id_tbl IS TABLE OF PO_VENDORS.VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
27: TYPE tax_recovery_override_flag_tbl IS TABLE OF PO_DISTRIBUTIONS_ALL.tax_recovery_override_flag%TYPE INDEX BY BINARY_INTEGER;
28: TYPE tax_recovery_rate_tbl IS TABLE OF PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 38: TYPE po_header_id_tbl IS TABLE OF PO_HEADERS_ALL.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

34: TYPE tc_tax_recovery_rule_id_tbl IS TABLE OF ap_tax_codes_all.tax_recovery_rule_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE tc_tax_recovery_rate_tbl IS TABLE OF ap_tax_codes_all.tax_recovery_rate%TYPE INDEX BY BINARY_INTEGER;
36: TYPE vendor_type_lookup_code_tbl IS TABLE OF po_vendors.vendor_type_lookup_code%TYPE INDEX BY BINARY_INTEGER;
37:
38: TYPE po_header_id_tbl IS TABLE OF PO_HEADERS_ALL.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
39: TYPE po_line_id_tbl IS TABLE OF PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
40: TYPE po_dist_id_tbl IS TABLE OF PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
41:
42: pg_get_tax_recovery_rate_tab get_rec_rate_tbl;