APPS.ZX_TAX_RECOVERY_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 36: po_distributions_all.po_distribution_id%TYPE

32:
33: -- PROCEDURE initialize;
34:
35: FUNCTION Get_Po_Distribution_Rate (p_distribution_id IN
36: po_distributions_all.po_distribution_id%TYPE
37: ) RETURN NUMBER IS
38:
39: l_rec_rate po_distributions_all.recovery_rate%TYPE;
40: --l_curr_calling_sequence VARCHAR2(2000);

Line 39: l_rec_rate po_distributions_all.recovery_rate%TYPE;

35: FUNCTION Get_Po_Distribution_Rate (p_distribution_id IN
36: po_distributions_all.po_distribution_id%TYPE
37: ) RETURN NUMBER IS
38:
39: l_rec_rate po_distributions_all.recovery_rate%TYPE;
40: --l_curr_calling_sequence VARCHAR2(2000);
41:
42: CURSOR c_recovery_rate IS
43: SELECT pod.recovery_rate

Line 44: FROM po_distributions_all pod

40: --l_curr_calling_sequence VARCHAR2(2000);
41:
42: CURSOR c_recovery_rate IS
43: SELECT pod.recovery_rate
44: FROM po_distributions_all pod
45: WHERE pod.po_distribution_id = p_distribution_id;
46: BEGIN
47: --REM-------------------DEBUG INFORMATION------------------------------------+
48:

Line 607: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE,

603: p_tax_id IN ap_tax_codes_all.tax_id%TYPE,
604: p_tax_date IN DATE default SYSDATE,
605: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
606: p_vendor_id IN po_vendors.vendor_id%TYPE,
607: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE,
608: p_tax_user_override_flag IN VARCHAR2,
609: p_user_tax_recovery_rate IN ap_tax_codes_all.tax_rate%TYPE,
610: p_concatenated_segments IN VARCHAR2,
611: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE,

Line 627: -- TYPE get_rec_rate_tbl1 IS TABLE OF PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;

623:
624: l_curr_calling_sequence VARCHAR2(2000);
625: l_rule_id ap_tax_codes_all.tax_recovery_rule_id%TYPE;
626: l_tax_rate ap_tax_codes_all.tax_recovery_rate%TYPE;
627: -- TYPE get_rec_rate_tbl1 IS TABLE OF PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;
628: -- l_tax_rate get_rec_rate_tbl1;
629: -- l_tax_rate get_rec_rate_tbl;
630: i number;
631: l_rec_rate NUMBER;

Line 651: po_distributions_all po

647: /* ==
648: CURSOR c_tax_code_id IS
649: SELECT pll.tax_code_id
650: from po_line_locations_all pll,
651: po_distributions_all po
652: where pll.line_location_id = po.line_location_id and
653: po.po_distribution_id = p_distribution_id;
654:
655: == */