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.PQH_PTX_BUS dependencies on PQH_PTX_SHD

Line 46: l_api_updating := pqh_ptx_shd.api_updating

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

Line 52: <> pqh_ptx_shd.g_old_rec.position_transaction_id) then

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

Line 56: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_PK');

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

Line 66: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_PK');

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

Line 118: l_api_updating := pqh_ptx_shd.api_updating

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

Line 124: <> nvl(pqh_ptx_shd.g_old_rec.organization_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_organization_id,hr_api.g_number)
124: <> nvl(pqh_ptx_shd.g_old_rec.organization_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_organization_id is not null then
127: --
128: -- check if organization_id value exists in hr_all_organization_units table

Line 140: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK9');

136: --
137: -- raise error as FK does not relate to PK in hr_all_organization_units
138: -- table.
139: --
140: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK9');
141: --
142: end if;
143: --
144: close c1;

Line 194: l_api_updating := pqh_ptx_shd.api_updating

190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_ptx_shd.api_updating
195: (p_position_transaction_id => p_position_transaction_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating

Line 200: <> nvl(pqh_ptx_shd.g_old_rec.position_definition_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_position_definition_id,hr_api.g_number)
200: <> nvl(pqh_ptx_shd.g_old_rec.position_definition_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_position_definition_id is not null then
203: --
204: -- check if position_definition_id value exists in per_position_definitions table

Line 216: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK6');

212: --
213: -- raise error as FK does not relate to PK in per_position_definitions
214: -- table.
215: --
216: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK6');
217: --
218: end if;
219: --
220: close c1;

Line 270: l_api_updating := pqh_ptx_shd.api_updating

266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc,5);
269: --
270: l_api_updating := pqh_ptx_shd.api_updating
271: (p_position_transaction_id => p_position_transaction_id,
272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating

Line 276: <> nvl(pqh_ptx_shd.g_old_rec.job_id,hr_api.g_number)

272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_job_id,hr_api.g_number)
276: <> nvl(pqh_ptx_shd.g_old_rec.job_id,hr_api.g_number)
277: or not l_api_updating) and
278: p_job_id is not null then
279: --
280: -- check if job_id value exists in per_jobs table

Line 292: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK5');

288: --
289: -- raise error as FK does not relate to PK in per_jobs
290: -- table.
291: --
292: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK5');
293: --
294: end if;
295: --
296: close c1;

Line 346: l_api_updating := pqh_ptx_shd.api_updating

342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc,5);
345: --
346: l_api_updating := pqh_ptx_shd.api_updating
347: (p_position_transaction_id => p_position_transaction_id,
348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating

Line 352: <> nvl(pqh_ptx_shd.g_old_rec.location_id,hr_api.g_number)

348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating
351: and nvl(p_location_id,hr_api.g_number)
352: <> nvl(pqh_ptx_shd.g_old_rec.location_id,hr_api.g_number)
353: or not l_api_updating) and
354: p_location_id is not null then
355: --
356: -- check if location_id value exists in hr_locations_all table

Line 368: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK4');

364: --
365: -- raise error as FK does not relate to PK in hr_locations_all
366: -- table.
367: --
368: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK4');
369: --
370: end if;
371: --
372: close c1;

Line 422: l_api_updating := pqh_ptx_shd.api_updating

418: Begin
419: --
420: hr_utility.set_location('Entering:'||l_proc,5);
421: --
422: l_api_updating := pqh_ptx_shd.api_updating
423: (p_position_transaction_id => p_position_transaction_id,
424: p_object_version_number => p_object_version_number);
425: --
426: if (l_api_updating

Line 428: <> nvl(pqh_ptx_shd.g_old_rec.availability_status_id,hr_api.g_number)

424: p_object_version_number => p_object_version_number);
425: --
426: if (l_api_updating
427: and nvl(p_availability_status_id,hr_api.g_number)
428: <> nvl(pqh_ptx_shd.g_old_rec.availability_status_id,hr_api.g_number)
429: or not l_api_updating) and
430: p_availability_status_id is not null then
431: --
432: -- check if availability_status_id value exists in per_shared_types table

