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

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

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

Line 120: <> NVL(pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: IF (l_api_updating AND
119: p_treaty_ben_allowed_flag
120: <> NVL(pqp_atd_shd.g_old_rec.treaty_ben_allowed_flag,hr_api.g_varchar2)
121: OR NOT l_api_updating)
122: AND p_treaty_ben_allowed_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_treaty_ben_allowed_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_treaty_ben_allowed_flag ,
129: p_effective_date => p_effective_date ) THEN
130: /* --

Line 196: <> nvl(pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: IF (l_api_updating AND
195: p_wthldg_allow_eligible_flag
196: <> nvl(pqp_atd_shd.g_old_rec.wthldg_allow_eligible_flag,hr_api.g_varchar2)
197: OR NOT l_api_updating)
198: AND p_wthldg_allow_eligible_flag IS NOT NULL THEN
199: --
200: -- check if value of lookup falls within lookup type.

Line 202: if hr_api.not_exists_in_hr_lookups

198: AND p_wthldg_allow_eligible_flag IS NOT NULL THEN
199: --
200: -- check if value of lookup falls within lookup type.
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_lookup_type => 'PQH_YES_NO' ,
204: p_lookup_code => p_wthldg_allow_eligible_flag,
205: p_effective_date => p_effective_date) then
206: /* --

Line 270: <> nvl(pqp_atd_shd.g_old_rec.addl_withholding_flag,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_addl_withholding_flag
270: <> nvl(pqp_atd_shd.g_old_rec.addl_withholding_flag,hr_api.g_varchar2)
271: or not l_api_updating)
272: and p_addl_withholding_flag is not null then
273: --
274: -- check if value of lookup falls within lookup type.

Line 276: if hr_api.not_exists_in_hr_lookups

272: and p_addl_withholding_flag is not null then
273: --
274: -- check if value of lookup falls within lookup type.
275: --
276: if hr_api.not_exists_in_hr_lookups
277: (p_lookup_type => 'PQH_YES_NO' ,
278: p_lookup_code => p_addl_withholding_flag,
279: p_effective_date => p_effective_date) then
280: /* --

Line 344: <> nvl(pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag,hr_api.g_varchar2)

340: p_object_version_number => p_object_version_number);
341: --
342: if (l_api_updating
343: and p_retro_lose_ben_date_flag
344: <> nvl(pqp_atd_shd.g_old_rec.retro_lose_ben_date_flag,hr_api.g_varchar2)
345: or not l_api_updating)
346: and p_retro_lose_ben_date_flag is not null then
347: --
348: -- check if value of lookup falls within lookup type.

Line 350: if hr_api.not_exists_in_hr_lookups

346: and p_retro_lose_ben_date_flag is not null then
347: --
348: -- check if value of lookup falls within lookup type.
349: --
350: if hr_api.not_exists_in_hr_lookups
351: (p_lookup_type => 'PQH_YES_NO' ,
352: p_lookup_code => p_retro_lose_ben_date_flag,
353: p_effective_date => p_effective_date) then
354: /* --

Line 418: <> nvl(pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag,hr_api.g_varchar2)

414: p_object_version_number => p_object_version_number);
415: --
416: if (l_api_updating
417: and p_retro_lose_ben_amt_flag
418: <> nvl(pqp_atd_shd.g_old_rec.retro_lose_ben_amt_flag,hr_api.g_varchar2)
419: or not l_api_updating)
420: and p_retro_lose_ben_amt_flag is not null then
421: --
422: -- check if value of lookup falls within lookup type.

Line 424: if hr_api.not_exists_in_hr_lookups

420: and p_retro_lose_ben_amt_flag is not null then
421: --
422: -- check if value of lookup falls within lookup type.
423: --
424: if hr_api.not_exists_in_hr_lookups
425: (p_lookup_type => 'PQH_YES_NO' ,
426: p_lookup_code => p_retro_lose_ben_amt_flag,
427: p_effective_date => p_effective_date) then
428: /* --

Line 492: <> nvl(pqp_atd_shd.g_old_rec.state_honors_treaty_flag,hr_api.g_varchar2)

488: p_object_version_number => p_object_version_number);
489: --
490: if (l_api_updating
491: and p_state_honors_treaty_flag
492: <> nvl(pqp_atd_shd.g_old_rec.state_honors_treaty_flag,hr_api.g_varchar2)
493: or not l_api_updating)
494: and p_state_honors_treaty_flag is not null then
495: --
496: -- check if value of lookup falls within lookup type.

Line 498: if hr_api.not_exists_in_hr_lookups

494: and p_state_honors_treaty_flag is not null then
495: --
496: -- check if value of lookup falls within lookup type.
497: --
498: if hr_api.not_exists_in_hr_lookups
499: (p_lookup_type => 'PQH_YES_NO' ,
500: p_lookup_code => p_state_honors_treaty_flag,
501: p_effective_date => p_effective_date) then
502: /* --

Line 565: <> NVL(pqp_atd_shd.g_old_rec.student_exempt_from_fica,hr_api.g_varchar2)

561: p_object_version_number => p_object_version_number);
562: --
563: IF (l_api_updating AND
564: p_student_exempt_from_fica
565: <> NVL(pqp_atd_shd.g_old_rec.student_exempt_from_fica,hr_api.g_varchar2)
566: OR NOT l_api_updating)
567: AND p_student_exempt_from_fica IS NOT NULL THEN
568: --
569: -- check if value of lookup falls within lookup type.

Line 571: IF hr_api.not_exists_in_hr_lookups

567: AND p_student_exempt_from_fica IS NOT NULL THEN
568: --
569: -- check if value of lookup falls within lookup type.
570: --
571: IF hr_api.not_exists_in_hr_lookups
572: (p_lookup_type => 'PQH_YES_NO' ,
573: p_lookup_code => p_student_exempt_from_fica ,
574: p_effective_date => p_effective_date ) THEN
575: /* --

Line 637: <> NVL(pqp_atd_shd.g_old_rec.nra_exempt_from_fica,hr_api.g_varchar2)

633: p_object_version_number => p_object_version_number);
634: --
635: IF (l_api_updating AND
636: p_nra_exempt_from_fica
637: <> NVL(pqp_atd_shd.g_old_rec.nra_exempt_from_fica,hr_api.g_varchar2)
638: OR NOT l_api_updating)
639: AND p_nra_exempt_from_fica IS NOT NULL THEN
640: --
641: -- check if value of lookup falls within lookup type.

Line 643: IF hr_api.not_exists_in_hr_lookups

639: AND p_nra_exempt_from_fica IS NOT NULL THEN
640: --
641: -- check if value of lookup falls within lookup type.
642: --
643: IF hr_api.not_exists_in_hr_lookups
644: (p_lookup_type => 'PQH_YES_NO' ,
645: p_lookup_code => p_nra_exempt_from_fica ,
646: p_effective_date => p_effective_date ) THEN
647: /* --

Line 710: <> nvl(pqp_atd_shd.g_old_rec.income_code, hr_api.g_varchar2)

706: p_object_version_number => p_object_version_number);
707: --
708: IF (l_api_updating AND
709: p_income_code
710: <> nvl(pqp_atd_shd.g_old_rec.income_code, hr_api.g_varchar2)
711: OR NOT l_api_updating)
712: AND p_income_code IS NOT NULL THEN
713: --
714: -- check if value of lookup falls within lookup type.

Line 716: IF hr_api.not_exists_in_hr_lookups

712: AND p_income_code IS NOT NULL THEN
713: --
714: -- check if value of lookup falls within lookup type.
715: --
716: IF hr_api.not_exists_in_hr_lookups
717: (p_lookup_type => 'PER_US_INCOME_TYPES' ,
718: p_lookup_code => p_income_code ,
719: p_effective_date => p_effective_date ) THEN
720: /* --

Line 783: <> nvl(pqp_atd_shd.g_old_rec.income_code_sub_type, hr_api.g_varchar2)

779: p_object_version_number => p_object_version_number);
780: --
781: IF (l_api_updating AND
782: p_income_code_sub_type
783: <> nvl(pqp_atd_shd.g_old_rec.income_code_sub_type, hr_api.g_varchar2)
784: OR NOT l_api_updating)
785: AND p_income_code_sub_type IS NOT NULL THEN
786: --
787: -- check if value of lookup falls within lookup type.

Line 789: IF hr_api.not_exists_in_hr_lookups

785: AND p_income_code_sub_type IS NOT NULL THEN
786: --
787: -- check if value of lookup falls within lookup type.
788: --
789: IF hr_api.not_exists_in_hr_lookups
790: (p_lookup_type => 'PQP_US_INCOME_CODE_SUB_TYPE',
791: p_lookup_code => p_income_code_sub_type ,
792: p_effective_date => p_effective_date ) THEN
793: /* --

Line 857: <> nvl(pqp_atd_shd.g_old_rec.exemption_code, hr_api.g_varchar2)

853: p_object_version_number => p_object_version_number);
854: --
855: IF (l_api_updating AND
856: p_exemption_code
857: <> nvl(pqp_atd_shd.g_old_rec.exemption_code, hr_api.g_varchar2)
858: OR NOT l_api_updating)
859: AND p_exemption_code IS NOT NULL THEN
860: --
861: -- check if value of lookup falls within lookup type.

Line 863: IF hr_api.not_exists_in_hr_lookups

859: AND p_exemption_code IS NOT NULL THEN
860: --
861: -- check if value of lookup falls within lookup type.
862: --
863: IF hr_api.not_exists_in_hr_lookups
864: (p_lookup_type => 'PQP_US_EXEMPTION_CODE' ,
865: p_lookup_code => p_exemption_code ,
866: p_effective_date => p_effective_date ) THEN
867: /* --

Line 932: <> nvl(pqp_atd_shd.g_old_rec.current_residency_status, hr_api.g_varchar2)

928: p_object_version_number => p_object_version_number);
929: --
930: IF (l_api_updating AND
931: p_current_residency_status
932: <> nvl(pqp_atd_shd.g_old_rec.current_residency_status, hr_api.g_varchar2)
933: OR NOT l_api_updating)
934: AND p_current_residency_status IS NOT NULL THEN
935: --
936: -- check if value of lookup falls within lookup type.

Line 938: IF hr_api.not_exists_in_hr_lookups

934: AND p_current_residency_status IS NOT NULL THEN
935: --
936: -- check if value of lookup falls within lookup type.
937: --
938: IF hr_api.not_exists_in_hr_lookups
939: (p_lookup_type => 'PER_US_RES_STATUS' ,
940: p_lookup_code => p_current_residency_status ,
941: p_effective_date => p_effective_date ) THEN
942: /* --

Line 1006: <> nvl(pqp_atd_shd.g_old_rec.tax_residence_country_code, hr_api.g_varchar2)

1002: p_object_version_number => p_object_version_number);
1003: --
1004: IF (l_api_updating AND
1005: p_tax_residence_country_code
1006: <> nvl(pqp_atd_shd.g_old_rec.tax_residence_country_code, hr_api.g_varchar2)
1007: OR NOT l_api_updating)
1008: AND p_tax_residence_country_code IS NOT NULL THEN
1009: --
1010: -- check if value of lookup falls within lookup type.

Line 1012: IF hr_api.not_exists_in_hr_lookups

1008: AND p_tax_residence_country_code IS NOT NULL THEN
1009: --
1010: -- check if value of lookup falls within lookup type.
1011: --
1012: IF hr_api.not_exists_in_hr_lookups
1013: (p_lookup_type => 'PER_US_COUNTRY_CODE' ,
1014: p_lookup_code => p_tax_residence_country_code ,
1015: p_effective_date => p_effective_date ) THEN
1016: /* --

Line 1080: <> nvl(pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type, hr_api.g_varchar2)

1076: p_object_version_number => p_object_version_number);
1077: --
1078: IF (l_api_updating AND
1079: p_addtnl_wthldng_amt_period
1080: <> nvl(pqp_atd_shd.g_old_rec.addl_wthldng_amt_period_type, hr_api.g_varchar2)
1081: OR NOT l_api_updating)
1082: AND p_addtnl_wthldng_amt_period IS NOT NULL THEN
1083: --
1084: -- check if value of lookup falls within lookup type.

Line 1086: IF hr_api.not_exists_in_hr_lookups

1082: AND p_addtnl_wthldng_amt_period IS NOT NULL THEN
1083: --
1084: -- check if value of lookup falls within lookup type.
1085: --
1086: IF hr_api.not_exists_in_hr_lookups
1087: (p_lookup_type => 'PROC_PERIOD_TYPE' ,
1088: p_lookup_code => p_addtnl_wthldng_amt_period ,
1089: p_effective_date => p_effective_date ) THEN
1090: /* --

Line 1153: <> nvl(pqp_atd_shd.g_old_rec.state_code, hr_api.g_varchar2)

1149: p_object_version_number => p_object_version_number);
1150: --
1151: IF (l_api_updating AND
1152: p_state_code
1153: <> nvl(pqp_atd_shd.g_old_rec.state_code, hr_api.g_varchar2)
1154: OR NOT l_api_updating)
1155: AND p_state_code IS NOT NULL THEN
1156: --
1157: -- check if value of lookup falls within lookup type.

Line 1159: IF hr_api.not_exists_in_hr_lookups

1155: AND p_state_code IS NOT NULL THEN
1156: --
1157: -- check if value of lookup falls within lookup type.
1158: --
1159: IF hr_api.not_exists_in_hr_lookups
1160: (p_lookup_type => 'US_STATE' ,
1161: p_lookup_code => p_state_code ,
1162: p_effective_date => p_effective_date ) THEN
1163: /* --

Line 1226: <> nvl(pqp_atd_shd.g_old_rec.record_source, hr_api.g_varchar2)

1222: p_object_version_number => p_object_version_number);
1223: --
1224: IF (l_api_updating AND
1225: p_record_source
1226: <> nvl(pqp_atd_shd.g_old_rec.record_source, hr_api.g_varchar2)
1227: OR NOT l_api_updating)
1228: AND p_record_source IS NOT NULL THEN
1229: --
1230: -- check if value of lookup falls within lookup type.

Line 1232: IF hr_api.not_exists_in_hr_lookups

1228: AND p_record_source IS NOT NULL THEN
1229: --
1230: -- check if value of lookup falls within lookup type.
1231: --
1232: IF hr_api.not_exists_in_hr_lookups
1233: (p_lookup_type => 'PQP_US_RECORD_SOURCE' ,
1234: p_lookup_code => p_record_source ,
1235: p_effective_date => p_effective_date ) THEN
1236: /* --

Line 1300: <> nvl(pqp_atd_shd.g_old_rec.visa_type, hr_api.g_varchar2)

1296: p_object_version_number => p_object_version_number);
1297: --
1298: IF (l_api_updating AND
1299: p_visa_type
1300: <> nvl(pqp_atd_shd.g_old_rec.visa_type, hr_api.g_varchar2)
1301: OR NOT l_api_updating)
1302: AND p_visa_type IS NOT NULL THEN
1303: --
1304: -- check if value of lookup falls within lookup type.

Line 1306: IF hr_api.not_exists_in_hr_lookups

1302: AND p_visa_type IS NOT NULL THEN
1303: --
1304: -- check if value of lookup falls within lookup type.
1305: --
1306: IF hr_api.not_exists_in_hr_lookups
1307: (p_lookup_type => 'PER_US_VISA_TYPES' ,
1308: p_lookup_code => p_visa_type ,
1309: p_effective_date => p_effective_date ) THEN
1310: /* --

Line 1374: <> nvl(pqp_atd_shd.g_old_rec.j_sub_type, hr_api.g_varchar2)

1370: p_object_version_number => p_object_version_number);
1371: --
1372: IF (l_api_updating AND
1373: p_j_sub_type
1374: <> nvl(pqp_atd_shd.g_old_rec.j_sub_type, hr_api.g_varchar2)
1375: OR NOT l_api_updating)
1376: AND p_j_sub_type IS NOT NULL THEN
1377: --
1378: -- check if value of lookup falls within lookup type.

Line 1380: IF hr_api.not_exists_in_hr_lookups

1376: AND p_j_sub_type IS NOT NULL THEN
1377: --
1378: -- check if value of lookup falls within lookup type.
1379: --
1380: IF hr_api.not_exists_in_hr_lookups
1381: (p_lookup_type => 'PER_US_VISA_CATEGORIES' ,
1382: p_lookup_code => p_j_sub_type ,
1383: p_effective_date => p_effective_date ) THEN
1384: /* --

Line 1447: <> nvl(pqp_atd_shd.g_old_rec.primary_activity, hr_api.g_varchar2)

1443: p_object_version_number => p_object_version_number);
1444: --
1445: IF (l_api_updating AND
1446: p_primary_activity
1447: <> nvl(pqp_atd_shd.g_old_rec.primary_activity, hr_api.g_varchar2)
1448: OR NOT l_api_updating)
1449: AND p_primary_activity IS NOT NULL THEN
1450: --
1451: -- check if value of lookup falls within lookup type.

Line 1453: IF hr_api.not_exists_in_hr_lookups

1449: AND p_primary_activity IS NOT NULL THEN
1450: --
1451: -- check if value of lookup falls within lookup type.
1452: --
1453: IF hr_api.not_exists_in_hr_lookups
1454: (p_lookup_type => 'PQP_US_PRIMARY_ACTIVITY' ,
1455: p_lookup_code => p_primary_activity ,
1456: p_effective_date => p_effective_date ) THEN
1457: /* --

Line 1520: <> nvl(pqp_atd_shd.g_old_rec.non_us_country_code, hr_api.g_varchar2)

1516: p_object_version_number => p_object_version_number);
1517: --
1518: IF (l_api_updating AND
1519: p_non_us_country_code
1520: <> nvl(pqp_atd_shd.g_old_rec.non_us_country_code, hr_api.g_varchar2)
1521: OR NOT l_api_updating)
1522: AND p_non_us_country_code IS NOT NULL THEN
1523: --
1524: -- check if value of lookup falls within lookup type.

Line 1526: IF hr_api.not_exists_in_hr_lookups

1522: AND p_non_us_country_code IS NOT NULL THEN
1523: --
1524: -- check if value of lookup falls within lookup type.
1525: --
1526: IF hr_api.not_exists_in_hr_lookups
1527: (p_lookup_type => 'FND_TERRITORIES_VL' ,
1528: p_lookup_code => p_non_us_country_code ,
1529: p_effective_date => p_effective_date ) THEN
1530: /* --

Line 1593: <> nvl(pqp_atd_shd.g_old_rec.citizenship_country_code, hr_api.g_varchar2)

1589: p_object_version_number => p_object_version_number);
1590: --
1591: IF (l_api_updating AND
1592: p_citizenship_country_code
1593: <> nvl(pqp_atd_shd.g_old_rec.citizenship_country_code, hr_api.g_varchar2)
1594: OR NOT l_api_updating)
1595: AND p_citizenship_country_code IS NOT NULL THEN
1596: --
1597: -- check if value of lookup falls within lookup type.

Line 1599: IF hr_api.not_exists_in_hr_lookups

1595: AND p_citizenship_country_code IS NOT NULL THEN
1596: --
1597: -- check if value of lookup falls within lookup type.
1598: --
1599: IF hr_api.not_exists_in_hr_lookups
1600: (p_lookup_type => 'FND_TERRITORIES_VL' ,
1601: p_lookup_code => p_citizenship_country_code ,
1602: p_effective_date => p_effective_date ) THEN
1603: /* --