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.PAY_PWO_UPD dependencies on PAY_PWO_SHD

Line 54: Procedure update_dml(p_rec in out nocopy pay_pwo_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy pay_pwo_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: pay_pwo_shd.g_api_dml := true; -- Set the api dml status

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

Line 77: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

73: comments = p_rec.comments,
74: object_version_number = p_rec.object_version_number
75: where occupation_id = p_rec.occupation_id;
76: --
77: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception

Line 84: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
85: pay_pwo_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated

Line 85: pay_pwo_shd.constraint_error

81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
85: pay_pwo_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

Line 89: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

85: pay_pwo_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
90: pay_pwo_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated

Line 90: pay_pwo_shd.constraint_error

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
90: pay_pwo_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

Line 94: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

90: pay_pwo_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
95: pay_pwo_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

Line 95: pay_pwo_shd.constraint_error

91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
95: pay_pwo_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;

Line 98: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status

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

Line 134: Procedure pre_update(p_rec in pay_pwo_shd.g_rec_type) is

130: -- Internal Row Handler Use Only.
131: --
132: -- {End Of Comments}
133: -- ----------------------------------------------------------------------------
134: Procedure pre_update(p_rec in pay_pwo_shd.g_rec_type) is
135: --
136: l_proc varchar2(72) := g_package||'pre_update';
137: --
138: Begin

Line 176: Procedure post_update(p_rec in pay_pwo_shd.g_rec_type) is

172: -- Internal Row Handler Use Only.
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure post_update(p_rec in pay_pwo_shd.g_rec_type) is
177: --
178: l_proc varchar2(72) := g_package||'post_update';
179: --
180: Begin

Line 196: ,p_business_group_id_o =>pay_pwo_shd.g_old_rec.business_group_id

192: ,p_rate_id =>p_rec.rate_id
193: ,p_job_id =>p_rec.job_id
194: ,p_comments =>p_rec.comments
195: ,p_object_version_number =>p_rec.object_version_number
196: ,p_business_group_id_o =>pay_pwo_shd.g_old_rec.business_group_id
197: ,p_rate_id_o =>pay_pwo_shd.g_old_rec.rate_id
198: ,p_job_id_o =>pay_pwo_shd.g_old_rec.job_id
199: ,p_comments_o =>pay_pwo_shd.g_old_rec.comments
200: ,p_object_version_number_o =>pay_pwo_shd.g_old_rec.object_version_number

Line 197: ,p_rate_id_o =>pay_pwo_shd.g_old_rec.rate_id

193: ,p_job_id =>p_rec.job_id
194: ,p_comments =>p_rec.comments
195: ,p_object_version_number =>p_rec.object_version_number
196: ,p_business_group_id_o =>pay_pwo_shd.g_old_rec.business_group_id
197: ,p_rate_id_o =>pay_pwo_shd.g_old_rec.rate_id
198: ,p_job_id_o =>pay_pwo_shd.g_old_rec.job_id
199: ,p_comments_o =>pay_pwo_shd.g_old_rec.comments
200: ,p_object_version_number_o =>pay_pwo_shd.g_old_rec.object_version_number
201: );

Line 198: ,p_job_id_o =>pay_pwo_shd.g_old_rec.job_id

194: ,p_comments =>p_rec.comments
195: ,p_object_version_number =>p_rec.object_version_number
196: ,p_business_group_id_o =>pay_pwo_shd.g_old_rec.business_group_id
197: ,p_rate_id_o =>pay_pwo_shd.g_old_rec.rate_id
198: ,p_job_id_o =>pay_pwo_shd.g_old_rec.job_id
199: ,p_comments_o =>pay_pwo_shd.g_old_rec.comments
200: ,p_object_version_number_o =>pay_pwo_shd.g_old_rec.object_version_number
201: );
202: --

Line 199: ,p_comments_o =>pay_pwo_shd.g_old_rec.comments

195: ,p_object_version_number =>p_rec.object_version_number
196: ,p_business_group_id_o =>pay_pwo_shd.g_old_rec.business_group_id
197: ,p_rate_id_o =>pay_pwo_shd.g_old_rec.rate_id
198: ,p_job_id_o =>pay_pwo_shd.g_old_rec.job_id
199: ,p_comments_o =>pay_pwo_shd.g_old_rec.comments
200: ,p_object_version_number_o =>pay_pwo_shd.g_old_rec.object_version_number
201: );
202: --
203: exception

