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.PER_ASG_BUS3 dependencies on HR_API

Line 61: hr_api.mandatory_arg_error

57: ) then
58: --
59: -- Check mandatory parameters have been set
60: --
61: hr_api.mandatory_arg_error
62: (p_api_name => l_proc
63: ,p_argument => 'effective_date'
64: ,p_argument_value => p_effective_date
65: );

Line 89: and nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)

85: hr_utility.set_location(l_proc, 30);
86: --
87: if ((l_api_updating
88: and (p_cagr_grade_def_id is not null)
89: and nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)
90: <> nvl(p_cagr_id_flex_num, hr_api.g_number))
91: or
92: (NOT l_api_updating and p_cagr_grade_def_id is not null)
93: or

Line 90: <> nvl(p_cagr_id_flex_num, hr_api.g_number))

86: --
87: if ((l_api_updating
88: and (p_cagr_grade_def_id is not null)
89: and nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)
90: <> nvl(p_cagr_id_flex_num, hr_api.g_number))
91: or
92: (NOT l_api_updating and p_cagr_grade_def_id is not null)
93: or
94: (l_api_updating and (p_cagr_grade_def_id is not null) and

Line 95: nvl(per_asg_shd.g_old_rec.cagr_grade_def_id, hr_api.g_number)

91: or
92: (NOT l_api_updating and p_cagr_grade_def_id is not null)
93: or
94: (l_api_updating and (p_cagr_grade_def_id is not null) and
95: nvl(per_asg_shd.g_old_rec.cagr_grade_def_id, hr_api.g_number)
96: <> nvl(p_cagr_grade_def_id, hr_api.g_number))) THEN
97: --
98: hr_utility.set_location(l_proc, 40);
99: --

Line 96: <> nvl(p_cagr_grade_def_id, hr_api.g_number))) THEN

92: (NOT l_api_updating and p_cagr_grade_def_id is not null)
93: or
94: (l_api_updating and (p_cagr_grade_def_id is not null) and
95: nvl(per_asg_shd.g_old_rec.cagr_grade_def_id, hr_api.g_number)
96: <> nvl(p_cagr_grade_def_id, hr_api.g_number))) THEN
97: --
98: hr_utility.set_location(l_proc, 40);
99: --
100: --

Line 185: hr_api.mandatory_arg_error

181: ) then
182: --
183: -- Check mandatory parameters have been set
184: --
185: hr_api.mandatory_arg_error
186: (p_api_name => l_proc
187: ,p_argument => 'effective_date'
188: ,p_argument_value => p_effective_date
189: );

Line 204: nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)

200: ,p_object_version_number => p_object_version_number);
201: hr_utility.set_location(l_proc, 30);
202: --
203: if ((l_api_updating and (p_cagr_id_flex_num is not null) and
204: nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)
205: <> nvl(p_cagr_id_flex_num, hr_api.g_number))
206: or
207: (NOT l_api_updating and p_cagr_id_flex_num is not null)
208: or

Line 205: <> nvl(p_cagr_id_flex_num, hr_api.g_number))

201: hr_utility.set_location(l_proc, 30);
202: --
203: if ((l_api_updating and (p_cagr_id_flex_num is not null) and
204: nvl(per_asg_shd.g_old_rec.cagr_id_flex_num, hr_api.g_number)
205: <> nvl(p_cagr_id_flex_num, hr_api.g_number))
206: or
207: (NOT l_api_updating and p_cagr_id_flex_num is not null)
208: or
209: (l_api_updating and (p_cagr_id_flex_num is not null) and

Line 210: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)

206: or
207: (NOT l_api_updating and p_cagr_id_flex_num is not null)
208: or
209: (l_api_updating and (p_cagr_id_flex_num is not null) and
210: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)
211: <> nvl(p_collective_agreement_id, hr_api.g_number))) THEN
212: --
213: hr_utility.set_location(l_proc, 40);
214: --

