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_RTD_INS dependencies on PSP_RTD_SHD

Line 76: (p_rec in out nocopy psp_rtd_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy psp_rtd_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 85: psp_rtd_shd.g_api_dml := true; -- Set the api dml status

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: psp_rtd_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: psp_report_template_details
88: --
89: insert into psp_report_template_details

Line 112: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status

108: ,p_rec.criteria_value2
109: ,p_rec.criteria_value3
110: );
111: --
112: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: Exception
116: When hr_api.check_integrity_violated Then

Line 118: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status

114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
119: psp_rtd_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated

Line 119: psp_rtd_shd.constraint_error

115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
119: psp_rtd_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status

Line 123: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status

119: psp_rtd_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
124: psp_rtd_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated

Line 124: psp_rtd_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
124: psp_rtd_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status

Line 128: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status

124: psp_rtd_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
129: psp_rtd_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status

Line 129: psp_rtd_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
129: psp_rtd_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;

Line 132: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status

128: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
129: psp_rtd_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
134: End insert_dml;
135: --
136: -- ----------------------------------------------------------------------------

Line 174: (p_rec in out nocopy psp_rtd_shd.g_rec_type

170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure pre_insert
174: (p_rec in out nocopy psp_rtd_shd.g_rec_type
175: ) is
176: --
177: Cursor C_Sel1 is select psp_report_template_details_s.nextval from sys.dual;
178: --

Line 261: (p_rec in psp_rtd_shd.g_rec_type

257: --
258: -- {End Of Comments}
259: -- ----------------------------------------------------------------------------
260: Procedure post_insert
261: (p_rec in psp_rtd_shd.g_rec_type
262: ) is
263: --
264: l_proc varchar2(72) := g_package||'post_insert';
265: --

Line 308: (p_rec in out nocopy psp_rtd_shd.g_rec_type

304: -- ----------------------------------------------------------------------------
305: -- |---------------------------------< ins >----------------------------------|
306: -- ----------------------------------------------------------------------------
307: Procedure ins
308: (p_rec in out nocopy psp_rtd_shd.g_rec_type
309: ) is
310: --
311: l_proc varchar2(72) := g_package||'ins';
312: --

Line 360: l_rec psp_rtd_shd.g_rec_type;

356: ,p_template_detail_id in number
357: ,p_object_version_number out nocopy number
358: ) is
359: --
360: l_rec psp_rtd_shd.g_rec_type;
361: l_proc varchar2(72) := g_package||'ins';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);

Line 370: psp_rtd_shd.convert_args

366: -- Call conversion function to turn arguments into the
367: -- p_rec structure.
368: --
369: l_rec :=
370: psp_rtd_shd.convert_args
371: (null
372: ,p_template_id
373: ,null
374: ,p_criteria_lookup_type