DBA Data[Home] [Help]

APPS.PAY_PPM_INS dependencies on PAY_PPM_SHD

Line 58: (p_rec in out nocopy pay_ppm_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_ppm_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is

Line 73: pay_ppm_shd.g_old_rec.effective_start_date

69: from pay_personal_payment_methods_f t
70: where t.personal_payment_method_id = p_rec.personal_payment_method_id
71:
72: and t.effective_start_date =
73: pay_ppm_shd.g_old_rec.effective_start_date
74: and t.effective_end_date = (p_validation_start_date - 1);
75: --
76: l_proc varchar2(72) := g_package||'dt_insert_dml';
77: l_created_by pay_personal_payment_methods_f.created_by%TYPE;

Line 130: pay_ppm_shd.g_api_dml := true; -- Set the api dml status

126: l_last_updated_by := fnd_global.user_id;
127: l_last_update_login := fnd_global.login_id;
128: End If;
129: --
130: pay_ppm_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: pay_personal_payment_methods_f
133: --
134: insert into pay_personal_payment_methods_f

Line 283: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

279: p_rec.ppm_information29,
280: p_rec.ppm_information30
281: );
282: --
283: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
284: hr_utility.set_location(' Leaving:'||l_proc, 15);
285: --
286: Exception
287: When hr_api.check_integrity_violated Then

Line 289: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

285: --
286: Exception
287: When hr_api.check_integrity_violated Then
288: -- A check constraint has been violated
289: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
290: pay_ppm_shd.constraint_error
291: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
292: When hr_api.unique_integrity_violated Then
293: -- Unique integrity has been violated

Line 290: pay_ppm_shd.constraint_error

286: Exception
287: When hr_api.check_integrity_violated Then
288: -- A check constraint has been violated
289: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
290: pay_ppm_shd.constraint_error
291: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
292: When hr_api.unique_integrity_violated Then
293: -- Unique integrity has been violated
294: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

Line 294: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

290: pay_ppm_shd.constraint_error
291: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
292: When hr_api.unique_integrity_violated Then
293: -- Unique integrity has been violated
294: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
295: pay_ppm_shd.constraint_error
296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297: When Others Then
298: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

Line 295: pay_ppm_shd.constraint_error

291: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
292: When hr_api.unique_integrity_violated Then
293: -- Unique integrity has been violated
294: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
295: pay_ppm_shd.constraint_error
296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297: When Others Then
298: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
299: Raise;

Line 298: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

294: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
295: pay_ppm_shd.constraint_error
296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297: When Others Then
298: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
299: Raise;
300: End dt_insert_dml;
301: --
302: -- ----------------------------------------------------------------------------

Line 306: (p_rec in out nocopy pay_ppm_shd.g_rec_type,

302: -- ----------------------------------------------------------------------------
303: -- |------------------------------< insert_dml >------------------------------|
304: -- ----------------------------------------------------------------------------
305: Procedure insert_dml
306: (p_rec in out nocopy pay_ppm_shd.g_rec_type,
307: p_effective_date in date,
308: p_datetrack_mode in varchar2,
309: p_validation_start_date in date,
310: p_validation_end_date in date) is

Line 366: (p_rec in out nocopy pay_ppm_shd.g_rec_type,

362: --
363: -- {End Of Comments}
364: -- ----------------------------------------------------------------------------
365: Procedure pre_insert
366: (p_rec in out nocopy pay_ppm_shd.g_rec_type,
367: p_effective_date in date,
368: p_datetrack_mode in varchar2,
369: p_validation_start_date in date,
370: p_validation_end_date in date) is

Line 430: (p_rec in pay_ppm_shd.g_rec_type,

426: --
427: -- {End Of Comments}
428: -- ----------------------------------------------------------------------------
429: Procedure post_insert
430: (p_rec in pay_ppm_shd.g_rec_type,
431: p_effective_date in date,
432: p_datetrack_mode in varchar2,
433: p_validation_start_date in date,
434: p_validation_end_date in date) is

Line 533: p_rec in pay_ppm_shd.g_rec_type,

529: --
530: Procedure ins_lck
531: (p_effective_date in date,
532: p_datetrack_mode in varchar2,
533: p_rec in pay_ppm_shd.g_rec_type,
534: p_validation_start_date out nocopy date,
535: p_validation_end_date out nocopy date) is
536: --
537: l_proc varchar2(72) := g_package||'ins_lck';

Line 626: p_rec in out nocopy pay_ppm_shd.g_rec_type,

622: -- |---------------------------------< ins >----------------------------------|
623: -- ----------------------------------------------------------------------------
624: Procedure ins
625: (
626: p_rec in out nocopy pay_ppm_shd.g_rec_type,
627: p_effective_date in date,
628: p_validate in boolean default false
629: ) IS
630: --

Line 801: l_rec pay_ppm_shd.g_rec_type;

797: p_ppm_information29 in varchar2 default null,
798: p_ppm_information30 in varchar2 default null
799: ) is
800: --
801: l_rec pay_ppm_shd.g_rec_type;
802: l_proc varchar2(72) := g_package||'ins';
803: --
804: Begin
805: hr_utility.set_location('Entering:'||l_proc, 5);

Line 811: pay_ppm_shd.convert_args

807: -- Call conversion function to turn arguments into the
808: -- p_rec structure.
809: --
810: l_rec :=
811: pay_ppm_shd.convert_args
812: (
813: null,
814: null,
815: null,