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_CTL_DEL dependencies on OTA_CTL_SHD

Line 52: (p_rec in ota_ctl_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ota_ctl_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 76: ota_ctl_shd.constraint_error

72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: ota_ctl_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;

Line 115: Procedure pre_delete(p_rec in ota_ctl_shd.g_rec_type) is

111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in ota_ctl_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin

Line 157: Procedure post_delete(p_rec in ota_ctl_shd.g_rec_type) is

153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_rec in ota_ctl_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin

Line 171: => ota_ctl_shd.g_old_rec.name

167: => p_rec.certification_id
168: ,p_language
169: => p_rec.language
170: ,p_name_o
171: => ota_ctl_shd.g_old_rec.name
172: ,p_description_o
173: => ota_ctl_shd.g_old_rec.description
174: ,p_objectives_o
175: => ota_ctl_shd.g_old_rec.objectives

Line 173: => ota_ctl_shd.g_old_rec.description

169: => p_rec.language
170: ,p_name_o
171: => ota_ctl_shd.g_old_rec.name
172: ,p_description_o
173: => ota_ctl_shd.g_old_rec.description
174: ,p_objectives_o
175: => ota_ctl_shd.g_old_rec.objectives
176: ,p_purpose_o
177: => ota_ctl_shd.g_old_rec.purpose

Line 175: => ota_ctl_shd.g_old_rec.objectives

171: => ota_ctl_shd.g_old_rec.name
172: ,p_description_o
173: => ota_ctl_shd.g_old_rec.description
174: ,p_objectives_o
175: => ota_ctl_shd.g_old_rec.objectives
176: ,p_purpose_o
177: => ota_ctl_shd.g_old_rec.purpose
178: ,p_keywords_o
179: => ota_ctl_shd.g_old_rec.keywords

Line 177: => ota_ctl_shd.g_old_rec.purpose

173: => ota_ctl_shd.g_old_rec.description
174: ,p_objectives_o
175: => ota_ctl_shd.g_old_rec.objectives
176: ,p_purpose_o
177: => ota_ctl_shd.g_old_rec.purpose
178: ,p_keywords_o
179: => ota_ctl_shd.g_old_rec.keywords
180: ,p_end_date_comments_o
181: => ota_ctl_shd.g_old_rec.end_date_comments

Line 179: => ota_ctl_shd.g_old_rec.keywords

175: => ota_ctl_shd.g_old_rec.objectives
176: ,p_purpose_o
177: => ota_ctl_shd.g_old_rec.purpose
178: ,p_keywords_o
179: => ota_ctl_shd.g_old_rec.keywords
180: ,p_end_date_comments_o
181: => ota_ctl_shd.g_old_rec.end_date_comments
182: ,p_initial_period_comments_o
183: => ota_ctl_shd.g_old_rec.initial_period_comments

Line 181: => ota_ctl_shd.g_old_rec.end_date_comments

177: => ota_ctl_shd.g_old_rec.purpose
178: ,p_keywords_o
179: => ota_ctl_shd.g_old_rec.keywords
180: ,p_end_date_comments_o
181: => ota_ctl_shd.g_old_rec.end_date_comments
182: ,p_initial_period_comments_o
183: => ota_ctl_shd.g_old_rec.initial_period_comments
184: ,p_renewal_period_comments_o
185: => ota_ctl_shd.g_old_rec.renewal_period_comments

Line 183: => ota_ctl_shd.g_old_rec.initial_period_comments

179: => ota_ctl_shd.g_old_rec.keywords
180: ,p_end_date_comments_o
181: => ota_ctl_shd.g_old_rec.end_date_comments
182: ,p_initial_period_comments_o
183: => ota_ctl_shd.g_old_rec.initial_period_comments
184: ,p_renewal_period_comments_o
185: => ota_ctl_shd.g_old_rec.renewal_period_comments
186: ,p_source_lang_o
187: => ota_ctl_shd.g_old_rec.source_lang

Line 185: => ota_ctl_shd.g_old_rec.renewal_period_comments

181: => ota_ctl_shd.g_old_rec.end_date_comments
182: ,p_initial_period_comments_o
183: => ota_ctl_shd.g_old_rec.initial_period_comments
184: ,p_renewal_period_comments_o
185: => ota_ctl_shd.g_old_rec.renewal_period_comments
186: ,p_source_lang_o
187: => ota_ctl_shd.g_old_rec.source_lang
188: );
189: --

Line 187: => ota_ctl_shd.g_old_rec.source_lang

183: => ota_ctl_shd.g_old_rec.initial_period_comments
184: ,p_renewal_period_comments_o
185: => ota_ctl_shd.g_old_rec.renewal_period_comments
186: ,p_source_lang_o
187: => ota_ctl_shd.g_old_rec.source_lang
188: );
189: --
190: exception
191: --

Line 207: (p_rec in ota_ctl_shd.g_rec_type

203: -- ----------------------------------------------------------------------------
204: -- |---------------------------------< del >----------------------------------|
205: -- ----------------------------------------------------------------------------
206: Procedure del
207: (p_rec in ota_ctl_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) := g_package||'del';
211: --

Line 217: ota_ctl_shd.lck

213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- We must lock the row which we need to delete.
216: --
217: ota_ctl_shd.lck
218: (p_rec.certification_id
219: ,p_rec.language
220: );
221: --

Line 254: l_rec ota_ctl_shd.g_rec_type;

250: (p_certification_id in number
251: ,p_language in varchar2
252: ) is
253: --
254: l_rec ota_ctl_shd.g_rec_type;
255: l_proc varchar2(72) := g_package||'del';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);