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

Line 57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>

53: begin
54: hr_utility.set_location('Entering:'||l_proc,10);
55: --
56: if ((p_rec.event_id is not null) and (
57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>

Line 58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or

54: hr_utility.set_location('Entering:'||l_proc,10);
55: --
56: if ((p_rec.event_id is not null) and (
57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or

Line 59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>

55: --
56: if ((p_rec.event_id is not null) and (
57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>

Line 60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or

56: if ((p_rec.event_id is not null) and (
57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or

Line 61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>

57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>

Line 62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or

58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or

Line 63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>

59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>

Line 64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or

60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or

Line 65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>

61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>

Line 66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or

62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or

Line 67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>

63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>

Line 68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or

64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or

Line 69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>

65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>

Line 70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or

66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or

Line 71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>

67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>

Line 72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or

68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or

Line 73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>

69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>

Line 74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or

70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or

Line 75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>

71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>

Line 76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or

72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or

Line 77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>

73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>

Line 78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or

74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or

Line 79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>

75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>

Line 80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or

76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or

Line 81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>

77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>

Line 82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or

78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or

Line 83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>

79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>

Line 84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or

80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or

Line 85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>

81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>

Line 86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or

82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or

Line 87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>

83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>

Line 88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or

84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or

Line 89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>

85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>

Line 90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or

86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or

Line 91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>

87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>

Line 92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or

88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or

Line 93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>

89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>

Line 94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or

90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>
98: nvl(p_rec.evt_information20, hr_api.g_varchar2) ))

Line 95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>

91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>
98: nvl(p_rec.evt_information20, hr_api.g_varchar2) ))
99: or (p_rec.event_id is null) then

Line 96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or

92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>
98: nvl(p_rec.evt_information20, hr_api.g_varchar2) ))
99: or (p_rec.event_id is null) then
100: --

Line 97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>

93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>
98: nvl(p_rec.evt_information20, hr_api.g_varchar2) ))
99: or (p_rec.event_id is null) then
100: --
101: -- Only execute the validation if absolutely necessary:

Line 98: nvl(p_rec.evt_information20, hr_api.g_varchar2) ))

94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>
98: nvl(p_rec.evt_information20, hr_api.g_varchar2) ))
99: or (p_rec.event_id is null) then
100: --
101: -- Only execute the validation if absolutely necessary:
102: -- a) During update, the structure column value or any

Line 191: hr_api.mandatory_arg_error

187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: --
189: -- Ensure that all the mandatory parameter are not null
190: --
191: hr_api.mandatory_arg_error
192: (p_api_name => l_proc
193: ,p_argument => 'event_id'
194: ,p_argument_value => p_event_id
195: );

Line 216: hr_api.set_security_group_id

212: CLOSE csr_sec_grp;
213: --
214: -- Set the security_group_id in CLIENT_INFO
215: --
216: hr_api.set_security_group_id
217: (p_security_group_id => l_security_group_id
218: );
219:
220: END IF;

