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.ARH_ADDR_PKG dependencies on HZ_LOCATION_V2PUB

Line 16: p_location_rec IN hz_location_v2pub.location_rec_type,

12: -- -> transaction has been printed with this location
13: ----------------------------
14: PROCEDURE check_printed_trx
15: (p_location_id IN NUMBER,
16: p_location_rec IN hz_location_v2pub.location_rec_type,
17: x_return_status IN OUT NOCOPY VARCHAR2,
18: x_msg_data IN OUT NOCOPY VARCHAR2,
19: x_msg_count IN OUT NOCOPY NUMBER);
20: --}

Line 32: p_location_rec IN hz_location_v2pub.location_rec_type,

28: -- return 'N' if the data in p_location_rec is equal to the existing location
29: -- return 'X' if the no existing location found
30: PROCEDURE compare_location_existing
31: (p_location_id IN NUMBER,
32: p_location_rec IN hz_location_v2pub.location_rec_type,
33: x_exist_loc_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,
34: x_loc_updated IN OUT NOCOPY VARCHAR2);
35:
36: ar_miss_char VARCHAR2(1) := '}';

Line 33: x_exist_loc_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,

29: -- return 'X' if the no existing location found
30: PROCEDURE compare_location_existing
31: (p_location_id IN NUMBER,
32: p_location_rec IN hz_location_v2pub.location_rec_type,
33: x_exist_loc_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,
34: x_loc_updated IN OUT NOCOPY VARCHAR2);
35:
36: ar_miss_char VARCHAR2(1) := '}';
37:

Line 914: location_rec hz_location_v2pub.location_rec_type;

910:
911:
912: IS
913:
914: location_rec hz_location_v2pub.location_rec_type;
915: psite_rec hz_party_site_v2pub.party_site_rec_type;
916: asite_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
917: tmp_var VARCHAR2(2000);
918: i number;

