DBA Data[Home] [Help]

APPS.PAY_ETP_INS dependencies on PAY_ETP_SHD

Line 80: (p_rec in out nocopy pay_etp_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_etp_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date

Line 94: pay_etp_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from pay_element_types_f t
92: where t.element_type_id = p_rec.element_type_id
93: and t.effective_start_date =
94: pay_etp_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pay_element_types_f.created_by%TYPE;

Line 152: pay_etp_shd.g_api_dml := true; -- Set the api dml status

148: l_last_updated_by := fnd_global.user_id;
149: l_last_update_login := fnd_global.login_id;
150: End If;
151: --
152: pay_etp_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pay_element_types_f
155: --
156: insert into pay_element_types_f

Line 355: pay_etp_shd.g_api_dml := false; -- Unset the api dml status

351: ,l_last_updated_by
352: ,l_last_update_login
353: );
354: --
355: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
356: hr_utility.set_location(' Leaving:'||l_proc, 15);
357: --
358: Exception
359: When hr_api.check_integrity_violated Then

Line 361: pay_etp_shd.g_api_dml := false; -- Unset the api dml status

357: --
358: Exception
359: When hr_api.check_integrity_violated Then
360: -- A check constraint has been violated
361: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
362: pay_etp_shd.constraint_error
363: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
364: When hr_api.unique_integrity_violated Then
365: -- Unique integrity has been violated

Line 362: pay_etp_shd.constraint_error

358: Exception
359: When hr_api.check_integrity_violated Then
360: -- A check constraint has been violated
361: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
362: pay_etp_shd.constraint_error
363: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
364: When hr_api.unique_integrity_violated Then
365: -- Unique integrity has been violated
366: pay_etp_shd.g_api_dml := false; -- Unset the api dml status

Line 366: pay_etp_shd.g_api_dml := false; -- Unset the api dml status

362: pay_etp_shd.constraint_error
363: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
364: When hr_api.unique_integrity_violated Then
365: -- Unique integrity has been violated
366: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
367: pay_etp_shd.constraint_error
368: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
369: When Others Then
370: pay_etp_shd.g_api_dml := false; -- Unset the api dml status

Line 367: pay_etp_shd.constraint_error

363: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
364: When hr_api.unique_integrity_violated Then
365: -- Unique integrity has been violated
366: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
367: pay_etp_shd.constraint_error
368: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
369: When Others Then
370: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
371: Raise;

Line 370: pay_etp_shd.g_api_dml := false; -- Unset the api dml status

366: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
367: pay_etp_shd.constraint_error
368: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
369: When Others Then
370: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
371: Raise;
372: End dt_insert_dml;
373: --
374: -- ----------------------------------------------------------------------------

Line 426: (p_rec in out nocopy pay_etp_shd.g_rec_type

422: -- ----------------------------------------------------------------------------
423: -- |------------------------------< insert_dml >------------------------------|
424: -- ----------------------------------------------------------------------------
425: Procedure insert_dml
426: (p_rec in out nocopy pay_etp_shd.g_rec_type
427: ,p_effective_date in date
428: ,p_datetrack_mode in varchar2
429: ,p_validation_start_date in date
430: ,p_validation_end_date in date

Line 489: (p_rec in out nocopy pay_etp_shd.g_rec_type

485: --
486: -- {End Of Comments}
487: -- ----------------------------------------------------------------------------
488: Procedure pre_insert
489: (p_rec in out nocopy pay_etp_shd.g_rec_type
490: ,p_effective_date in date
491: ,p_datetrack_mode in varchar2
492: ,p_validation_start_date in date
493: ,p_validation_end_date in date

Line 590: (p_rec in pay_etp_shd.g_rec_type

586: --
587: -- {End Of Comments}
588: -- ----------------------------------------------------------------------------
589: Procedure post_insert
590: (p_rec in pay_etp_shd.g_rec_type
591: ,p_effective_date in date
592: ,p_datetrack_mode in varchar2
593: ,p_validation_start_date in date
594: ,p_validation_end_date in date

Line 856: ,p_rec in pay_etp_shd.g_rec_type

852: -- ----------------------------------------------------------------------------
853: Procedure ins_lck
854: (p_effective_date in date
855: ,p_datetrack_mode in varchar2
856: ,p_rec in pay_etp_shd.g_rec_type
857: ,p_validation_start_date out nocopy date
858: ,p_validation_end_date out nocopy date
859: ) is
860: --

Line 896: ,p_rec in out nocopy pay_etp_shd.g_rec_type

892: -- |---------------------------------< ins >----------------------------------|
893: -- ----------------------------------------------------------------------------
894: Procedure ins
895: (p_effective_date in date
896: ,p_rec in out nocopy pay_etp_shd.g_rec_type
897: ,p_processing_priority_warning out nocopy boolean
898: ) is
899: --
900: l_proc varchar2(72) := g_package||'ins';

Line 1072: l_rec pay_etp_shd.g_rec_type;

1068: ,p_comment_id out nocopy number
1069: ,p_processing_priority_warning out nocopy boolean
1070: ) is
1071: --
1072: l_rec pay_etp_shd.g_rec_type;
1073: l_proc varchar2(72) := g_package||'ins';
1074: l_processing_priority_warning boolean;
1075: --
1076: Begin

Line 1083: pay_etp_shd.convert_args

1079: -- Call conversion function to turn arguments into the
1080: -- p_rec structure.
1081: --
1082: l_rec :=
1083: pay_etp_shd.convert_args
1084: (null
1085: ,null
1086: ,null
1087: ,p_business_group_id