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 1746: HR_API.MANDATORY_ARG_ERROR (

1742: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1743: --
1744: -- Check parameters
1745: --
1746: HR_API.MANDATORY_ARG_ERROR (
1747: P_API_NAME => G_PACKAGE,
1748: P_ARGUMENT => 'P_PARENT_EVENT_ID',
1749: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
1750: --

Line 1768: l_course_start_date := hr_api.g_sot;

1764: fnd_message.set_name('OTA','OTA_13579_EVT_SESSION_DATES');
1765: fnd_message.raise_error;
1766: end if;
1767: /* if l_course_start_date is null then
1768: l_course_start_date := hr_api.g_sot;
1769: end if;
1770: if l_course_end_date is null then
1771: l_course_end_date := hr_api.g_eot;
1772: end if; */

Line 1771: l_course_end_date := hr_api.g_eot;

1767: /* if l_course_start_date is null then
1768: l_course_start_date := hr_api.g_sot;
1769: end if;
1770: if l_course_end_date is null then
1771: l_course_end_date := hr_api.g_eot;
1772: end if; */
1773: L_COURSE_SPANS_SESSIONS :=
1774: ( (L_COURSE_START_DATE is not null)
1775: and (L_COURSE_END_DATE is not null)

Line 1813: HR_API.MANDATORY_ARG_ERROR (

1809: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1810: --
1811: -- Check parameters
1812: --
1813: HR_API.MANDATORY_ARG_ERROR (
1814: G_PACKAGE,
1815: 'p_event_id',
1816: p_event_id);
1817: --

Line 1949: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

1945: --
1946: procedure check_parameters is
1947: --
1948: begin
1949: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
1950: 'p_event_id',
1951: p_event_id);
1952: --
1953: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

Line 1953: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

1949: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
1950: 'p_event_id',
1951: p_event_id);
1952: --
1953: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
1954: 'p_event_type',
1955: p_event_type);
1956: end check_parameters;
1957: --

Line 2069: HR_API.MANDATORY_ARG_ERROR (

2065: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
2066: --
2067: -- Check parameters
2068: --
2069: HR_API.MANDATORY_ARG_ERROR (
2070: P_API_NAME => G_PACKAGE,
2071: P_ARGUMENT => 'P_EVENT_TYPE',
2072: P_ARGUMENT_VALUE => P_EVENT_TYPE);
2073: HR_API.MANDATORY_ARG_ERROR (

Line 2073: HR_API.MANDATORY_ARG_ERROR (

2069: HR_API.MANDATORY_ARG_ERROR (
2070: P_API_NAME => G_PACKAGE,
2071: P_ARGUMENT => 'P_EVENT_TYPE',
2072: P_ARGUMENT_VALUE => P_EVENT_TYPE);
2073: HR_API.MANDATORY_ARG_ERROR (
2074: P_API_NAME => G_PACKAGE,
2075: P_ARGUMENT => 'P_PARENT_EVENT_ID',
2076: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
2077: --

Line 2128: HR_API.MANDATORY_ARG_ERROR (

2124: HR_UTILITY.SET_LOCATION ('Entering:' || G_PACKAGE || 'VALID_PARENT_EVENT', 5);
2125: --
2126: -- Check parameters
2127: --
2128: HR_API.MANDATORY_ARG_ERROR (
2129: G_PACKAGE,
2130: 'P_BUSINESS_GROUP_ID',
2131: P_BUSINESS_GROUP_ID);
2132: --

Line 2133: HR_API.MANDATORY_ARG_ERROR (

2129: G_PACKAGE,
2130: 'P_BUSINESS_GROUP_ID',
2131: P_BUSINESS_GROUP_ID);
2132: --
2133: HR_API.MANDATORY_ARG_ERROR (
2134: G_PACKAGE,
2135: 'P_EVENT_TYPE',
2136: P_EVENT_TYPE);
2137: --

Line 2282: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

2278: procedure check_parameters is
2279: --
2280: begin
2281: --
2282: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2283: 'p_event_type',
2284: p_event_type);
2285: --
2286: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

Line 2286: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

2282: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2283: 'p_event_type',
2284: p_event_type);
2285: --
2286: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2287: 'p_event_id',
2288: p_event_id);
2289: --
2290: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

Line 2290: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

2286: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2287: 'p_event_id',
2288: p_event_id);
2289: --
2290: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2291: 'p_enrolment_start_date',
2292: p_enrolment_start_date);
2293: --
2294: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

Line 2294: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,

2290: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2291: 'p_enrolment_start_date',
2292: p_enrolment_start_date);
2293: --
2294: HR_API.MANDATORY_ARG_ERROR ( G_PACKAGE,
2295: 'p_enrolment_end_date',
2296: p_enrolment_end_date);
2297: --
2298: if (p_event_type = 'PROGRAMME' and p_parent_event_id is not null)

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

