APPS.HR_PAC_SHD dependencies on HR_PATTERN_CONSTRUCTIONS

Line 97: from hr_pattern_constructions

93: pattern_id,
94: pattern_bit_id,
95: component_pattern_id,
96: object_version_number
97: from hr_pattern_constructions
98: where pattern_construction_id = p_pattern_construction_id;
99: --
100: l_proc varchar2(72) := g_package||'api_updating';
101: l_fct_ret boolean;

Line 173: from hr_pattern_constructions

169: pattern_id,
170: pattern_bit_id,
171: component_pattern_id,
172: object_version_number
173: from hr_pattern_constructions
174: where pattern_construction_id = p_pattern_construction_id
175: for update nowait;
176: --
177: l_proc varchar2(72) := g_package||'lck';

Line 216: hr_utility.set_message_token('TABLE_NAME', 'hr_pattern_constructions');

212: -- The object is locked therefore we need to supply a meaningful
213: -- error message.
214: --
215: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
216: hr_utility.set_message_token('TABLE_NAME', 'hr_pattern_constructions');
217: hr_utility.raise_error;
218: End lck;
219: --
220: -- ----------------------------------------------------------------------------