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 HR_API

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

47: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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

119: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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 199: and nvl(p_worksheet_id,hr_api.g_number)

195: (p_worksheet_detail_id => p_worksheet_detail_id,
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

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 283: and nvl(p_grade_id,hr_api.g_number)

279: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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 385: and nvl(p_job_id,hr_api.g_number)

381: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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 461: and nvl(p_position_transaction_id,hr_api.g_number)

457: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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 537: and nvl(p_budget_detail_id,hr_api.g_number)

533: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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 631: and nvl(p_organization_id,hr_api.g_number)

627: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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

730: and p_defer_flag is not null then
731: --
732: -- check if value of lookup falls within lookup type.
733: --
734: if hr_api.not_exists_in_hr_lookups
735: (p_lookup_type => 'YES_NO',
736: p_lookup_code => p_defer_flag,
737: p_effective_date => p_effective_date) then
738: --

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

798: and p_budget_unit3_value_type_cd is not null then
799: --
800: -- check if value of lookup falls within lookup type.
801: --
802: if hr_api.not_exists_in_hr_lookups
803: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
804: p_lookup_code => p_budget_unit3_value_type_cd,
805: p_effective_date => p_effective_date) then
806: --

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

866: and p_budget_unit2_value_type_cd is not null then
867: --
868: -- check if value of lookup falls within lookup type.
869: --
870: if hr_api.not_exists_in_hr_lookups
871: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
872: p_lookup_code => p_budget_unit2_value_type_cd,
873: p_effective_date => p_effective_date) then
874: --

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

934: and p_budget_unit1_value_type_cd 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 => 'PQH_BUDGET_UNIT_VALUE_TYPE',
940: p_lookup_code => p_budget_unit1_value_type_cd,
941: p_effective_date => p_effective_date) then
942: --

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

1002: and p_action_cd is not null then
1003: --
1004: -- check if value of lookup falls within lookup type.
1005: --
1006: if hr_api.not_exists_in_hr_lookups
1007: (p_lookup_type => 'PQH_WORKSHEET_DETAIL_ACTION',
1008: p_lookup_code => p_action_cd,
1009: p_effective_date => p_effective_date) then
1010: --

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

1071: and p_status is not null then
1072: --
1073: -- check if value of lookup falls within lookup type.
1074: --
1075: if hr_api.not_exists_in_hr_lookups
1076: (p_lookup_type => 'PQH_TRANSACTION_STATUS',
1077: p_lookup_code => p_status,
1078: p_effective_date => p_effective_date) then
1079: --

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

1140: and p_propagation_method is not null then
1141: --
1142: -- check if value of lookup falls within lookup type.
1143: --
1144: if hr_api.not_exists_in_hr_lookups
1145: (p_lookup_type => 'PQH_WORKSHEET_PROPAGATE_METHOD',
1146: p_lookup_code => p_propagation_method,
1147: p_effective_date => p_effective_date) then
1148: --

Line 1212: and nvl(p_position_id,hr_api.g_number)

1208: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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 1264: and nvl(p_user_id,hr_api.g_number)

1260: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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 1320: and nvl(p_budget_unit1_percent,hr_api.g_number)

1316: (p_worksheet_detail_id => p_worksheet_detail_id,
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: --

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 1335: and nvl(p_budget_unit1_value,hr_api.g_number)

1331: end if;
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: --

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 1351: and nvl(p_budget_unit1_available,hr_api.g_number)

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

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 1368: and nvl(p_budget_unit2_percent,hr_api.g_number)

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

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 1383: and nvl(p_budget_unit2_value,hr_api.g_number)

1379: end if;
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: --

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 1399: and nvl(p_budget_unit2_available,hr_api.g_number)

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

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 1415: and nvl(p_budget_unit3_percent,hr_api.g_number)

1411: **/
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: --

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 1430: and nvl(p_budget_unit3_value,hr_api.g_number)

1426: end if;
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: --

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 1446: and nvl(p_budget_unit3_available,hr_api.g_number)

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

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