eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APL_BUS dependencies on PER_APL_SHD

Line 18: Procedure check_non_updateable_args(p_rec in per_apl_shd.g_rec_type)

14: --
15: -- ----------------------------------------------------------------------------
16: -- |--------------------< check_non_updateable_args >-------------------------|
17: -- ----------------------------------------------------------------------------
18: Procedure check_non_updateable_args(p_rec in per_apl_shd.g_rec_type)
19: is
20: --
21: l_proc varchar2(72) := g_package||'check_non_updateable_args';
22: --

Line 29: if not per_apl_shd.api_updating

25: --
26: -- Only proceed with validation if a row exists for
27: -- the current record in the HR Schema
28: --
29: if not per_apl_shd.api_updating
30: (p_application_id => p_rec.application_id
31: ,p_object_version_number => p_rec.object_version_number
32: ) then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 43: per_apl_shd.g_old_rec.business_group_id then

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'
47: ,p_base_table => per_apl_shd.g_tab_nam

Line 47: ,p_base_table => per_apl_shd.g_tab_nam

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: );
49: end if;
50: --
51: if nvl(p_rec.person_id, hr_api.g_number) <>

Line 52: per_apl_shd.g_old_rec.person_id then

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'
56: ,p_base_table => per_apl_shd.g_tab_nam

Line 56: ,p_base_table => per_apl_shd.g_tab_nam

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: );
58: end if;
59: hr_utility.set_location(' Leaving:'||l_proc, 14);
60: end check_non_updateable_args;

Line 93: (p_rec in per_apl_shd.g_rec_type) is

89: -- Access Status:
90: -- Internal Table Handler Use Only.
91: -- ---------------------------------------------------------------------------
92: procedure df_update_validate
93: (p_rec in per_apl_shd.g_rec_type) is
94: --
95: l_proc varchar2(72) := g_package||'df_update_validate';
96: --
97: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 201: Procedure insert_validate(p_rec in per_apl_shd.g_rec_type

197: --
198: -- ----------------------------------------------------------------------------
199: -- |---------------------------< insert_validate >----------------------------|
200: -- ----------------------------------------------------------------------------
201: Procedure insert_validate(p_rec in per_apl_shd.g_rec_type
202: ,p_effective_date in date
203: ,p_validate_df_flex in boolean default true) is -- 4689836
204: --
205: l_proc varchar2(72) := g_package||'insert_validate';

Line 214: ,p_associated_column1 => per_apl_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

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: --
217: --After validating the set of important attributes,
218: --if multiple message detection is enabled and atleast

Line 312: Procedure update_validate(p_rec in per_apl_shd.g_rec_type

308: --
309: -- ----------------------------------------------------------------------------
310: -- |---------------------------< update_validate >----------------------------|
311: -- ----------------------------------------------------------------------------
312: Procedure update_validate(p_rec in per_apl_shd.g_rec_type
313: ,p_effective_date in date) is
314: --
315: l_proc varchar2(72) := g_package||'update_validate';
316: --

Line 324: ,p_associated_column1 => per_apl_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

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: --
327: --After validating the set of important attributes,
328: --if multiple message detection is enabled and atleast

Line 390: Procedure delete_validate(p_rec in per_apl_shd.g_rec_type) is

386: --
387: -- ----------------------------------------------------------------------------
388: -- |---------------------------< delete_validate >----------------------------|
389: -- ----------------------------------------------------------------------------
390: Procedure delete_validate(p_rec in per_apl_shd.g_rec_type) is
391: --
392: l_proc varchar2(72) := g_package||'delete_validate';
393: --
394: Begin

Line 466: l_api_updating := per_apl_shd.api_updating

462: hr_utility.set_location(l_proc,11);
463: --
464: -- Check if application is being updated and load g_old_rec if applicable
465: --
466: l_api_updating := per_apl_shd.api_updating
467: (p_application_id => p_application_id
468: ,p_object_version_number => p_object_version_number);
469: --
470: -- Proceed with validation based on outcome of api_updating call

Line 475: per_apl_shd.g_old_rec.date_received <> p_date_received)

471: -- On update, only the date_received can change so no need to check
472: -- for person_id changes.
473: --
474: if ((l_api_updating and
475: per_apl_shd.g_old_rec.date_received <> p_date_received)
476: or (NOT l_api_updating)) then
477: --
478: hr_utility.set_location(l_proc,21);
479: --

Line 609: l_api_updating := per_apl_shd.api_updating

605: if (p_projected_hire_date is not null) then
606: --
607: -- Check if application is being updated and load g_old_rec if applicable
608: --
609: l_api_updating := per_apl_shd.api_updating
610: (p_application_id => p_application_id
611: ,p_object_version_number => p_object_version_number);
612: --
613: -- Proceed with validation based on outcome of api_updating call

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 690: l_api_updating := per_apl_shd.api_updating

686: hr_utility.set_location(l_proc,11);
687: --
688: -- Check if application is being updated and load g_old_rec if applicable
689: --
690: l_api_updating := per_apl_shd.api_updating
691: (p_application_id => p_application_id
692: ,p_object_version_number => p_object_version_number);
693: --
694: -- Proceed with validation based on outcome of api_updating call

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 718: if (per_apl_shd.g_old_rec.date_end is not null and

714: hr_utility.set_location(l_proc,31);
715: --
716: -- If change is from not-null to different not-null then raise error
717: --
718: if (per_apl_shd.g_old_rec.date_end is not null and
719: per_apl_shd.g_old_rec.date_end <> p_date_end) then
720: hr_utility.set_location('Inside:'||l_proc,35);
721: hr_utility.set_message(801,'HR_51234_APL_INVALID_UPDATE');
722: hr_multi_message.add

Line 719: per_apl_shd.g_old_rec.date_end <> p_date_end) then

715: --
716: -- If change is from not-null to different not-null then raise error
717: --
718: if (per_apl_shd.g_old_rec.date_end is not null and
719: per_apl_shd.g_old_rec.date_end <> p_date_end) then
720: hr_utility.set_location('Inside:'||l_proc,35);
721: hr_utility.set_message(801,'HR_51234_APL_INVALID_UPDATE');
722: hr_multi_message.add
723: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'

Line 806: l_api_updating := per_apl_shd.api_updating

802: --
803: --
804: -- Check if application is being updated and load g_old_rec if applicable
805: --
806: l_api_updating := per_apl_shd.api_updating
807: (p_application_id => p_application_id
808: ,p_object_version_number => p_object_version_number);
809: --
810: -- Proceed with validation based on outcome of api_updating call

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 875: l_api_updating := per_apl_shd.api_updating

871: if p_termination_reason is not null then
872: --
873: -- Check if application is being updated and load g_old_rec if applicable
874: --
875: l_api_updating := per_apl_shd.api_updating
876: (p_application_id => p_application_id
877: ,p_object_version_number => p_object_version_number);
878: --
879: -- Proceed with validation based on outcome of api_updating call

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: --