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_AAD_BUS dependencies on HR_API

Line 51: and nvl(p_analyzed_data_id,hr_api.g_number)

47: (p_analyzed_data_id => p_analyzed_data_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_analyzed_data_id,hr_api.g_number)
52: <> pqp_aad_shd.g_old_rec.analyzed_data_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 120: <> nvl(pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_withldg_allow_eligible_flag
120: <> nvl(pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag,hr_api.g_varchar2)
121: or not l_api_updating)
122: and p_withldg_allow_eligible_flag is not null then
123: --
124: -- check if value of lookup falls within lookup type.

Line 126: if hr_api.not_exists_in_hr_lookups

122: and p_withldg_allow_eligible_flag is not null then
123: --
124: -- check if value of lookup falls within lookup type.
125: --
126: if hr_api.not_exists_in_hr_lookups
127: (p_lookup_type => 'PQH_YES_NO',
128: p_lookup_code => p_withldg_allow_eligible_flag,
129: p_effective_date => p_effective_date) then
130: --

Line 191: <> nvl(pqp_aad_shd.g_old_rec.current_residency_status, hr_api.g_varchar2)

187: p_object_version_number => p_object_version_number);
188: --
189: IF (l_api_updating AND
190: p_current_residency_status
191: <> nvl(pqp_aad_shd.g_old_rec.current_residency_status, hr_api.g_varchar2)
192: OR NOT l_api_updating)
193: AND p_current_residency_status IS NOT NULL THEN
194: --
195: -- check if value of lookup falls within lookup type.

Line 197: IF hr_api.not_exists_in_hr_lookups

193: AND p_current_residency_status IS NOT NULL THEN
194: --
195: -- check if value of lookup falls within lookup type.
196: --
197: IF hr_api.not_exists_in_hr_lookups
198: (p_lookup_type => 'PER_US_RES_STATUS' ,
199: p_lookup_code => p_current_residency_status ,
200: p_effective_date => p_effective_date ) THEN
201: --

Line 262: <> nvl(pqp_aad_shd.g_old_rec.tax_residence_country_code, hr_api.g_varchar2)

258: p_object_version_number => p_object_version_number);
259: --
260: IF (l_api_updating AND
261: p_tax_residence_country_code
262: <> nvl(pqp_aad_shd.g_old_rec.tax_residence_country_code, hr_api.g_varchar2)
263: OR NOT l_api_updating)
264: AND p_tax_residence_country_code IS NOT NULL THEN
265: --
266: -- check if value of lookup falls within lookup type.

Line 268: IF hr_api.not_exists_in_hr_lookups

264: AND p_tax_residence_country_code IS NOT NULL THEN
265: --
266: -- check if value of lookup falls within lookup type.
267: --
268: IF hr_api.not_exists_in_hr_lookups
269: (p_lookup_type => 'PER_US_COUNTRY_CODE' ,
270: p_lookup_code => p_tax_residence_country_code ,
271: p_effective_date => p_effective_date ) THEN
272: --

Line 332: <> nvl(pqp_aad_shd.g_old_rec.record_source, hr_api.g_varchar2)

328: p_object_version_number => p_object_version_number);
329: --
330: IF (l_api_updating AND
331: p_record_source
332: <> nvl(pqp_aad_shd.g_old_rec.record_source, hr_api.g_varchar2)
333: OR NOT l_api_updating)
334: AND p_record_source IS NOT NULL THEN
335: --
336: -- check if value of lookup falls within lookup type.

Line 338: IF hr_api.not_exists_in_hr_lookups

334: AND p_record_source IS NOT NULL THEN
335: --
336: -- check if value of lookup falls within lookup type.
337: --
338: IF hr_api.not_exists_in_hr_lookups
339: (p_lookup_type => 'PQP_US_RECORD_SOURCE' ,
340: p_lookup_code => p_record_source ,
341: p_effective_date => p_effective_date ) THEN
342: --

Line 402: <> nvl(pqp_aad_shd.g_old_rec.visa_type, hr_api.g_varchar2)

398: p_object_version_number => p_object_version_number);
399: --
400: IF (l_api_updating AND
401: p_visa_type
402: <> nvl(pqp_aad_shd.g_old_rec.visa_type, hr_api.g_varchar2)
403: OR NOT l_api_updating)
404: AND p_visa_type IS NOT NULL THEN
405: --
406: -- check if value of lookup falls within lookup type.

