DBA Data[Home] [Help]

APPS.PAY_ETP_INS_ND dependencies on PAY_ETP_SHD_ND

Line 80: (p_rec in out nocopy pay_etp_shd_nd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.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 351: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status

347: ,l_last_updated_by
348: ,l_last_update_login
349: );
350: --
351: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status
352: hr_utility.set_location(' Leaving:'||l_proc, 15);
353: --
354: Exception
355: When hr_api.check_integrity_violated Then

Line 357: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status

353: --
354: Exception
355: When hr_api.check_integrity_violated Then
356: -- A check constraint has been violated
357: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status
358: pay_etp_shd_nd.constraint_error
359: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
360: When hr_api.unique_integrity_violated Then
361: -- Unique integrity has been violated

Line 358: pay_etp_shd_nd.constraint_error

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

Line 362: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status

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

Line 363: pay_etp_shd_nd.constraint_error

359: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
360: When hr_api.unique_integrity_violated Then
361: -- Unique integrity has been violated
362: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status
363: pay_etp_shd_nd.constraint_error
364: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
365: When Others Then
366: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status
367: Raise;

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

362: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status
363: pay_etp_shd_nd.constraint_error
364: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
365: When Others Then
366: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status
367: Raise;
368: End dt_insert_dml;
369: --
370: -- ----------------------------------------------------------------------------

Line 422: (p_rec in out nocopy pay_etp_shd_nd.g_rec_type

418: -- ----------------------------------------------------------------------------
419: -- |------------------------------< insert_dml >------------------------------|
420: -- ----------------------------------------------------------------------------
421: Procedure insert_dml
422: (p_rec in out nocopy pay_etp_shd_nd.g_rec_type
423: ,p_effective_date in date
424: ,p_datetrack_mode in varchar2
425: ,p_validation_start_date in date
426: ,p_validation_end_date in date

Line 485: (p_rec in out nocopy pay_etp_shd_nd.g_rec_type

481: --
482: -- {End Of Comments}
483: -- ----------------------------------------------------------------------------
484: Procedure pre_insert
485: (p_rec in out nocopy pay_etp_shd_nd.g_rec_type
486: ,p_effective_date in date
487: ,p_datetrack_mode in varchar2
488: ,p_validation_start_date in date
489: ,p_validation_end_date in date

Line 586: (p_rec in pay_etp_shd_nd.g_rec_type

582: --
583: -- {End Of Comments}
584: -- ----------------------------------------------------------------------------
585: Procedure post_insert
586: (p_rec in pay_etp_shd_nd.g_rec_type
587: ,p_effective_date in date
588: ,p_datetrack_mode in varchar2
589: ,p_validation_start_date in date
590: ,p_validation_end_date in date

Line 852: ,p_rec in pay_etp_shd_nd.g_rec_type

848: -- ----------------------------------------------------------------------------
849: Procedure ins_lck
850: (p_effective_date in date
851: ,p_datetrack_mode in varchar2
852: ,p_rec in pay_etp_shd_nd.g_rec_type
853: ,p_validation_start_date out nocopy date
854: ,p_validation_end_date out nocopy date
855: ) is
856: --

Line 892: ,p_rec in out nocopy pay_etp_shd_nd.g_rec_type

888: -- |---------------------------------< ins >----------------------------------|
889: -- ----------------------------------------------------------------------------
890: Procedure ins
891: (p_effective_date in date
892: ,p_rec in out nocopy pay_etp_shd_nd.g_rec_type
893: ,p_processing_priority_warning out nocopy boolean
894: ) is
895: --
896: l_proc varchar2(72) := g_package||'ins';

Line 1066: l_rec pay_etp_shd_nd.g_rec_type;

1062: ,p_comment_id out nocopy number
1063: ,p_processing_priority_warning out nocopy boolean
1064: ) is
1065: --
1066: l_rec pay_etp_shd_nd.g_rec_type;
1067: l_proc varchar2(72) := g_package||'ins';
1068: l_processing_priority_warning boolean;
1069: --
1070: Begin

Line 1077: pay_etp_shd_nd.convert_args

1073: -- Call conversion function to turn arguments into the
1074: -- p_rec structure.
1075: --
1076: l_rec :=
1077: pay_etp_shd_nd.convert_args
1078: (null
1079: ,null
1080: ,null
1081: ,p_business_group_id