APPS.GMA_SY_TEXT_TKN_PKG dependencies on SY_TEXT_TKN_TL

Line 15: cursor C is select ROWID from SY_TEXT_TKN_TL

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from SY_TEXT_TKN_TL
16: where TEXT_KEY = X_TEXT_KEY
17: and LANG_CODE = X_LANG_CODE
18: and LANGUAGE = userenv('LANG')
19: ;

Line 21: insert into SY_TEXT_TKN_TL (

17: and LANG_CODE = X_LANG_CODE
18: and LANGUAGE = userenv('LANG')
19: ;
20: begin
21: insert into SY_TEXT_TKN_TL (
22: TEXT_KEY,
23: LANG_CODE,
24: TEXT_CODE,
25: TOKEN_DESC,

Line 49: from SY_TEXT_TKN_TL T

45: from FND_LANGUAGES L
46: where L.INSTALLED_FLAG in ('I', 'B')
47: and not exists
48: (select NULL
49: from SY_TEXT_TKN_TL T
50: where T.TEXT_KEY = X_TEXT_KEY
51: and T.LANG_CODE = X_LANG_CODE
52: and T.LANGUAGE = L.LANGUAGE_CODE);
53:

Line 74: from SY_TEXT_TKN_TL

70: cursor c1 is select
71: TEXT_CODE,
72: TOKEN_DESC,
73: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
74: from SY_TEXT_TKN_TL
75: where TEXT_KEY = X_TEXT_KEY
76: and LANG_CODE = X_LANG_CODE
77: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
78: for update of TEXT_KEY nowait;

Line 106: update SY_TEXT_TKN_TL set

102: X_LAST_UPDATED_BY in NUMBER,
103: X_LAST_UPDATE_LOGIN in NUMBER
104: ) is
105: begin
106: update SY_TEXT_TKN_TL set
107: TEXT_CODE = X_TEXT_CODE,
108: TOKEN_DESC = X_TOKEN_DESC,
109: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
110: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 127: delete from SY_TEXT_TKN_TL

123: X_TEXT_KEY in VARCHAR2,
124: X_LANG_CODE in VARCHAR2
125: ) is
126: begin
127: delete from SY_TEXT_TKN_TL
128: where TEXT_KEY = X_TEXT_KEY
129: and LANG_CODE = X_LANG_CODE;
130:
131: if (sql%notfound) then

Line 140: update SY_TEXT_TKN_TL T set (

136:
137: procedure ADD_LANGUAGE
138: is
139: begin
140: update SY_TEXT_TKN_TL T set (
141: TOKEN_DESC
142: ) = (select
143: B.TOKEN_DESC
144: from SY_TEXT_TKN_TL B

Line 144: from SY_TEXT_TKN_TL B

140: update SY_TEXT_TKN_TL T set (
141: TOKEN_DESC
142: ) = (select
143: B.TOKEN_DESC
144: from SY_TEXT_TKN_TL B
145: where B.TEXT_KEY = T.TEXT_KEY
146: and B.LANG_CODE = T.LANG_CODE
147: and B.LANGUAGE = T.SOURCE_LANG)
148: where (

Line 156: from SY_TEXT_TKN_TL SUBB, SY_TEXT_TKN_TL SUBT

152: ) in (select
153: SUBT.TEXT_KEY,
154: SUBT.LANG_CODE,
155: SUBT.LANGUAGE
156: from SY_TEXT_TKN_TL SUBB, SY_TEXT_TKN_TL SUBT
157: where SUBB.TEXT_KEY = SUBT.TEXT_KEY
158: and SUBB.LANG_CODE = SUBT.LANG_CODE
159: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
160: and (SUBB.TOKEN_DESC <> SUBT.TOKEN_DESC

Line 163: insert into SY_TEXT_TKN_TL (

159: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
160: and (SUBB.TOKEN_DESC <> SUBT.TOKEN_DESC
161: ));
162:
163: insert into SY_TEXT_TKN_TL (
164: TEXT_KEY,
165: LANG_CODE,
166: TEXT_CODE,
167: TOKEN_DESC,

Line 187: from SY_TEXT_TKN_TL B, FND_LANGUAGES L

183: B.LAST_UPDATED_BY,
184: B.LAST_UPDATE_LOGIN,
185: L.LANGUAGE_CODE,
186: B.SOURCE_LANG
187: from SY_TEXT_TKN_TL B, FND_LANGUAGES L
188: where L.INSTALLED_FLAG in ('I', 'B')
189: and B.LANGUAGE = userenv('LANG')
190: and not exists
191: (select NULL

Line 192: from SY_TEXT_TKN_TL T

188: where L.INSTALLED_FLAG in ('I', 'B')
189: and B.LANGUAGE = userenv('LANG')
190: and not exists
191: (select NULL
192: from SY_TEXT_TKN_TL T
193: where T.TEXT_KEY = B.TEXT_KEY
194: and T.LANG_CODE = B.LANG_CODE
195: and T.LANGUAGE = L.LANGUAGE_CODE);
196: end ADD_LANGUAGE;

Line 208: update SY_TEXT_TKN_TL set

204: X_OWNER in VARCHAR2
205: ) IS
206: BEGIN
207:
208: update SY_TEXT_TKN_TL set
209: TEXT_CODE = X_TEXT_CODE,
210: TOKEN_DESC = X_TOKEN_DESC,
211: SOURCE_LANG = userenv('LANG'),
212: LAST_UPDATE_DATE = sysdate,

Line 236: FROM SY_TEXT_TKN_TL

232: l_user_id :=1;
233: END IF;
234:
235: SELECT text_key into l_text_key
236: FROM SY_TEXT_TKN_TL
237: WHERE TEXT_KEY = X_TEXT_KEY;
238:
239:
240: GMA_SY_TEXT_TKN_PKG.UPDATE_ROW ( X_TEXT_KEY => X_TEXT_KEY,