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 602: PROCEDURE Get_Default_Rate (p_tax_code IN ap_tax_codes_all.name%TYPE,

598: -- p_calling_sequence IN
599: -- p_tax_recovery_rate IN OUT NOCOPY
600:
601: /* Get_Default_Rate */
602: PROCEDURE Get_Default_Rate (p_tax_code IN ap_tax_codes_all.name%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,

Line 603: p_tax_id IN ap_tax_codes_all.tax_id%TYPE,

599: -- p_tax_recovery_rate IN OUT NOCOPY
600:
601: /* Get_Default_Rate */
602: PROCEDURE Get_Default_Rate (p_tax_code IN ap_tax_codes_all.name%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,

Line 609: p_user_tax_recovery_rate IN ap_tax_codes_all.tax_rate%TYPE,

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

Line 618: p_tc_tax_recovery_rule_id IN ap_tax_codes_all.tax_recovery_rule_id%TYPE,

614: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
615: FUNC_SHORT_NAME IN VARCHAR2 default 'NONE',
616: p_calling_sequence IN VARCHAR2,
617: p_chart_of_accounts_id IN gl_ledgers.chart_of_accounts_id%TYPE,
618: p_tc_tax_recovery_rule_id IN ap_tax_codes_all.tax_recovery_rule_id%TYPE,
619: p_tc_tax_recovery_rate IN ap_tax_codes_all.tax_recovery_rate%TYPE,
620: p_vendor_type_lookup_code IN po_vendors.vendor_type_lookup_code%TYPE,
621: p_tax_recovery_rate IN OUT NOCOPY number) AS
622:

Line 619: p_tc_tax_recovery_rate IN ap_tax_codes_all.tax_recovery_rate%TYPE,

615: FUNC_SHORT_NAME IN VARCHAR2 default 'NONE',
616: p_calling_sequence IN VARCHAR2,
617: p_chart_of_accounts_id IN gl_ledgers.chart_of_accounts_id%TYPE,
618: p_tc_tax_recovery_rule_id IN ap_tax_codes_all.tax_recovery_rule_id%TYPE,
619: p_tc_tax_recovery_rate IN ap_tax_codes_all.tax_recovery_rate%TYPE,
620: p_vendor_type_lookup_code IN po_vendors.vendor_type_lookup_code%TYPE,
621: p_tax_recovery_rate IN OUT NOCOPY number) AS
622:
623:

Line 625: l_rule_id ap_tax_codes_all.tax_recovery_rule_id%TYPE;

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

Line 626: l_tax_rate ap_tax_codes_all.tax_recovery_rate%TYPE;

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

Line 638: l_tax_type ap_tax_codes_all.tax_type%type;

634: -- == l_tax_from_po_flag ap_system_parameters_all.tax_from_po_flag%TYPE;
635: l_tax_rule_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
636: lp_concatenate varchar2(2000);
637: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;
638: l_tax_type ap_tax_codes_all.tax_type%type;
639: l_get_rule_rate NUMBER;
640: -- == l_match_on_tax_flag ap_system_parameters_all.match_on_tax_flag%type;--added for bug 3960162.
641:
642: --REM

Line 664: FROM ap_tax_codes_all tc

660: /* ==
661: --Fixed bug 1036684, removed nvl from cursor.
662: CURSOR c_rule_rate_cd IS
663: SELECT tc.tax_recovery_rule_id, tc.tax_recovery_rate
664: FROM ap_tax_codes_all tc
665: WHERE tc.name = p_tax_code
666: AND p_tax_date BETWEEN tc.start_date
667: AND nvl(tc.inactive_date,p_tax_date)
668: AND tc.enabled_flag='Y' ;

Line 679: FROM ap_tax_codes_all tc

675: /* ==
676: --Fixed bug 1036684, removed nvl from cursor.
677: CURSOR c_rule_rate_id IS
678: SELECT tc.tax_recovery_rule_id,tc.tax_recovery_rate
679: FROM ap_tax_codes_all tc
680: WHERE tc.tax_id = p_tax_id
681: AND tc.enabled_flag='Y';
682: -- Bug1094321 fix , added Condition value for the vendor
683: CURSOR c_cond_val IS

Line 719: FROM ap_tax_codes_all

715:
716: /* ==
717: CURSOR c_tax_type is
718: SELECT tax_type
719: FROM ap_tax_codes_all
720: WHERE tax_id = p_tax_id;
721:
722: CURSOR c_tax_type_csr is
723: SELECT tax_type

Line 724: FROM ap_tax_codes_all

720: WHERE tax_id = p_tax_id;
721:
722: CURSOR c_tax_type_csr is
723: SELECT tax_type
724: FROM ap_tax_codes_all
725: WHERE tax_id in (SELECT
726: tax_id
727: FROM ap_tax_codes_all
728: WHERE

Line 727: FROM ap_tax_codes_all

723: SELECT tax_type
724: FROM ap_tax_codes_all
725: WHERE tax_id in (SELECT
726: tax_id
727: FROM ap_tax_codes_all
728: WHERE
729: name = p_tax_code and
730: p_tax_date between start_date and
731: inactive_date and enabled_flag = 'Y');