APPS.AK_LOOKUP_CODES_PKG dependencies on AK_LOOKUP_CODES

Line 1: package body AK_LOOKUP_CODES_PKG as

1: package body AK_LOOKUP_CODES_PKG as
2: /* $Header: AKDLKUPB.pls 120.3 2006/01/25 15:57:21 tshort ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_LOOKUP_CODE in VARCHAR2,

Line 14: cursor C is select ROWID from AK_LOOKUP_CODES

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from AK_LOOKUP_CODES
15: where LOOKUP_CODE = X_LOOKUP_CODE
16: and LOOKUP_TYPE = X_LOOKUP_TYPE
17: and LANGUAGE = userenv('LANG')
18: ;

Line 20: insert into AK_LOOKUP_CODES (

16: and LOOKUP_TYPE = X_LOOKUP_TYPE
17: and LANGUAGE = userenv('LANG')
18: ;
19: begin
20: insert into AK_LOOKUP_CODES (
21: LOOKUP_CODE,
22: LOOKUP_TYPE,
23: DESCRIPTION,
24: LAST_UPDATE_DATE,

Line 46: from AK_LOOKUP_CODES T

42: from FND_LANGUAGES L
43: where L.INSTALLED_FLAG in ('I', 'B')
44: and not exists
45: (select NULL
46: from AK_LOOKUP_CODES T
47: where T.LOOKUP_CODE = X_LOOKUP_CODE
48: and T.LOOKUP_TYPE = X_LOOKUP_TYPE
49: and T.LANGUAGE = L.LANGUAGE_CODE);
50:

Line 68: from AK_LOOKUP_CODES

64: X_DESCRIPTION in VARCHAR2
65: ) is
66: cursor c1 is select
67: DESCRIPTION
68: from AK_LOOKUP_CODES
69: where LOOKUP_CODE = X_LOOKUP_CODE
70: and LOOKUP_TYPE = X_LOOKUP_TYPE
71: and LANGUAGE = userenv('LANG')
72: for update of LOOKUP_CODE nowait;

Line 104: update AK_LOOKUP_CODES set

100: X_LAST_UPDATED_BY in NUMBER,
101: X_LAST_UPDATE_LOGIN in NUMBER
102: ) is
103: begin
104: update AK_LOOKUP_CODES set
105: DESCRIPTION = X_DESCRIPTION,
106: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
107: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
108: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 124: delete from AK_LOOKUP_CODES

120: X_LOOKUP_CODE in VARCHAR2,
121: X_LOOKUP_TYPE in VARCHAR2
122: ) is
123: begin
124: delete from AK_LOOKUP_CODES
125: where LOOKUP_CODE = X_LOOKUP_CODE
126: and LOOKUP_TYPE = X_LOOKUP_TYPE;
127:
128: if (sql%notfound) then

Line 143: update AK_LOOKUP_CODES T set (

139: /* as a quick workaround to fix the time-consuming table handler issue */
140: /* Eventually we'll need to turn them into a separate fix_language procedure */
141: /*
142:
143: update AK_LOOKUP_CODES T set (
144: DESCRIPTION
145: ) = (select
146: B.DESCRIPTION
147: from AK_LOOKUP_CODES B

Line 147: from AK_LOOKUP_CODES B

143: update AK_LOOKUP_CODES T set (
144: DESCRIPTION
145: ) = (select
146: B.DESCRIPTION
147: from AK_LOOKUP_CODES B
148: where B.LOOKUP_CODE = T.LOOKUP_CODE
149: and B.LOOKUP_TYPE = T.LOOKUP_TYPE
150: and B.LANGUAGE = T.SOURCE_LANG)
151: where (

Line 159: from AK_LOOKUP_CODES SUBB, AK_LOOKUP_CODES SUBT

155: ) in (select
156: SUBT.LOOKUP_CODE,
157: SUBT.LOOKUP_TYPE,
158: SUBT.LANGUAGE
159: from AK_LOOKUP_CODES SUBB, AK_LOOKUP_CODES SUBT
160: where SUBB.LOOKUP_CODE = SUBT.LOOKUP_CODE
161: and SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
162: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
163: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 170: insert /*+ append parallel(tt) */ into AK_LOOKUP_CODES tt (

166: ));
167:
168: */
169:
170: insert /*+ append parallel(tt) */ into AK_LOOKUP_CODES tt (
171: LOOKUP_CODE,
172: LOOKUP_TYPE,
173: DESCRIPTION,
174: LAST_UPDATE_DATE,

Line 193: from AK_LOOKUP_CODES B, FND_LANGUAGES L

189: B.CREATION_DATE,
190: B.CREATED_BY,
191: L.LANGUAGE_CODE,
192: B.SOURCE_LANG
193: from AK_LOOKUP_CODES B, FND_LANGUAGES L
194: where L.INSTALLED_FLAG in ('I', 'B')
195: and B.LANGUAGE = userenv('LANG')
196: ) v, AK_LOOKUP_CODES T
197: where T.LOOKUP_CODE(+) = v.LOOKUP_CODE

Line 196: ) v, AK_LOOKUP_CODES T

192: B.SOURCE_LANG
193: from AK_LOOKUP_CODES B, FND_LANGUAGES L
194: where L.INSTALLED_FLAG in ('I', 'B')
195: and B.LANGUAGE = userenv('LANG')
196: ) v, AK_LOOKUP_CODES T
197: where T.LOOKUP_CODE(+) = v.LOOKUP_CODE
198: and T.LOOKUP_TYPE(+) = v.LOOKUP_TYPE
199: and T.LANGUAGE(+) = v.LANGUAGE_CODE
200: and T.LOOKUP_CODE is NULL

Line 214: update AK_LOOKUP_CODES set

210: X_LAST_UPDATED_BY in NUMBER,
211: X_LAST_UPDATE_LOGIN in NUMBER
212: ) is
213: begin
214: update AK_LOOKUP_CODES set
215: DESCRIPTION = X_DESCRIPTION,
216: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
217: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
218: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 227: end AK_LOOKUP_CODES_PKG;

223:
224: end TRANSLATE_ROW;
225:
226:
227: end AK_LOOKUP_CODES_PKG;