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 2330: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;

2326: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2327: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2328: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2329: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2330: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2331: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2332: l_collector_name VARCHAR2(80) := NULL;
2333: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2334: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';

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

2327: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2328: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2329: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2330: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2331: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2332: l_collector_name VARCHAR2(80) := NULL;
2333: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2334: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2335: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;

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

2329: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2330: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2331: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2332: l_collector_name VARCHAR2(80) := NULL;
2333: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2334: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2335: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2336: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2337: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';

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

2330: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2331: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2332: l_collector_name VARCHAR2(80) := NULL;
2333: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2334: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2335: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2336: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2337: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2338: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';

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

2331: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2332: l_collector_name VARCHAR2(80) := NULL;
2333: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2334: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2335: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2336: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2337: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2338: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2339: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';

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

2332: l_collector_name VARCHAR2(80) := NULL;
2333: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2334: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2335: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2336: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2337: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2338: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2339: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2340: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';

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

2333: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;
2334: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2335: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2336: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2337: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2338: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2339: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2340: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2341: l_statement_cycle_name VARCHAR2(80) := NULL;

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

2334: l_credit_checking hz_customer_profiles.credit_checking%TYPE := 'Y';
2335: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2336: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2337: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2338: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2339: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2340: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2341: l_statement_cycle_name VARCHAR2(80) := NULL;
2342: l_standard_terms_name VARCHAR2(80) := NULL;

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

2335: l_next_credit_review_date hz_customer_profiles.next_credit_review_date%TYPE := NULL;
2336: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2337: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2338: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2339: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2340: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2341: l_statement_cycle_name VARCHAR2(80) := NULL;
2342: l_standard_terms_name VARCHAR2(80) := NULL;
2343: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';

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

2336: l_tolerance hz_customer_profiles.tolerance%TYPE := 0;
2337: l_discount_terms hz_customer_profiles.discount_terms%TYPE := 'Y';
2338: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2339: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2340: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2341: l_statement_cycle_name VARCHAR2(80) := NULL;
2342: l_standard_terms_name VARCHAR2(80) := NULL;
2343: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2344: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';

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

2339: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2340: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2341: l_statement_cycle_name VARCHAR2(80) := NULL;
2342: l_standard_terms_name VARCHAR2(80) := NULL;
2343: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2344: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;

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

2340: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2341: l_statement_cycle_name VARCHAR2(80) := NULL;
2342: l_standard_terms_name VARCHAR2(80) := NULL;
2343: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2344: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;

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

2341: l_statement_cycle_name VARCHAR2(80) := NULL;
2342: l_standard_terms_name VARCHAR2(80) := NULL;
2343: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2344: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;

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

2342: l_standard_terms_name VARCHAR2(80) := NULL;
2343: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2344: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';

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

2343: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2344: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;

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

2344: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;

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

2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;

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

2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2354: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;

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

2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2354: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2355: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;

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

2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2354: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2355: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2356: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2357: l_account_status hz_customer_profiles.account_status%TYPE := NULL;

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

2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2354: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2355: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2356: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2357: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2358: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;

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

2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2354: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2355: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2356: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2357: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2358: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2359: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;

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

2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2354: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2355: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2356: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2357: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2358: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2359: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2360: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';

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

2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2354: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2355: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2356: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2357: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2358: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2359: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2360: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2361: l_autocash_hierarchy_name VARCHAR2(80) := NULL;

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

2354: l_payment_grace_days hz_customer_profiles.payment_grace_days%TYPE := 0;
2355: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2356: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2357: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2358: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2359: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2360: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2361: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2362: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;

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

2355: l_discount_grace_days hz_customer_profiles.discount_grace_days%TYPE := 0;
2356: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2357: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2358: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2359: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2360: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2361: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2362: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2363: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;

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

2356: l_statement_cycle_id hz_customer_profiles.statement_cycle_id%TYPE := NULL;
2357: l_account_status hz_customer_profiles.account_status%TYPE := NULL;
2358: l_percent_collectable hz_customer_profiles.percent_collectable%TYPE := NULL;
2359: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2360: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2361: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2362: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2363: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2364: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';

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

2359: l_autocash_hierarchy_id hz_customer_profiles.autocash_hierarchy_id%TYPE := NULL;
2360: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2361: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2362: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2363: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2364: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2365: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2366: l_grouping_rule_name VARCHAR2(80) := NULL;
2367: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;

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

2360: l_auto_rec_incl_disputed_flag hz_customer_profiles.auto_rec_incl_disputed_flag%TYPE := 'Y';
2361: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2362: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2363: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2364: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2365: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2366: l_grouping_rule_name VARCHAR2(80) := NULL;
2367: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2368: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';

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

2361: l_autocash_hierarchy_name VARCHAR2(80) := NULL;
2362: l_autocash_hierarchy_name_adr VARCHAR2(80) := NULL;
2363: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2364: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2365: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2366: l_grouping_rule_name VARCHAR2(80) := NULL;
2367: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2368: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2369: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;

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

2363: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := NULL;
2364: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2365: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2366: l_grouping_rule_name VARCHAR2(80) := NULL;
2367: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2368: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2369: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2370: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2371: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;

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

2364: l_charge_on_fin_charge_flag hz_customer_profiles.charge_on_finance_charge_flag%TYPE := 'N';
2365: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2366: l_grouping_rule_name VARCHAR2(80) := NULL;
2367: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2368: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2369: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2370: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2371: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2372: l_lockbox_matching_name VARCHAR2(80) := NULL;

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

2365: l_grouping_rule_id hz_customer_profiles.grouping_rule_id%TYPE := NULL;
2366: l_grouping_rule_name VARCHAR2(80) := NULL;
2367: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2368: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2369: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2370: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2371: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2372: l_lockbox_matching_name VARCHAR2(80) := NULL;
2373:

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

2366: l_grouping_rule_name VARCHAR2(80) := NULL;
2367: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2368: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2369: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2370: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2371: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2372: l_lockbox_matching_name VARCHAR2(80) := NULL;
2373:
2374: s_Address_Id hz_locations.location_id%TYPE := NULL;

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

2367: l_clearing_days hz_customer_profiles.clearing_days%TYPE := NULL;
2368: l_cons_inv_flag hz_customer_profiles.cons_inv_flag%TYPE := 'N';
2369: l_cons_inv_type hz_customer_profiles.cons_inv_type%TYPE := NULL;
2370: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2371: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2372: l_lockbox_matching_name VARCHAR2(80) := NULL;
2373:
2374: s_Address_Id hz_locations.location_id%TYPE := NULL;
2375: s_Status hz_party_sites.Status%TYPE := 'A';