Line 444: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK12');

440: --
441: -- raise error as FK does not relate to PK in per_shared_types
442: -- table.
443: --
444: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK12');
445: --
446: end if;
447: --
448: close c1;

Line 498: l_api_updating := pqh_ptx_shd.api_updating

494: Begin
495: --
496: hr_utility.set_location('Entering:'||l_proc,5);
497: --
498: l_api_updating := pqh_ptx_shd.api_updating
499: (p_position_transaction_id => p_position_transaction_id,
500: p_object_version_number => p_object_version_number);
501: --
502: if (l_api_updating

Line 504: <> nvl(pqh_ptx_shd.g_old_rec.entry_grade_id,hr_api.g_number)

500: p_object_version_number => p_object_version_number);
501: --
502: if (l_api_updating
503: and nvl(p_entry_grade_id,hr_api.g_number)
504: <> nvl(pqh_ptx_shd.g_old_rec.entry_grade_id,hr_api.g_number)
505: or not l_api_updating) and
506: p_entry_grade_id is not null then
507: --
508: -- check if entry_grade_id value exists in per_grades table

Line 520: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK11');

516: --
517: -- raise error as FK does not relate to PK in per_grades
518: -- table.
519: --
520: pqh_ptx_shd.constraint_error('PQH_POSITION_TRANSACTIONS_FK11');
521: --
522: end if;
523: --
524: close c1;

Line 570: l_api_updating := pqh_ptx_shd.api_updating

566: Begin
567: --
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: l_api_updating := pqh_ptx_shd.api_updating
571: (p_position_transaction_id => p_position_transaction_id,
572: p_object_version_number => p_object_version_number);
573: --
574: if (l_api_updating

Line 576: <> nvl(pqh_ptx_shd.g_old_rec.work_term_end_month_cd,hr_api.g_varchar2)

572: p_object_version_number => p_object_version_number);
573: --
574: if (l_api_updating
575: and p_work_term_end_month_cd
576: <> nvl(pqh_ptx_shd.g_old_rec.work_term_end_month_cd,hr_api.g_varchar2)
577: or not l_api_updating)
578: and p_work_term_end_month_cd is not null then
579: --
580: -- check if value of lookup falls within lookup type.

Line 638: l_api_updating := pqh_ptx_shd.api_updating

634: Begin
635: --
636: hr_utility.set_location('Entering:'||l_proc, 5);
637: --
638: l_api_updating := pqh_ptx_shd.api_updating
639: (p_position_transaction_id => p_position_transaction_id,
640: p_object_version_number => p_object_version_number);
641: --
642: if (l_api_updating

Line 644: <> nvl(pqh_ptx_shd.g_old_rec.work_term_end_day_cd,hr_api.g_varchar2)

640: p_object_version_number => p_object_version_number);
641: --
642: if (l_api_updating
643: and p_work_term_end_day_cd
644: <> nvl(pqh_ptx_shd.g_old_rec.work_term_end_day_cd,hr_api.g_varchar2)
645: or not l_api_updating)
646: and p_work_term_end_day_cd is not null then
647: --
648: -- check if value of lookup falls within lookup type.

Line 706: l_api_updating := pqh_ptx_shd.api_updating

702: Begin
703: --
704: hr_utility.set_location('Entering:'||l_proc, 5);
705: --
706: l_api_updating := pqh_ptx_shd.api_updating
707: (p_position_transaction_id => p_position_transaction_id,
708: p_object_version_number => p_object_version_number);
709: --
710: if (l_api_updating

Line 712: <> nvl(pqh_ptx_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)

708: p_object_version_number => p_object_version_number);
709: --
710: if (l_api_updating
711: and p_work_period_type_cd
712: <> nvl(pqh_ptx_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)
713: or not l_api_updating)
714: and p_work_period_type_cd is not null then
715: --
716: -- check if value of lookup falls within lookup type.

Line 774: l_api_updating := pqh_ptx_shd.api_updating

