eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_COND_ASSIGNMENTS_PKG dependencies on LNS_COND_ASSIGNMENTS

Line 1: PACKAGE BODY LNS_COND_ASSIGNMENTS_PKG AS

1: PACKAGE BODY LNS_COND_ASSIGNMENTS_PKG AS
2: /* $Header: LNS_CASGM_TBLH_B.pls 120.2.12010000.4 2008/08/29 20:12:06 mbolli ship $ */
3:
4: /* Insert_Row procedure */
5: PROCEDURE Insert_Row(

Line 27: SELECT ROWID FROM LNS_COND_ASSIGNMENTS

23: ,P_DELETE_DISABLED_FLAG IN VARCHAR2
24: ) IS
25:
26: CURSOR l_insert is
27: SELECT ROWID FROM LNS_COND_ASSIGNMENTS
28: WHERE COND_ASSIGNMENT_ID = X_COND_ASSIGNMENT_ID ;
29:
30: l_rowid varchar2(2000);
31:

Line 33: INSERT INTO LNS_COND_ASSIGNMENTS

29:
30: l_rowid varchar2(2000);
31:
32: BEGIN
33: INSERT INTO LNS_COND_ASSIGNMENTS
34: (
35: COND_ASSIGNMENT_ID
36: ,LOAN_ID
37: ,CONDITION_ID

Line 53: DECODE(X_COND_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_COND_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_COND_ASSIGNMENTS_S.NEXTVAL, X_COND_ASSIGNMENT_ID)

49: ,END_DATE_ACTIVE
50: ,DISB_HEADER_ID
51: ,DELETE_DISABLED_FLAG
52: ) VALUES (
53: DECODE(X_COND_ASSIGNMENT_ID, FND_API.G_MISS_NUM, LNS_COND_ASSIGNMENTS_S.NEXTVAL, NULL, LNS_COND_ASSIGNMENTS_S.NEXTVAL, X_COND_ASSIGNMENT_ID)
54: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
55: ,DECODE(P_CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
56: ,DECODE(P_CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
57: ,DECODE(P_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)

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 131: SELECT CONDITION_ID FROM LNS_COND_ASSIGNMENTS

127: where L.INSTALLED_FLAG in ('I', 'B')
128: and L.LANGUAGE_CODE <> userenv('LANG')
129: AND SourceTL.language = L.LANGUAGE_CODE
130: AND SourceTL.CONDITION_ID = (
131: SELECT CONDITION_ID FROM LNS_COND_ASSIGNMENTS
132: WHERE COND_ASSIGNMENT_ID = X_COND_ASSIGNMENT_ID
133: )
134: AND not exists
135: (select NULL

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 172: UPDATE LNS_COND_ASSIGNMENTS SET

168: ,P_DISB_HEADER_ID IN NUMBER
169: ,P_DELETE_DISABLED_FLAG IN VARCHAR2
170: ) IS
171: BEGIN
172: UPDATE LNS_COND_ASSIGNMENTS SET
173: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
174: ,CONDITION_ID = DECODE(P_CONDITION_ID, NULL, CONDITION_ID, FND_API.G_MISS_NUM, NULL, P_CONDITION_ID)
175: ,CONDITION_MET_FLAG = DECODE(P_CONDITION_MET_FLAG, NULL, CONDITION_MET_FLAG, FND_API.G_MISS_CHAR, NULL, P_CONDITION_MET_FLAG)
176: ,MANDATORY_FLAG = DECODE(P_MANDATORY_FLAG, NULL, MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, P_MANDATORY_FLAG)

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 220: DELETE FROM LNS_COND_ASSIGNMENTS

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: DELETE FROM LNS_COND_ASSIGNMENTS
221: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 249: CURSOR C IS SELECT * FROM LNS_COND_ASSIGNMENTS

245: ,P_END_DATE_ACTIVE IN DATE
246: ,P_DISB_HEADER_ID IN NUMBER
247: ,P_DELETE_DISABLED_FLAG IN VARCHAR2
248: ) IS
249: CURSOR C IS SELECT * FROM LNS_COND_ASSIGNMENTS
250: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
251: FOR UPDATE of COND_ASSIGNMENT_ID NOWAIT;
252: Recinfo C%ROWTYPE;
253:

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 357: from LNS_COND_ASSIGNMENTS B

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
359: );
360:
361: update LNS_COND_ASSIGNMENTS_TL T set (

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;