APPS.LNS_COND_ASSIGNMENTS_PKG dependencies on LNS_COND_ASSIGNMENTS_TL

Line 75: INSERT INTO LNS_COND_ASSIGNMENTS_TL (

71: COND_ASSIGNMENT_ID
72: INTO
73: X_COND_ASSIGNMENT_ID;
74:
75: INSERT INTO LNS_COND_ASSIGNMENTS_TL (
76: COND_ASSIGNMENT_ID
77: ,CONDITION_DESCRIPTION
78: ,LANGUAGE
79: ,SOURCE_LANG

Line 100: from LNS_COND_ASSIGNMENTS_TL T

96: where L.INSTALLED_FLAG in ('I', 'B')
97: AND L.LANGUAGE_CODE = userenv('LANG')
98: AND not exists
99: (select NULL
100: from LNS_COND_ASSIGNMENTS_TL T
101: where T.cond_assignment_id = x_cond_assignment_id
102: and T.LANGUAGE = L.LANGUAGE_CODE);
103:
104:

Line 106: INSERT INTO LNS_COND_ASSIGNMENTS_TL (

102: and T.LANGUAGE = L.LANGUAGE_CODE);
103:
104:
105:
106: INSERT INTO LNS_COND_ASSIGNMENTS_TL (
107: COND_ASSIGNMENT_ID
108: ,CONDITION_DESCRIPTION
109: ,LANGUAGE
110: ,SOURCE_LANG

Line 136: from LNS_COND_ASSIGNMENTS_TL T

132: WHERE COND_ASSIGNMENT_ID = X_COND_ASSIGNMENT_ID
133: )
134: AND not exists
135: (select NULL
136: from LNS_COND_ASSIGNMENTS_TL T
137: where T.cond_assignment_id = x_cond_assignment_id
138: and T.LANGUAGE = L.LANGUAGE_CODE);
139:
140:

Line 193: UPDATE LNS_COND_ASSIGNMENTS_TL SET

189: if (sql%notfound) then
190: raise no_data_found;
191: end if;
192:
193: UPDATE LNS_COND_ASSIGNMENTS_TL SET
194: CONDITION_DESCRIPTION = DECODE(P_CONDITION_DESCRIPTION, NULL, CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
195: ,LAST_UPDATE_DATE = sysdate
196: ,LAST_UPDATED_BY = fnd_global.user_id
197: ,LAST_UPDATE_LOGIN = fnd_global.user_id

Line 213: DELETE FROM LNS_COND_ASSIGNMENTS_TL

209: /* Delete_Row procedure */
210: PROCEDURE Delete_Row(P_COND_ASSIGNMENT_ID IN NUMBER) IS
211: BEGIN
212:
213: DELETE FROM LNS_COND_ASSIGNMENTS_TL
214: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 258: FROM LNS_COND_ASSIGNMENTS_TL

254: CURSOR C_TL IS
255: SELECT
256: CONDITION_DESCRIPTION
257: ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
258: FROM LNS_COND_ASSIGNMENTS_TL
259: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
260: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG)
261: FOR UPDATE of COND_ASSIGNMENT_ID NOWAIT;
262: -- tlinfo C_TL%ROWTYPE;

Line 354: delete from LNS_COND_ASSIGNMENTS_TL T

350:
351: procedure ADD_LANGUAGE
352: is
353: begin
354: delete from LNS_COND_ASSIGNMENTS_TL T
355: where not exists
356: (select NULL
357: from LNS_COND_ASSIGNMENTS B
358: where B.COND_ASSIGNMENT_ID = T.COND_ASSIGNMENT_ID

Line 361: update LNS_COND_ASSIGNMENTS_TL T set (

357: from LNS_COND_ASSIGNMENTS B
358: where B.COND_ASSIGNMENT_ID = T.COND_ASSIGNMENT_ID
359: );
360:
361: update LNS_COND_ASSIGNMENTS_TL T set (
362: CONDITION_DESCRIPTION
363: ) = (select
364: B.CONDITION_DESCRIPTION
365: from LNS_COND_ASSIGNMENTS_TL B

Line 365: from LNS_COND_ASSIGNMENTS_TL B

361: update LNS_COND_ASSIGNMENTS_TL T set (
362: CONDITION_DESCRIPTION
363: ) = (select
364: B.CONDITION_DESCRIPTION
365: from LNS_COND_ASSIGNMENTS_TL B
366: where B.COND_ASSIGNMENT_ID = T.COND_ASSIGNMENT_ID
367: and B.LANGUAGE = T.SOURCE_LANG)
368: where (
369: T.COND_ASSIGNMENT_ID,

Line 374: from LNS_COND_ASSIGNMENTS_TL SUBB, LNS_COND_ASSIGNMENTS_TL SUBT

370: T.LANGUAGE
371: ) in (select
372: SUBT.COND_ASSIGNMENT_ID,
373: SUBT.LANGUAGE
374: from LNS_COND_ASSIGNMENTS_TL SUBB, LNS_COND_ASSIGNMENTS_TL SUBT
375: where SUBB.COND_ASSIGNMENT_ID = SUBT.COND_ASSIGNMENT_ID
376: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
377: and (SUBB.CONDITION_DESCRIPTION <> SUBT.CONDITION_DESCRIPTION
378: or (SUBB.CONDITION_DESCRIPTION is null and SUBT.CONDITION_DESCRIPTION is not null)

Line 382: insert into LNS_COND_ASSIGNMENTS_TL (

378: or (SUBB.CONDITION_DESCRIPTION is null and SUBT.CONDITION_DESCRIPTION is not null)
379: or (SUBB.CONDITION_DESCRIPTION is not null and SUBT.CONDITION_DESCRIPTION is null)
380: ));
381:
382: insert into LNS_COND_ASSIGNMENTS_TL (
383: COND_ASSIGNMENT_ID,
384: CONDITION_DESCRIPTION,
385: LAST_UPDATE_DATE,
386: LAST_UPDATED_BY,

Line 402: from LNS_COND_ASSIGNMENTS_TL B, FND_LANGUAGES L

398: B.CREATED_BY,
399: B.LAST_UPDATE_LOGIN,
400: L.LANGUAGE_CODE,
401: B.SOURCE_LANG
402: from LNS_COND_ASSIGNMENTS_TL B, FND_LANGUAGES L
403: where L.INSTALLED_FLAG in ('I', 'B')
404: and B.LANGUAGE = userenv('LANG')
405: and not exists
406: (select NULL

Line 407: from LNS_COND_ASSIGNMENTS_TL T

403: where L.INSTALLED_FLAG in ('I', 'B')
404: and B.LANGUAGE = userenv('LANG')
405: and not exists
406: (select NULL
407: from LNS_COND_ASSIGNMENTS_TL T
408: where T.COND_ASSIGNMENT_ID = B.COND_ASSIGNMENT_ID
409: and T.LANGUAGE = L.LANGUAGE_CODE);
410:
411: end ADD_LANGUAGE;