APPS.PER_APL_BUS dependencies on HR_API

Line 42: if nvl(p_rec.business_group_id, hr_api.g_number) <>

38: --
39: hr_utility.set_location(l_proc, 6);
40: --
41: --
42: if nvl(p_rec.business_group_id, hr_api.g_number) <>
43: per_apl_shd.g_old_rec.business_group_id then
44: hr_api.argument_changed_error
45: (p_api_name => l_proc
46: ,p_argument => 'BUSINESS_GROUP_ID'

Line 44: hr_api.argument_changed_error

40: --
41: --
42: if nvl(p_rec.business_group_id, hr_api.g_number) <>
43: per_apl_shd.g_old_rec.business_group_id then
44: hr_api.argument_changed_error
45: (p_api_name => l_proc
46: ,p_argument => 'BUSINESS_GROUP_ID'
47: ,p_base_table => per_apl_shd.g_tab_nam
48: );

Line 51: if nvl(p_rec.person_id, hr_api.g_number) <>

47: ,p_base_table => per_apl_shd.g_tab_nam
48: );
49: end if;
50: --
51: if nvl(p_rec.person_id, hr_api.g_number) <>
52: per_apl_shd.g_old_rec.person_id then
53: hr_api.argument_changed_error
54: (p_api_name => l_proc
55: ,p_argument => 'PERSON_ID'

Line 53: hr_api.argument_changed_error

49: end if;
50: --
51: if nvl(p_rec.person_id, hr_api.g_number) <>
52: per_apl_shd.g_old_rec.person_id then
53: hr_api.argument_changed_error
54: (p_api_name => l_proc
55: ,p_argument => 'PERSON_ID'
56: ,p_base_table => per_apl_shd.g_tab_nam
57: );

Line 100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>

96: --
97: begin
98: hr_utility.set_location('Entering:'||l_proc, 10);
99: --
100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>
101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>

Line 101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or

97: begin
98: hr_utility.set_location('Entering:'||l_proc, 10);
99: --
100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>
101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or

Line 102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>

98: hr_utility.set_location('Entering:'||l_proc, 10);
99: --
100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>
101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>

Line 103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or

99: --
100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>
101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or

Line 104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>

100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>
101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>

Line 105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or

101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or

Line 106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>

102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>

Line 107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or

103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or

Line 108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>

104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>

Line 109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or

105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or

Line 110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>

106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>

Line 111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or

107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or

Line 112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>

108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>

Line 113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or

109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or

Line 114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>

110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>

Line 115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or

111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or

Line 116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>

112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>

Line 117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or

113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or

Line 118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>

114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>

Line 119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or

115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or

Line 120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>

116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>

Line 121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or

117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or

Line 122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>

118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>

Line 123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or

119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or

Line 124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>

120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>

Line 125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or

121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or

Line 126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>

122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>

Line 127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or

123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or

Line 128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>

124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>

Line 129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or

125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or

Line 130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>

126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>

Line 131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or

127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or

Line 132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>

128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>

Line 133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or

129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or

Line 134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>

130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>

Line 135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or

131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or

Line 136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>

132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>

Line 137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or

133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>
141: nvl(p_rec.appl_attribute20, hr_api.g_varchar2)

Line 138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>

134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>
141: nvl(p_rec.appl_attribute20, hr_api.g_varchar2)
142: then

Line 139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or

135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>
141: nvl(p_rec.appl_attribute20, hr_api.g_varchar2)
142: then
143: -- either the attribute_category or attribute1..30 have changed

Line 140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>

136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>
141: nvl(p_rec.appl_attribute20, hr_api.g_varchar2)
142: then
143: -- either the attribute_category or attribute1..30 have changed
144: -- so we must call the DFF validation routine

Line 141: nvl(p_rec.appl_attribute20, hr_api.g_varchar2)

137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>
141: nvl(p_rec.appl_attribute20, hr_api.g_varchar2)
142: then
143: -- either the attribute_category or attribute1..30 have changed
144: -- so we must call the DFF validation routine
145: --

Line 212: hr_api.validate_bus_grp_id

208: hr_utility.set_location('Entering:'||l_proc, 5);
209: --
210: -- Validate Important Attributes
211: --
212: hr_api.validate_bus_grp_id
213: (p_business_group_id => p_rec.business_group_id
214: ,p_associated_column1 => per_apl_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
215: ); -- Validate Bus Grp
216: --

Line 322: hr_api.validate_bus_grp_id

318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- Validate Important Attributes
321: --
322: hr_api.validate_bus_grp_id
323: (p_business_group_id => p_rec.business_group_id
324: ,p_associated_column1 => per_apl_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
325: ); -- Validate Bus Grp
326: --

Line 448: hr_api.mandatory_arg_error

444: hr_utility.set_location('Entering:'||l_proc,1);
445: --
446: -- Perform mandatory parameter checks
447: --
448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc
450: ,p_argument => 'date_received'
451: ,p_argument_value => p_date_received
452: );