770: Begin
771: --
772: hr_utility.set_location('Entering:'||l_proc, 5);
773: --
774: l_api_updating := pqh_ptx_shd.api_updating
775: (p_position_transaction_id => p_position_transaction_id,
776: p_object_version_number => p_object_version_number);
777: --
778: if (l_api_updating

Line 780: <> nvl(pqh_ptx_shd.g_old_rec.works_council_approval_flag,hr_api.g_varchar2)

776: p_object_version_number => p_object_version_number);
777: --
778: if (l_api_updating
779: and p_works_council_approval_flag
780: <> nvl(pqh_ptx_shd.g_old_rec.works_council_approval_flag,hr_api.g_varchar2)
781: or not l_api_updating)
782: and p_works_council_approval_flag is not null then
783: --
784: -- check if value of lookup falls within lookup type.

Line 842: l_api_updating := pqh_ptx_shd.api_updating

838: Begin
839: --
840: hr_utility.set_location('Entering:'||l_proc, 5);
841: --
842: l_api_updating := pqh_ptx_shd.api_updating
843: (p_position_transaction_id => p_position_transaction_id,
844: p_object_version_number => p_object_version_number);
845: --
846: if (l_api_updating

Line 848: <> nvl(pqh_ptx_shd.g_old_rec.term_start_month_cd,hr_api.g_varchar2)

844: p_object_version_number => p_object_version_number);
845: --
846: if (l_api_updating
847: and p_term_start_month_cd
848: <> nvl(pqh_ptx_shd.g_old_rec.term_start_month_cd,hr_api.g_varchar2)
849: or not l_api_updating)
850: and p_term_start_month_cd is not null then
851: --
852: -- check if value of lookup falls within lookup type.

Line 910: l_api_updating := pqh_ptx_shd.api_updating

906: Begin
907: --
908: hr_utility.set_location('Entering:'||l_proc, 5);
909: --
910: l_api_updating := pqh_ptx_shd.api_updating
911: (p_position_transaction_id => p_position_transaction_id,
912: p_object_version_number => p_object_version_number);
913: --
914: if (l_api_updating

Line 916: <> nvl(pqh_ptx_shd.g_old_rec.term_start_day_cd,hr_api.g_varchar2)

912: p_object_version_number => p_object_version_number);
913: --
914: if (l_api_updating
915: and p_term_start_day_cd
916: <> nvl(pqh_ptx_shd.g_old_rec.term_start_day_cd,hr_api.g_varchar2)
917: or not l_api_updating)
918: and p_term_start_day_cd is not null then
919: --
920: -- check if value of lookup falls within lookup type.

Line 978: l_api_updating := pqh_ptx_shd.api_updating

974: Begin
975: --
976: hr_utility.set_location('Entering:'||l_proc, 5);
977: --
978: l_api_updating := pqh_ptx_shd.api_updating
979: (p_position_transaction_id => p_position_transaction_id,
980: p_object_version_number => p_object_version_number);
981: --
982: if (l_api_updating

Line 984: <> nvl(pqh_ptx_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)

980: p_object_version_number => p_object_version_number);
981: --
982: if (l_api_updating
983: and p_seasonal_flag
984: <> nvl(pqh_ptx_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)
985: or not l_api_updating)
986: and p_seasonal_flag is not null then
987: --
988: -- check if value of lookup falls within lookup type.

Line 1054: l_api_updating := pqh_ptx_shd.api_updating

1050: Begin
1051: --
1052: hr_utility.set_location('Entering:'||l_proc, 5);
1053: --
1054: l_api_updating := pqh_ptx_shd.api_updating
1055: (p_position_transaction_id => p_position_transaction_id,
1056: p_object_version_number => p_object_version_number);
1057: --
1058: if (l_api_updating

Line 1060: <> nvl(pqh_ptx_shd.g_old_rec.review_flag,hr_api.g_varchar2)

1056: p_object_version_number => p_object_version_number);
1057: --
1058: if (l_api_updating
1059: and p_review_flag
1060: <> nvl(pqh_ptx_shd.g_old_rec.review_flag,hr_api.g_varchar2)
1061: or not l_api_updating)
1062: and p_review_flag is not null then
1063: --
1064: -- check if value of lookup falls within lookup type.