Line 211: <> nvl(p_collective_agreement_id, hr_api.g_number))) THEN

207: (NOT l_api_updating and p_cagr_id_flex_num is not null)
208: or
209: (l_api_updating and (p_cagr_id_flex_num is not null) and
210: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)
211: <> nvl(p_collective_agreement_id, hr_api.g_number))) THEN
212: --
213: hr_utility.set_location(l_proc, 40);
214: --
215: --

Line 297: hr_api.mandatory_arg_error

293: --
294: --
295: -- Check mandatory parameters have been set
296: --
297: hr_api.mandatory_arg_error
298: (p_api_name => l_proc
299: ,p_argument => 'effective_date'
300: ,p_argument_value => p_effective_date
301: );

Line 302: hr_api.mandatory_arg_error

298: (p_api_name => l_proc
299: ,p_argument => 'effective_date'
300: ,p_argument_value => p_effective_date
301: );
302: hr_api.mandatory_arg_error
303: (p_api_name => l_proc
304: ,p_argument => 'validation_start_date'
305: ,p_argument_value => p_validation_start_date
306: );

Line 307: hr_api.mandatory_arg_error

303: (p_api_name => l_proc
304: ,p_argument => 'validation_start_date'
305: ,p_argument_value => p_validation_start_date
306: );
307: hr_api.mandatory_arg_error
308: (p_api_name => l_proc
309: ,p_argument => 'person_id'
310: ,p_argument_value => p_person_id
311: );

Line 326: nvl(per_asg_shd.g_old_rec.contract_id, hr_api.g_number)

322: ,p_object_version_number => p_object_version_number);
323: hr_utility.set_location(l_proc, 30);
324: --
325: if ((l_api_updating and
326: nvl(per_asg_shd.g_old_rec.contract_id, hr_api.g_number)
327: <> nvl(p_contract_id, hr_api.g_number) AND (p_contract_id is not null))
328: or
329: (NOT l_api_updating and p_contract_id is not null)) THEN
330: hr_utility.set_location(l_proc, 40);

Line 327: <> nvl(p_contract_id, hr_api.g_number) AND (p_contract_id is not null))

323: hr_utility.set_location(l_proc, 30);
324: --
325: if ((l_api_updating and
326: nvl(per_asg_shd.g_old_rec.contract_id, hr_api.g_number)
327: <> nvl(p_contract_id, hr_api.g_number) AND (p_contract_id is not null))
328: or
329: (NOT l_api_updating and p_contract_id is not null)) THEN
330: hr_utility.set_location(l_proc, 40);
331: --

Line 419: hr_api.mandatory_arg_error

415: --
416: --
417: -- Check mandatory parameters have been set
418: --
419: hr_api.mandatory_arg_error
420: (p_api_name => l_proc
421: ,p_argument => 'effective_date'
422: ,p_argument_value => p_effective_date
423: );

Line 426: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

422: ,p_argument_value => p_effective_date
423: );
424: hr_utility.set_location(l_proc, 20);
425: --
426: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
427: --
428: -- Only proceed with validation if :
429: -- a) The current g_old_rec is current and / or
430: -- b) The value for collective_agreement_id has changed or is new

Line 441: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)

437: ,p_object_version_number => p_object_version_number);
438: hr_utility.set_location(l_proc, 30);
439: --
440: if ((l_api_updating and
441: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)
442: <> nvl(p_collective_agreement_id, hr_api.g_number))
443: or
444: (NOT l_api_updating)
445: or

Line 442: <> nvl(p_collective_agreement_id, hr_api.g_number))

438: hr_utility.set_location(l_proc, 30);
439: --
440: if ((l_api_updating and
441: nvl(per_asg_shd.g_old_rec.collective_agreement_id, hr_api.g_number)
442: <> nvl(p_collective_agreement_id, hr_api.g_number))
443: or
444: (NOT l_api_updating)
445: or
446: (l_api_updating and

Line 447: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)

443: or
444: (NOT l_api_updating)
445: or
446: (l_api_updating and
447: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)
448: <> nvl(p_establishment_id, hr_api.g_number) AND (l_legislation_code = 'FR')))
449: THEN
450: hr_utility.set_location(l_proc, 40);
451: --

