48: organization_id
49: ,language
50: ,source_lang
51: ,name
52: from hr_all_organization_units_tl
53: where organization_id = p_organization_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;
114: organization_id
115: ,language
116: ,source_lang
117: ,name
118: from hr_all_organization_units_tl
119: where organization_id = p_organization_id
120: and language = p_language
121: for update nowait;
122: --
160: -- The object is locked therefore we need to supply a meaningful
161: -- error message.
162: --
163: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
164: fnd_message.set_token('TABLE_NAME', 'hr_all_organization_units_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------