Line 1133: l_api_updating := pqh_ptx_shd.api_updating

1129: Begin
1130: --
1131: hr_utility.set_location('Entering:'||l_proc, 5);
1132: --
1133: l_api_updating := pqh_ptx_shd.api_updating
1134: (p_position_transaction_id => p_position_transaction_id,
1135: p_object_version_number => p_object_version_number);
1136: --
1137: if (l_api_updating

Line 1139: <> nvl(pqh_ptx_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2)

1135: p_object_version_number => p_object_version_number);
1136: --
1137: if (l_api_updating
1138: and p_replacement_required_flag
1139: <> nvl(pqh_ptx_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2)
1140: or not l_api_updating)
1141: and p_replacement_required_flag is not null then
1142: --
1143: -- check if value of lookup falls within lookup type.

Line 1201: l_api_updating := pqh_ptx_shd.api_updating

1197: Begin
1198: --
1199: hr_utility.set_location('Entering:'||l_proc, 5);
1200: --
1201: l_api_updating := pqh_ptx_shd.api_updating
1202: (p_position_transaction_id => p_position_transaction_id,
1203: p_object_version_number => p_object_version_number);
1204: --
1205: if (l_api_updating

Line 1207: <> nvl(pqh_ptx_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2)

1203: p_object_version_number => p_object_version_number);
1204: --
1205: if (l_api_updating
1206: and p_probation_period_unit_cd
1207: <> nvl(pqh_ptx_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2)
1208: or not l_api_updating)
1209: and p_probation_period_unit_cd is not null then
1210: --
1211: -- check if value of lookup falls within lookup type.

Line 1269: l_api_updating := pqh_ptx_shd.api_updating

1265: Begin
1266: --
1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268: --
1269: l_api_updating := pqh_ptx_shd.api_updating
1270: (p_position_transaction_id => p_position_transaction_id,
1271: p_object_version_number => p_object_version_number);
1272: --
1273: if (l_api_updating

Line 1275: <> nvl(pqh_ptx_shd.g_old_rec.permit_recruitment_flag,hr_api.g_varchar2)

1271: p_object_version_number => p_object_version_number);
1272: --
1273: if (l_api_updating
1274: and p_permit_recruitment_flag
1275: <> nvl(pqh_ptx_shd.g_old_rec.permit_recruitment_flag,hr_api.g_varchar2)
1276: or not l_api_updating)
1277: and p_permit_recruitment_flag is not null then
1278: --
1279: -- check if value of lookup falls within lookup type.

Line 1337: l_api_updating := pqh_ptx_shd.api_updating

