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_WDT_BUS dependencies on PQH_WDT_SHD

Line 46: l_api_updating := pqh_wdt_shd.api_updating

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

Line 52: <> pqh_wdt_shd.g_old_rec.worksheet_detail_id) then

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

Line 56: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_PK');

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

Line 66: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_PK');

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

Line 118: l_api_updating := pqh_wdt_shd.api_updating

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

Line 124: <> nvl(pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id,hr_api.g_number)

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

Line 140: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK8');

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

Line 194: l_api_updating := pqh_wdt_shd.api_updating

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

Line 200: <> nvl(pqh_wdt_shd.g_old_rec.worksheet_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_worksheet_id,hr_api.g_number)
200: <> nvl(pqh_wdt_shd.g_old_rec.worksheet_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if worksheet_id value exists in pqh_worksheets table
204: --

Line 215: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK7');

211: --
212: -- raise error as FK does not relate to PK in pqh_worksheets
213: -- table.
214: --
215: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK7');
216: --
217: end if;
218: --
219: close c1;

Line 278: l_api_updating := pqh_wdt_shd.api_updating

274: Begin
275: --
276: hr_utility.set_location('Entering:'||l_proc,5);
277: --
278: l_api_updating := pqh_wdt_shd.api_updating
279: (p_worksheet_detail_id => p_worksheet_detail_id,
280: p_object_version_number => p_object_version_number);
281: --
282: if (l_api_updating

Line 284: <> nvl(pqh_wdt_shd.g_old_rec.grade_id,hr_api.g_number)

280: p_object_version_number => p_object_version_number);
281: --
282: if (l_api_updating
283: and nvl(p_grade_id,hr_api.g_number)
284: <> nvl(pqh_wdt_shd.g_old_rec.grade_id,hr_api.g_number)
285: or not l_api_updating) and
286: p_grade_id is not null then
287: --
288: /**

Line 326: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK6');

322: --
323: -- raise error as FK does not relate to PK in per_grades
324: -- table.
325: --
326: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK6');
327: --
328: end if;
329: --
330: close c1;

Line 380: l_api_updating := pqh_wdt_shd.api_updating

376: Begin
377: --
378: hr_utility.set_location('Entering:'||l_proc,5);
379: --
380: l_api_updating := pqh_wdt_shd.api_updating
381: (p_worksheet_detail_id => p_worksheet_detail_id,
382: p_object_version_number => p_object_version_number);
383: --
384: if (l_api_updating

Line 386: <> nvl(pqh_wdt_shd.g_old_rec.job_id,hr_api.g_number)

382: p_object_version_number => p_object_version_number);
383: --
384: if (l_api_updating
385: and nvl(p_job_id,hr_api.g_number)
386: <> nvl(pqh_wdt_shd.g_old_rec.job_id,hr_api.g_number)
387: or not l_api_updating) and
388: p_job_id is not null then
389: --
390: -- check if job_id value exists in per_jobs table

Line 402: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK5');

398: --
399: -- raise error as FK does not relate to PK in per_jobs
400: -- table.
401: --
402: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK5');
403: --
404: end if;
405: --
406: close c1;

Line 456: l_api_updating := pqh_wdt_shd.api_updating

452: Begin
453: --
454: hr_utility.set_location('Entering:'||l_proc,5);
455: --
456: l_api_updating := pqh_wdt_shd.api_updating
457: (p_worksheet_detail_id => p_worksheet_detail_id,
458: p_object_version_number => p_object_version_number);
459: --
460: if (l_api_updating

Line 462: <> nvl(pqh_wdt_shd.g_old_rec.position_transaction_id,hr_api.g_number)

458: p_object_version_number => p_object_version_number);
459: --
460: if (l_api_updating
461: and nvl(p_position_transaction_id,hr_api.g_number)
462: <> nvl(pqh_wdt_shd.g_old_rec.position_transaction_id,hr_api.g_number)
463: or not l_api_updating) and
464: p_position_transaction_id is not null then
465: --
466: -- check if position_transaction_id value exists in pqh_position_transactions table

Line 478: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK4');

474: --
475: -- raise error as FK does not relate to PK in pqh_position_transactions
476: -- table.
477: --
478: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK4');
479: --
480: end if;
481: --
482: close c1;

Line 532: l_api_updating := pqh_wdt_shd.api_updating

528: Begin
529: --
530: hr_utility.set_location('Entering:'||l_proc,5);
531: --
532: l_api_updating := pqh_wdt_shd.api_updating
533: (p_worksheet_detail_id => p_worksheet_detail_id,
534: p_object_version_number => p_object_version_number);
535: --
536: if (l_api_updating

Line 538: <> nvl(pqh_wdt_shd.g_old_rec.budget_detail_id,hr_api.g_number)

534: p_object_version_number => p_object_version_number);
535: --
536: if (l_api_updating
537: and nvl(p_budget_detail_id,hr_api.g_number)
538: <> nvl(pqh_wdt_shd.g_old_rec.budget_detail_id,hr_api.g_number)
539: or not l_api_updating) and
540: p_budget_detail_id is not null then
541: --
542: -- check if budget_detail_id value exists in pqh_budget_details table

Line 554: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK3');

550: --
551: -- raise error as FK does not relate to PK in pqh_budget_details
552: -- table.
553: --
554: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK3');
555: --
556: end if;
557: --
558: close c1;

Line 626: l_api_updating := pqh_wdt_shd.api_updating

622: Begin
623: --
624: hr_utility.set_location('Entering:'||l_proc,5);
625: --
626: l_api_updating := pqh_wdt_shd.api_updating
627: (p_worksheet_detail_id => p_worksheet_detail_id,
628: p_object_version_number => p_object_version_number);
629: --
630: if (l_api_updating

Line 632: <> nvl(pqh_wdt_shd.g_old_rec.organization_id,hr_api.g_number)

628: p_object_version_number => p_object_version_number);
629: --
630: if (l_api_updating
631: and nvl(p_organization_id,hr_api.g_number)
632: <> nvl(pqh_wdt_shd.g_old_rec.organization_id,hr_api.g_number)
633: or not l_api_updating) and
634: p_organization_id is not null then
635: --
636: -- check if organization_id value exists in hr_organization_units table

Line 648: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK2');

644: --
645: -- raise error as FK does not relate to PK in hr_organization_units
646: -- table.
647: --
648: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK2');
649: --
650: end if;
651: --
652: close c1;

Line 722: l_api_updating := pqh_wdt_shd.api_updating

718: Begin
719: --
720: hr_utility.set_location('Entering:'||l_proc, 5);
721: --
722: l_api_updating := pqh_wdt_shd.api_updating
723: (p_worksheet_detail_id => p_worksheet_detail_id,
724: p_object_version_number => p_object_version_number);
725: --
726: if (l_api_updating

Line 728: <> nvl(pqh_wdt_shd.g_old_rec.defer_flag,hr_api.g_varchar2)

724: p_object_version_number => p_object_version_number);
725: --
726: if (l_api_updating
727: and p_defer_flag
728: <> nvl(pqh_wdt_shd.g_old_rec.defer_flag,hr_api.g_varchar2)
729: or not l_api_updating)
730: and p_defer_flag is not null then
731: --
732: -- check if value of lookup falls within lookup type.

Line 790: l_api_updating := pqh_wdt_shd.api_updating

786: Begin
787: --
788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: l_api_updating := pqh_wdt_shd.api_updating
791: (p_worksheet_detail_id => p_worksheet_detail_id,
792: p_object_version_number => p_object_version_number);
793: --
794: if (l_api_updating

Line 796: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)

792: p_object_version_number => p_object_version_number);
793: --
794: if (l_api_updating
795: and p_budget_unit3_value_type_cd
796: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)
797: or not l_api_updating)
798: and p_budget_unit3_value_type_cd is not null then
799: --
800: -- check if value of lookup falls within lookup type.

Line 858: l_api_updating := pqh_wdt_shd.api_updating

854: Begin
855: --
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: --
858: l_api_updating := pqh_wdt_shd.api_updating
859: (p_worksheet_detail_id => p_worksheet_detail_id,
860: p_object_version_number => p_object_version_number);
861: --
862: if (l_api_updating

Line 864: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)

860: p_object_version_number => p_object_version_number);
861: --
862: if (l_api_updating
863: and p_budget_unit2_value_type_cd
864: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)
865: or not l_api_updating)
866: and p_budget_unit2_value_type_cd is not null then
867: --
868: -- check if value of lookup falls within lookup type.

Line 926: l_api_updating := pqh_wdt_shd.api_updating

922: Begin
923: --
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: l_api_updating := pqh_wdt_shd.api_updating
927: (p_worksheet_detail_id => p_worksheet_detail_id,
928: p_object_version_number => p_object_version_number);
929: --
930: if (l_api_updating

Line 932: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)

928: p_object_version_number => p_object_version_number);
929: --
930: if (l_api_updating
931: and p_budget_unit1_value_type_cd
932: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)
933: or not l_api_updating)
934: and p_budget_unit1_value_type_cd is not null then
935: --
936: -- check if value of lookup falls within lookup type.

Line 994: l_api_updating := pqh_wdt_shd.api_updating

990: Begin
991: --
992: hr_utility.set_location('Entering:'||l_proc, 5);
993: --
994: l_api_updating := pqh_wdt_shd.api_updating
995: (p_worksheet_detail_id => p_worksheet_detail_id,
996: p_object_version_number => p_object_version_number);
997: --
998: if (l_api_updating

Line 1000: <> nvl(pqh_wdt_shd.g_old_rec.action_cd,hr_api.g_varchar2)

996: p_object_version_number => p_object_version_number);
997: --
998: if (l_api_updating
999: and p_action_cd
1000: <> nvl(pqh_wdt_shd.g_old_rec.action_cd,hr_api.g_varchar2)
1001: or not l_api_updating)
1002: and p_action_cd is not null then
1003: --
1004: -- check if value of lookup falls within lookup type.

Line 1063: l_api_updating := pqh_wdt_shd.api_updating

1059: Begin
1060: --
1061: hr_utility.set_location('Entering:'||l_proc, 5);
1062: --
1063: l_api_updating := pqh_wdt_shd.api_updating
1064: (p_worksheet_detail_id => p_worksheet_detail_id,
1065: p_object_version_number => p_object_version_number);
1066: --
1067: if (l_api_updating

Line 1069: <> nvl(pqh_wdt_shd.g_old_rec.status,hr_api.g_varchar2)

1065: p_object_version_number => p_object_version_number);
1066: --
1067: if (l_api_updating
1068: and p_status
1069: <> nvl(pqh_wdt_shd.g_old_rec.status,hr_api.g_varchar2)
1070: or not l_api_updating)
1071: and p_status is not null then
1072: --
1073: -- check if value of lookup falls within lookup type.

Line 1132: l_api_updating := pqh_wdt_shd.api_updating

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

Line 1138: <> nvl(pqh_wdt_shd.g_old_rec.propagation_method,hr_api.g_varchar2)

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

Line 1207: l_api_updating := pqh_wdt_shd.api_updating

1203: Begin
1204: --
1205: hr_utility.set_location('Entering:'||l_proc,5);
1206: --
1207: l_api_updating := pqh_wdt_shd.api_updating
1208: (p_worksheet_detail_id => p_worksheet_detail_id,
1209: p_object_version_number => p_object_version_number);
1210: --
1211: if (l_api_updating

Line 1213: <> nvl(pqh_wdt_shd.g_old_rec.position_id,hr_api.g_number)

1209: p_object_version_number => p_object_version_number);
1210: --
1211: if (l_api_updating
1212: and nvl(p_position_id,hr_api.g_number)
1213: <> nvl(pqh_wdt_shd.g_old_rec.position_id,hr_api.g_number)
1214: or not l_api_updating) and
1215: p_position_id is not null then
1216: --
1217: -- check if position_id value exists in hr_positions_f table

Line 1259: l_api_updating := pqh_wdt_shd.api_updating

1255: Begin
1256: --
1257: hr_utility.set_location('Entering:'||l_proc,5);
1258: --
1259: l_api_updating := pqh_wdt_shd.api_updating
1260: (p_worksheet_detail_id => p_worksheet_detail_id,
1261: p_object_version_number => p_object_version_number);
1262: --
1263: if (l_api_updating

Line 1265: <> nvl(pqh_wdt_shd.g_old_rec.user_id,hr_api.g_number)

1261: p_object_version_number => p_object_version_number);
1262: --
1263: if (l_api_updating
1264: and nvl(p_user_id,hr_api.g_number)
1265: <> nvl(pqh_wdt_shd.g_old_rec.user_id,hr_api.g_number)
1266: or not l_api_updating) and
1267: p_user_id is not null then
1268: --
1269: -- check if user_id value exists in fnd_user table

Line 1315: l_api_updating := pqh_wdt_shd.api_updating

1311: hr_utility.set_location('Entering:'||l_proc,5);
1312: --
1313: -- Check if all non-numeric values are all +ve / 0
1314: --
1315: l_api_updating := pqh_wdt_shd.api_updating
1316: (p_worksheet_detail_id => p_worksheet_detail_id,
1317: p_object_version_number => p_object_version_number);
1318: --
1319: if (l_api_updating

Line 1321: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit1_percent,hr_api.g_number)

1317: p_object_version_number => p_object_version_number);
1318: --
1319: if (l_api_updating
1320: and nvl(p_budget_unit1_percent,hr_api.g_number)
1321: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit1_percent,hr_api.g_number)
1322: or not l_api_updating) and
1323: p_budget_unit1_percent is not null then
1324: --
1325: -- Raise error if the value is negative

Line 1336: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit1_value,hr_api.g_number)

1332: --
1333: --
1334: if (l_api_updating
1335: and nvl(p_budget_unit1_value,hr_api.g_number)
1336: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit1_value,hr_api.g_number)
1337: or not l_api_updating) and
1338: p_budget_unit1_value is not null then
1339: --
1340: -- Raise error if the value is negative

Line 1352: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit1_available,hr_api.g_number)

1348: --
1349: /**
1350: if (l_api_updating
1351: and nvl(p_budget_unit1_available,hr_api.g_number)
1352: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit1_available,hr_api.g_number)
1353: or not l_api_updating) and
1354: p_budget_unit1_available is not null then
1355: --
1356: -- Raise error if the value is negative

Line 1369: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit2_percent,hr_api.g_number)

1365: --
1366: --
1367: if (l_api_updating
1368: and nvl(p_budget_unit2_percent,hr_api.g_number)
1369: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit2_percent,hr_api.g_number)
1370: or not l_api_updating) and
1371: p_budget_unit2_percent is not null then
1372: --
1373: -- Raise error if the value is negative

Line 1384: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit2_value,hr_api.g_number)

1380: --
1381: --
1382: if (l_api_updating
1383: and nvl(p_budget_unit2_value,hr_api.g_number)
1384: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit2_value,hr_api.g_number)
1385: or not l_api_updating) and
1386: p_budget_unit2_value is not null then
1387: --
1388: -- Raise error if the value is negative

Line 1400: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit2_available,hr_api.g_number)

1396: --
1397: /**
1398: if (l_api_updating
1399: and nvl(p_budget_unit2_available,hr_api.g_number)
1400: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit2_available,hr_api.g_number)
1401: or not l_api_updating) and
1402: p_budget_unit2_available is not null then
1403: --
1404: -- Raise error if the value is negative

Line 1416: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit3_percent,hr_api.g_number)

1412: --
1413: --
1414: if (l_api_updating
1415: and nvl(p_budget_unit3_percent,hr_api.g_number)
1416: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit3_percent,hr_api.g_number)
1417: or not l_api_updating) and
1418: p_budget_unit3_percent is not null then
1419: --
1420: -- Raise error if the value is negative

Line 1431: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit3_value,hr_api.g_number)

1427: --
1428: --
1429: if (l_api_updating
1430: and nvl(p_budget_unit3_value,hr_api.g_number)
1431: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit3_value,hr_api.g_number)
1432: or not l_api_updating) and
1433: p_budget_unit3_value is not null then
1434: --
1435: -- Raise error if the value is negative

Line 1447: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit3_available,hr_api.g_number)

1443: --
1444: /**
1445: if (l_api_updating
1446: and nvl(p_budget_unit3_available,hr_api.g_number)
1447: <> nvl(pqh_wdt_shd.g_old_rec.budget_unit3_available,hr_api.g_number)
1448: or not l_api_updating) and
1449: p_budget_unit3_available is not null then
1450: --
1451: -- Raise error if the value is negative

Line 1468: Procedure insert_validate(p_rec in pqh_wdt_shd.g_rec_type

1464: --
1465: -- ----------------------------------------------------------------------------
1466: -- |---------------------------< insert_validate >----------------------------|
1467: -- ----------------------------------------------------------------------------
1468: Procedure insert_validate(p_rec in pqh_wdt_shd.g_rec_type
1469: ,p_effective_date in date) is
1470: --
1471: l_proc varchar2(72) := g_package||'insert_validate';
1472: --

Line 1588: Procedure update_validate(p_rec in pqh_wdt_shd.g_rec_type

1584: --
1585: -- ----------------------------------------------------------------------------
1586: -- |---------------------------< update_validate >----------------------------|
1587: -- ----------------------------------------------------------------------------
1588: Procedure update_validate(p_rec in pqh_wdt_shd.g_rec_type
1589: ,p_effective_date in date) is
1590: --
1591: l_proc varchar2(72) := g_package||'update_validate';
1592: --

Line 1710: Procedure delete_validate(p_rec in pqh_wdt_shd.g_rec_type

1706: --
1707: -- ----------------------------------------------------------------------------
1708: -- |---------------------------< delete_validate >----------------------------|
1709: -- ----------------------------------------------------------------------------
1710: Procedure delete_validate(p_rec in pqh_wdt_shd.g_rec_type
1711: ,p_effective_date in date) is
1712: --
1713: l_proc varchar2(72) := g_package||'delete_validate';
1714: --