APPS.PER_SBT_SHD dependencies on PER_SUBJECTS_TAKEN

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_SUBJECTS_TAKEN_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 52: from per_subjects_taken_tl

48: subjects_taken_id
49: ,language
50: ,source_lang
51: ,grade_attained
52: from per_subjects_taken_tl
53: where subjects_taken_id = p_subjects_taken_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from per_subjects_taken_tl

114: subjects_taken_id
115: ,language
116: ,source_lang
117: ,grade_attained
118: from per_subjects_taken_tl
119: where subjects_taken_id = p_subjects_taken_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'per_subjects_taken_tl');

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', 'per_subjects_taken_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 175: delete from PER_SUBJECTS_TAKEN_TL T

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

Line 178: from PER_SUBJECTS_TAKEN B

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

Line 182: update PER_SUBJECTS_TAKEN_TL T set (

178: from PER_SUBJECTS_TAKEN B
179: where B.SUBJECTS_TAKEN_ID = T.SUBJECTS_TAKEN_ID
180: );
181:
182: update PER_SUBJECTS_TAKEN_TL T set (
183: GRADE_ATTAINED
184: ) = (select
185: B.GRADE_ATTAINED
186: from PER_SUBJECTS_TAKEN_TL B

Line 186: from PER_SUBJECTS_TAKEN_TL B

182: update PER_SUBJECTS_TAKEN_TL T set (
183: GRADE_ATTAINED
184: ) = (select
185: B.GRADE_ATTAINED
186: from PER_SUBJECTS_TAKEN_TL B
187: where B.SUBJECTS_TAKEN_ID = T.SUBJECTS_TAKEN_ID
188: and B.LANGUAGE = T.SOURCE_LANG)
189: where (
190: T.SUBJECTS_TAKEN_ID,

Line 195: from PER_SUBJECTS_TAKEN_TL SUBB, PER_SUBJECTS_TAKEN_TL SUBT

191: T.LANGUAGE
192: ) in (select
193: SUBT.SUBJECTS_TAKEN_ID,
194: SUBT.LANGUAGE
195: from PER_SUBJECTS_TAKEN_TL SUBB, PER_SUBJECTS_TAKEN_TL SUBT
196: where SUBB.SUBJECTS_TAKEN_ID = SUBT.SUBJECTS_TAKEN_ID
197: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
198: and (SUBB.GRADE_ATTAINED <> SUBT.GRADE_ATTAINED
199: or (SUBB.GRADE_ATTAINED is null and SUBT.GRADE_ATTAINED is not null)

Line 203: insert into PER_SUBJECTS_TAKEN_TL (

199: or (SUBB.GRADE_ATTAINED is null and SUBT.GRADE_ATTAINED is not null)
200: or (SUBB.GRADE_ATTAINED is not null and SUBT.GRADE_ATTAINED is null)
201: ));
202:
203: insert into PER_SUBJECTS_TAKEN_TL (
204: SUBJECTS_TAKEN_ID,
205: GRADE_ATTAINED,
206: CREATED_BY,
207: CREATION_DATE,

Line 223: from PER_SUBJECTS_TAKEN_TL B, FND_LANGUAGES L

219: B.LAST_UPDATE_DATE,
220: B.LAST_UPDATE_LOGIN,
221: L.LANGUAGE_CODE,
222: B.SOURCE_LANG
223: from PER_SUBJECTS_TAKEN_TL B, FND_LANGUAGES L
224: where L.INSTALLED_FLAG in ('I', 'B')
225: and B.LANGUAGE = userenv('LANG')
226: and not exists
227: (select NULL

Line 228: from PER_SUBJECTS_TAKEN_TL T

224: where L.INSTALLED_FLAG in ('I', 'B')
225: and B.LANGUAGE = userenv('LANG')
226: and not exists
227: (select NULL
228: from PER_SUBJECTS_TAKEN_TL T
229: where T.SUBJECTS_TAKEN_ID = B.SUBJECTS_TAKEN_ID
230: and T.LANGUAGE = L.LANGUAGE_CODE);
231: --
232: End;