79: location_structure_id := arp_standard.sysparm.location_structure_id;
80: from_postal_code := arp_standard.sysparm.from_postal_code;
81: to_postal_code := arp_standard.sysparm.to_postal_code;
82: home_country_code := arp_standard.sysparm.default_country;
83: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);
84: --
85: if ( default_country_code is null ) then
86: default_country_code := home_country_code;
87: end if;
95: where territory_code = default_country_code;
96: end if;
97: --
98: --
99: fnd_profile.get('AR_CHANGE_CUST_NAME',change_cust_name);
100: fnd_profile.get('AS_USE_CUSTOMER_KEYS_FLAG',use_customer_keys_flag);
101:
102: -- OE/OM Change
103: --
96: end if;
97: --
98: --
99: fnd_profile.get('AR_CHANGE_CUST_NAME',change_cust_name);
100: fnd_profile.get('AS_USE_CUSTOMER_KEYS_FLAG',use_customer_keys_flag);
101:
102: -- OE/OM Change
103: --
104: -- fnd_profile.get('SO_ORGANIZATION_ID',so_organization_id);
100: fnd_profile.get('AS_USE_CUSTOMER_KEYS_FLAG',use_customer_keys_flag);
101:
102: -- OE/OM Change
103: --
104: -- fnd_profile.get('SO_ORGANIZATION_ID',so_organization_id);
105: --
106: oe_profile.get('SO_ORGANIZATION_ID',so_organization_id);
107:
108: begin