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 PQP_AAD_SHD

Line 46: l_api_updating := pqp_aad_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqp_aad_shd.api_updating
47: (p_analyzed_data_id => p_analyzed_data_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqp_aad_shd.g_old_rec.analyzed_data_id) then

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: --
56: pqp_aad_shd.constraint_error('PQP_ANALYZED_ALIEN_DATA_PK');

Line 56: pqp_aad_shd.constraint_error('PQP_ANALYZED_ALIEN_DATA_PK');

52: <> pqp_aad_shd.g_old_rec.analyzed_data_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqp_aad_shd.constraint_error('PQP_ANALYZED_ALIEN_DATA_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqp_aad_shd.constraint_error('PQP_ANALYZED_ALIEN_DATA_PK');

62: if p_analyzed_data_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqp_aad_shd.constraint_error('PQP_ANALYZED_ALIEN_DATA_PK');
67: --
68: end if;
69: --
70: end if;

Line 114: l_api_updating := pqp_aad_shd.api_updating

110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := pqp_aad_shd.api_updating
115: (p_analyzed_data_id => p_analyzed_data_id,
116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating

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 185: l_api_updating := pqp_aad_shd.api_updating

181: BEGIN
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: l_api_updating := pqp_aad_shd.api_updating
186: (p_analyzed_data_id => p_analyzed_data_id ,
187: p_object_version_number => p_object_version_number);
188: --
189: IF (l_api_updating AND

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 256: l_api_updating := pqp_aad_shd.api_updating

252: BEGIN
253: --
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: l_api_updating := pqp_aad_shd.api_updating
257: (p_analyzed_data_id => p_analyzed_data_id ,
258: p_object_version_number => p_object_version_number);
259: --
260: IF (l_api_updating AND

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 326: l_api_updating := pqp_aad_shd.api_updating

322: BEGIN
323: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: l_api_updating := pqp_aad_shd.api_updating
327: (p_analyzed_data_id => p_analyzed_data_id ,
328: p_object_version_number => p_object_version_number);
329: --
330: IF (l_api_updating AND

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 396: l_api_updating := pqp_aad_shd.api_updating

392: BEGIN
393: --
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: l_api_updating := pqp_aad_shd.api_updating
397: (p_analyzed_data_id => p_analyzed_data_id ,
398: p_object_version_number => p_object_version_number);
399: --
400: IF (l_api_updating AND

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 466: l_api_updating := pqp_aad_shd.api_updating

462: BEGIN
463: --
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: l_api_updating := pqp_aad_shd.api_updating
467: (p_analyzed_data_id => p_analyzed_data_id ,
468: p_object_version_number => p_object_version_number);
469: --
470: IF (l_api_updating AND

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 537: l_api_updating := pqp_aad_shd.api_updating

533: BEGIN
534: --
535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: l_api_updating := pqp_aad_shd.api_updating
538: (p_analyzed_data_id => p_analyzed_data_id ,
539: p_object_version_number => p_object_version_number);
540: --
541: IF (l_api_updating AND

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 608: l_api_updating := pqp_aad_shd.api_updating

604: BEGIN
605: --
606: hr_utility.set_location('Entering:'||l_proc, 5);
607: --
608: l_api_updating := pqp_aad_shd.api_updating
609: (p_analyzed_data_id => p_analyzed_data_id ,
610: p_object_version_number => p_object_version_number);
611: --
612: IF (l_api_updating AND

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 678: l_api_updating := pqp_aad_shd.api_updating

674: BEGIN
675: --
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: l_api_updating := pqp_aad_shd.api_updating
679: (p_analyzed_data_id => p_analyzed_data_id ,
680: p_object_version_number => p_object_version_number);
681: --
682: IF (l_api_updating AND

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 711: Procedure insert_validate(p_rec in pqp_aad_shd.g_rec_type

707: --
708: -- ----------------------------------------------------------------------------
709: -- |---------------------------< insert_validate >----------------------------|
710: -- ----------------------------------------------------------------------------
711: Procedure insert_validate(p_rec in pqp_aad_shd.g_rec_type
712: ,p_effective_date in date) is
713: --
714: l_proc varchar2(72) := g_package||'insert_validate';
715: --

Line 790: Procedure update_validate(p_rec in pqp_aad_shd.g_rec_type

786: --
787: -- ----------------------------------------------------------------------------
788: -- |---------------------------< update_validate >----------------------------|
789: -- ----------------------------------------------------------------------------
790: Procedure update_validate(p_rec in pqp_aad_shd.g_rec_type
791: ,p_effective_date in date) is
792: --
793: l_proc varchar2(72) := g_package||'update_validate';
794: --

Line 866: Procedure delete_validate(p_rec in pqp_aad_shd.g_rec_type

862: --
863: -- ----------------------------------------------------------------------------
864: -- |---------------------------< delete_validate >----------------------------|
865: -- ----------------------------------------------------------------------------
866: Procedure delete_validate(p_rec in pqp_aad_shd.g_rec_type
867: ,p_effective_date in date) is
868: --
869: l_proc varchar2(72) := g_package||'delete_validate';
870: --