APPS.ZX_TAX_RECOVERY_PKG dependencies on PO_VENDORS

Line 409: p_vendorclass in po_vendors.vendor_type_lookup_code%TYPE,

405: --REM For uniform naming convention l_rule parameter IN changed to " p_rule"
406: --REM ----------------------------------------------------------------------+
407: FUNCTION Get_Rule_Rate (p_rule IN NUMBER,
408: p_tax_date IN DATE default SYSDATE,
409: p_vendorclass in po_vendors.vendor_type_lookup_code%TYPE,
410: p_concatenate in VARCHAR2) RETURN NUMBER IS
411:
412: l_rec_rate ap_tax_recvry_rates_all.recovery_rate%TYPE;
413: l_procedure ap_tax_recvry_rates_all.function%TYPE;

Line 606: p_vendor_id IN po_vendors.vendor_id%TYPE,

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

Line 620: p_vendor_type_lookup_code IN po_vendors.vendor_type_lookup_code%TYPE,

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

Line 637: l_cond_val po_vendors.vendor_type_lookup_code%TYPE;

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

Line 685: FROM po_vendors

681: AND tc.enabled_flag='Y';
682: -- Bug1094321 fix , added Condition value for the vendor
683: CURSOR c_cond_val IS
684: SELECT vendor_type_lookup_code
685: FROM po_vendors
686: WHERE po_vendors.vendor_id = p_vendor_id;
687:
688: == */
689:

Line 686: WHERE po_vendors.vendor_id = p_vendor_id;

682: -- Bug1094321 fix , added Condition value for the vendor
683: CURSOR c_cond_val IS
684: SELECT vendor_type_lookup_code
685: FROM po_vendors
686: WHERE po_vendors.vendor_id = p_vendor_id;
687:
688: == */
689:
690: /*created the cursor for bug 3960162 to fetch the match_on_tax_flag to default