Line 448: <> nvl(p_establishment_id, hr_api.g_number) AND (l_legislation_code = 'FR')))

444: (NOT l_api_updating)
445: or
446: (l_api_updating and
447: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)
448: <> nvl(p_establishment_id, hr_api.g_number) AND (l_legislation_code = 'FR')))
449: THEN
450: hr_utility.set_location(l_proc, 40);
451: --
452: -- If NOT French, it is not mandatory but must be valid if it exists

Line 567: hr_api.mandatory_arg_error

563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: --
565: -- Check mandatory parameters have been set
566: --
567: hr_api.mandatory_arg_error
568: (p_api_name => l_proc
569: ,p_argument => 'assignment_type'
570: ,p_argument_value => p_assignment_type
571: );

Line 572: hr_api.mandatory_arg_error

568: (p_api_name => l_proc
569: ,p_argument => 'assignment_type'
570: ,p_argument_value => p_assignment_type
571: );
572: hr_api.mandatory_arg_error
573: (p_api_name => l_proc
574: ,p_argument => 'effective_date'
575: ,p_argument_value => p_effective_date
576: );

Line 579: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

575: ,p_argument_value => p_effective_date
576: );
577: --
578:
579: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
580:
581: --
582: -- Only proceed with validation if :
583: -- a) The current g_old_rec is current and

Line 596: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)

592: ,p_object_version_number => p_object_version_number);
593: hr_utility.set_location(l_proc, 30);
594: --
595: if ((l_api_updating and
596: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)
597: <> nvl(p_establishment_id, hr_api.g_number)
598: AND (p_establishment_id is not null))
599: or
600: ((l_api_updating) AND (l_legislation_code = 'FR') AND (p_assignment_type = 'E')

Line 597: <> nvl(p_establishment_id, hr_api.g_number)

593: hr_utility.set_location(l_proc, 30);
594: --
595: if ((l_api_updating and
596: nvl(per_asg_shd.g_old_rec.establishment_id, hr_api.g_number)
597: <> nvl(p_establishment_id, hr_api.g_number)
598: AND (p_establishment_id is not null))
599: or
600: ((l_api_updating) AND (l_legislation_code = 'FR') AND (p_assignment_type = 'E')
601: AND (p_establishment_id is null) AND ( nvl(per_asg_shd.g_old_rec.establishment_id,

Line 602: hr_api.g_number) <> nvl(p_establishment_id, hr_api.g_number)) )

598: AND (p_establishment_id is not null))
599: or
600: ((l_api_updating) AND (l_legislation_code = 'FR') AND (p_assignment_type = 'E')
601: AND (p_establishment_id is null) AND ( nvl(per_asg_shd.g_old_rec.establishment_id,
602: hr_api.g_number) <> nvl(p_establishment_id, hr_api.g_number)) )
603: or
604: (NOT l_api_updating )
605: or
606: (l_api_updating and

Line 607: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)

603: or
604: (NOT l_api_updating )
605: or
606: (l_api_updating and
607: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
608: <> nvl(p_assignment_type, hr_api.g_varchar2) AND (l_legislation_code = 'FR')
609: and (p_assignment_type = 'E')))
610: THEN
611: hr_utility.set_location(l_proc, 40);

Line 608: <> nvl(p_assignment_type, hr_api.g_varchar2) AND (l_legislation_code = 'FR')

604: (NOT l_api_updating )
605: or
606: (l_api_updating and
607: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
608: <> nvl(p_assignment_type, hr_api.g_varchar2) AND (l_legislation_code = 'FR')
609: and (p_assignment_type = 'E')))
610: THEN
611: hr_utility.set_location(l_proc, 40);
612: --

Line 780: IF hr_api.not_exists_in_dt_hr_lookups