Line 200: ,p_object_version_number_o =>pay_pwo_shd.g_old_rec.object_version_number

196: ,p_business_group_id_o =>pay_pwo_shd.g_old_rec.business_group_id
197: ,p_rate_id_o =>pay_pwo_shd.g_old_rec.rate_id
198: ,p_job_id_o =>pay_pwo_shd.g_old_rec.job_id
199: ,p_comments_o =>pay_pwo_shd.g_old_rec.comments
200: ,p_object_version_number_o =>pay_pwo_shd.g_old_rec.object_version_number
201: );
202: --
203: exception
204: --

Line 262: Procedure convert_defs(p_rec in out nocopy pay_pwo_shd.g_rec_type) is

258: -- Internal Row Handler Use Only.
259: --
260: -- {End Of Comments}
261: -- ----------------------------------------------------------------------------
262: Procedure convert_defs(p_rec in out nocopy pay_pwo_shd.g_rec_type) is
263: --
264: l_proc varchar2(72) := g_package||'convert_defs';
265: --
266: Begin

Line 277: pay_pwo_shd.g_old_rec.business_group_id;

273: -- is being used then we must set to the 'current' argument value.
274: --
275: If (p_rec.business_group_id = hr_api.g_number) then
276: p_rec.business_group_id :=
277: pay_pwo_shd.g_old_rec.business_group_id;
278: End If;
279: If (p_rec.rate_id = hr_api.g_number) then
280: p_rec.rate_id :=
281: pay_pwo_shd.g_old_rec.rate_id;

Line 281: pay_pwo_shd.g_old_rec.rate_id;

277: pay_pwo_shd.g_old_rec.business_group_id;
278: End If;
279: If (p_rec.rate_id = hr_api.g_number) then
280: p_rec.rate_id :=
281: pay_pwo_shd.g_old_rec.rate_id;
282: End If;
283: If (p_rec.job_id = hr_api.g_number) then
284: p_rec.job_id :=
285: pay_pwo_shd.g_old_rec.job_id;

Line 285: pay_pwo_shd.g_old_rec.job_id;

281: pay_pwo_shd.g_old_rec.rate_id;
282: End If;
283: If (p_rec.job_id = hr_api.g_number) then
284: p_rec.job_id :=
285: pay_pwo_shd.g_old_rec.job_id;
286: End If;
287: If (p_rec.comments = hr_api.g_varchar2) then
288: p_rec.comments :=
289: pay_pwo_shd.g_old_rec.comments;

Line 289: pay_pwo_shd.g_old_rec.comments;

285: pay_pwo_shd.g_old_rec.job_id;
286: End If;
287: If (p_rec.comments = hr_api.g_varchar2) then
288: p_rec.comments :=
289: pay_pwo_shd.g_old_rec.comments;
290: End If;
291:
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 302: p_rec in out nocopy pay_pwo_shd.g_rec_type

298: -- |---------------------------------< upd >----------------------------------|
299: -- ----------------------------------------------------------------------------
300: Procedure upd
301: (
302: p_rec in out nocopy pay_pwo_shd.g_rec_type
303: ) is
304: --
305: l_proc varchar2(72) := g_package||'upd';
306: --

Line 312: pay_pwo_shd.lck

308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: -- We must lock the row which we need to update.
311: --
312: pay_pwo_shd.lck
313: (
314: p_rec.occupation_id,
315: p_rec.object_version_number
316: );

Line 351: l_rec pay_pwo_shd.g_rec_type;

347: p_comments in varchar2 default hr_api.g_varchar2,
348: p_object_version_number in out nocopy number
349: ) is
350: --
351: l_rec pay_pwo_shd.g_rec_type;
352: l_proc varchar2(72) := g_package||'upd';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);

Line 361: pay_pwo_shd.convert_args

357: -- Call conversion function to turn arguments into the
358: -- l_rec structure.
359: --
360: l_rec :=
361: pay_pwo_shd.convert_args
362: (
363: p_occupation_id,
364: hr_api.g_number,
365: hr_api.g_number,