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_DEL dependencies on PSP_PFB_SHD

Line 52: (p_rec in psp_pfb_shd.g_rec_type

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

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

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

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

63: --
64: delete from psp_report_period_frequency_b
65: where period_frequency_id = p_rec.period_frequency_id;
66: --
67: psp_pfb_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: psp_pfb_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: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
75: psp_pfb_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status

Line 75: psp_pfb_shd.constraint_error

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

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

74: psp_pfb_shd.g_api_dml := false; -- Unset the api dml status
75: psp_pfb_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: psp_pfb_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 psp_pfb_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in psp_pfb_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 psp_pfb_shd.g_rec_type) is

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

Line 168: => psp_pfb_shd.g_old_rec.object_version_number

164: psp_pfb_rkd.after_delete
165: (p_period_frequency_id
166: => p_rec.period_frequency_id
167: ,p_object_version_number_o
168: => psp_pfb_shd.g_old_rec.object_version_number
169: ,p_start_date_o
170: => psp_pfb_shd.g_old_rec.start_date
171: ,p_unit_of_measure_o
172: => psp_pfb_shd.g_old_rec.unit_of_measure

Line 170: => psp_pfb_shd.g_old_rec.start_date

166: => p_rec.period_frequency_id
167: ,p_object_version_number_o
168: => psp_pfb_shd.g_old_rec.object_version_number
169: ,p_start_date_o
170: => psp_pfb_shd.g_old_rec.start_date
171: ,p_unit_of_measure_o
172: => psp_pfb_shd.g_old_rec.unit_of_measure
173: ,p_period_duration_o
174: => psp_pfb_shd.g_old_rec.period_duration

Line 172: => psp_pfb_shd.g_old_rec.unit_of_measure

168: => psp_pfb_shd.g_old_rec.object_version_number
169: ,p_start_date_o
170: => psp_pfb_shd.g_old_rec.start_date
171: ,p_unit_of_measure_o
172: => psp_pfb_shd.g_old_rec.unit_of_measure
173: ,p_period_duration_o
174: => psp_pfb_shd.g_old_rec.period_duration
175: ,p_report_type_o
176: => psp_pfb_shd.g_old_rec.report_type

Line 174: => psp_pfb_shd.g_old_rec.period_duration

170: => psp_pfb_shd.g_old_rec.start_date
171: ,p_unit_of_measure_o
172: => psp_pfb_shd.g_old_rec.unit_of_measure
173: ,p_period_duration_o
174: => psp_pfb_shd.g_old_rec.period_duration
175: ,p_report_type_o
176: => psp_pfb_shd.g_old_rec.report_type
177: );
178: --

Line 176: => psp_pfb_shd.g_old_rec.report_type

172: => psp_pfb_shd.g_old_rec.unit_of_measure
173: ,p_period_duration_o
174: => psp_pfb_shd.g_old_rec.period_duration
175: ,p_report_type_o
176: => psp_pfb_shd.g_old_rec.report_type
177: );
178: --
179: exception
180: --

Line 196: (p_rec in psp_pfb_shd.g_rec_type

192: -- ----------------------------------------------------------------------------
193: -- |---------------------------------< del >----------------------------------|
194: -- ----------------------------------------------------------------------------
195: Procedure del
196: (p_rec in psp_pfb_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72) := g_package||'del';
200: --

Line 206: psp_pfb_shd.lck

202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- We must lock the row which we need to delete.
205: --
206: psp_pfb_shd.lck
207: (p_rec.period_frequency_id
208: ,p_rec.object_version_number
209: );
210: --

Line 243: l_rec psp_pfb_shd.g_rec_type;

239: (p_period_frequency_id in number
240: ,p_object_version_number in number
241: ) is
242: --
243: l_rec psp_pfb_shd.g_rec_type;
244: l_proc varchar2(72) := g_package||'del';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);