776:
777: l_uom_lookup := 'QUALIFYING_UNITS';
778: -- Check that the uom exists in HR_LOOKUPS
779:
780: IF hr_api.not_exists_in_dt_hr_lookups
781: (p_effective_date => p_effective_date
782: ,p_lookup_type => l_uom_lookup
783: ,p_lookup_code => p_notice_period_uom
784: ,p_validation_start_date => p_validation_start_date

Line 832: (nvl(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2) <> p_employee_category))) THEN

828: -- b) The value for employee category has changed
829: --
830: IF ( (p_assignment_id IS NULL) OR
831: ((p_assignment_id IS NOT NULL) AND
832: (nvl(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2) <> p_employee_category))) THEN
833:
834: hr_utility.set_location(l_proc, 40);
835:
836: l_catg_lookup := 'EMPLOYEE_CATG';

Line 840: IF hr_api.not_exists_in_dt_hr_lookups

836: l_catg_lookup := 'EMPLOYEE_CATG';
837:
838: -- Check that the uom exists in HR_LOOKUPS
839:
840: IF hr_api.not_exists_in_dt_hr_lookups
841: (p_effective_date => p_effective_date
842: ,p_lookup_type => l_catg_lookup
843: ,p_lookup_code => p_employee_category
844: ,p_validation_start_date => p_validation_start_date

Line 901: NVL(actual_termination_date, hr_api.g_eot);

897: FROM per_periods_of_placement pop
898: WHERE pop.person_id = p_person_id
899: AND pop.date_start = p_pop_date_start
900: AND p_validation_start_date BETWEEN pop.date_start AND
901: NVL(actual_termination_date, hr_api.g_eot);
902: --
903: BEGIN
904: --
905: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 909: hr_api.mandatory_arg_error

905: hr_utility.set_location('Entering:'|| l_proc, 10);
906: --
907: -- Check mandatory parameters have been set
908: --
909: hr_api.mandatory_arg_error
910: (p_api_name => l_proc
911: ,p_argument => 'person_id'
912: ,p_argument_value => p_person_id
913: );

Line 915: hr_api.mandatory_arg_error

911: ,p_argument => 'person_id'
912: ,p_argument_value => p_person_id
913: );
914: --
915: hr_api.mandatory_arg_error
916: (p_api_name => l_proc
917: ,p_argument => 'validation_start_date'
918: ,p_argument_value => p_validation_start_date
919: );

Line 921: hr_api.mandatory_arg_error

917: ,p_argument => 'validation_start_date'
918: ,p_argument_value => p_validation_start_date
919: );
920: --
921: hr_api.mandatory_arg_error
922: (p_api_name => l_proc
923: ,p_argument => 'validation_end_date'
924: ,p_argument_value => p_validation_end_date
925: );

Line 927: hr_api.mandatory_arg_error

923: ,p_argument => 'validation_end_date'
924: ,p_argument_value => p_validation_end_date
925: );
926: --
927: hr_api.mandatory_arg_error
928: (p_api_name => l_proc
929: ,p_argument => 'effective_date'
930: ,p_argument_value => p_effective_date
931: );

Line 969: hr_api.mandatory_arg_error

965: --
966: -- Check the mandatory parameter period of service for
967: -- an employee.
968: --
969: hr_api.mandatory_arg_error
970: (p_api_name => l_proc
971: ,p_argument => 'period_of_placement_date_start'
972: ,p_argument_value => p_pop_date_start);
973: --

Line 1010: IF p_validation_end_date > NVL(l_actual_termination_date, hr_api.g_eot) THEN

1006: --
1007: -- Check if the period of placement has been closed before the
1008: -- validation end date.
1009: --
1010: IF p_validation_end_date > NVL(l_actual_termination_date, hr_api.g_eot) THEN
1011: --
1012: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1013: hr_utility.raise_error;
1014: --

Line 1061: hr_api.mandatory_arg_error

