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 PER_ADDRESSES

Line 2103: (p_HR_Address_Rec IN OUT NOCOPY Per_Addresses%ROWTYPE

2099: -- =============================================================================
2100: -- ~ Person_Address_API:
2101: -- =============================================================================
2102: PROCEDURE Person_Address_API
2103: (p_HR_Address_Rec IN OUT NOCOPY Per_Addresses%ROWTYPE
2104: ,p_validate IN Boolean
2105: ,p_action IN Varchar2
2106: ,p_effective_date IN Date
2107: ,p_pradd_ovlapval_override IN Boolean

Line 2267: l_HR_Address_Rec Per_Addresses%ROWTYPE;

2263: ,p_HR_object_version_number OUT NOCOPY Number
2264: ) AS
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);

Line 2471: l_Style per_addresses.style%TYPE;

2467: FUNCTION Chk_Address_Style
2468: (p_leg_code IN Varchar2
2469: ,p_HZ_country IN Varchar2) RETURN Varchar2 IS
2470:
2471: l_Style per_addresses.style%TYPE;
2472: l_Style_Code per_addresses.style%TYPE;
2473: l_leg_inst_rec csr_chk_prod%ROWTYPE;
2474:
2475: BEGIN

Line 2472: l_Style_Code per_addresses.style%TYPE;

2468: (p_leg_code IN Varchar2
2469: ,p_HZ_country IN Varchar2) RETURN Varchar2 IS
2470:
2471: l_Style per_addresses.style%TYPE;
2472: l_Style_Code per_addresses.style%TYPE;
2473: l_leg_inst_rec csr_chk_prod%ROWTYPE;
2474:
2475: BEGIN
2476: IF p_leg_code = p_HZ_Country THEN

Line 2534: l_Style per_addresses.style%TYPE;

2530: ,p_business_group_id IN Number
2531: ,p_primary_flag IN Varchar2
2532: ,p_party_site_id IN Number) RETURN Varchar2 IS
2533:
2534: l_Style per_addresses.style%TYPE;
2535: l_Style_Code per_addresses.style%TYPE;
2536: l_leg_inst_rec csr_chk_prod%ROWTYPE;
2537:
2538: BEGIN

Line 2535: l_Style_Code per_addresses.style%TYPE;

2531: ,p_primary_flag IN Varchar2
2532: ,p_party_site_id IN Number) RETURN Varchar2 IS
2533:
2534: l_Style per_addresses.style%TYPE;
2535: l_Style_Code per_addresses.style%TYPE;
2536: l_leg_inst_rec csr_chk_prod%ROWTYPE;
2537:
2538: BEGIN
2539: IF p_leg_code = p_HZ_Country THEN

Line 2601: ,p_HR_Address_Rec IN OUT NOCOPY Per_addresses%ROWTYPE

2597: PROCEDURE Map_To_HR_Address
2598: (p_column_name IN Varchar2
2599: ,p_column_value IN Varchar2
2600: ,p_col_lookup_type IN Varchar2
2601: ,p_HR_Address_Rec IN OUT NOCOPY Per_addresses%ROWTYPE
2602: ) AS
2603:
2604: l_proc_name Varchar2(150);
2605: l_valid_col_value Varchar2(150);

Line 2836: (p_HR_Address_Rec IN OUT NOCOPY Per_addresses%ROWTYPE

2832: -- =============================================================================
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

Line 2997: ,p_HR_Address_Rec IN OUT NOCOPY Per_addresses%ROWTYPE

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;
3000: l_add_map Varchar2(150);
3001: l_lookup_map Varchar2(150);

Line 2999: l_address_style per_addresses.style%TYPE;

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;
3000: l_add_map Varchar2(150);
3001: l_lookup_map Varchar2(150);
3002: l_leg_code Varchar2(5);
3003: BEGIN

Line 3033: (p_HR_Address_Rec IN Per_addresses%ROWTYPE

3029: -- ~ ConCat_Segments:
3030: -- ===========================================================================
3031:
3032: PROCEDURE ConCat_Segments
3033: (p_HR_Address_Rec IN Per_addresses%ROWTYPE
3034: ,p_concat_string OUT NOCOPY Varchar2
3035: ) AS
3036:
3037: CURSOR csr_delim IS

Line 3041: AND application_table_name = 'PER_ADDRESSES'

3037: CURSOR csr_delim IS
3038: SELECT concatenated_segment_delimiter
3039: FROM fnd_descriptive_flexs
3040: WHERE descriptive_flexfield_name = 'Address Structure'
3041: AND application_table_name = 'PER_ADDRESSES'
3042: AND application_id = 800;
3043:
3044: CURSOR csr_add_cols (c_context IN Varchar) IS
3045: SELECT fcu.column_seq_num

Line 3164: l_HR_Address_Rec Per_addresses%ROWTYPE;

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
3168: -- Get the HZ Locations details based on the id

Line 3227: l_HR_Address_Rec Per_addresses%ROWTYPE;

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);
3231:

Line 3456: ,p_per_addr_rec_new IN per_addresses%ROWTYPE

3452: ,p_person_id IN Number
3453: ,p_party_id IN Number
3454: ,p_address_id IN Number
3455: ,p_effective_date IN Date
3456: ,p_per_addr_rec_new IN per_addresses%ROWTYPE
3457: -- TCA
3458: ,p_party_type IN Varchar2
3459: ,p_action IN Varchar2
3460: ,p_status IN hz_party_sites.status%TYPE

Line 3475: l_HR_Address_Rec Per_addresses%ROWTYPE;

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;
3479: l_add_map Varchar2(150);

Line 3476: l_address_style per_addresses.style%TYPE;

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;
3479: l_add_map Varchar2(150);
3480: l_lookup_map Varchar2(150);

Line 3774: ,p_per_addr_rec_new IN per_addresses%ROWTYPE

3770: ,p_person_id IN Number
3771: ,p_party_id IN Number
3772: ,p_address_id IN Number
3773: ,p_effective_date IN Date
3774: ,p_per_addr_rec_new IN per_addresses%ROWTYPE
3775: ,p_per_addr_rec_old IN per_addresses%ROWTYPE
3776: -- TCA
3777: ,p_party_type IN Varchar2
3778: ,p_action IN Varchar2

Line 3775: ,p_per_addr_rec_old IN per_addresses%ROWTYPE

3771: ,p_party_id IN Number
3772: ,p_address_id IN Number
3773: ,p_effective_date IN Date
3774: ,p_per_addr_rec_new IN per_addresses%ROWTYPE
3775: ,p_per_addr_rec_old IN per_addresses%ROWTYPE
3776: -- TCA
3777: ,p_party_type IN Varchar2
3778: ,p_action IN Varchar2
3779: ,p_status IN Varchar2

Line 3800: l_HR_Address_Rec Per_addresses%ROWTYPE;

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;
3804: --

Line 3801: l_address_style per_addresses.style%TYPE;

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;
3804: --
3805: l_add_map Varchar2(150);