APPS.HR_PPU_SHD dependencies on HR_PATTERN_PURPOSE_USAGES

Line 79: from hr_pattern_purpose_usages

75: entity_name,
76: pattern_purpose,
77: hierarchy_level,
78: object_version_number
79: from hr_pattern_purpose_usages
80: where purpose_usage_id = p_purpose_usage_id;
81: --
82: l_proc varchar2(72) := g_package||'api_updating';
83: l_fct_ret boolean;

Line 153: from hr_pattern_purpose_usages

149: entity_name,
150: pattern_purpose,
151: hierarchy_level,
152: object_version_number
153: from hr_pattern_purpose_usages
154: where purpose_usage_id = p_purpose_usage_id
155: for update nowait;
156: --
157: l_proc varchar2(72) := g_package||'lck';

Line 196: hr_utility.set_message_token('TABLE_NAME', 'hr_pattern_purpose_usages');

192: -- The object is locked therefore we need to supply a meaningful
193: -- error message.
194: --
195: hr_utility.set_message('801', 'HR_7165_OBJECT_LOCKED');
196: hr_utility.set_message_token('TABLE_NAME', 'hr_pattern_purpose_usages');
197: hr_utility.raise_error;
198: End lck;
199: --
200: -- ----------------------------------------------------------------------------