Line 277: hr_api.mandatory_arg_error (p_api_name => l_proc,

273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: -- Ensure that all the mandatory parameters are not null
276: --
277: hr_api.mandatory_arg_error (p_api_name => l_proc,
278: p_argument => 'event_id',
279: p_argument_value => p_event_id);
280: open csr_leg_code;
281: fetch csr_leg_code into l_legislation_code;

Line 609: If nvl(l_course_start_date, hr_api.g_sot) < p_enrollment_start_date Then

605: If l_course_start_date is not null Then
606: --
607: -- Course startdate is earlier than enrollment startdate
608: --
609: If nvl(l_course_start_date, hr_api.g_sot) < p_enrollment_start_date Then
610: --
611: --
612: -- ** TEMP ** Add error message with the following text.
613: fnd_message.set_name('OTA', 'OTA_13481_ENROL_START_AFTER');

Line 625: If nvl(p_enrollment_start_date, hr_api.g_sot) > l_course_end_date Then

621: If l_course_end_date is not null Then
622: --
623: -- Enrollment startdate is earlier than course enddate
624: --
625: If nvl(p_enrollment_start_date, hr_api.g_sot) > l_course_end_date Then
626: --
627: -- ** TEMP ** Add error message with the following text.
628: fnd_message.set_name('OTA','OTA_13474_ENROLL_START_AFTER');
629: fnd_message.raise_error;

Line 971: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then

967: If p_par_end is not null Then
968: --
969: -- Child startdate is later than parent enddate
970: --
971: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then
972: --
973: -- ** TEMP ** Add error message with the following text.
974: fnd_message.set_name('OTA','OTA_13474_ENROLL_START_AFTER');
975: fnd_message.raise_error;

Line 1128: l_start_date := hr_api.g_sot;

1124: fetch check_dates into l_start_date, l_end_date, l_act_vrsn_id;
1125: close check_dates;
1126: --
1127: if l_start_date is null then
1128: l_start_date := hr_api.g_sot;
1129: end if;
1130: if l_end_date is null then
1131: l_end_date := hr_api.g_eot;
1132: end if;

Line 1131: l_end_date := hr_api.g_eot;

1127: if l_start_date is null then
1128: l_start_date := hr_api.g_sot;
1129: end if;
1130: if l_end_date is null then
1131: l_end_date := hr_api.g_eot;
1132: end if;
1133: --
1134: l_evt_start_date := p_course_start_date;
1135: l_evt_end_date := p_course_end_date;

Line 1155: l_evt_end_date := hr_api.g_eot;

1151: */
1152: --
1153: -- added for bug#4069324
1154: if l_evt_end_date is null then
1155: l_evt_end_date := hr_api.g_eot;
1156: end if;
1157: --
1158: -- Added extra conditions to handle development events
1159: --

Line 1174: l_act_start_date := hr_api.g_sot;

1170: fetch check_act_dates into l_act_start_date, l_act_end_date;
1171: close check_act_dates;
1172: --
1173: if l_act_start_date is null then
1174: l_act_start_date := hr_api.g_sot;
1175: end if;
1176: if l_act_end_date is null then
1177: l_act_end_date := hr_api.g_eot;
1178: end if;

Line 1177: l_act_end_date := hr_api.g_eot;

1173: if l_act_start_date is null then
1174: l_act_start_date := hr_api.g_sot;
1175: end if;
1176: if l_act_end_date is null then
1177: l_act_end_date := hr_api.g_eot;
1178: end if;
1179: --
1180: l_evt_start_date := p_course_start_date;
1181: l_evt_end_date := p_course_end_date;

Line 1200: l_evt_end_date := hr_api.g_eot;

1196: end if;
1197: */
1198: -- added for bug#4069324
1199: if l_evt_end_date is null then
1200: l_evt_end_date := hr_api.g_eot;
1201: end if;
1202: --
1203:
1204: --

Line 1255: l_start_date := hr_api.g_sot;

1251: fetch check_dates into l_start_date, l_end_date;
1252: close check_dates;
1253: --
1254: if l_start_date is null then
1255: l_start_date := hr_api.g_sot;
1256: end if;
1257: if l_end_date is null then
1258: l_end_date := hr_api.g_eot;
1259: end if;

Line 1258: l_end_date := hr_api.g_eot;

1254: if l_start_date is null then
1255: l_start_date := hr_api.g_sot;
1256: end if;
1257: if l_end_date is null then
1258: l_end_date := hr_api.g_eot;
1259: end if;
1260: --
1261: l_evt_start_date := p_course_start_date;
1262: l_evt_end_date := p_course_end_date;

Line 1316: not between nvl(p_enrolment_start_date,hr_api.g_sot) and nvl(p_enrolment_end_date +1,hr_api.g_eot);

1312: and ota_timezone_util.convert_date(trunc(date_booking_placed)
1313: , to_char(date_booking_placed, 'HH24:MI')
1314: , ota_timezone_util.get_server_timezone_code
1315: , p_timezone)
1316: not between nvl(p_enrolment_start_date,hr_api.g_sot) and nvl(p_enrolment_end_date +1,hr_api.g_eot);
1317: begin
1318: --
1319: hr_utility.set_location(' Entering:'||l_proc,10);
1320: --

Line 1373: l_start_date := hr_api.g_sot;

1369: fetch c_check_dates into l_start_date, l_end_date;
1370: exit when c_check_dates%notfound;
1371: --
1372: if l_start_date is null then
1373: l_start_date := hr_api.g_sot;
1374: end if;
1375: if l_end_date is null then
1376: l_end_date := hr_api.g_eot;
1377: end if;

Line 1376: l_end_date := hr_api.g_eot;

1372: if l_start_date is null then
1373: l_start_date := hr_api.g_sot;
1374: end if;
1375: if l_end_date is null then
1376: l_end_date := hr_api.g_eot;
1377: end if;
1378: --
1379: l_evt_start_date := p_course_start_date;
1380: l_evt_end_date := p_course_end_date;

Line 1425: and (course_start_date < nvl(p_course_start_date,hr_api.g_sot)

1421: select null
1422: from ota_events
1423: where parent_event_id = p_event_id
1424: and event_type = 'SESSION'
1425: and (course_start_date < nvl(p_course_start_date,hr_api.g_sot)
1426: or course_start_date > nvl(p_course_end_date,hr_api.g_eot));
1427: --
1428: /*
1429: cursor check_course_null_dates is

Line 1426: or course_start_date > nvl(p_course_end_date,hr_api.g_eot));

1422: from ota_events
1423: where parent_event_id = p_event_id
1424: and event_type = 'SESSION'
1425: and (course_start_date < nvl(p_course_start_date,hr_api.g_sot)
1426: or course_start_date > nvl(p_course_end_date,hr_api.g_eot));
1427: --
1428: /*
1429: cursor check_course_null_dates is
1430: select 'X'

Line 1504: HR_API.MANDATORY_ARG_ERROR (

1500: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1501: --
1502: -- Check arguments
1503: --
1504: HR_API.MANDATORY_ARG_ERROR (
1505: G_PACKAGE,
1506: 'P_TITLE',
1507: P_TITLE);
1508: HR_API.MANDATORY_ARG_ERROR (

Line 1508: HR_API.MANDATORY_ARG_ERROR (

1504: HR_API.MANDATORY_ARG_ERROR (
1505: G_PACKAGE,
1506: 'P_TITLE',
1507: P_TITLE);
1508: HR_API.MANDATORY_ARG_ERROR (
1509: G_PACKAGE,
1510: 'P_BUSINESS_GROUP_ID',
1511: P_BUSINESS_GROUP_ID);
1512: --

Line 1613: HR_API.MANDATORY_ARG_ERROR (

1609: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1610: --
1611: -- Check parameters
1612: --
1613: HR_API.MANDATORY_ARG_ERROR (
1614: P_API_NAME => G_PACKAGE,
1615: P_ARGUMENT => 'P_PARENT_EVENT_ID',
1616: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
1617: --

Line 1727: HR_API.MANDATORY_ARG_ERROR (

1723: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1724: --
1725: -- Check parameters
1726: --
1727: HR_API.MANDATORY_ARG_ERROR (
1728: P_API_NAME => G_PACKAGE,
1729: P_ARGUMENT => 'P_PARENT_EVENT_ID',
1730: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
1731: --

Line 1749: l_course_start_date := hr_api.g_sot;

1745: fnd_message.set_name('OTA','OTA_13579_EVT_SESSION_DATES');
1746: fnd_message.raise_error;
1747: end if;
1748: /* if l_course_start_date is null then
1749: l_course_start_date := hr_api.g_sot;
1750: end if;
1751: if l_course_end_date is null then
1752: l_course_end_date := hr_api.g_eot;
1753: end if; */

Line 1752: l_course_end_date := hr_api.g_eot;

1748: /* if l_course_start_date is null then
1749: l_course_start_date := hr_api.g_sot;
1750: end if;
1751: if l_course_end_date is null then
1752: l_course_end_date := hr_api.g_eot;
1753: end if; */
1754: L_COURSE_SPANS_SESSIONS :=
1755: ( (L_COURSE_START_DATE is not null)
1756: and (L_COURSE_END_DATE is not null)

Line 1794: HR_API.MANDATORY_ARG_ERROR (

1790: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1791: --
1792: -- Check parameters
1793: --
1794: HR_API.MANDATORY_ARG_ERROR (
1795: G_PACKAGE,
1796: 'p_event_id',
1797: p_event_id);
1798: --

Line 1930: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

1926: --
1927: procedure check_parameters is
1928: --
1929: begin
1930: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
1931: 'p_event_id',
1932: p_event_id);
1933: --
1934: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

Line 1934: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

1930: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
1931: 'p_event_id',
1932: p_event_id);
1933: --
1934: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
1935: 'p_event_type',
1936: p_event_type);
1937: end check_parameters;
1938: --

Line 2050: HR_API.MANDATORY_ARG_ERROR (

2046: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
2047: --
2048: -- Check parameters
2049: --
2050: HR_API.MANDATORY_ARG_ERROR (
2051: P_API_NAME => G_PACKAGE,
2052: P_ARGUMENT => 'P_EVENT_TYPE',
2053: P_ARGUMENT_VALUE => P_EVENT_TYPE);
2054: HR_API.MANDATORY_ARG_ERROR (

Line 2054: HR_API.MANDATORY_ARG_ERROR (

2050: HR_API.MANDATORY_ARG_ERROR (
2051: P_API_NAME => G_PACKAGE,
2052: P_ARGUMENT => 'P_EVENT_TYPE',
2053: P_ARGUMENT_VALUE => P_EVENT_TYPE);
2054: HR_API.MANDATORY_ARG_ERROR (
2055: P_API_NAME => G_PACKAGE,
2056: P_ARGUMENT => 'P_PARENT_EVENT_ID',
2057: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
2058: --

Line 2109: HR_API.MANDATORY_ARG_ERROR (

2105: HR_UTILITY.SET_LOCATION ('Entering:' || G_PACKAGE || 'VALID_PARENT_EVENT', 5);
2106: --
2107: -- Check parameters
2108: --
2109: HR_API.MANDATORY_ARG_ERROR (
2110: G_PACKAGE,
2111: 'P_BUSINESS_GROUP_ID',
2112: P_BUSINESS_GROUP_ID);
2113: --

Line 2114: HR_API.MANDATORY_ARG_ERROR (

2110: G_PACKAGE,
2111: 'P_BUSINESS_GROUP_ID',
2112: P_BUSINESS_GROUP_ID);
2113: --
2114: HR_API.MANDATORY_ARG_ERROR (
2115: G_PACKAGE,
2116: 'P_EVENT_TYPE',
2117: P_EVENT_TYPE);
2118: --

Line 2263: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

2259: procedure check_parameters is
2260: --
2261: begin
2262: --
2263: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2264: 'p_event_type',
2265: p_event_type);
2266: --
2267: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

Line 2267: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

2263: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2264: 'p_event_type',
2265: p_event_type);
2266: --
2267: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2268: 'p_event_id',
2269: p_event_id);
2270: --
2271: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

Line 2271: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

2267: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2268: 'p_event_id',
2269: p_event_id);
2270: --
2271: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2272: 'p_enrolment_start_date',
2273: p_enrolment_start_date);
2274: --
2275: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

Line 2275: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

2271: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2272: 'p_enrolment_start_date',
2273: p_enrolment_start_date);
2274: --
2275: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2276: 'p_enrolment_end_date',
2277: p_enrolment_end_date);
2278: --
2279: if (p_event_type = 'PROGRAMME' and p_parent_event_id is not null)

