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.ZX_TAX_RECOVERY_PKG dependencies on AP_TAX_CODES_ALL

Line 616: PROCEDURE Get_Default_Rate (p_tax_code IN ap_tax_codes_all.name%TYPE,

612: -- p_calling_sequence IN
613: -- p_tax_recovery_rate IN OUT NOCOPY
614:
615: /* Get_Default_Rate */
616: PROCEDURE Get_Default_Rate (p_tax_code IN ap_tax_codes_all.name%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,

Line 617: p_tax_id IN ap_tax_codes_all.tax_id%TYPE,

613: -- p_tax_recovery_rate IN OUT NOCOPY
614:
615: /* Get_Default_Rate */
616: PROCEDURE Get_Default_Rate (p_tax_code IN ap_tax_codes_all.name%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,

Line 623: p_user_tax_recovery_rate IN ap_tax_codes_all.tax_rate%TYPE,

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,
626: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
627: p_item_org_id IN mtl_system_items.organization_id%TYPE,

Line 632: p_tc_tax_recovery_rule_id IN ap_tax_codes_all.tax_recovery_rule_id%TYPE,

628: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
629: FUNC_SHORT_NAME IN VARCHAR2 default 'NONE',
630: p_calling_sequence IN VARCHAR2,
631: p_chart_of_accounts_id IN gl_ledgers.chart_of_accounts_id%TYPE,
632: p_tc_tax_recovery_rule_id IN ap_tax_codes_all.tax_recovery_rule_id%TYPE,
633: p_tc_tax_recovery_rate IN ap_tax_codes_all.tax_recovery_rate%TYPE,
634: p_vendor_type_lookup_code IN po_vendors.vendor_type_lookup_code%TYPE,
635: p_tax_recovery_rate IN OUT NOCOPY number) AS
636:

Line 633: p_tc_tax_recovery_rate IN ap_tax_codes_all.tax_recovery_rate%TYPE,

629: FUNC_SHORT_NAME IN VARCHAR2 default 'NONE',
630: p_calling_sequence IN VARCHAR2,
631: p_chart_of_accounts_id IN gl_ledgers.chart_of_accounts_id%TYPE,
632: p_tc_tax_recovery_rule_id IN ap_tax_codes_all.tax_recovery_rule_id%TYPE,
633: p_tc_tax_recovery_rate IN ap_tax_codes_all.tax_recovery_rate%TYPE,
634: p_vendor_type_lookup_code IN po_vendors.vendor_type_lookup_code%TYPE,
635: p_tax_recovery_rate IN OUT NOCOPY number) AS
636:
637:

Line 639: l_rule_id ap_tax_codes_all.tax_recovery_rule_id%TYPE;

635: p_tax_recovery_rate IN OUT NOCOPY number) AS
636:
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;

Line 640: l_tax_rate ap_tax_codes_all.tax_recovery_rate%TYPE;

636:
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;

Line 652: l_tax_type ap_tax_codes_all.tax_type%type;

648: -- == l_tax_from_po_flag ap_system_parameters_all.tax_from_po_flag%TYPE;
649: l_tax_rule_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
650: lp_concatenate varchar2(2000);
651: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;
652: l_tax_type ap_tax_codes_all.tax_type%type;
653: l_get_rule_rate NUMBER;
654: -- == l_match_on_tax_flag ap_system_parameters_all.match_on_tax_flag%type;--added for bug 3960162.
655:
656: --REM

Line 678: FROM ap_tax_codes_all tc

674: /* ==
675: --Fixed bug 1036684, removed nvl from cursor.
676: CURSOR c_rule_rate_cd IS
677: SELECT tc.tax_recovery_rule_id, tc.tax_recovery_rate
678: FROM ap_tax_codes_all tc
679: WHERE tc.name = p_tax_code
680: AND p_tax_date BETWEEN tc.start_date
681: AND nvl(tc.inactive_date,p_tax_date)
682: AND tc.enabled_flag='Y' ;

Line 693: FROM ap_tax_codes_all tc

689: /* ==
690: --Fixed bug 1036684, removed nvl from cursor.
691: CURSOR c_rule_rate_id IS
692: SELECT tc.tax_recovery_rule_id,tc.tax_recovery_rate
693: FROM ap_tax_codes_all tc
694: WHERE tc.tax_id = p_tax_id
695: AND tc.enabled_flag='Y';
696: -- Bug1094321 fix , added Condition value for the vendor
697: CURSOR c_cond_val IS

Line 733: FROM ap_tax_codes_all

729:
730: /* ==
731: CURSOR c_tax_type is
732: SELECT tax_type
733: FROM ap_tax_codes_all
734: WHERE tax_id = p_tax_id;
735:
736: CURSOR c_tax_type_csr is
737: SELECT tax_type

Line 738: FROM ap_tax_codes_all

734: WHERE tax_id = p_tax_id;
735:
736: CURSOR c_tax_type_csr is
737: SELECT tax_type
738: FROM ap_tax_codes_all
739: WHERE tax_id in (SELECT
740: tax_id
741: FROM ap_tax_codes_all
742: WHERE

Line 741: FROM ap_tax_codes_all

737: SELECT tax_type
738: FROM ap_tax_codes_all
739: WHERE tax_id in (SELECT
740: tax_id
741: FROM ap_tax_codes_all
742: WHERE
743: name = p_tax_code and
744: p_tax_date between start_date and
745: inactive_date and enabled_flag = 'Y');