1057:
1058: --
1059: -- Check that mandatory parameters have been set.
1060: --
1061: hr_api.mandatory_arg_error
1062: (p_api_name => l_proc
1063: ,p_argument => 'assignment_type'
1064: ,p_argument_value => p_assignment_type
1065: );

Line 1086: NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number) <>

1082: hr_utility.set_location(l_proc, 30);
1083: END IF;
1084:
1085: IF ((l_api_updating AND
1086: NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number) <>
1087: NVL(p_vendor_id, hr_api.g_number)) OR
1088: (NOT l_api_updating)) THEN
1089:
1090: IF g_debug THEN

Line 1087: NVL(p_vendor_id, hr_api.g_number)) OR

1083: END IF;
1084:
1085: IF ((l_api_updating AND
1086: NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number) <>
1087: NVL(p_vendor_id, hr_api.g_number)) OR
1088: (NOT l_api_updating)) THEN
1089:
1090: IF g_debug THEN
1091: hr_utility.set_location(l_proc, 40);

Line 1193: hr_api.mandatory_arg_error

1189:
1190: --
1191: -- Check that mandatory parameters have been set.
1192: --
1193: hr_api.mandatory_arg_error
1194: (p_api_name => l_proc
1195: ,p_argument => 'assignment_type'
1196: ,p_argument_value => p_assignment_type
1197: );

Line 1218: NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number) <>

1214: hr_utility.set_location(l_proc, 30);
1215: END IF;
1216:
1217: IF ((l_api_updating AND
1218: NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number) <>
1219: NVL(p_vendor_site_id, hr_api.g_number)) OR
1220: (NOT l_api_updating)) THEN
1221:
1222: IF g_debug THEN

Line 1219: NVL(p_vendor_site_id, hr_api.g_number)) OR

1215: END IF;
1216:
1217: IF ((l_api_updating AND
1218: NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number) <>
1219: NVL(p_vendor_site_id, hr_api.g_number)) OR
1220: (NOT l_api_updating)) THEN
1221:
1222: IF g_debug THEN
1223: hr_utility.set_location(l_proc, 40);

Line 1345: hr_api.mandatory_arg_error

1341:
1342: --
1343: -- Check that mandatory parameters have been set.
1344: --
1345: hr_api.mandatory_arg_error
1346: (p_api_name => l_proc
1347: ,p_argument => 'assignment_type'
1348: ,p_argument_value => p_assignment_type
1349: );

Line 1370: NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number) <>

1366: hr_utility.set_location(l_proc, 30);
1367: END IF;
1368:
1369: IF ((l_api_updating AND
1370: NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number) <>
1371: NVL(p_po_header_id, hr_api.g_number)) OR
1372: (NOT l_api_updating)) THEN
1373:
1374: IF g_debug THEN

Line 1371: NVL(p_po_header_id, hr_api.g_number)) OR

1367: END IF;
1368:
1369: IF ((l_api_updating AND
1370: NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number) <>
1371: NVL(p_po_header_id, hr_api.g_number)) OR
1372: (NOT l_api_updating)) THEN
1373:
1374: IF g_debug THEN
1375: hr_utility.set_location(l_proc, 40);

Line 1505: hr_api.mandatory_arg_error

1501:
1502: --
1503: -- Check that mandatory parameters have been set.
1504: --
1505: hr_api.mandatory_arg_error
1506: (p_api_name => l_proc
1507: ,p_argument => 'assignment_type'
1508: ,p_argument_value => p_assignment_type
1509: );

Line 1530: NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number) <>

1526: hr_utility.set_location(l_proc, 30);
1527: END IF;
1528:
1529: IF ((l_api_updating AND
1530: NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number) <>
1531: NVL(p_po_line_id, hr_api.g_number)) OR
1532: (NOT l_api_updating)) THEN
1533:
1534: IF g_debug THEN

Line 1531: NVL(p_po_line_id, hr_api.g_number)) OR

