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 709: nvl(per_apl_shd.g_old_rec.date_end,hr_api.g_date) <>

705: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
706: );
707: --
708: elsif (l_api_updating and
709: nvl(per_apl_shd.g_old_rec.date_end,hr_api.g_date) <>
710: p_date_end) then
711: --
712: -- Date end changed to a not null value so do validation
713: --

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

809: --
810: -- Proceed with validation based on outcome of api_updating call
811: --
812: if ((l_api_updating and
813: nvl(per_apl_shd.g_old_rec.successful_flag,hr_api.g_date) <>
814: nvl(p_successful_flag,hr_api.g_varchar2))
815: or
816: NOT l_api_updating) then
817: --

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

810: -- Proceed with validation based on outcome of api_updating call
811: --
812: if ((l_api_updating and
813: nvl(per_apl_shd.g_old_rec.successful_flag,hr_api.g_date) <>
814: nvl(p_successful_flag,hr_api.g_varchar2))
815: or
816: NOT l_api_updating) then
817: --
818: hr_utility.set_location('Inside:'||l_proc,11);

Line 863: hr_api.mandatory_arg_error

859: hr_utility.set_location('Entering:'||l_proc,1);
860: --
861: -- Check mandatory parameters have been set
862: --
863: hr_api.mandatory_arg_error
864: (p_api_name => l_proc
865: ,p_argument => 'effective_date'
866: ,p_argument_value => p_effective_date
867: );

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

878: --
879: -- Proceed with validation based on outcome of api_updating call
880: --
881: if ((l_api_updating and
882: nvl(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2) <>
883: nvl(p_termination_reason,hr_api.g_varchar2))
884: or
885: NOT l_api_updating) then
886: --

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

879: -- Proceed with validation based on outcome of api_updating call
880: --
881: if ((l_api_updating and
882: nvl(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2) <>
883: nvl(p_termination_reason,hr_api.g_varchar2))
884: or
885: NOT l_api_updating) then
886: --
887: hr_utility.set_location('Inside:'||l_proc,11);

Line 891: if hr_api.not_exists_in_hr_lookups

887: hr_utility.set_location('Inside:'||l_proc,11);
888: --
889: -- Check that termination reason is in the lookups table
890: --
891: if hr_api.not_exists_in_hr_lookups
892: (p_effective_date => p_effective_date
893: ,p_lookup_type => 'TERM_APL_REASON'
894: ,p_lookup_code => p_termination_reason
895: )then

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

940: hr_utility.set_location('Entering:'|| l_proc, 10);
941: --
942: -- Ensure that all the mandatory parameter are not null
943: --
944: hr_api.mandatory_arg_error(p_api_name => l_proc,
945: p_argument => 'application_id',
946: p_argument_value => p_application_id);
947: --
948: open csr_leg_code;