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_GDA_UPD dependencies on PQP_GDA_SHD

Line 55: (p_rec in out nocopy pqp_gda_shd.g_rec_type

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

Line 93: pqp_gda_shd.constraint_error

89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: pqp_gda_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --

Line 98: pqp_gda_shd.constraint_error

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

Line 103: pqp_gda_shd.constraint_error

99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: pqp_gda_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;

Line 143: (p_rec in pqp_gda_shd.g_rec_type

139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure pre_update
143: (p_rec in pqp_gda_shd.g_rec_type
144: ) is
145: --
146: l_proc varchar2(72) := g_package||'pre_update';
147: --

Line 188: ,p_rec in pqp_gda_shd.g_rec_type

184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure post_update
187: (p_effective_date in date
188: ,p_rec in pqp_gda_shd.g_rec_type
189: ) is
190: --
191: l_proc varchar2(72) := g_package||'post_update';
192: --

Line 222: => pqp_gda_shd.g_old_rec.gap_absence_plan_id

218: => p_rec.fte -- LG
219: ,p_object_version_number
220: => p_rec.object_version_number
221: ,p_gap_absence_plan_id_o
222: => pqp_gda_shd.g_old_rec.gap_absence_plan_id
223: ,p_absence_date_o
224: => pqp_gda_shd.g_old_rec.absence_date
225: ,p_work_pattern_day_type_o
226: => pqp_gda_shd.g_old_rec.work_pattern_day_type

Line 224: => pqp_gda_shd.g_old_rec.absence_date

220: => p_rec.object_version_number
221: ,p_gap_absence_plan_id_o
222: => pqp_gda_shd.g_old_rec.gap_absence_plan_id
223: ,p_absence_date_o
224: => pqp_gda_shd.g_old_rec.absence_date
225: ,p_work_pattern_day_type_o
226: => pqp_gda_shd.g_old_rec.work_pattern_day_type
227: ,p_level_of_entitlement_o
228: => pqp_gda_shd.g_old_rec.level_of_entitlement

Line 226: => pqp_gda_shd.g_old_rec.work_pattern_day_type

222: => pqp_gda_shd.g_old_rec.gap_absence_plan_id
223: ,p_absence_date_o
224: => pqp_gda_shd.g_old_rec.absence_date
225: ,p_work_pattern_day_type_o
226: => pqp_gda_shd.g_old_rec.work_pattern_day_type
227: ,p_level_of_entitlement_o
228: => pqp_gda_shd.g_old_rec.level_of_entitlement
229: ,p_level_of_pay_o
230: => pqp_gda_shd.g_old_rec.level_of_pay

Line 228: => pqp_gda_shd.g_old_rec.level_of_entitlement

224: => pqp_gda_shd.g_old_rec.absence_date
225: ,p_work_pattern_day_type_o
226: => pqp_gda_shd.g_old_rec.work_pattern_day_type
227: ,p_level_of_entitlement_o
228: => pqp_gda_shd.g_old_rec.level_of_entitlement
229: ,p_level_of_pay_o
230: => pqp_gda_shd.g_old_rec.level_of_pay
231: ,p_duration_o
232: => pqp_gda_shd.g_old_rec.duration

Line 230: => pqp_gda_shd.g_old_rec.level_of_pay

226: => pqp_gda_shd.g_old_rec.work_pattern_day_type
227: ,p_level_of_entitlement_o
228: => pqp_gda_shd.g_old_rec.level_of_entitlement
229: ,p_level_of_pay_o
230: => pqp_gda_shd.g_old_rec.level_of_pay
231: ,p_duration_o
232: => pqp_gda_shd.g_old_rec.duration
233: ,p_duration_in_hours_o
234: => pqp_gda_shd.g_old_rec.duration_in_hours

Line 232: => pqp_gda_shd.g_old_rec.duration

228: => pqp_gda_shd.g_old_rec.level_of_entitlement
229: ,p_level_of_pay_o
230: => pqp_gda_shd.g_old_rec.level_of_pay
231: ,p_duration_o
232: => pqp_gda_shd.g_old_rec.duration
233: ,p_duration_in_hours_o
234: => pqp_gda_shd.g_old_rec.duration_in_hours
235: ,p_working_days_per_week_o
236: => pqp_gda_shd.g_old_rec.working_days_per_week

Line 234: => pqp_gda_shd.g_old_rec.duration_in_hours

230: => pqp_gda_shd.g_old_rec.level_of_pay
231: ,p_duration_o
232: => pqp_gda_shd.g_old_rec.duration
233: ,p_duration_in_hours_o
234: => pqp_gda_shd.g_old_rec.duration_in_hours
235: ,p_working_days_per_week_o
236: => pqp_gda_shd.g_old_rec.working_days_per_week
237: ,p_fte_o -- LG
238: => pqp_gda_shd.g_old_rec.fte -- LG

Line 236: => pqp_gda_shd.g_old_rec.working_days_per_week

232: => pqp_gda_shd.g_old_rec.duration
233: ,p_duration_in_hours_o
234: => pqp_gda_shd.g_old_rec.duration_in_hours
235: ,p_working_days_per_week_o
236: => pqp_gda_shd.g_old_rec.working_days_per_week
237: ,p_fte_o -- LG
238: => pqp_gda_shd.g_old_rec.fte -- LG
239: ,p_object_version_number_o
240: => pqp_gda_shd.g_old_rec.object_version_number

Line 238: => pqp_gda_shd.g_old_rec.fte -- LG

234: => pqp_gda_shd.g_old_rec.duration_in_hours
235: ,p_working_days_per_week_o
236: => pqp_gda_shd.g_old_rec.working_days_per_week
237: ,p_fte_o -- LG
238: => pqp_gda_shd.g_old_rec.fte -- LG
239: ,p_object_version_number_o
240: => pqp_gda_shd.g_old_rec.object_version_number
241: );
242: --

Line 240: => pqp_gda_shd.g_old_rec.object_version_number

236: => pqp_gda_shd.g_old_rec.working_days_per_week
237: ,p_fte_o -- LG
238: => pqp_gda_shd.g_old_rec.fte -- LG
239: ,p_object_version_number_o
240: => pqp_gda_shd.g_old_rec.object_version_number
241: );
242: --
243: exception
244: --

Line 300: (p_rec in out nocopy pqp_gda_shd.g_rec_type

296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure convert_defs
300: (p_rec in out nocopy pqp_gda_shd.g_rec_type
301: ) is
302: --
303: Begin
304: --

Line 312: pqp_gda_shd.g_old_rec.gap_absence_plan_id;

308: -- is being used then we must set to the 'current' argument value.
309: --
310: If (p_rec.gap_absence_plan_id = hr_api.g_number) then
311: p_rec.gap_absence_plan_id :=
312: pqp_gda_shd.g_old_rec.gap_absence_plan_id;
313: End If;
314: If (p_rec.absence_date = hr_api.g_date) then
315: p_rec.absence_date :=
316: pqp_gda_shd.g_old_rec.absence_date;

Line 316: pqp_gda_shd.g_old_rec.absence_date;

312: pqp_gda_shd.g_old_rec.gap_absence_plan_id;
313: End If;
314: If (p_rec.absence_date = hr_api.g_date) then
315: p_rec.absence_date :=
316: pqp_gda_shd.g_old_rec.absence_date;
317: End If;
318: If (p_rec.work_pattern_day_type = hr_api.g_varchar2) then
319: p_rec.work_pattern_day_type :=
320: pqp_gda_shd.g_old_rec.work_pattern_day_type;

Line 320: pqp_gda_shd.g_old_rec.work_pattern_day_type;

316: pqp_gda_shd.g_old_rec.absence_date;
317: End If;
318: If (p_rec.work_pattern_day_type = hr_api.g_varchar2) then
319: p_rec.work_pattern_day_type :=
320: pqp_gda_shd.g_old_rec.work_pattern_day_type;
321: End If;
322: If (p_rec.level_of_entitlement = hr_api.g_varchar2) then
323: p_rec.level_of_entitlement :=
324: pqp_gda_shd.g_old_rec.level_of_entitlement;

Line 324: pqp_gda_shd.g_old_rec.level_of_entitlement;

320: pqp_gda_shd.g_old_rec.work_pattern_day_type;
321: End If;
322: If (p_rec.level_of_entitlement = hr_api.g_varchar2) then
323: p_rec.level_of_entitlement :=
324: pqp_gda_shd.g_old_rec.level_of_entitlement;
325: End If;
326: If (p_rec.level_of_pay = hr_api.g_varchar2) then
327: p_rec.level_of_pay :=
328: pqp_gda_shd.g_old_rec.level_of_pay;

Line 328: pqp_gda_shd.g_old_rec.level_of_pay;

324: pqp_gda_shd.g_old_rec.level_of_entitlement;
325: End If;
326: If (p_rec.level_of_pay = hr_api.g_varchar2) then
327: p_rec.level_of_pay :=
328: pqp_gda_shd.g_old_rec.level_of_pay;
329: End If;
330: If (p_rec.duration = hr_api.g_number) then
331: p_rec.duration :=
332: pqp_gda_shd.g_old_rec.duration;

Line 332: pqp_gda_shd.g_old_rec.duration;

328: pqp_gda_shd.g_old_rec.level_of_pay;
329: End If;
330: If (p_rec.duration = hr_api.g_number) then
331: p_rec.duration :=
332: pqp_gda_shd.g_old_rec.duration;
333: End If;
334: If (p_rec.duration_in_hours = hr_api.g_number) then
335: p_rec.duration_in_hours :=
336: pqp_gda_shd.g_old_rec.duration_in_hours;

Line 336: pqp_gda_shd.g_old_rec.duration_in_hours;

332: pqp_gda_shd.g_old_rec.duration;
333: End If;
334: If (p_rec.duration_in_hours = hr_api.g_number) then
335: p_rec.duration_in_hours :=
336: pqp_gda_shd.g_old_rec.duration_in_hours;
337: End If;
338: If (p_rec.working_days_per_week = hr_api.g_number) then
339: p_rec.working_days_per_week :=
340: pqp_gda_shd.g_old_rec.working_days_per_week;

Line 340: pqp_gda_shd.g_old_rec.working_days_per_week;

336: pqp_gda_shd.g_old_rec.duration_in_hours;
337: End If;
338: If (p_rec.working_days_per_week = hr_api.g_number) then
339: p_rec.working_days_per_week :=
340: pqp_gda_shd.g_old_rec.working_days_per_week;
341: End If;
342: -- LG added below if block
343: If (p_rec.fte = hr_api.g_number) then
344: p_rec.fte :=

Line 345: pqp_gda_shd.g_old_rec.fte;

341: End If;
342: -- LG added below if block
343: If (p_rec.fte = hr_api.g_number) then
344: p_rec.fte :=
345: pqp_gda_shd.g_old_rec.fte;
346: End If;
347: --
348: End convert_defs;
349: --

Line 355: ,p_rec in out nocopy pqp_gda_shd.g_rec_type

351: -- |---------------------------------< upd >----------------------------------|
352: -- ----------------------------------------------------------------------------
353: Procedure upd
354: (p_effective_date in date
355: ,p_rec in out nocopy pqp_gda_shd.g_rec_type
356: ) is
357: --
358: l_proc varchar2(72) := g_package||'upd';
359: --

Line 365: pqp_gda_shd.lck

361: hr_utility.set_location('Entering:'||l_proc, 5);
362: --
363: -- We must lock the row which we need to update.
364: --
365: pqp_gda_shd.lck
366: (p_rec.gap_daily_absence_id
367: ,p_rec.object_version_number
368: );
369: --

Line 422: l_rec pqp_gda_shd.g_rec_type;

418: ,p_working_days_per_week in number default hr_api.g_number
419: ,p_fte in number default hr_api.g_number -- LG
420: ) is
421: --
422: l_rec pqp_gda_shd.g_rec_type;
423: l_proc varchar2(72) := g_package||'upd';
424: --
425: Begin
426: hr_utility.set_location('Entering:'||l_proc, 5);

Line 432: pqp_gda_shd.convert_args

428: -- Call conversion function to turn arguments into the
429: -- l_rec structure.
430: --
431: l_rec :=
432: pqp_gda_shd.convert_args
433: (p_gap_daily_absence_id
434: ,p_gap_absence_plan_id
435: ,p_absence_date
436: ,p_work_pattern_day_type