APPS.FND_STAGE_FN_PARAMETERS_PKG dependencies on FND_STAGE_FN_PARAMETERS_TL

Line 18: cursor C is select ROWID from FND_STAGE_FN_PARAMETERS_TL

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from FND_STAGE_FN_PARAMETERS_TL
19: where APPLICATION_ID = X_APPLICATION_ID
20: and FUNCTION_ID = X_FUNCTION_ID
21: and PARAMETER_ID = X_PARAMETER_ID
22: and LANGUAGE = userenv('LANG')

Line 25: insert into FND_STAGE_FN_PARAMETERS_TL (

21: and PARAMETER_ID = X_PARAMETER_ID
22: and LANGUAGE = userenv('LANG')
23: ;
24: begin
25: insert into FND_STAGE_FN_PARAMETERS_TL (
26: APPLICATION_ID,
27: FUNCTION_ID,
28: PARAMETER_ID,
29: PARAMETER_NAME,

Line 57: from FND_STAGE_FN_PARAMETERS_TL T

53: from FND_LANGUAGES L
54: where L.INSTALLED_FLAG in ('I', 'B')
55: and not exists
56: (select NULL
57: from FND_STAGE_FN_PARAMETERS_TL T
58: where T.APPLICATION_ID = X_APPLICATION_ID
59: and T.FUNCTION_ID = X_FUNCTION_ID
60: and T.PARAMETER_ID = X_PARAMETER_ID
61: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 85: from FND_STAGE_FN_PARAMETERS_TL

81: cursor c1 is select
82: PARAMETER_NAME,
83: USER_PARAMETER_NAME,
84: DESCRIPTION
85: from FND_STAGE_FN_PARAMETERS_TL
86: where APPLICATION_ID = X_APPLICATION_ID
87: and FUNCTION_ID = X_FUNCTION_ID
88: and PARAMETER_ID = X_PARAMETER_ID
89: and LANGUAGE = userenv('LANG')

Line 127: update FND_STAGE_FN_PARAMETERS_TL set

123: X_LAST_UPDATED_BY in NUMBER,
124: X_LAST_UPDATE_LOGIN in NUMBER
125: ) is
126: begin
127: update FND_STAGE_FN_PARAMETERS_TL set
128: PARAMETER_NAME = X_PARAMETER_NAME,
129: USER_PARAMETER_NAME = X_USER_PARAMETER_NAME,
130: DESCRIPTION = X_DESCRIPTION,
131: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 151: delete from FND_STAGE_FN_PARAMETERS_TL

147: X_FUNCTION_ID in NUMBER,
148: X_PARAMETER_ID in NUMBER
149: ) is
150: begin
151: delete from FND_STAGE_FN_PARAMETERS_TL
152: where APPLICATION_ID = X_APPLICATION_ID
153: and FUNCTION_ID = X_FUNCTION_ID
154: and PARAMETER_ID = X_PARAMETER_ID;
155:

Line 170: update FND_STAGE_FN_PARAMETERS_TL T set (

166: /* as a quick workaround to fix the time-consuming table handler issue */
167: /* Eventually we'll need to turn them into a separate fix_language procedure */
168: /*
169:
170: update FND_STAGE_FN_PARAMETERS_TL T set (
171: USER_PARAMETER_NAME,
172: DESCRIPTION
173: ) = (select
174: B.USER_PARAMETER_NAME,

Line 176: from FND_STAGE_FN_PARAMETERS_TL B

172: DESCRIPTION
173: ) = (select
174: B.USER_PARAMETER_NAME,
175: B.DESCRIPTION
176: from FND_STAGE_FN_PARAMETERS_TL B
177: where B.APPLICATION_ID = T.APPLICATION_ID
178: and B.FUNCTION_ID = T.FUNCTION_ID
179: and B.PARAMETER_ID = T.PARAMETER_ID
180: and B.LANGUAGE = T.SOURCE_LANG)

Line 191: from FND_STAGE_FN_PARAMETERS_TL SUBB, FND_STAGE_FN_PARAMETERS_TL SUBT

187: SUBT.APPLICATION_ID,
188: SUBT.FUNCTION_ID,
189: SUBT.PARAMETER_ID,
190: SUBT.LANGUAGE
191: from FND_STAGE_FN_PARAMETERS_TL SUBB, FND_STAGE_FN_PARAMETERS_TL SUBT
192: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
193: and SUBB.FUNCTION_ID = SUBT.FUNCTION_ID
194: and SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
195: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 203: insert into FND_STAGE_FN_PARAMETERS_TL (

199: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
200: ));
201: */
202:
203: insert into FND_STAGE_FN_PARAMETERS_TL (
204: APPLICATION_ID,
205: FUNCTION_ID,
206: PARAMETER_ID,
207: PARAMETER_NAME,

Line 231: from FND_STAGE_FN_PARAMETERS_TL B, FND_LANGUAGES L

227: B.USER_PARAMETER_NAME,
228: B.DESCRIPTION,
229: L.LANGUAGE_CODE,
230: userenv('LANG')
231: from FND_STAGE_FN_PARAMETERS_TL B, FND_LANGUAGES L
232: where L.INSTALLED_FLAG in ('I', 'B')
233: and B.LANGUAGE = userenv('LANG')
234: and not exists
235: (select NULL

Line 236: from FND_STAGE_FN_PARAMETERS_TL T

232: where L.INSTALLED_FLAG in ('I', 'B')
233: and B.LANGUAGE = userenv('LANG')
234: and not exists
235: (select NULL
236: from FND_STAGE_FN_PARAMETERS_TL T
237: where T.APPLICATION_ID = B.APPLICATION_ID
238: and T.FUNCTION_ID = B.FUNCTION_ID
239: and T.PARAMETER_ID = B.PARAMETER_ID
240: and T.LANGUAGE = L.LANGUAGE_CODE);