DBA Data[Home] [Help]

APPS.PER_SHT_DEL dependencies on PER_SHARED_TYPES

Line 57: p_entity_name=>'PER_SHARED_TYPES',

53: -- Added the following code as a part of Zero Downtime Patching Project.
54: -- Code Starts Here.
55: --
56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PER_SHARED_TYPES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),

Line 72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(

68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),
72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(
73: PER_RIC_PKG.col_info_rec('SHARED_TYPE_ID', NULL, p_rec.shared_type_id,NULL)))),
74: p_ref_type=>'DEL');
75: --
76: -- Code Ends Here

Line 78: -- Delete the per_shared_types row.

74: p_ref_type=>'DEL');
75: --
76: -- Code Ends Here
77: --
78: -- Delete the per_shared_types row.
79: --
80: delete from per_shared_types
81: where shared_type_id = p_rec.shared_type_id;
82: --

Line 80: delete from per_shared_types

76: -- Code Ends Here
77: --
78: -- Delete the per_shared_types row.
79: --
80: delete from per_shared_types
81: where shared_type_id = p_rec.shared_type_id;
82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: --

Line 228: (p_module_name => 'per_shared_types'

224: --
225: when hr_api.cannot_find_prog_unit then
226: --
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'per_shared_types'
229: ,p_hook_type => 'AD');
230: --
231: end;
232: --