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.PQP_GAP_UPD dependencies on PQP_GAP_SHD

Line 55: (p_rec in out nocopy pqp_gap_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqp_gap_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 88: pqp_gap_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: pqp_gap_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --

Line 93: pqp_gap_shd.constraint_error

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pqp_gap_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --

Line 98: pqp_gap_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pqp_gap_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;

Line 138: (p_rec in pqp_gap_shd.g_rec_type

134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_update
138: (p_rec in pqp_gap_shd.g_rec_type
139: ) is
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --

Line 183: ,p_rec in pqp_gap_shd.g_rec_type

179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure post_update
182: (p_effective_date in date
183: ,p_rec in pqp_gap_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --

Line 207: => pqp_gap_shd.g_old_rec.assignment_id

203: => p_rec.last_gap_daily_absence_date
204: ,p_object_version_number
205: => p_rec.object_version_number
206: ,p_assignment_id_o
207: => pqp_gap_shd.g_old_rec.assignment_id
208: ,p_absence_attendance_id_o
209: => pqp_gap_shd.g_old_rec.absence_attendance_id
210: ,p_pl_id_o
211: => pqp_gap_shd.g_old_rec.pl_id

Line 209: => pqp_gap_shd.g_old_rec.absence_attendance_id

205: => p_rec.object_version_number
206: ,p_assignment_id_o
207: => pqp_gap_shd.g_old_rec.assignment_id
208: ,p_absence_attendance_id_o
209: => pqp_gap_shd.g_old_rec.absence_attendance_id
210: ,p_pl_id_o
211: => pqp_gap_shd.g_old_rec.pl_id
212: ,p_last_gap_daily_absence_dat_o
213: => pqp_gap_shd.g_old_rec.last_gap_daily_absence_date

Line 211: => pqp_gap_shd.g_old_rec.pl_id

207: => pqp_gap_shd.g_old_rec.assignment_id
208: ,p_absence_attendance_id_o
209: => pqp_gap_shd.g_old_rec.absence_attendance_id
210: ,p_pl_id_o
211: => pqp_gap_shd.g_old_rec.pl_id
212: ,p_last_gap_daily_absence_dat_o
213: => pqp_gap_shd.g_old_rec.last_gap_daily_absence_date
214: ,p_object_version_number_o
215: => pqp_gap_shd.g_old_rec.object_version_number

Line 213: => pqp_gap_shd.g_old_rec.last_gap_daily_absence_date

209: => pqp_gap_shd.g_old_rec.absence_attendance_id
210: ,p_pl_id_o
211: => pqp_gap_shd.g_old_rec.pl_id
212: ,p_last_gap_daily_absence_dat_o
213: => pqp_gap_shd.g_old_rec.last_gap_daily_absence_date
214: ,p_object_version_number_o
215: => pqp_gap_shd.g_old_rec.object_version_number
216: );
217: --

Line 215: => pqp_gap_shd.g_old_rec.object_version_number

211: => pqp_gap_shd.g_old_rec.pl_id
212: ,p_last_gap_daily_absence_dat_o
213: => pqp_gap_shd.g_old_rec.last_gap_daily_absence_date
214: ,p_object_version_number_o
215: => pqp_gap_shd.g_old_rec.object_version_number
216: );
217: --
218: exception
219: --

Line 275: (p_rec in out nocopy pqp_gap_shd.g_rec_type

271: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure convert_defs
275: (p_rec in out nocopy pqp_gap_shd.g_rec_type
276: ) is
277: --
278: Begin
279: --

Line 287: pqp_gap_shd.g_old_rec.assignment_id;

283: -- is being used then we must set to the 'current' argument value.
284: --
285: If (p_rec.assignment_id = hr_api.g_number) then
286: p_rec.assignment_id :=
287: pqp_gap_shd.g_old_rec.assignment_id;
288: End If;
289: If (p_rec.absence_attendance_id = hr_api.g_number) then
290: p_rec.absence_attendance_id :=
291: pqp_gap_shd.g_old_rec.absence_attendance_id;

Line 291: pqp_gap_shd.g_old_rec.absence_attendance_id;

287: pqp_gap_shd.g_old_rec.assignment_id;
288: End If;
289: If (p_rec.absence_attendance_id = hr_api.g_number) then
290: p_rec.absence_attendance_id :=
291: pqp_gap_shd.g_old_rec.absence_attendance_id;
292: End If;
293: If (p_rec.pl_id = hr_api.g_number) then
294: p_rec.pl_id :=
295: pqp_gap_shd.g_old_rec.pl_id;

Line 295: pqp_gap_shd.g_old_rec.pl_id;

291: pqp_gap_shd.g_old_rec.absence_attendance_id;
292: End If;
293: If (p_rec.pl_id = hr_api.g_number) then
294: p_rec.pl_id :=
295: pqp_gap_shd.g_old_rec.pl_id;
296: End If;
297: If (p_rec.last_gap_daily_absence_date = hr_api.g_date) then
298: p_rec.last_gap_daily_absence_date :=
299: pqp_gap_shd.g_old_rec.last_gap_daily_absence_date;

Line 299: pqp_gap_shd.g_old_rec.last_gap_daily_absence_date;

295: pqp_gap_shd.g_old_rec.pl_id;
296: End If;
297: If (p_rec.last_gap_daily_absence_date = hr_api.g_date) then
298: p_rec.last_gap_daily_absence_date :=
299: pqp_gap_shd.g_old_rec.last_gap_daily_absence_date;
300: End If;
301: --
302: End convert_defs;
303: --

Line 309: ,p_rec in out nocopy pqp_gap_shd.g_rec_type

305: -- |---------------------------------< upd >----------------------------------|
306: -- ----------------------------------------------------------------------------
307: Procedure upd
308: (p_effective_date in date
309: ,p_rec in out nocopy pqp_gap_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'upd';
313: --

Line 319: pqp_gap_shd.lck

315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: -- We must lock the row which we need to update.
318: --
319: pqp_gap_shd.lck
320: (p_rec.gap_absence_plan_id
321: ,p_rec.object_version_number
322: );
323: --

Line 371: l_rec pqp_gap_shd.g_rec_type;

367: ,p_pl_id in number default hr_api.g_number
368: ,p_last_gap_daily_absence_date in date default hr_api.g_date
369: ) is
370: --
371: l_rec pqp_gap_shd.g_rec_type;
372: l_proc varchar2(72) := g_package||'upd';
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);

Line 381: pqp_gap_shd.convert_args

377: -- Call conversion function to turn arguments into the
378: -- l_rec structure.
379: --
380: l_rec :=
381: pqp_gap_shd.convert_args
382: (p_gap_absence_plan_id
383: ,p_assignment_id
384: ,p_absence_attendance_id
385: ,p_pl_id