3150: hr_utility.set_location('Entering:'||l_proc, 5);
3151: --
3152:
3153: if (((p_event_id is not null) and
3154: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>
3155: nvl(p_owner_id,hr_api.g_number))
3156: or (p_event_id is null)) then
3157:
3158: IF p_owner_id is not null then

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

3151: --
3152:
3153: if (((p_event_id is not null) and
3154: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>
3155: nvl(p_owner_id,hr_api.g_number))
3156: or (p_event_id is null)) then
3157:
3158: IF p_owner_id is not null then
3159:

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

3213: Begin
3214: hr_utility.set_location('Entering:'||l_proc, 5);
3215:
3216: if (((p_event_id is not null) and
3217: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3218: nvl(p_line_id,hr_api.g_number))
3219: or (p_event_id is null)) then
3220: --
3221: hr_utility.set_location('Entering:'||l_proc, 10);

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

3214: hr_utility.set_location('Entering:'||l_proc, 5);
3215:
3216: if (((p_event_id is not null) and
3217: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3218: nvl(p_line_id,hr_api.g_number))
3219: or (p_event_id is null)) then
3220: --
3221: hr_utility.set_location('Entering:'||l_proc, 10);
3222: if (p_line_id is not null) then

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

3417:
3418: Begin
3419: hr_utility.set_location('Entering:'||l_proc, 5);
3420: if (((p_event_id is not null) and
3421: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3422: nvl(p_training_center_id,hr_api.g_number))
3423: or (p_event_id is null)) then
3424: --
3425: hr_utility.set_location('Entering:'||l_proc, 10);

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

3418: Begin
3419: hr_utility.set_location('Entering:'||l_proc, 5);
3420: if (((p_event_id is not null) and
3421: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3422: nvl(p_training_center_id,hr_api.g_number))
3423: or (p_event_id is null)) then
3424: --
3425: hr_utility.set_location('Entering:'||l_proc, 10);
3426: if (p_training_center_id is not null) then

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

3475: Begin
3476: hr_utility.set_location('Entering:'||l_proc, 5);
3477:
3478: if (((p_event_id is not null) and
3479: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3480: nvl(p_location_id,hr_api.g_number))
3481: or (p_event_id is null)) then
3482: --
3483: hr_utility.set_location('Entering:'||l_proc, 10);

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

3476: hr_utility.set_location('Entering:'||l_proc, 5);
3477:
3478: if (((p_event_id is not null) and
3479: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3480: nvl(p_location_id,hr_api.g_number))
3481: or (p_event_id is null)) then
3482: --
3483: hr_utility.set_location('Entering:'||l_proc, 10);
3484: if (p_location_id is not null) then

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

3535:
3536: hr_utility.set_location('Entering:'||l_proc, 5);
3537:
3538: if (((p_event_id is not null) and
3539: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3540: nvl(p_offering_id,hr_api.g_number))
3541: or (p_event_id is null)) then
3542: --
3543: hr_utility.set_location('Entering:'||l_proc, 10);

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

3536: hr_utility.set_location('Entering:'||l_proc, 5);
3537:
3538: if (((p_event_id is not null) and
3539: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3540: nvl(p_offering_id,hr_api.g_number))
3541: or (p_event_id is null)) then
3542: --
3543: hr_utility.set_location('Entering:'||l_proc, 10);
3544: if (p_offering_id is not null) then

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

3688: --modified for eBS by asud
3689: /*
3690: -- Call all supporting business operations
3691: --
3692: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
3693: --
3694: VALIDITY_CHECKS (
3695: P_REC => P_REC);
3696: --

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

3698: --*/
3699: --modified for eBS by asud
3700: -- Call all supporting business operations
3701: -- Validate Important Attributes
3702: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3703: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3704: --
3705: hr_multi_message.end_validation_set;
3706:

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

3737: --
3738: -- Call all supporting business operations
3739: --
3740: /*
3741: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
3742: --
3743: VALIDITY_CHECKS (
3744: P_REC => P_REC);
3745: --

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

3746: hr_utility.set_location(' Leaving:'||l_proc, 10);
3747: --
3748: */
3749: -- Validate Important Attributes
3750: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3751: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3752: --
3753: hr_multi_message.end_validation_set;
3754: