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_GDS_DEL dependencies on PQP_GDS_SHD

Line 52: (p_rec in pqp_gds_shd.g_rec_type

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

Line 60: pqp_gds_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: pqp_gds_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pqp_gap_duration_summary row.
63: --
64: delete from pqp_gap_duration_summary

Line 67: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from pqp_gap_duration_summary
65: where gap_duration_summary_id = p_rec.gap_duration_summary_id;
66: --
67: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
75: pqp_gds_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status

Line 75: pqp_gds_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
75: pqp_gds_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;

Line 78: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status

74: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
75: pqp_gds_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in pqp_gds_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in pqp_gds_shd.g_rec_type) is

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

Line 168: => pqp_gds_shd.g_old_rec.assignment_id

164: pqp_gds_rkd.after_delete
165: (p_gap_duration_summary_id
166: => p_rec.gap_duration_summary_id
167: ,p_assignment_id_o
168: => pqp_gds_shd.g_old_rec.assignment_id
169: ,p_gap_absence_plan_id_o
170: => pqp_gds_shd.g_old_rec.gap_absence_plan_id
171: ,p_summary_type_o
172: => pqp_gds_shd.g_old_rec.summary_type

Line 170: => pqp_gds_shd.g_old_rec.gap_absence_plan_id

166: => p_rec.gap_duration_summary_id
167: ,p_assignment_id_o
168: => pqp_gds_shd.g_old_rec.assignment_id
169: ,p_gap_absence_plan_id_o
170: => pqp_gds_shd.g_old_rec.gap_absence_plan_id
171: ,p_summary_type_o
172: => pqp_gds_shd.g_old_rec.summary_type
173: ,p_gap_level_o
174: => pqp_gds_shd.g_old_rec.gap_level

Line 172: => pqp_gds_shd.g_old_rec.summary_type

168: => pqp_gds_shd.g_old_rec.assignment_id
169: ,p_gap_absence_plan_id_o
170: => pqp_gds_shd.g_old_rec.gap_absence_plan_id
171: ,p_summary_type_o
172: => pqp_gds_shd.g_old_rec.summary_type
173: ,p_gap_level_o
174: => pqp_gds_shd.g_old_rec.gap_level
175: ,p_duration_in_days_o
176: => pqp_gds_shd.g_old_rec.duration_in_days

Line 174: => pqp_gds_shd.g_old_rec.gap_level

170: => pqp_gds_shd.g_old_rec.gap_absence_plan_id
171: ,p_summary_type_o
172: => pqp_gds_shd.g_old_rec.summary_type
173: ,p_gap_level_o
174: => pqp_gds_shd.g_old_rec.gap_level
175: ,p_duration_in_days_o
176: => pqp_gds_shd.g_old_rec.duration_in_days
177: ,p_duration_in_hours_o
178: => pqp_gds_shd.g_old_rec.duration_in_hours

Line 176: => pqp_gds_shd.g_old_rec.duration_in_days

172: => pqp_gds_shd.g_old_rec.summary_type
173: ,p_gap_level_o
174: => pqp_gds_shd.g_old_rec.gap_level
175: ,p_duration_in_days_o
176: => pqp_gds_shd.g_old_rec.duration_in_days
177: ,p_duration_in_hours_o
178: => pqp_gds_shd.g_old_rec.duration_in_hours
179: ,p_date_start_o
180: => pqp_gds_shd.g_old_rec.date_start

Line 178: => pqp_gds_shd.g_old_rec.duration_in_hours

174: => pqp_gds_shd.g_old_rec.gap_level
175: ,p_duration_in_days_o
176: => pqp_gds_shd.g_old_rec.duration_in_days
177: ,p_duration_in_hours_o
178: => pqp_gds_shd.g_old_rec.duration_in_hours
179: ,p_date_start_o
180: => pqp_gds_shd.g_old_rec.date_start
181: ,p_date_end_o
182: => pqp_gds_shd.g_old_rec.date_end

Line 180: => pqp_gds_shd.g_old_rec.date_start

176: => pqp_gds_shd.g_old_rec.duration_in_days
177: ,p_duration_in_hours_o
178: => pqp_gds_shd.g_old_rec.duration_in_hours
179: ,p_date_start_o
180: => pqp_gds_shd.g_old_rec.date_start
181: ,p_date_end_o
182: => pqp_gds_shd.g_old_rec.date_end
183: ,p_object_version_number_o
184: => pqp_gds_shd.g_old_rec.object_version_number

Line 182: => pqp_gds_shd.g_old_rec.date_end

178: => pqp_gds_shd.g_old_rec.duration_in_hours
179: ,p_date_start_o
180: => pqp_gds_shd.g_old_rec.date_start
181: ,p_date_end_o
182: => pqp_gds_shd.g_old_rec.date_end
183: ,p_object_version_number_o
184: => pqp_gds_shd.g_old_rec.object_version_number
185: );
186: --

Line 184: => pqp_gds_shd.g_old_rec.object_version_number

180: => pqp_gds_shd.g_old_rec.date_start
181: ,p_date_end_o
182: => pqp_gds_shd.g_old_rec.date_end
183: ,p_object_version_number_o
184: => pqp_gds_shd.g_old_rec.object_version_number
185: );
186: --
187: exception
188: --

Line 204: (p_rec in pqp_gds_shd.g_rec_type

200: -- ----------------------------------------------------------------------------
201: -- |---------------------------------< del >----------------------------------|
202: -- ----------------------------------------------------------------------------
203: Procedure del
204: (p_rec in pqp_gds_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'del';
208: --

Line 214: pqp_gds_shd.lck

210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: pqp_gds_shd.lck
215: (p_rec.gap_duration_summary_id
216: ,p_rec.object_version_number
217: );
218: --

Line 251: l_rec pqp_gds_shd.g_rec_type;

247: (p_gap_duration_summary_id in number
248: ,p_object_version_number in number
249: ) is
250: --
251: l_rec pqp_gds_shd.g_rec_type;
252: l_proc varchar2(72) := g_package||'del';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);