Line 408: IF hr_api.not_exists_in_hr_lookups

404: AND p_visa_type IS NOT NULL THEN
405: --
406: -- check if value of lookup falls within lookup type.
407: --
408: IF hr_api.not_exists_in_hr_lookups
409: (p_lookup_type => 'PER_US_VISA_TYPES' ,
410: p_lookup_code => p_visa_type ,
411: p_effective_date => p_effective_date ) THEN
412: --

Line 472: <> nvl(pqp_aad_shd.g_old_rec.j_sub_type,hr_api.g_varchar2)

468: p_object_version_number => p_object_version_number);
469: --
470: IF (l_api_updating AND
471: p_j_sub_type
472: <> nvl(pqp_aad_shd.g_old_rec.j_sub_type,hr_api.g_varchar2)
473: OR NOT l_api_updating)
474: AND p_j_sub_type IS NOT NULL THEN
475: --
476: -- check if value of lookup falls within lookup type.

Line 478: IF hr_api.not_exists_in_hr_lookups

474: AND p_j_sub_type IS NOT NULL THEN
475: --
476: -- check if value of lookup falls within lookup type.
477: --
478: IF hr_api.not_exists_in_hr_lookups
479: (p_lookup_type => 'PER_US_VISA_CATEGORIES' ,
480: p_lookup_code => p_j_sub_type ,
481: p_effective_date => p_effective_date ) THEN
482: --

Line 543: <> nvl(pqp_aad_shd.g_old_rec.primary_activity, hr_api.g_varchar2)

539: p_object_version_number => p_object_version_number);
540: --
541: IF (l_api_updating AND
542: p_primary_activity
543: <> nvl(pqp_aad_shd.g_old_rec.primary_activity, hr_api.g_varchar2)
544: OR NOT l_api_updating)
545: AND p_primary_activity IS NOT NULL THEN
546: --
547: -- check if value of lookup falls within lookup type.

Line 549: IF hr_api.not_exists_in_hr_lookups

545: AND p_primary_activity IS NOT NULL THEN
546: --
547: -- check if value of lookup falls within lookup type.
548: --
549: IF hr_api.not_exists_in_hr_lookups
550: (p_lookup_type => 'PQP_US_PRIMARY_ACTIVITY' ,
551: p_lookup_code => p_primary_activity ,
552: p_effective_date => p_effective_date ) THEN
553: --

Line 614: <> nvl(pqp_aad_shd.g_old_rec.non_us_country_code, hr_api.g_varchar2)

610: p_object_version_number => p_object_version_number);
611: --
612: IF (l_api_updating AND
613: p_non_us_country_code
614: <> nvl(pqp_aad_shd.g_old_rec.non_us_country_code, hr_api.g_varchar2)
615: OR NOT l_api_updating)
616: AND p_non_us_country_code IS NOT NULL THEN
617: --
618: -- check if value of lookup falls within lookup type.

Line 620: IF hr_api.not_exists_in_hr_lookups

616: AND p_non_us_country_code IS NOT NULL THEN
617: --
618: -- check if value of lookup falls within lookup type.
619: --
620: IF hr_api.not_exists_in_hr_lookups
621: (p_lookup_type => 'FND_TERRITORIES_VL' ,
622: p_lookup_code => p_non_us_country_code ,
623: p_effective_date => p_effective_date ) THEN
624: --

Line 684: <> nvl(pqp_aad_shd.g_old_rec.citizenship_country_code, hr_api.g_varchar2)

680: p_object_version_number => p_object_version_number);
681: --
682: IF (l_api_updating AND
683: p_citizenship_country_code
684: <> nvl(pqp_aad_shd.g_old_rec.citizenship_country_code, hr_api.g_varchar2)
685: OR NOT l_api_updating)
686: AND p_citizenship_country_code IS NOT NULL THEN
687: --
688: -- check if value of lookup falls within lookup type.

Line 690: IF hr_api.not_exists_in_hr_lookups

686: AND p_citizenship_country_code IS NOT NULL THEN
687: --
688: -- check if value of lookup falls within lookup type.
689: --
690: IF hr_api.not_exists_in_hr_lookups
691: (p_lookup_type => 'FND_TERRITORIES_VL' ,
692: p_lookup_code => p_citizenship_country_code ,
693: p_effective_date => p_effective_date ) THEN
694: --