Line 3134: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>

3130: hr_utility.set_location('Entering:'||l_proc, 5);
3131: --
3132:
3133: if (((p_event_id is not null) and
3134: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>
3135: nvl(p_owner_id,hr_api.g_number))
3136: or (p_event_id is null)) then
3137:
3138: IF p_owner_id is not null then

Line 3135: nvl(p_owner_id,hr_api.g_number))

3131: --
3132:
3133: if (((p_event_id is not null) and
3134: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>
3135: nvl(p_owner_id,hr_api.g_number))
3136: or (p_event_id is null)) then
3137:
3138: IF p_owner_id is not null then
3139:

Line 3197: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>

3193: Begin
3194: hr_utility.set_location('Entering:'||l_proc, 5);
3195:
3196: if (((p_event_id is not null) and
3197: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3198: nvl(p_line_id,hr_api.g_number))
3199: or (p_event_id is null)) then
3200: --
3201: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3198: nvl(p_line_id,hr_api.g_number))

3194: hr_utility.set_location('Entering:'||l_proc, 5);
3195:
3196: if (((p_event_id is not null) and
3197: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3198: nvl(p_line_id,hr_api.g_number))
3199: or (p_event_id is null)) then
3200: --
3201: hr_utility.set_location('Entering:'||l_proc, 10);
3202: if (p_line_id is not null) then

