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 PQP_ATD_SHD

Line 46: l_api_updating := pqp_atd_shd.api_updating

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

Line 52: <> pqp_atd_shd.g_old_rec.alien_transaction_id) then

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

Line 56: pqp_atd_shd.constraint_error('PQP_ALIEN_TRANSACTION_DATA_PK');

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

Line 66: pqp_atd_shd.constraint_error('PQP_ALIEN_TRANSACTION_DATA_PK');

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

Line 114: l_api_updating := pqp_atd_shd.api_updating

110: BEGIN
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := pqp_atd_shd.api_updating
115: (p_alien_transaction_id => p_alien_transaction_id,
116: p_object_version_number => p_object_version_number);
117: --
118: IF (l_api_updating AND

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 190: l_api_updating := pqp_atd_shd.api_updating

186: BEGIN
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := pqp_atd_shd.api_updating
191: (p_alien_transaction_id => p_alien_transaction_id ,
192: p_object_version_number => p_object_version_number);
193: --
194: IF (l_api_updating AND

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 264: l_api_updating := pqp_atd_shd.api_updating

260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := pqp_atd_shd.api_updating
265: (p_alien_transaction_id => p_alien_transaction_id,
266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating

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 338: l_api_updating := pqp_atd_shd.api_updating

334: Begin
335: --
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: l_api_updating := pqp_atd_shd.api_updating
339: (p_alien_transaction_id => p_alien_transaction_id,
340: p_object_version_number => p_object_version_number);
341: --
342: if (l_api_updating

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 412: l_api_updating := pqp_atd_shd.api_updating

408: Begin
409: --
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: l_api_updating := pqp_atd_shd.api_updating
413: (p_alien_transaction_id => p_alien_transaction_id,
414: p_object_version_number => p_object_version_number);
415: --
416: if (l_api_updating

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 486: l_api_updating := pqp_atd_shd.api_updating

482: Begin
483: --
484: hr_utility.set_location('Entering:'||l_proc, 5);
485: --
486: l_api_updating := pqp_atd_shd.api_updating
487: (p_alien_transaction_id => p_alien_transaction_id,
488: p_object_version_number => p_object_version_number);
489: --
490: if (l_api_updating

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 559: l_api_updating := pqp_atd_shd.api_updating

555: BEGIN
556: --
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: l_api_updating := pqp_atd_shd.api_updating
560: (p_alien_transaction_id => p_alien_transaction_id,
561: p_object_version_number => p_object_version_number);
562: --
563: IF (l_api_updating AND

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 631: l_api_updating := pqp_atd_shd.api_updating

627: BEGIN
628: --
629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: l_api_updating := pqp_atd_shd.api_updating
632: (p_alien_transaction_id => p_alien_transaction_id,
633: p_object_version_number => p_object_version_number);
634: --
635: IF (l_api_updating AND

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 704: l_api_updating := pqp_atd_shd.api_updating

700: BEGIN
701: --
702: hr_utility.set_location('Entering:'||l_proc, 5);
703: --
704: l_api_updating := pqp_atd_shd.api_updating
705: (p_alien_transaction_id => p_alien_transaction_id ,
706: p_object_version_number => p_object_version_number);
707: --
708: IF (l_api_updating AND

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 777: l_api_updating := pqp_atd_shd.api_updating

773: BEGIN
774: --
775: hr_utility.set_location('Entering:'||l_proc, 5);
776: --
777: l_api_updating := pqp_atd_shd.api_updating
778: (p_alien_transaction_id => p_alien_transaction_id ,
779: p_object_version_number => p_object_version_number);
780: --
781: IF (l_api_updating AND

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 851: l_api_updating := pqp_atd_shd.api_updating

847: BEGIN
848: --
849: hr_utility.set_location('Entering:'||l_proc, 5);
850: --
851: l_api_updating := pqp_atd_shd.api_updating
852: (p_alien_transaction_id => p_alien_transaction_id ,
853: p_object_version_number => p_object_version_number);
854: --
855: IF (l_api_updating AND

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 926: l_api_updating := pqp_atd_shd.api_updating

922: BEGIN
923: --
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: l_api_updating := pqp_atd_shd.api_updating
927: (p_alien_transaction_id => p_alien_transaction_id ,
928: p_object_version_number => p_object_version_number);
929: --
930: IF (l_api_updating AND

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 1000: l_api_updating := pqp_atd_shd.api_updating

996: BEGIN
997: --
998: hr_utility.set_location('Entering:'||l_proc, 5);
999: --
1000: l_api_updating := pqp_atd_shd.api_updating
1001: (p_alien_transaction_id => p_alien_transaction_id ,
1002: p_object_version_number => p_object_version_number);
1003: --
1004: IF (l_api_updating AND

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 1074: l_api_updating := pqp_atd_shd.api_updating

1070: BEGIN
1071: --
1072: hr_utility.set_location('Entering:'||l_proc, 5);
1073: --
1074: l_api_updating := pqp_atd_shd.api_updating
1075: (p_alien_transaction_id => p_alien_transaction_id ,
1076: p_object_version_number => p_object_version_number);
1077: --
1078: IF (l_api_updating AND

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 1147: l_api_updating := pqp_atd_shd.api_updating

1143: BEGIN
1144: --
1145: hr_utility.set_location('Entering:'||l_proc, 5);
1146: --
1147: l_api_updating := pqp_atd_shd.api_updating
1148: (p_alien_transaction_id => p_alien_transaction_id ,
1149: p_object_version_number => p_object_version_number);
1150: --
1151: IF (l_api_updating AND

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 1220: l_api_updating := pqp_atd_shd.api_updating

1216: BEGIN
1217: --
1218: hr_utility.set_location('Entering:'||l_proc, 5);
1219: --
1220: l_api_updating := pqp_atd_shd.api_updating
1221: (p_alien_transaction_id => p_alien_transaction_id ,
1222: p_object_version_number => p_object_version_number);
1223: --
1224: IF (l_api_updating AND

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 1294: l_api_updating := pqp_atd_shd.api_updating

1290: BEGIN
1291: --
1292: hr_utility.set_location('Entering:'||l_proc, 5);
1293: --
1294: l_api_updating := pqp_atd_shd.api_updating
1295: (p_alien_transaction_id => p_alien_transaction_id ,
1296: p_object_version_number => p_object_version_number);
1297: --
1298: IF (l_api_updating AND

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 1368: l_api_updating := pqp_atd_shd.api_updating

1364: BEGIN
1365: --
1366: hr_utility.set_location('Entering:'||l_proc, 5);
1367: --
1368: l_api_updating := pqp_atd_shd.api_updating
1369: (p_alien_transaction_id => p_alien_transaction_id ,
1370: p_object_version_number => p_object_version_number);
1371: --
1372: IF (l_api_updating AND

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 1441: l_api_updating := pqp_atd_shd.api_updating

1437: BEGIN
1438: --
1439: hr_utility.set_location('Entering:'||l_proc, 5);
1440: --
1441: l_api_updating := pqp_atd_shd.api_updating
1442: (p_alien_transaction_id => p_alien_transaction_id ,
1443: p_object_version_number => p_object_version_number);
1444: --
1445: IF (l_api_updating AND

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 1514: l_api_updating := pqp_atd_shd.api_updating

1510: BEGIN
1511: --
1512: hr_utility.set_location('Entering:'||l_proc, 5);
1513: --
1514: l_api_updating := pqp_atd_shd.api_updating
1515: (p_alien_transaction_id => p_alien_transaction_id ,
1516: p_object_version_number => p_object_version_number);
1517: --
1518: IF (l_api_updating AND

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 1587: l_api_updating := pqp_atd_shd.api_updating

1583: BEGIN
1584: --
1585: hr_utility.set_location('Entering:'||l_proc, 5);
1586: --
1587: l_api_updating := pqp_atd_shd.api_updating
1588: (p_alien_transaction_id => p_alien_transaction_id ,
1589: p_object_version_number => p_object_version_number);
1590: --
1591: IF (l_api_updating AND

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

1668: END chk_benefit_amount_percent;
1669: -- ----------------------------------------------------------------------------
1670: -- |---------------------------< insert_validate >----------------------------|
1671: -- ----------------------------------------------------------------------------
1672: Procedure insert_validate(p_rec in pqp_atd_shd.g_rec_type
1673: ,p_effective_date in date) is
1674: --
1675: l_proc varchar2(72) := g_package||'insert_validate';
1676: --

Line 1828: Procedure update_validate(p_rec in pqp_atd_shd.g_rec_type

1824: --
1825: -- ----------------------------------------------------------------------------
1826: -- |---------------------------< update_validate >----------------------------|
1827: -- ----------------------------------------------------------------------------
1828: Procedure update_validate(p_rec in pqp_atd_shd.g_rec_type
1829: ,p_effective_date in date) is
1830: --
1831: l_proc varchar2(72) := g_package||'update_validate';
1832: --

Line 1984: Procedure delete_validate(p_rec in pqp_atd_shd.g_rec_type

1980: --
1981: -- ----------------------------------------------------------------------------
1982: -- |---------------------------< delete_validate >----------------------------|
1983: -- ----------------------------------------------------------------------------
1984: Procedure delete_validate(p_rec in pqp_atd_shd.g_rec_type
1985: ,p_effective_date in date) is
1986: --
1987: l_proc varchar2(72) := g_package||'delete_validate';
1988: --