1333: Begin
1334: --
1335: hr_utility.set_location('Entering:'||l_proc, 5);
1336: --
1337: l_api_updating := pqh_ptx_shd.api_updating
1338: (p_position_transaction_id => p_position_transaction_id,
1339: p_object_version_number => p_object_version_number);
1340: --
1341: if (l_api_updating

Line 1343: <> nvl(pqh_ptx_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)

1339: p_object_version_number => p_object_version_number);
1340: --
1341: if (l_api_updating
1342: and p_permanent_temporary_flag
1343: <> nvl(pqh_ptx_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
1344: or not l_api_updating)
1345: and p_permanent_temporary_flag is not null then
1346: --
1347: -- check if value of lookup falls within lookup type.

Line 1405: l_api_updating := pqh_ptx_shd.api_updating

1401: Begin
1402: --
1403: hr_utility.set_location('Entering:'||l_proc, 5);
1404: --
1405: l_api_updating := pqh_ptx_shd.api_updating
1406: (p_position_transaction_id => p_position_transaction_id,
1407: p_object_version_number => p_object_version_number);
1408: --
1409: if (l_api_updating

Line 1411: <> nvl(pqh_ptx_shd.g_old_rec.pay_term_end_month_cd,hr_api.g_varchar2)

1407: p_object_version_number => p_object_version_number);
1408: --
1409: if (l_api_updating
1410: and p_pay_term_end_month_cd
1411: <> nvl(pqh_ptx_shd.g_old_rec.pay_term_end_month_cd,hr_api.g_varchar2)
1412: or not l_api_updating)
1413: and p_pay_term_end_month_cd is not null then
1414: --
1415: -- check if value of lookup falls within lookup type.

Line 1473: l_api_updating := pqh_ptx_shd.api_updating

1469: Begin
1470: --
1471: hr_utility.set_location('Entering:'||l_proc, 5);
1472: --
1473: l_api_updating := pqh_ptx_shd.api_updating
1474: (p_position_transaction_id => p_position_transaction_id,
1475: p_object_version_number => p_object_version_number);
1476: --
1477: if (l_api_updating

Line 1479: <> nvl(pqh_ptx_shd.g_old_rec.pay_term_end_day_cd,hr_api.g_varchar2)

1475: p_object_version_number => p_object_version_number);
1476: --
1477: if (l_api_updating
1478: and p_pay_term_end_day_cd
1479: <> nvl(pqh_ptx_shd.g_old_rec.pay_term_end_day_cd,hr_api.g_varchar2)
1480: or not l_api_updating)
1481: and p_pay_term_end_day_cd is not null then
1482: --
1483: -- check if value of lookup falls within lookup type.

Line 1541: l_api_updating := pqh_ptx_shd.api_updating

1537: Begin
1538: --
1539: hr_utility.set_location('Entering:'||l_proc, 5);
1540: --
1541: l_api_updating := pqh_ptx_shd.api_updating
1542: (p_position_transaction_id => p_position_transaction_id,
1543: p_object_version_number => p_object_version_number);
1544: --
1545: if (l_api_updating

Line 1547: <> nvl(pqh_ptx_shd.g_old_rec.overlap_unit_cd,hr_api.g_varchar2)

1543: p_object_version_number => p_object_version_number);
1544: --
1545: if (l_api_updating
1546: and p_overlap_unit_cd
1547: <> nvl(pqh_ptx_shd.g_old_rec.overlap_unit_cd,hr_api.g_varchar2)
1548: or not l_api_updating)
1549: and p_overlap_unit_cd is not null then
1550: --
1551: -- check if value of lookup falls within lookup type.

Line 1609: l_api_updating := pqh_ptx_shd.api_updating

1605: Begin
1606: --
1607: hr_utility.set_location('Entering:'||l_proc, 5);
1608: --
1609: l_api_updating := pqh_ptx_shd.api_updating
1610: (p_position_transaction_id => p_position_transaction_id,
1611: p_object_version_number => p_object_version_number);
1612: --
1613: if (l_api_updating

Line 1615: <> nvl(pqh_ptx_shd.g_old_rec.bargaining_unit_cd,hr_api.g_varchar2)

1611: p_object_version_number => p_object_version_number);
1612: --
1613: if (l_api_updating
1614: and p_bargaining_unit_cd
1615: <> nvl(pqh_ptx_shd.g_old_rec.bargaining_unit_cd,hr_api.g_varchar2)
1616: or not l_api_updating)
1617: and p_bargaining_unit_cd is not null then
1618: --
1619: -- check if value of lookup falls within lookup type.

Line 1749: l_api_updating := pqh_ptx_shd.api_updating

1745: l_api_updating boolean;
1746: l_permit_extended_pay boolean;
1747: begin
1748: hr_utility.set_location('Entering:'||l_proc,10);
1749: l_api_updating := pqh_ptx_shd.api_updating
1750: (p_position_transaction_id => p_position_transaction_id
1751: ,p_object_version_number => p_object_version_number);
1752:
1753: if (((l_api_updating and p_work_period_type_cd

Line 1754: <> nvl(pqh_ptx_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)

1750: (p_position_transaction_id => p_position_transaction_id
1751: ,p_object_version_number => p_object_version_number);
1752:
1753: if (((l_api_updating and p_work_period_type_cd
1754: <> nvl(pqh_ptx_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)
1755: and nvl(p_WORK_PERIOD_TYPE_CD,'N') = 'Y') then
1756: hr_utility.set_location('Check permit_extended_pay:'||l_proc,10);
1757: l_permit_extended_pay := permit_extended_pay(p_position_transaction_id => p_position_transaction_id);
1758: hr_utility.set_location('Checking permit_extended_pay complete:'||l_proc,10);

Line 1796: l_api_updating := pqh_ptx_shd.api_updating

1792:
1793: --
1794: hr_utility.set_location('Entering:'||l_proc,5);
1795: --
1796: l_api_updating := pqh_ptx_shd.api_updating
1797: (p_position_transaction_id => p_position_transaction_id,
1798: p_object_version_number => p_object_version_number);
1799: --
1800: if (l_api_updating

Line 1802: <> nvl(pqh_ptx_shd.g_old_rec.date_effective,hr_api.g_date)

1798: p_object_version_number => p_object_version_number);
1799: --
1800: if (l_api_updating
1801: and nvl(date_effective,hr_api.g_date)
1802: <> nvl(pqh_ptx_shd.g_old_rec.date_effective,hr_api.g_date)
1803: or not l_api_updating) and
1804: date_effective is not null then
1805: --
1806: if current_org_prop_end_date < date_effective then

Line 1842: <> nvl(pqh_ptx_shd.g_old_rec.current_org_prop_end_date,hr_api.g_date)

1838: end if;
1839: --
1840: if (l_api_updating
1841: and nvl(current_org_prop_end_date,hr_api.g_date)
1842: <> nvl(pqh_ptx_shd.g_old_rec.current_org_prop_end_date,hr_api.g_date)
1843: or not l_api_updating) and
1844: current_org_prop_end_date is not null then
1845: --
1846: if current_org_prop_end_date < date_effective then

Line 1854: <> nvl(pqh_ptx_shd.g_old_rec.current_job_prop_end_date,hr_api.g_date)

1850: end if;
1851: --
1852: if (l_api_updating
1853: and nvl(current_job_prop_end_date,hr_api.g_date)
1854: <> nvl(pqh_ptx_shd.g_old_rec.current_job_prop_end_date,hr_api.g_date)
1855: or not l_api_updating) and
1856: current_job_prop_end_date is not null then
1857: --
1858: if current_job_prop_end_date < date_effective then

Line 1866: <> nvl(pqh_ptx_shd.g_old_rec.avail_status_prop_end_date,hr_api.g_date)

1862: end if;
1863: --
1864: if (l_api_updating
1865: and nvl(avail_status_prop_end_date,hr_api.g_date)
1866: <> nvl(pqh_ptx_shd.g_old_rec.avail_status_prop_end_date,hr_api.g_date)
1867: or not l_api_updating) and
1868: avail_status_prop_end_date is not null then
1869: --
1870: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (

Line 1882: <> nvl(pqh_ptx_shd.g_old_rec.earliest_hire_date,hr_api.g_date)

1878: end if;
1879: --
1880: if (l_api_updating
1881: and nvl(earliest_hire_date,hr_api.g_date)
1882: <> nvl(pqh_ptx_shd.g_old_rec.earliest_hire_date,hr_api.g_date)
1883: or not l_api_updating) and
1884: earliest_hire_date is not null then
1885: --
1886: if earliest_hire_date < date_effective then

Line 1900: <> nvl(pqh_ptx_shd.g_old_rec.fill_by_date,hr_api.g_date)

1896: end if;
1897: --
1898: if (l_api_updating
1899: and nvl(fill_by_date,hr_api.g_date)
1900: <> nvl(pqh_ptx_shd.g_old_rec.fill_by_date,hr_api.g_date)
1901: or not l_api_updating) and
1902: fill_by_date is not null then
1903: --
1904: if fill_by_date < nvl(earliest_hire_date, date_effective) then

Line 1913: <> nvl(pqh_ptx_shd.g_old_rec.fill_by_date,hr_api.g_date)

1909: end if;
1910: --
1911: if (l_api_updating
1912: and nvl(fill_by_date,hr_api.g_date)
1913: <> nvl(pqh_ptx_shd.g_old_rec.fill_by_date,hr_api.g_date)
1914: or not l_api_updating) and
1915: fill_by_date is not null then
1916: --
1917: if proposed_date_for_layoff <= date_effective then

Line 1941: l_api_updating := pqh_ptx_shd.api_updating

1937: from pqh_ptx_extra_info
1938: where position_transaction_id = nvl(p_position_transaction_id,-1)
1939: and information_type = 'PER_SEASONAL';
1940: begin
1941: l_api_updating := pqh_ptx_shd.api_updating
1942: (p_position_transaction_id => p_position_transaction_id
1943: ,p_object_version_number => p_object_version_number);
1944:
1945: if (l_api_updating

Line 1947: <> nvl(pqh_ptx_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)

1943: ,p_object_version_number => p_object_version_number);
1944:
1945: if (l_api_updating
1946: and p_seasonal_flag
1947: <> nvl(pqh_ptx_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)
1948: and (p_seasonal_flag='N' or p_seasonal_flag is null)) then
1949: open c_seasonal;
1950: fetch c_seasonal into l_dummy;
1951: if c_seasonal%found then

Line 1977: l_api_updating := pqh_ptx_shd.api_updating

1973: where position_transaction_id = p_position_transaction_id
1974: and information_type = 'PER_OVERLAP';
1975: begin
1976: hr_utility.set_location('Entering:'||l_proc,10);
1977: l_api_updating := pqh_ptx_shd.api_updating
1978: (p_position_transaction_id => p_position_transaction_id
1979: ,p_object_version_number => p_object_version_number);
1980:
1981: if (l_api_updating

Line 1983: <> nvl(pqh_ptx_shd.g_old_rec.overlap_period,hr_api.g_number)

1979: ,p_object_version_number => p_object_version_number);
1980:
1981: if (l_api_updating
1982: and nvl(p_overlap_period,-1)
1983: <> nvl(pqh_ptx_shd.g_old_rec.overlap_period,hr_api.g_number)
1984: and p_overlap_period is null) then
1985: hr_utility.set_location('Checking for Overlap Dates in Position Extra Info:'||l_proc,20);
1986: open c_overlap;
1987: fetch c_overlap into l_dummy;

Line 2005: Procedure insert_validate(p_rec in pqh_ptx_shd.g_rec_type

2001: --
2002: -- ----------------------------------------------------------------------------
2003: -- |---------------------------< insert_validate >----------------------------|
2004: -- ----------------------------------------------------------------------------
2005: Procedure insert_validate(p_rec in pqh_ptx_shd.g_rec_type
2006: ,p_effective_date in date) is
2007: --
2008: l_proc varchar2(72) := g_package||'insert_validate';
2009: --

Line 2188: Procedure update_validate(p_rec in pqh_ptx_shd.g_rec_type

2184: --
2185: -- ----------------------------------------------------------------------------
2186: -- |---------------------------< update_validate >----------------------------|
2187: -- ----------------------------------------------------------------------------
2188: Procedure update_validate(p_rec in pqh_ptx_shd.g_rec_type
2189: ,p_effective_date in date) is
2190: --
2191: l_proc varchar2(72) := g_package||'update_validate';
2192: --

Line 2377: Procedure delete_validate(p_rec in pqh_ptx_shd.g_rec_type

2373: --
2374: -- ----------------------------------------------------------------------------
2375: -- |---------------------------< delete_validate >----------------------------|
2376: -- ----------------------------------------------------------------------------
2377: Procedure delete_validate(p_rec in pqh_ptx_shd.g_rec_type
2378: ,p_effective_date in date) is
2379: --
2380: l_proc varchar2(72) := g_package||'delete_validate';
2381: --