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 HR_API

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

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

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

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
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

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 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 201: if hr_api.not_exists_in_hr_lookups

197: and p_retro_lose_ben_amt_flag is not null then
198: --
199: -- check if value of lookup falls within lookup type.
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'PQH_YES_NO' ,
203: p_lookup_code => p_retro_lose_ben_amt_flag,
204: p_effective_date => p_effective_date) then
205: --

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 271: if hr_api.not_exists_in_hr_lookups

267: and p_treaty_ben_allowed_flag is not null then
268: --
269: -- check if value of lookup falls within lookup type.
270: --
271: if hr_api.not_exists_in_hr_lookups
272: (p_lookup_type => 'PQH_YES_NO' ,
273: p_lookup_code => p_treaty_ben_allowed_flag,
274: p_effective_date => p_effective_date) then
275: --

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 341: if hr_api.not_exists_in_hr_lookups

337: and p_addl_withholding_flag is not null then
338: --
339: -- check if value of lookup falls within lookup type.
340: --
341: if hr_api.not_exists_in_hr_lookups
342: (p_lookup_type => 'PQH_YES_NO' ,
343: p_lookup_code => p_addl_withholding_flag,
344: p_effective_date => p_effective_date) then
345: --

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 411: if hr_api.not_exists_in_hr_lookups

407: and p_retro_lose_ben_date_flag is not null then
408: --
409: -- check if value of lookup falls within lookup type.
410: --
411: if hr_api.not_exists_in_hr_lookups
412: (p_lookup_type => 'PQH_YES_NO' ,
413: p_lookup_code => p_retro_lose_ben_date_flag,
414: p_effective_date => p_effective_date) then
415: --

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 481: IF hr_api.not_exists_in_hr_lookups

477: AND p_student_exempt_from_ss IS NOT NULL THEN
478: --
479: -- check if value of lookup falls within lookup type.
480: --
481: IF hr_api.not_exists_in_hr_lookups
482: (p_lookup_type => 'PQH_YES_NO' ,
483: p_lookup_code => p_student_exempt_from_ss ,
484: p_effective_date => p_effective_date ) THEN
485: --

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 551: IF hr_api.not_exists_in_hr_lookups

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

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 621: IF hr_api.not_exists_in_hr_lookups

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

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 691: IF hr_api.not_exists_in_hr_lookups

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

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 761: IF hr_api.not_exists_in_hr_lookups

757: AND p_income_code_sub_type IS NOT NULL THEN
758: --
759: -- check if value of lookup falls within lookup type.
760: --
761: IF hr_api.not_exists_in_hr_lookups
762: (p_lookup_type => 'PQP_US_INCOME_CODE_SUB_TYPE' ,
763: p_lookup_code => p_income_code_sub_type ,
764: p_effective_date => p_effective_date ) THEN
765: --

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 832: IF hr_api.not_exists_in_hr_lookups

828: AND p_exemption_code IS NOT NULL THEN
829: --
830: -- check if value of lookup falls within lookup type.
831: --
832: IF hr_api.not_exists_in_hr_lookups
833: (p_lookup_type => 'PQP_US_EXEMPTION_CODE' ,
834: p_lookup_code => p_exemption_code ,
835: p_effective_date => p_effective_date ) THEN
836: --

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 903: IF hr_api.not_exists_in_hr_lookups

899: AND p_addl_wthldng_amt_period_type IS NOT NULL THEN
900: --
901: -- check if value of lookup falls within lookup type.
902: --
903: IF hr_api.not_exists_in_hr_lookups
904: (p_lookup_type => 'PROC_PERIOD_TYPE' ,
905: p_lookup_code => p_addl_wthldng_amt_period_type ,
906: p_effective_date => p_effective_date ) THEN
907: --