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_DET_BUS dependencies on PQP_DET_SHD

Line 46: l_api_updating := pqp_det_shd.api_updating

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

Line 52: <> pqp_det_shd.g_old_rec.analyzed_data_details_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_analyzed_data_details_id,hr_api.g_number)
52: <> pqp_det_shd.g_old_rec.analyzed_data_details_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqp_det_shd.constraint_error('PQP_ANALYZED_ALIEN_DETAILS_PK');

Line 56: pqp_det_shd.constraint_error('PQP_ANALYZED_ALIEN_DETAILS_PK');

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

Line 66: pqp_det_shd.constraint_error('PQP_ANALYZED_ALIEN_DETAILS_PK');

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

Line 118: l_api_updating := pqp_det_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqp_det_shd.api_updating
119: (p_analyzed_data_details_id => p_analyzed_data_details_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

Line 124: <> nvl(pqp_det_shd.g_old_rec.analyzed_data_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_analyzed_data_id,hr_api.g_number)
124: <> nvl(pqp_det_shd.g_old_rec.analyzed_data_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if analyzed_data_id value exists in pqp_analyzed_alien_data table
128: --

Line 139: pqp_det_shd.constraint_error('PQP_ANALYZED_ALIEN_DATA_FK1');

135: --
136: -- raise error as FK does not relate to PK in pqp_analyzed_alien_data
137: -- table.
138: --
139: pqp_det_shd.constraint_error('PQP_ANALYZED_ALIEN_DATA_FK1');
140: --
141: end if;
142: --
143: close c1;

Line 189: l_api_updating := pqp_det_shd.api_updating

185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := pqp_det_shd.api_updating
190: (p_analyzed_data_details_id => p_analyzed_data_details_id,
191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating

Line 195: <> nvl(pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_retro_lose_ben_amt_flag
195: <> nvl(pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag,hr_api.g_varchar2)
196: or not l_api_updating)
197: and p_retro_lose_ben_amt_flag is not null then
198: --
199: -- check if value of lookup falls within lookup type.

Line 259: l_api_updating := pqp_det_shd.api_updating

255: Begin
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := pqp_det_shd.api_updating
260: (p_analyzed_data_details_id => p_analyzed_data_details_id,
261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating

Line 265: <> nvl(pqp_det_shd.g_old_rec.treaty_ben_allowed_flag,hr_api.g_varchar2)

261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating
264: and p_treaty_ben_allowed_flag
265: <> nvl(pqp_det_shd.g_old_rec.treaty_ben_allowed_flag,hr_api.g_varchar2)
266: or not l_api_updating)
267: and p_treaty_ben_allowed_flag is not null then
268: --
269: -- check if value of lookup falls within lookup type.

Line 329: l_api_updating := pqp_det_shd.api_updating

325: Begin
326: --
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: l_api_updating := pqp_det_shd.api_updating
330: (p_analyzed_data_details_id => p_analyzed_data_details_id,
331: p_object_version_number => p_object_version_number);
332: --
333: if (l_api_updating

Line 335: <> nvl(pqp_det_shd.g_old_rec.addl_withholding_flag,hr_api.g_varchar2)

331: p_object_version_number => p_object_version_number);
332: --
333: if (l_api_updating
334: and p_addl_withholding_flag
335: <> nvl(pqp_det_shd.g_old_rec.addl_withholding_flag,hr_api.g_varchar2)
336: or not l_api_updating)
337: and p_addl_withholding_flag is not null then
338: --
339: -- check if value of lookup falls within lookup type.

Line 399: l_api_updating := pqp_det_shd.api_updating

395: Begin
396: --
397: hr_utility.set_location('Entering:'||l_proc, 5);
398: --
399: l_api_updating := pqp_det_shd.api_updating
400: (p_analyzed_data_details_id => p_analyzed_data_details_id,
401: p_object_version_number => p_object_version_number);
402: --
403: if (l_api_updating

Line 405: <> nvl(pqp_det_shd.g_old_rec.retro_lose_ben_date_flag,hr_api.g_varchar2)

401: p_object_version_number => p_object_version_number);
402: --
403: if (l_api_updating
404: and p_retro_lose_ben_date_flag
405: <> nvl(pqp_det_shd.g_old_rec.retro_lose_ben_date_flag,hr_api.g_varchar2)
406: or not l_api_updating)
407: and p_retro_lose_ben_date_flag is not null then
408: --
409: -- check if value of lookup falls within lookup type.

Line 469: l_api_updating := pqp_det_shd.api_updating

465: BEGIN
466: --
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: l_api_updating := pqp_det_shd.api_updating
470: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
471: p_object_version_number => p_object_version_number);
472: --
473: IF (l_api_updating AND

Line 475: <> NVL(pqp_det_shd.g_old_rec.student_exempt_from_ss,hr_api.g_varchar2)

471: p_object_version_number => p_object_version_number);
472: --
473: IF (l_api_updating AND
474: p_student_exempt_from_ss
475: <> NVL(pqp_det_shd.g_old_rec.student_exempt_from_ss,hr_api.g_varchar2)
476: OR NOT l_api_updating)
477: AND p_student_exempt_from_ss IS NOT NULL THEN
478: --
479: -- check if value of lookup falls within lookup type.

Line 539: l_api_updating := pqp_det_shd.api_updating

535: BEGIN
536: --
537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: l_api_updating := pqp_det_shd.api_updating
540: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
541: p_object_version_number => p_object_version_number);
542: --
543: IF (l_api_updating AND

Line 545: <> NVL(pqp_det_shd.g_old_rec.nra_exempt_from_ss,hr_api.g_varchar2)

541: p_object_version_number => p_object_version_number);
542: --
543: IF (l_api_updating AND
544: p_nra_exempt_from_ss
545: <> NVL(pqp_det_shd.g_old_rec.nra_exempt_from_ss,hr_api.g_varchar2)
546: OR NOT l_api_updating)
547: AND p_nra_exempt_from_ss IS NOT NULL THEN
548: --
549: -- check if value of lookup falls within lookup type.

Line 609: l_api_updating := pqp_det_shd.api_updating

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

Line 615: <> NVL(pqp_det_shd.g_old_rec.nra_exempt_from_medicare,hr_api.g_varchar2)

611: p_object_version_number => p_object_version_number);
612: --
613: IF (l_api_updating AND
614: p_nra_exempt_from_medicare
615: <> NVL(pqp_det_shd.g_old_rec.nra_exempt_from_medicare,hr_api.g_varchar2)
616: OR NOT l_api_updating)
617: AND p_nra_exempt_from_medicare IS NOT NULL THEN
618: --
619: -- check if value of lookup falls within lookup type.