1527: END IF;
1528:
1529: IF ((l_api_updating AND
1530: NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number) <>
1531: NVL(p_po_line_id, hr_api.g_number)) OR
1532: (NOT l_api_updating)) THEN
1533:
1534: IF g_debug THEN
1535: hr_utility.set_location(l_proc, 40);

Line 1647: hr_api.mandatory_arg_error

1643:
1644: --
1645: -- Check that mandatory parameters have been set.
1646: --
1647: hr_api.mandatory_arg_error
1648: (p_api_name => l_proc
1649: ,p_argument => 'assignment_type'
1650: ,p_argument_value => p_assignment_type
1651: );

Line 1672: NVL(per_asg_shd.g_old_rec.projected_assignment_end, hr_api.g_date) <>

1668: hr_utility.set_location(l_proc, 30);
1669: END IF;
1670:
1671: IF ((l_api_updating AND
1672: NVL(per_asg_shd.g_old_rec.projected_assignment_end, hr_api.g_date) <>
1673: NVL(p_projected_assignment_end, hr_api.g_date)) OR
1674: (NOT l_api_updating)) THEN
1675:
1676: IF g_debug THEN

Line 1673: NVL(p_projected_assignment_end, hr_api.g_date)) OR

1669: END IF;
1670:
1671: IF ((l_api_updating AND
1672: NVL(per_asg_shd.g_old_rec.projected_assignment_end, hr_api.g_date) <>
1673: NVL(p_projected_assignment_end, hr_api.g_date)) OR
1674: (NOT l_api_updating)) THEN
1675:
1676: IF g_debug THEN
1677: hr_utility.set_location(l_proc, 40);

Line 1785: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)

1781: END IF;
1782:
1783: IF (l_api_updating
1784: AND
1785: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
1786: <> NVL(p_vendor_id, hr_api.g_number))
1787: OR
1788: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
1789: <> NVL(p_vendor_site_id, hr_api.g_number))))

Line 1786: <> NVL(p_vendor_id, hr_api.g_number))

1782:
1783: IF (l_api_updating
1784: AND
1785: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
1786: <> NVL(p_vendor_id, hr_api.g_number))
1787: OR
1788: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
1789: <> NVL(p_vendor_site_id, hr_api.g_number))))
1790: OR

Line 1788: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)

1784: AND
1785: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
1786: <> NVL(p_vendor_id, hr_api.g_number))
1787: OR
1788: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
1789: <> NVL(p_vendor_site_id, hr_api.g_number))))
1790: OR
1791: NOT l_api_updating THEN
1792:

Line 1789: <> NVL(p_vendor_site_id, hr_api.g_number))))

1785: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
1786: <> NVL(p_vendor_id, hr_api.g_number))
1787: OR
1788: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
1789: <> NVL(p_vendor_site_id, hr_api.g_number))))
1790: OR
1791: NOT l_api_updating THEN
1792:
1793: IF g_debug THEN

Line 1903: ((NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)

1899: END IF;
1900:
1901: IF (l_api_updating
1902: AND
1903: ((NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
1904: <> NVL(p_po_header_id, hr_api.g_number))
1905: OR
1906: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
1907: <> NVL(p_po_line_id, hr_api.g_number))))

Line 1904: <> NVL(p_po_header_id, hr_api.g_number))

1900:
1901: IF (l_api_updating
1902: AND
1903: ((NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
1904: <> NVL(p_po_header_id, hr_api.g_number))
1905: OR
1906: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
1907: <> NVL(p_po_line_id, hr_api.g_number))))
1908: OR

Line 1906: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)

1902: AND
1903: ((NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
1904: <> NVL(p_po_header_id, hr_api.g_number))
1905: OR
1906: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
1907: <> NVL(p_po_line_id, hr_api.g_number))))
1908: OR
1909: NOT l_api_updating THEN
1910:

Line 1907: <> NVL(p_po_line_id, hr_api.g_number))))