Line 1163: HZ_LOCATION_V2PUB.create_location (

1159: -- { Party Site and Related Location creation process
1160: --
1161: IF i_create_location = 'Y' THEN
1162:
1163: HZ_LOCATION_V2PUB.create_location (
1164: p_location_rec => location_rec,
1165: x_location_id => x_location_id,
1166: x_return_status => x_return_status,
1167: x_msg_count => x_msg_count,

Line 1450: location_rec hz_location_v2pub.location_rec_type;

1446: --
1447: --
1448: l_site_use_id number;
1449: l_site_use_status VARCHAR2(1);
1450: location_rec hz_location_v2pub.location_rec_type;
1451: psite_rec hz_party_site_v2pub.party_site_rec_type;
1452: asite_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1453: tmp_var VARCHAR2(2000);
1454: i number;

Line 1823: HZ_LOCATION_V2PUB.update_location (

1819: asite_rec.ORG_ID := INIT_SWITCH(X_ORG_ID);
1820: ------------------
1821: -- Location update
1822: ------------------
1823: HZ_LOCATION_V2PUB.update_location (
1824: p_location_rec => location_rec,
1825: p_object_version_number => l_object_version_location,
1826: x_return_status => x_return_status,
1827: x_msg_count => x_msg_count,

Line 2352: p_location_rec IN hz_location_v2pub.location_rec_type,

2348: -- -> transaction has been printed with this location
2349: ----------------------------
2350: PROCEDURE check_printed_trx
2351: (p_location_id IN NUMBER,
2352: p_location_rec IN hz_location_v2pub.location_rec_type,
2353: x_return_status IN OUT NOCOPY VARCHAR2,
2354: x_msg_data IN OUT NOCOPY VARCHAR2,
2355: x_msg_count IN OUT NOCOPY NUMBER)
2356: IS

Line 2375: l_exist_location hz_location_v2pub.location_rec_type;

2371: WHERE loc.location_id = party_site.location_id
2372: AND party_site.party_site_id = acct_site.party_site_id
2373: AND loc.location_id = p_location_id;
2374: --
2375: l_exist_location hz_location_v2pub.location_rec_type;
2376: --
2377: /*Bug 4605384*/
2378: /*
2379: CURSOR c_check IS

Line 2560: l_exist_location hz_location_v2pub.location_rec_type;

2556: WHERE loc.location_id = party_site.location_id
2557: AND party_site.party_site_id = acct_site.party_site_id
2558: AND loc.location_id = p_location_id;
2559: --
2560: l_exist_location hz_location_v2pub.location_rec_type;
2561: --
2562: /*Bug 4605384*/
2563: /*
2564: CURSOR c_check IS

Line 2580: l_location_rec hz_location_v2pub.location_rec_type;

2576: --
2577: loc_modified VARCHAR2(1) := 'N';
2578: AR_NO_ROW_IN_SYSTEM_PARAMETERS EXCEPTION;
2579: --
2580: l_location_rec hz_location_v2pub.location_rec_type;
2581: tmp_var VARCHAR2(2000);
2582: tmp_var1 VARCHAR2(2000);
2583: BEGIN
2584: arp_standard.debug('check_printed_trx +');

Line 2746: l_exist_location hz_location_v2pub.location_rec_type;

2742: WHERE loc.location_id = party_site.location_id
2743: AND party_site.party_site_id = acct_site.party_site_id
2744: AND loc.location_id = p_location_id;
2745: --
2746: l_exist_location hz_location_v2pub.location_rec_type;
2747: --
2748: /*Bug 4605384 Changed as per consistency for changes allowed in address*/
2749: /*
2750: CURSOR c_check IS

Line 2767: l_location_rec hz_location_v2pub.location_rec_type;

2763: --
2764: loc_modified VARCHAR2(1) := 'N';
2765: AR_NO_ROW_IN_SYSTEM_PARAMETERS EXCEPTION;
2766: --
2767: l_location_rec hz_location_v2pub.location_rec_type;
2768: tmp_var VARCHAR2(2000);
2769: tmp_var1 VARCHAR2(2000);
2770: BEGIN
2771: arp_standard.debug('check_addr_modif_allowed +');

Line 2891: p_location_rec IN hz_location_v2pub.location_rec_type,

2887: -- return 'N' if the data in p_location_rec is equal to the existing location
2888: -- return 'X' if the no existing location found
2889: PROCEDURE compare_location_existing
2890: (p_location_id IN NUMBER,
2891: p_location_rec IN hz_location_v2pub.location_rec_type,
2892: x_exist_loc_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,
2893: x_loc_updated IN OUT NOCOPY VARCHAR2)
2894: IS
2895: CURSOR c_exist_loc IS

Line 2892: x_exist_loc_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,

2888: -- return 'X' if the no existing location found
2889: PROCEDURE compare_location_existing
2890: (p_location_id IN NUMBER,
2891: p_location_rec IN hz_location_v2pub.location_rec_type,
2892: x_exist_loc_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,
2893: x_loc_updated IN OUT NOCOPY VARCHAR2)
2894: IS
2895: CURSOR c_exist_loc IS
2896: SELECT loc.country ,

Line 2923: l_location_rec hz_location_v2pub.location_rec_type;

2919: loc.Sales_Tax_Inside_City_Limits,
2920: loc.Sales_Tax_Geocode
2921: FROM hz_locations loc
2922: WHERE location_id = p_location_id;
2923: l_location_rec hz_location_v2pub.location_rec_type;
2924: loc_modified VARCHAR2(1) := 'N';
2925: BEGIN
2926: arp_standard.debug('compare_location_existing +');
2927: arp_standard.debug(' p_location_id :'||p_location_id);

Line 3177: l_location_rec hz_location_v2pub.location_rec_type;

3173: x_Sales_Tax_Inside_City_Limits IN OUT NOCOPY VARCHAR2,
3174: --
3175: x_loc_updated IN OUT NOCOPY VARCHAR2)
3176: IS
3177: l_location_rec hz_location_v2pub.location_rec_type;
3178: l_exist_loc_rec hz_location_v2pub.location_rec_type;
3179: BEGIN
3180: arp_standard.debug('compare_location_existing overload +');
3181:

Line 3178: l_exist_loc_rec hz_location_v2pub.location_rec_type;

3174: --
3175: x_loc_updated IN OUT NOCOPY VARCHAR2)
3176: IS
3177: l_location_rec hz_location_v2pub.location_rec_type;
3178: l_exist_loc_rec hz_location_v2pub.location_rec_type;
3179: BEGIN
3180: arp_standard.debug('compare_location_existing overload +');
3181:
3182: arp_standard.debug('IN VALUES + ');

Line 3335: l_exist_loc_rec hz_location_v2pub.LOCATION_REC_TYPE;

3331: x_return_status IN OUT NOCOPY VARCHAR2,
3332: x_msg_data IN OUT NOCOPY VARCHAR2,
3333: x_msg_count IN OUT NOCOPY NUMBER)
3334: IS
3335: l_exist_loc_rec hz_location_v2pub.LOCATION_REC_TYPE;
3336: tmp_var VARCHAR2(2000);
3337: tmp_var1 VARCHAR2(2000);
3338: BEGIN
3339: hz_location_v2pub.get_location_rec(

Line 3339: hz_location_v2pub.get_location_rec(

3335: l_exist_loc_rec hz_location_v2pub.LOCATION_REC_TYPE;
3336: tmp_var VARCHAR2(2000);
3337: tmp_var1 VARCHAR2(2000);
3338: BEGIN
3339: hz_location_v2pub.get_location_rec(
3340: p_location_id => p_location_id,
3341: x_location_rec => l_exist_loc_rec,
3342: x_return_status => x_return_status,
3343: x_msg_count => x_msg_count,