APPS.PER_STL_SHD dependencies on PER_RI_SETUP_TASKS

Line 21: If (p_constraint_name = 'PER_RI_SETUP_TASKS_TL_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_RI_SETUP_TASKS_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 26: ElsIf (p_constraint_name = 'PER_RI_SETUP_TASKS_TL_PK1') Then

22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PER_RI_SETUP_TASKS_TL_PK1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 57: from per_ri_setup_tasks_tl

53: ,language
54: ,source_lang
55: ,setup_task_name
56: ,setup_task_description
57: from per_ri_setup_tasks_tl
58: where setup_task_code = p_setup_task_code;
59: --
60: l_fct_ret boolean;
61: --

Line 119: from per_ri_setup_tasks_tl

115: ,language
116: ,source_lang
117: ,setup_task_name
118: ,setup_task_description
119: from per_ri_setup_tasks_tl
120: where setup_task_code = p_setup_task_code
121: for update nowait;
122: --
123: l_proc varchar2(72) := g_package||'lck';

Line 158: fnd_message.set_token('TABLE_NAME', 'per_ri_setup_tasks_tl');

154: -- The object is locked therefore we need to supply a meaningful
155: -- error message.
156: --
157: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
158: fnd_message.set_token('TABLE_NAME', 'per_ri_setup_tasks_tl');
159: fnd_message.raise_error;
160: End lck;
161: --
162: -- ----------------------------------------------------------------------------

Line 175: delete from PER_RI_SETUP_TASKS_TL T

171: -- ----------------------------------------------------------------------------
172: PROCEDURE add_language IS
173: Begin
174: --
175: delete from PER_RI_SETUP_TASKS_TL T
176: where not exists
177: (select NULL
178: from PER_RI_SETUP_TASKS B
179: where B.SETUP_TASK_CODE = T.SETUP_TASK_CODE

Line 178: from PER_RI_SETUP_TASKS B

174: --
175: delete from PER_RI_SETUP_TASKS_TL T
176: where not exists
177: (select NULL
178: from PER_RI_SETUP_TASKS B
179: where B.SETUP_TASK_CODE = T.SETUP_TASK_CODE
180: );
181:
182: update PER_RI_SETUP_TASKS_TL T set (

Line 182: update PER_RI_SETUP_TASKS_TL T set (

178: from PER_RI_SETUP_TASKS B
179: where B.SETUP_TASK_CODE = T.SETUP_TASK_CODE
180: );
181:
182: update PER_RI_SETUP_TASKS_TL T set (
183: SETUP_TASK_NAME,
184: SETUP_TASK_DESCRIPTION
185: ) = (select
186: B.SETUP_TASK_NAME,

Line 188: from PER_RI_SETUP_TASKS_TL B

184: SETUP_TASK_DESCRIPTION
185: ) = (select
186: B.SETUP_TASK_NAME,
187: B.SETUP_TASK_DESCRIPTION
188: from PER_RI_SETUP_TASKS_TL B
189: where B.SETUP_TASK_CODE = T.SETUP_TASK_CODE
190: and B.LANGUAGE = T.SOURCE_LANG)
191: where (
192: T.SETUP_TASK_CODE,

Line 197: from PER_RI_SETUP_TASKS_TL SUBB, PER_RI_SETUP_TASKS_TL SUBT

193: T.LANGUAGE
194: ) in (select
195: SUBT.SETUP_TASK_CODE,
196: SUBT.LANGUAGE
197: from PER_RI_SETUP_TASKS_TL SUBB, PER_RI_SETUP_TASKS_TL SUBT
198: where SUBB.SETUP_TASK_CODE = SUBT.SETUP_TASK_CODE
199: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
200: and (SUBB.SETUP_TASK_NAME <> SUBT.SETUP_TASK_NAME
201: or SUBB.SETUP_TASK_DESCRIPTION <> SUBT.SETUP_TASK_DESCRIPTION

Line 204: insert into PER_RI_SETUP_TASKS_TL (

200: and (SUBB.SETUP_TASK_NAME <> SUBT.SETUP_TASK_NAME
201: or SUBB.SETUP_TASK_DESCRIPTION <> SUBT.SETUP_TASK_DESCRIPTION
202: ));
203:
204: insert into PER_RI_SETUP_TASKS_TL (
205: SETUP_TASK_CODE,
206: SETUP_TASK_NAME,
207: SETUP_TASK_DESCRIPTION,
208: LAST_UPDATE_DATE,

Line 226: from PER_RI_SETUP_TASKS_TL B, FND_LANGUAGES L

222: B.CREATED_BY,
223: B.CREATION_DATE,
224: L.LANGUAGE_CODE,
225: B.SOURCE_LANG
226: from PER_RI_SETUP_TASKS_TL B, FND_LANGUAGES L
227: where L.INSTALLED_FLAG in ('I', 'B')
228: and B.LANGUAGE = userenv('LANG')
229: and not exists
230: (select NULL

Line 231: from PER_RI_SETUP_TASKS_TL T

227: where L.INSTALLED_FLAG in ('I', 'B')
228: and B.LANGUAGE = userenv('LANG')
229: and not exists
230: (select NULL
231: from PER_RI_SETUP_TASKS_TL T
232: where T.SETUP_TASK_CODE = B.SETUP_TASK_CODE
233: and T.LANGUAGE = L.LANGUAGE_CODE);
234: --
235: End add_language;