1903: ((NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
1904: <> NVL(p_po_header_id, hr_api.g_number))
1905: OR
1906: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
1907: <> NVL(p_po_line_id, hr_api.g_number))))
1908: OR
1909: NOT l_api_updating THEN
1910:
1911: IF g_debug THEN

Line 2024: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)

2020: END IF;
2021:
2022: IF (l_api_updating
2023: AND
2024: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
2025: <> NVL(p_vendor_id, hr_api.g_number))
2026: OR
2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))

Line 2025: <> NVL(p_vendor_id, hr_api.g_number))

2021:
2022: IF (l_api_updating
2023: AND
2024: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
2025: <> NVL(p_vendor_id, hr_api.g_number))
2026: OR
2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))
2029: OR

Line 2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)

2023: AND
2024: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
2025: <> NVL(p_vendor_id, hr_api.g_number))
2026: OR
2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))
2029: OR
2030: (NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
2031: <> NVL(p_po_header_id, hr_api.g_number))))

Line 2028: <> NVL(p_vendor_site_id, hr_api.g_number))

2024: ((NVL(per_asg_shd.g_old_rec.vendor_id, hr_api.g_number)
2025: <> NVL(p_vendor_id, hr_api.g_number))
2026: OR
2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))
2029: OR
2030: (NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
2031: <> NVL(p_po_header_id, hr_api.g_number))))
2032: OR

Line 2030: (NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)

2026: OR
2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))
2029: OR
2030: (NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
2031: <> NVL(p_po_header_id, hr_api.g_number))))
2032: OR
2033: NOT l_api_updating THEN
2034:

Line 2031: <> NVL(p_po_header_id, hr_api.g_number))))

2027: (NVL(per_asg_shd.g_old_rec.vendor_site_id, hr_api.g_number)
2028: <> NVL(p_vendor_site_id, hr_api.g_number))
2029: OR
2030: (NVL(per_asg_shd.g_old_rec.po_header_id, hr_api.g_number)
2031: <> NVL(p_po_header_id, hr_api.g_number))))
2032: OR
2033: NOT l_api_updating THEN
2034:
2035: IF g_debug THEN

Line 2099: SELECT NVL(pol.job_id, hr_api.g_number) job_id

2095: --
2096: -- Fetch the job for this PO line.
2097: --
2098: CURSOR csr_chk_po_job_match IS
2099: SELECT NVL(pol.job_id, hr_api.g_number) job_id
2100: FROM po_temp_labor_lines_v pol
2101: WHERE pol.po_line_id = p_po_line_id;
2102:
2103: BEGIN

Line 2131: ((NVL(per_asg_shd.g_old_rec.job_id, hr_api.g_number)

2127: END IF;
2128:
2129: IF (l_api_updating
2130: AND
2131: ((NVL(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
2132: <> NVL(p_job_id, hr_api.g_number))
2133: OR
2134: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
2135: <> NVL(p_po_line_id, hr_api.g_number))))

Line 2132: <> NVL(p_job_id, hr_api.g_number))

2128:
2129: IF (l_api_updating
2130: AND
2131: ((NVL(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
2132: <> NVL(p_job_id, hr_api.g_number))
2133: OR
2134: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
2135: <> NVL(p_po_line_id, hr_api.g_number))))
2136: OR

Line 2134: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)

2130: AND
2131: ((NVL(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
2132: <> NVL(p_job_id, hr_api.g_number))
2133: OR
2134: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
2135: <> NVL(p_po_line_id, hr_api.g_number))))
2136: OR
2137: NOT l_api_updating THEN
2138:

Line 2135: <> NVL(p_po_line_id, hr_api.g_number))))

2131: ((NVL(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
2132: <> NVL(p_job_id, hr_api.g_number))
2133: OR
2134: (NVL(per_asg_shd.g_old_rec.po_line_id, hr_api.g_number)
2135: <> NVL(p_po_line_id, hr_api.g_number))))
2136: OR
2137: NOT l_api_updating THEN
2138:
2139: IF g_debug THEN

