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.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 2836: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;

2832: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2833: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2834: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2835: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2836: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2837: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2838: l_collector_name VARCHAR2(80) := NULL;
2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';

Line 2837: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;

2833: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2834: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2835: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2836: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2837: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2838: l_collector_name VARCHAR2(80) := NULL;
2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;

Line 2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;

2835: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2836: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2837: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2838: l_collector_name VARCHAR2(80) := NULL;
2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';

Line 2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';

2836: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2837: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2838: l_collector_name VARCHAR2(80) := NULL;
2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';

Line 2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;

2837: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2838: l_collector_name VARCHAR2(80) := NULL;
2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';

Line 2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;

2838: l_collector_name VARCHAR2(80) := NULL;
2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';

Line 2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';

2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2847: l_statement_cycle_name VARCHAR2(80) := NULL;

Line 2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';

2840: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2847: l_statement_cycle_name VARCHAR2(80) := NULL;
2848: l_standard_terms_name VARCHAR2(80) := NULL;

Line 2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';

2841: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2847: l_statement_cycle_name VARCHAR2(80) := NULL;
2848: l_standard_terms_name VARCHAR2(80) := NULL;
2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';

Line 2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';

2842: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2843: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2847: l_statement_cycle_name VARCHAR2(80) := NULL;
2848: l_standard_terms_name VARCHAR2(80) := NULL;
2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';

Line 2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';

2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2847: l_statement_cycle_name VARCHAR2(80) := NULL;
2848: l_standard_terms_name VARCHAR2(80) := NULL;
2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;

Line 2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';

2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2847: l_statement_cycle_name VARCHAR2(80) := NULL;
2848: l_standard_terms_name VARCHAR2(80) := NULL;
2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;

Line 2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;

2847: l_statement_cycle_name VARCHAR2(80) := NULL;
2848: l_standard_terms_name VARCHAR2(80) := NULL;
2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;

Line 2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;

2848: l_standard_terms_name VARCHAR2(80) := NULL;
2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';

Line 2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;

2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;

Line 2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;

2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;

Line 2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;

2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;

Line 2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';

2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;

Line 2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;

2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;

Line 2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;

2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;

Line 2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;

2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2864: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;

Line 2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;

2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2864: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2865: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;

Line 2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;

2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2864: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2865: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2866: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';

Line 2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;

2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2864: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2865: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2866: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2867: l_autocash_hierarchy_name VARCHAR2(80) := NULL;

Line 2864: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;

2860: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2864: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2865: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2866: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2867: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2868: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;

Line 2865: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;

2861: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2864: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2865: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2866: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2867: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2868: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2869: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;

Line 2866: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';

2862: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2863: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2864: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2865: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2866: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2867: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2868: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2869: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2870: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';

Line 2869: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;

2865: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2866: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2867: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2868: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2869: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2870: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2871: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2872: l_grouping_rule_name VARCHAR2(80) := NULL;
2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;

Line 2870: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';

2866: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2867: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2868: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2869: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2870: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2871: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2872: l_grouping_rule_name VARCHAR2(80) := NULL;
2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2874: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';

Line 2871: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;

2867: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2868: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2869: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2870: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2871: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2872: l_grouping_rule_name VARCHAR2(80) := NULL;
2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2874: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2875: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;

Line 2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;

2869: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2870: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2871: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2872: l_grouping_rule_name VARCHAR2(80) := NULL;
2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2874: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2875: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2876: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2877: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;

Line 2874: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';

2870: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2871: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2872: l_grouping_rule_name VARCHAR2(80) := NULL;
2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2874: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2875: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2876: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2877: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2878: l_lockbox_matching_name VARCHAR2(80) := NULL;

Line 2875: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;

2871: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2872: l_grouping_rule_name VARCHAR2(80) := NULL;
2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2874: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2875: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2876: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2877: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2878: l_lockbox_matching_name VARCHAR2(80) := NULL;
2879:

Line 2876: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;

2872: l_grouping_rule_name VARCHAR2(80) := NULL;
2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2874: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2875: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2876: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2877: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2878: l_lockbox_matching_name VARCHAR2(80) := NULL;
2879:
2880: s_Address_Id hz_locations.location_id%TYPE := NULL;

Line 2877: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;

2873: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2874: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2875: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2876: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2877: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2878: l_lockbox_matching_name VARCHAR2(80) := NULL;
2879:
2880: s_Address_Id hz_locations.location_id%TYPE := NULL;
2881: s_Status hz_party_sites.Status%TYPE := 'A';