48: element_set_id
49: ,language
50: ,source_lang
51: ,element_set_name
52: from pay_element_sets_tl
53: where element_set_id = p_element_set_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;
114: element_set_id
115: ,language
116: ,source_lang
117: ,element_set_name
118: from pay_element_sets_tl
119: where element_set_id = p_element_set_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', 'pay_element_sets_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------