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.PSP_PFB_UPD dependencies on PSP_PFB_SHD

Line 55: (p_rec in out nocopy psp_pfb_shd.g_rec_type

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

Line 66: psp_pfb_shd.g_api_dml := true; -- Set the api dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: psp_pfb_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the psp_report_period_frequency_b Row
69: --
70: update psp_report_period_frequency_b

Line 80: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

76: ,period_duration = p_rec.period_duration
77: ,report_type = p_rec.report_type
78: where period_frequency_id = p_rec.period_frequency_id;
79: --
80: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception

Line 87: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
88: psp_pfb_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

Line 88: psp_pfb_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
88: psp_pfb_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: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

Line 92: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

88: psp_pfb_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: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
93: psp_pfb_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

Line 93: psp_pfb_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: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
93: psp_pfb_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: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

Line 97: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

93: psp_pfb_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: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
98: psp_pfb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

Line 98: psp_pfb_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: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
98: psp_pfb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
102: Raise;

Line 101: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

97: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
98: psp_pfb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
102: Raise;
103: End update_dml;
104: --
105: -- ----------------------------------------------------------------------------

Line 138: (p_rec in psp_pfb_shd.g_rec_type

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

Line 182: (p_rec in psp_pfb_shd.g_rec_type

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

Line 205: => psp_pfb_shd.g_old_rec.object_version_number

201: => p_rec.period_duration
202: ,p_report_type
203: => p_rec.report_type
204: ,p_object_version_number_o
205: => psp_pfb_shd.g_old_rec.object_version_number
206: ,p_start_date_o
207: => psp_pfb_shd.g_old_rec.start_date
208: ,p_unit_of_measure_o
209: => psp_pfb_shd.g_old_rec.unit_of_measure

Line 207: => psp_pfb_shd.g_old_rec.start_date

203: => p_rec.report_type
204: ,p_object_version_number_o
205: => psp_pfb_shd.g_old_rec.object_version_number
206: ,p_start_date_o
207: => psp_pfb_shd.g_old_rec.start_date
208: ,p_unit_of_measure_o
209: => psp_pfb_shd.g_old_rec.unit_of_measure
210: ,p_period_duration_o
211: => psp_pfb_shd.g_old_rec.period_duration

Line 209: => psp_pfb_shd.g_old_rec.unit_of_measure

205: => psp_pfb_shd.g_old_rec.object_version_number
206: ,p_start_date_o
207: => psp_pfb_shd.g_old_rec.start_date
208: ,p_unit_of_measure_o
209: => psp_pfb_shd.g_old_rec.unit_of_measure
210: ,p_period_duration_o
211: => psp_pfb_shd.g_old_rec.period_duration
212: ,p_report_type_o
213: => psp_pfb_shd.g_old_rec.report_type

Line 211: => psp_pfb_shd.g_old_rec.period_duration

207: => psp_pfb_shd.g_old_rec.start_date
208: ,p_unit_of_measure_o
209: => psp_pfb_shd.g_old_rec.unit_of_measure
210: ,p_period_duration_o
211: => psp_pfb_shd.g_old_rec.period_duration
212: ,p_report_type_o
213: => psp_pfb_shd.g_old_rec.report_type
214: );
215: --

Line 213: => psp_pfb_shd.g_old_rec.report_type

209: => psp_pfb_shd.g_old_rec.unit_of_measure
210: ,p_period_duration_o
211: => psp_pfb_shd.g_old_rec.period_duration
212: ,p_report_type_o
213: => psp_pfb_shd.g_old_rec.report_type
214: );
215: --
216: exception
217: --

Line 273: (p_rec in out nocopy psp_pfb_shd.g_rec_type

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

Line 285: psp_pfb_shd.g_old_rec.start_date;

281: -- is being used then we must set to the 'current' argument value.
282: --
283: If (p_rec.start_date = hr_api.g_date) then
284: p_rec.start_date :=
285: psp_pfb_shd.g_old_rec.start_date;
286: End If;
287: If (p_rec.unit_of_measure = hr_api.g_varchar2) then
288: p_rec.unit_of_measure :=
289: psp_pfb_shd.g_old_rec.unit_of_measure;

Line 289: psp_pfb_shd.g_old_rec.unit_of_measure;

285: psp_pfb_shd.g_old_rec.start_date;
286: End If;
287: If (p_rec.unit_of_measure = hr_api.g_varchar2) then
288: p_rec.unit_of_measure :=
289: psp_pfb_shd.g_old_rec.unit_of_measure;
290: End If;
291: If (p_rec.period_duration = hr_api.g_number) then
292: p_rec.period_duration :=
293: psp_pfb_shd.g_old_rec.period_duration;

Line 293: psp_pfb_shd.g_old_rec.period_duration;

289: psp_pfb_shd.g_old_rec.unit_of_measure;
290: End If;
291: If (p_rec.period_duration = hr_api.g_number) then
292: p_rec.period_duration :=
293: psp_pfb_shd.g_old_rec.period_duration;
294: End If;
295: If (p_rec.report_type = hr_api.g_varchar2) then
296: p_rec.report_type :=
297: psp_pfb_shd.g_old_rec.report_type;

Line 297: psp_pfb_shd.g_old_rec.report_type;

293: psp_pfb_shd.g_old_rec.period_duration;
294: End If;
295: If (p_rec.report_type = hr_api.g_varchar2) then
296: p_rec.report_type :=
297: psp_pfb_shd.g_old_rec.report_type;
298: End If;
299: --
300: End convert_defs;
301: --

Line 306: (p_rec in out nocopy psp_pfb_shd.g_rec_type

302: -- ----------------------------------------------------------------------------
303: -- |---------------------------------< upd >----------------------------------|
304: -- ----------------------------------------------------------------------------
305: Procedure upd
306: (p_rec in out nocopy psp_pfb_shd.g_rec_type
307: ) is
308: --
309: l_proc varchar2(72) := g_package||'upd';
310: --

Line 316: psp_pfb_shd.lck

312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: -- We must lock the row which we need to update.
315: --
316: psp_pfb_shd.lck
317: (p_rec.period_frequency_id
318: ,p_rec.object_version_number
319: );
320: --

Line 365: l_rec psp_pfb_shd.g_rec_type;

361: ,p_period_duration in number default hr_api.g_number
362: ,p_report_type in varchar2 default hr_api.g_varchar2
363: ) is
364: --
365: l_rec psp_pfb_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'upd';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);

Line 375: psp_pfb_shd.convert_args

371: -- Call conversion function to turn arguments into the
372: -- l_rec structure.
373: --
374: l_rec :=
375: psp_pfb_shd.convert_args
376: (p_period_frequency_id
377: ,p_object_version_number
378: ,p_start_date
379: ,p_unit_of_measure