Line 3401: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>

3397:
3398: Begin
3399: hr_utility.set_location('Entering:'||l_proc, 5);
3400: if (((p_event_id is not null) and
3401: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3402: nvl(p_training_center_id,hr_api.g_number))
3403: or (p_event_id is null)) then
3404: --
3405: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3402: nvl(p_training_center_id,hr_api.g_number))

3398: Begin
3399: hr_utility.set_location('Entering:'||l_proc, 5);
3400: if (((p_event_id is not null) and
3401: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3402: nvl(p_training_center_id,hr_api.g_number))
3403: or (p_event_id is null)) then
3404: --
3405: hr_utility.set_location('Entering:'||l_proc, 10);
3406: if (p_training_center_id is not null) then

Line 3459: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>

3455: Begin
3456: hr_utility.set_location('Entering:'||l_proc, 5);
3457:
3458: if (((p_event_id is not null) and
3459: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3460: nvl(p_location_id,hr_api.g_number))
3461: or (p_event_id is null)) then
3462: --
3463: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3460: nvl(p_location_id,hr_api.g_number))

3456: hr_utility.set_location('Entering:'||l_proc, 5);
3457:
3458: if (((p_event_id is not null) and
3459: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3460: nvl(p_location_id,hr_api.g_number))
3461: or (p_event_id is null)) then
3462: --
3463: hr_utility.set_location('Entering:'||l_proc, 10);
3464: if (p_location_id is not null) then