Line 456: hr_api.mandatory_arg_error

452: );
453: --
454: -- Perform person_id mandatory check
455: --
456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc
458: ,p_argument => 'person_id'
459: ,p_argument_value => p_person_id
460: );

Line 535: if (p_date_received > nvl(p_date_end,hr_api.g_eot)) then

531: hr_utility.set_location(l_proc,61);
532: --
533: -- Validate date received with respect to DATE_END
534: --
535: if (p_date_received > nvl(p_date_end,hr_api.g_eot)) then
536: hr_utility.set_message(801,'HR_51188_APL_DTE_REC_DTE_END');
537: hr_multi_message.add
538: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
539: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'

Line 547: if (p_date_received > nvl(p_projected_hire_date,hr_api.g_eot)) then

543: hr_utility.set_location(l_proc,71);
544: --
545: -- Validate date received with respect to PROJECTED HIRE DATE
546: --
547: if (p_date_received > nvl(p_projected_hire_date,hr_api.g_eot)) then
548: hr_utility.set_message(801,'HR_51189_APL_DTE_REC_PROJ_HIRE');
549: hr_multi_message.add
550: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
551: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'

Line 616: nvl(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date) <>

612: --
613: -- Proceed with validation based on outcome of api_updating call
614: --
615: if ((l_api_updating and
616: nvl(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date) <>
617: nvl(p_projected_hire_date,hr_api.g_date))
618: or
619: NOT l_api_updating) then
620: --

Line 617: nvl(p_projected_hire_date,hr_api.g_date))

613: -- Proceed with validation based on outcome of api_updating call
614: --
615: if ((l_api_updating and
616: nvl(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date) <>
617: nvl(p_projected_hire_date,hr_api.g_date))
618: or
619: NOT l_api_updating) then
620: --
621: hr_utility.set_location('Inside:'||l_proc,11);

Line 703: nvl(per_apl_shd.g_old_rec.date_end,hr_api.g_date) <>

699: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
700: );
701: --
702: elsif (l_api_updating and
703: nvl(per_apl_shd.g_old_rec.date_end,hr_api.g_date) <>
704: p_date_end) then
705: --
706: -- Date end changed to a not null value so do validation
707: --

Line 806: nvl(per_apl_shd.g_old_rec.successful_flag,hr_api.g_date) <>

802: --
803: -- Proceed with validation based on outcome of api_updating call
804: --
805: if ((l_api_updating and
806: nvl(per_apl_shd.g_old_rec.successful_flag,hr_api.g_date) <>
807: nvl(p_successful_flag,hr_api.g_varchar2))
808: or
809: NOT l_api_updating) then
810: --

Line 807: nvl(p_successful_flag,hr_api.g_varchar2))

803: -- Proceed with validation based on outcome of api_updating call
804: --
805: if ((l_api_updating and
806: nvl(per_apl_shd.g_old_rec.successful_flag,hr_api.g_date) <>
807: nvl(p_successful_flag,hr_api.g_varchar2))
808: or
809: NOT l_api_updating) then
810: --
811: hr_utility.set_location('Inside:'||l_proc,11);

Line 856: hr_api.mandatory_arg_error

852: hr_utility.set_location('Entering:'||l_proc,1);
853: --
854: -- Check mandatory parameters have been set
855: --
856: hr_api.mandatory_arg_error
857: (p_api_name => l_proc
858: ,p_argument => 'effective_date'
859: ,p_argument_value => p_effective_date
860: );

Line 875: nvl(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2) <>

871: --
872: -- Proceed with validation based on outcome of api_updating call
873: --
874: if ((l_api_updating and
875: nvl(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2) <>
876: nvl(p_termination_reason,hr_api.g_varchar2))
877: or
878: NOT l_api_updating) then
879: --

Line 876: nvl(p_termination_reason,hr_api.g_varchar2))

872: -- Proceed with validation based on outcome of api_updating call
873: --
874: if ((l_api_updating and
875: nvl(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2) <>
876: nvl(p_termination_reason,hr_api.g_varchar2))
877: or
878: NOT l_api_updating) then
879: --
880: hr_utility.set_location('Inside:'||l_proc,11);

Line 884: if hr_api.not_exists_in_hr_lookups

880: hr_utility.set_location('Inside:'||l_proc,11);
881: --
882: -- Check that termination reason is in the lookups table
883: --
884: if hr_api.not_exists_in_hr_lookups
885: (p_effective_date => p_effective_date
886: ,p_lookup_type => 'TERM_APL_REASON'
887: ,p_lookup_code => p_termination_reason
888: )then

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

933: hr_utility.set_location('Entering:'|| l_proc, 10);
934: --
935: -- Ensure that all the mandatory parameter are not null
936: --
937: hr_api.mandatory_arg_error(p_api_name => l_proc,
938: p_argument => 'application_id',
939: p_argument_value => p_application_id);
940: --
941: open csr_leg_code;