APPS.ZX_TAX_RECOVERY_PKG dependencies on PO_VENDORS

Line 423: p_vendorclass in po_vendors.vendor_type_lookup_code%TYPE,

419: --REM For uniform naming convention l_rule parameter IN changed to " p_rule"
420: --REM ----------------------------------------------------------------------+
421: FUNCTION Get_Rule_Rate (p_rule IN NUMBER,
422: p_tax_date IN DATE default SYSDATE,
423: p_vendorclass in po_vendors.vendor_type_lookup_code%TYPE,
424: p_concatenate in VARCHAR2) RETURN NUMBER IS
425:
426: l_rec_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
427: l_procedure ap_tax_recvry_rates_all.function%TYPE;

Line 620: p_vendor_id IN po_vendors.vendor_id%TYPE,

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,
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,

Line 634: p_vendor_type_lookup_code IN po_vendors.vendor_type_lookup_code%TYPE,

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:
638: l_curr_calling_sequence VARCHAR2(2000);

Line 651: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;

647: -- == l_non_rec_tax_flag financials_system_params_all.non_recoverable_tax_flag%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:

Line 699: FROM po_vendors

695: AND tc.enabled_flag='Y';
696: -- Bug1094321 fix , added Condition value for the vendor
697: CURSOR c_cond_val IS
698: SELECT vendor_type_lookup_code
699: FROM po_vendors
700: WHERE po_vendors.vendor_id = p_vendor_id;
701:
702: == */
703:

Line 700: WHERE po_vendors.vendor_id = p_vendor_id;

696: -- Bug1094321 fix , added Condition value for the vendor
697: CURSOR c_cond_val IS
698: SELECT vendor_type_lookup_code
699: FROM po_vendors
700: WHERE po_vendors.vendor_id = p_vendor_id;
701:
702: == */
703:
704: /*created the cursor for bug 3960162 to fetch the match_on_tax_flag to default