Line 2200: hr_api.mandatory_arg_error

2196: hr_utility.set_location('Entering:'|| l_proc, 10);
2197: --
2198: -- Check mandatory parameters have been set
2199: --
2200: hr_api.mandatory_arg_error
2201: (p_api_name => l_proc
2202: ,p_argument => 'assignment_type'
2203: ,p_argument_value => p_assignment_type
2204: );

Line 2220: NVL(per_asg_shd.g_old_rec.vendor_assignment_number, hr_api.g_varchar2) <>

2216: --
2217: hr_utility.set_location(l_proc, 30);
2218: --
2219: IF ((l_api_updating AND
2220: NVL(per_asg_shd.g_old_rec.vendor_assignment_number, hr_api.g_varchar2) <>
2221: NVL(p_vendor_assignment_number, hr_api.g_varchar2)) OR
2222: (NOT l_api_updating)) THEN
2223: --
2224: hr_utility.set_location(l_proc, 40);

Line 2221: NVL(p_vendor_assignment_number, hr_api.g_varchar2)) OR

2217: hr_utility.set_location(l_proc, 30);
2218: --
2219: IF ((l_api_updating AND
2220: NVL(per_asg_shd.g_old_rec.vendor_assignment_number, hr_api.g_varchar2) <>
2221: NVL(p_vendor_assignment_number, hr_api.g_varchar2)) OR
2222: (NOT l_api_updating)) THEN
2223: --
2224: hr_utility.set_location(l_proc, 40);
2225: --

Line 2280: hr_api.mandatory_arg_error

2276: hr_utility.set_location('Entering:'|| l_proc, 10);
2277: --
2278: -- Check mandatory parameters have been set
2279: --
2280: hr_api.mandatory_arg_error
2281: (p_api_name => l_proc
2282: ,p_argument => 'assignment_type'
2283: ,p_argument_value => p_assignment_type
2284: );

Line 2300: NVL(per_asg_shd.g_old_rec.vendor_employee_number, hr_api.g_varchar2) <>

2296: --
2297: hr_utility.set_location(l_proc, 30);
2298: --
2299: IF ((l_api_updating AND
2300: NVL(per_asg_shd.g_old_rec.vendor_employee_number, hr_api.g_varchar2) <>
2301: NVL(p_vendor_employee_number, hr_api.g_varchar2)) OR
2302: (NOT l_api_updating)) THEN
2303: --
2304: hr_utility.set_location(l_proc, 40);

Line 2301: NVL(p_vendor_employee_number, hr_api.g_varchar2)) OR

2297: hr_utility.set_location(l_proc, 30);
2298: --
2299: IF ((l_api_updating AND
2300: NVL(per_asg_shd.g_old_rec.vendor_employee_number, hr_api.g_varchar2) <>
2301: NVL(p_vendor_employee_number, hr_api.g_varchar2)) OR
2302: (NOT l_api_updating)) THEN
2303: --
2304: hr_utility.set_location(l_proc, 40);
2305: --

Line 2368: (nvl(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2) <> p_work_at_home))) THEN

2364: -- b) The value for notice_period_uom has changed
2365: --
2366: IF ( (p_assignment_id IS NULL) OR
2367: ((p_assignment_id IS NOT NULL) AND
2368: (nvl(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2) <> p_work_at_home))) THEN
2369:
2370: hr_utility.set_location(l_proc, 40);
2371:
2372: l_wah_lookup := 'YES_NO';

Line 2375: IF hr_api.not_exists_in_dt_hr_lookups

2371:
2372: l_wah_lookup := 'YES_NO';
2373: -- Check that the uom exists in HR_LOOKUPS
2374:
2375: IF hr_api.not_exists_in_dt_hr_lookups
2376: (p_effective_date => p_effective_date
2377: ,p_lookup_type => l_wah_lookup
2378: ,p_lookup_code => p_work_at_home
2379: ,p_validation_start_date => p_validation_start_date