Line 3519: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>

3515:
3516: hr_utility.set_location('Entering:'||l_proc, 5);
3517:
3518: if (((p_event_id is not null) and
3519: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3520: nvl(p_offering_id,hr_api.g_number))
3521: or (p_event_id is null)) then
3522: --
3523: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3520: nvl(p_offering_id,hr_api.g_number))

3516: hr_utility.set_location('Entering:'||l_proc, 5);
3517:
3518: if (((p_event_id is not null) and
3519: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3520: nvl(p_offering_id,hr_api.g_number))
3521: or (p_event_id is null)) then
3522: --
3523: hr_utility.set_location('Entering:'||l_proc, 10);
3524: if (p_offering_id is not null) then

Line 3672: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

3668: --modified for eBS by asud
3669: /*
3670: -- Call all supporting business operations
3671: --
3672: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
3673: --
3674: VALIDITY_CHECKS (
3675: P_REC => P_REC);
3676: --

Line 3682: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,

3678: --*/
3679: --modified for eBS by asud
3680: -- Call all supporting business operations
3681: -- Validate Important Attributes
3682: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3683: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3684: --
3685: hr_multi_message.end_validation_set;
3686:

Line 3721: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

3717: --
3718: -- Call all supporting business operations
3719: --
3720: /*
3721: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
3722: --
3723: VALIDITY_CHECKS (
3724: P_REC => P_REC);
3725: --

Line 3730: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,

3726: hr_utility.set_location(' Leaving:'||l_proc, 10);
3727: --
3728: */
3729: -- Validate Important Attributes
3730: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3731: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3732: --
3733: hr_multi_message.end_validation_set;
3734: