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.PQP_HRTCA_INTEGRATION dependencies on HZ_LOCATIONS

Line 29: ,hz_locations hzl

25: ,hps.object_version_number
26: ,hzl.object_version_number
27: ,hzl.ROWID
28: FROM hz_party_sites hps
29: ,hz_locations hzl
30: WHERE hps.party_id(+) = :c_party_id
31: AND hzl.location_id(+) = hps.location_id
32: AND hps.identifying_address_flag(+) = '||'''Y''';
33:

Line 101: FROM hz_locations hzl

97:
98: -- Cursor to get the TCA location
99: CURSOR csr_hz_loc (c_location_id IN Number) IS
100: SELECT *
101: FROM hz_locations hzl
102: WHERE hzl.location_id = c_location_id;
103:
104: -- Cursor to get the party site id
105: CURSOR csr_site_id (c_party_id IN Number

Line 2269: --l_HZ_Loc_Row Hz_Locations%ROWTYPE;

2265:
2266: l_party_site_rec hz_party_sites%ROWTYPE;
2267: l_HR_Address_Rec Per_Addresses%ROWTYPE;
2268: --l_HZ_Loc_Rec Hz_Location_V2pub.Location_Rec_Type;
2269: --l_HZ_Loc_Row Hz_Locations%ROWTYPE;
2270: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Create_Address_TCA_To_HR';
2271: l_map_info_category Varchar2(150);
2272: l_error_msg Varchar2(2000);
2273: BEGIN

Line 2441: hz_locations hzl

2437: CURSOR csr_site_id (c_party_id IN Number
2438: ,c_primary_flag IN Varchar2) IS
2439: SELECT hzl.country
2440: FROM hz_party_sites hps,
2441: hz_locations hzl
2442: WHERE hps.location_id = hzl.location_id
2443: AND hps.status = 'A'
2444: AND hps.party_id = c_party_id
2445: AND hps.identifying_address_flag = c_primary_flag;

Line 2837: ,p_HZ_Location_Row IN Hz_Locations%ROWTYPE

2833: -- ~ Map_HR_Row_Values:
2834: -- =============================================================================
2835: PROCEDURE Map_HR_Row_Values
2836: (p_HR_Address_Rec IN OUT NOCOPY Per_addresses%ROWTYPE
2837: ,p_HZ_Location_Row IN Hz_Locations%ROWTYPE
2838: ,p_add_map IN Varchar2
2839: ,p_lookup_map IN Varchar2
2840: ,p_leg_code IN Varchar2
2841: ) AS

Line 2995: (p_HZ_Location_Row IN Hz_Locations%ROWTYPE

2991: -- =============================================================================
2992: -- ~ TCA_To_HR_Address:
2993: -- =============================================================================
2994: PROCEDURE TCA_To_HR_Address
2995: (p_HZ_Location_Row IN Hz_Locations%ROWTYPE
2996: ,p_Mapping_Type IN Varchar2 DEFAULT 'TCA_TO_HR'
2997: ,p_HR_Address_Rec IN OUT NOCOPY Per_addresses%ROWTYPE
2998: ) AS
2999: l_address_style per_addresses.style%TYPE;

Line 3163: l_HZ_Loc_Row Hz_Locations%ROWTYPE;

3159: FROM dual);
3160: TYPE csr_oss_t IS REF CURSOR;
3161: csr_dt csr_oss_t;
3162: l_concat_add_string Varchar2(1000);
3163: l_HZ_Loc_Row Hz_Locations%ROWTYPE;
3164: l_HR_Address_Rec Per_addresses%ROWTYPE;
3165: l_business_group_id per_business_groups.business_group_id%TYPE;
3166: l_effective_date Date;
3167: BEGIN

Line 3168: -- Get the HZ Locations details based on the id

3164: l_HR_Address_Rec Per_addresses%ROWTYPE;
3165: l_business_group_id per_business_groups.business_group_id%TYPE;
3166: l_effective_date Date;
3167: BEGIN
3168: -- Get the HZ Locations details based on the id
3169: OPEN csr_hz_loc (c_location_id => p_location_id);
3170: FETCH csr_hz_loc INTO l_HZ_Loc_Row;
3171: CLOSE csr_hz_loc;
3172:

Line 3226: l_HZ_Loc_Row Hz_Locations%ROWTYPE;

3222: ) RETURN Varchar2 AS
3223:
3224: TYPE csr_oss_t IS REF CURSOR;
3225: csr_dt csr_oss_t;
3226: l_HZ_Loc_Row Hz_Locations%ROWTYPE;
3227: l_HR_Address_Rec Per_addresses%ROWTYPE;
3228: l_business_group_id per_business_groups.business_group_id%TYPE;
3229: l_effective_date Date;
3230: l_return_value Varchar2(150);

Line 3340: ,p_HZ_Location_Row IN OUT NOCOPY Hz_Locations%ROWTYPE

3336: PROCEDURE Map_To_TCA_Address
3337: (p_column_name IN Varchar2
3338: ,p_column_value IN Varchar2
3339: ,p_col_lookup_type IN Varchar2
3340: ,p_HZ_Location_Row IN OUT NOCOPY Hz_Locations%ROWTYPE
3341: ) AS
3342:
3343: l_valid_col_value Varchar2(150);
3344: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'Map_To_TCA_Address';

Line 3474: l_HZ_Location_Row Hz_Locations%ROWTYPE;

3470: ,p_msg_data OUT NOCOPY Varchar2
3471: ) AS
3472:
3473: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Create_Address_HR_To_TCA';
3474: l_HZ_Location_Row Hz_Locations%ROWTYPE;
3475: l_HR_Address_Rec Per_addresses%ROWTYPE;
3476: l_address_style per_addresses.style%TYPE;
3477: l_Address_Mapping pqp_configuration_values%ROWTYPE;
3478: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;

Line 3794: FROM hz_locations hzl

3790: ) AS
3791: -- Cursor to get the current Primary Location
3792: CURSOR csr_hz_loc(c_hz_location_id IN Number) IS
3793: SELECT hzl.*
3794: FROM hz_locations hzl
3795: WHERE hzl.location_id = c_hz_location_id;
3796:
3797: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'Update_Address_HR_To_TCA';
3798: l_HZ_Location_Row Hz_Locations%ROWTYPE;

Line 3798: l_HZ_Location_Row Hz_Locations%ROWTYPE;

3794: FROM hz_locations hzl
3795: WHERE hzl.location_id = c_hz_location_id;
3796:
3797: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'Update_Address_HR_To_TCA';
3798: l_HZ_Location_Row Hz_Locations%ROWTYPE;
3799: l_HZ_Location_Cur_Row Hz_Locations%ROWTYPE;
3800: l_HR_Address_Rec Per_addresses%ROWTYPE;
3801: l_address_style per_addresses.style%TYPE;
3802: l_Address_Mapping pqp_configuration_values%ROWTYPE;

Line 3799: l_HZ_Location_Cur_Row Hz_Locations%ROWTYPE;

3795: WHERE hzl.location_id = c_hz_location_id;
3796:
3797: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'Update_Address_HR_To_TCA';
3798: l_HZ_Location_Row Hz_Locations%ROWTYPE;
3799: l_HZ_Location_Cur_Row Hz_Locations%ROWTYPE;
3800: l_HR_Address_Rec Per_addresses%ROWTYPE;
3801: l_address_style per_addresses.style%TYPE;
3802: l_Address_Mapping pqp_configuration_values%ROWTYPE;
3803: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;