Line 679: l_api_updating := pqp_det_shd.api_updating

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

Line 685: <> NVL(pqp_det_shd.g_old_rec.income_code,hr_api.g_varchar2)

681: p_object_version_number => p_object_version_number);
682: --
683: IF (l_api_updating AND
684: p_income_code
685: <> NVL(pqp_det_shd.g_old_rec.income_code,hr_api.g_varchar2)
686: OR NOT l_api_updating)
687: AND p_income_code IS NOT NULL THEN
688: --
689: -- check if value of lookup falls within lookup type.

Line 749: l_api_updating := pqp_det_shd.api_updating

745: BEGIN
746: --
747: hr_utility.set_location('Entering:'||l_proc, 5);
748: --
749: l_api_updating := pqp_det_shd.api_updating
750: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
751: p_object_version_number => p_object_version_number);
752: --
753: IF (l_api_updating AND

Line 755: <> NVL(pqp_det_shd.g_old_rec.income_code_sub_type,hr_api.g_varchar2)

751: p_object_version_number => p_object_version_number);
752: --
753: IF (l_api_updating AND
754: p_income_code_sub_type
755: <> NVL(pqp_det_shd.g_old_rec.income_code_sub_type,hr_api.g_varchar2)
756: OR NOT l_api_updating)
757: AND p_income_code_sub_type IS NOT NULL THEN
758: --
759: -- check if value of lookup falls within lookup type.

Line 820: l_api_updating := pqp_det_shd.api_updating

816: BEGIN
817: --
818: hr_utility.set_location('Entering:'||l_proc, 5);
819: --
820: l_api_updating := pqp_det_shd.api_updating
821: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
822: p_object_version_number => p_object_version_number);
823: --
824: IF (l_api_updating AND

Line 826: <> NVL(pqp_det_shd.g_old_rec.exemption_code,hr_api.g_varchar2)

822: p_object_version_number => p_object_version_number);
823: --
824: IF (l_api_updating AND
825: p_exemption_code
826: <> NVL(pqp_det_shd.g_old_rec.exemption_code,hr_api.g_varchar2)
827: OR NOT l_api_updating)
828: AND p_exemption_code IS NOT NULL THEN
829: --
830: -- check if value of lookup falls within lookup type.

Line 891: l_api_updating := pqp_det_shd.api_updating

887: BEGIN
888: --
889: hr_utility.set_location('Entering:'||l_proc, 5);
890: --
891: l_api_updating := pqp_det_shd.api_updating
892: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
893: p_object_version_number => p_object_version_number);
894: --
895: IF (l_api_updating AND

Line 897: <> NVL(pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type,hr_api.g_varchar2)

893: p_object_version_number => p_object_version_number);
894: --
895: IF (l_api_updating AND
896: p_addl_wthldng_amt_period_type
897: <> NVL(pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type,hr_api.g_varchar2)
898: OR NOT l_api_updating)
899: AND p_addl_wthldng_amt_period_type IS NOT NULL THEN
900: --
901: -- check if value of lookup falls within lookup type.

Line 928: Procedure insert_validate(p_rec in pqp_det_shd.g_rec_type

924:
925: -- ----------------------------------------------------------------------------
926: -- |---------------------------< insert_validate >----------------------------|
927: -- ----------------------------------------------------------------------------
928: Procedure insert_validate(p_rec in pqp_det_shd.g_rec_type
929: ,p_effective_date in date) is
930: --
931: l_proc varchar2(72) := g_package||'insert_validate';
932: --

Line 1021: Procedure update_validate(p_rec in pqp_det_shd.g_rec_type

1017: --
1018: -- ----------------------------------------------------------------------------
1019: -- |---------------------------< update_validate >----------------------------|
1020: -- ----------------------------------------------------------------------------
1021: Procedure update_validate(p_rec in pqp_det_shd.g_rec_type
1022: ,p_effective_date in date) is
1023: --
1024: l_proc varchar2(72) := g_package||'update_validate';
1025: --

Line 1114: Procedure delete_validate(p_rec in pqp_det_shd.g_rec_type

1110: --
1111: -- ----------------------------------------------------------------------------
1112: -- |---------------------------< delete_validate >----------------------------|
1113: -- ----------------------------------------------------------------------------
1114: Procedure delete_validate(p_rec in pqp_det_shd.g_rec_type
1115: ,p_effective_date in date) is
1116: --
1117: l_proc varchar2(72) := g_package||'delete_validate';
1118: --