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 621: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE,

617: p_tax_id IN ap_tax_codes_all.tax_id%TYPE,
618: p_tax_date IN DATE default SYSDATE,
619: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
620: p_vendor_id IN po_vendors.vendor_id%TYPE,
621: p_distribution_id IN po_distributions_all.po_distribution_id%TYPE,
622: p_tax_user_override_flag IN VARCHAR2,
623: p_user_tax_recovery_rate IN ap_tax_codes_all.tax_rate%TYPE,
624: p_concatenated_segments IN VARCHAR2,
625: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE,

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

637:
638: l_curr_calling_sequence VARCHAR2(2000);
639: l_rule_id ap_tax_codes_all.tax_recovery_rule_id%TYPE;
640: l_tax_rate ap_tax_codes_all.tax_recovery_rate%TYPE;
641: -- TYPE get_rec_rate_tbl1 IS TABLE OF PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;
642: -- l_tax_rate get_rec_rate_tbl1;
643: -- l_tax_rate get_rec_rate_tbl;
644: i number;
645: l_rec_rate NUMBER;

Line 665: po_distributions_all po

661: /* ==
662: CURSOR c_tax_code_id IS
663: SELECT pll.tax_code_id
664: from po_line_locations_all pll,
665: po_distributions_all po
666: where pll.line_location_id = po.line_location_id and
667: po.po_distribution_id = p_distribution_id;
668:
669: == */