APPS.FND_FLEXBUILDER_PARAMS_PKG dependencies on FND_FLEXBUILDER_PARAMS_TL

Line 100: insert into FND_FLEXBUILDER_PARAMS_TL (

96: X_LAST_UPDATED_BY,
97: X_LAST_UPDATE_LOGIN
98: );
99:
100: insert into FND_FLEXBUILDER_PARAMS_TL (
101: APPLICATION_ID,
102: FUNCTION_CODE,
103: SEQUENCE,
104: PARAMETER_NAME,

Line 130: from FND_FLEXBUILDER_PARAMS_TL T

126: from FND_LANGUAGES L
127: where L.INSTALLED_FLAG in ('I', 'B')
128: and not exists
129: (select NULL
130: from FND_FLEXBUILDER_PARAMS_TL T
131: where T.APPLICATION_ID = X_APPLICATION_ID
132: and T.FUNCTION_CODE = X_FUNCTION_CODE
133: and T.SEQUENCE = X_SEQUENCE
134: and T.PARAMETER_NAME = X_PARAMETER_NAME

Line 201: from FND_FLEXBUILDER_PARAMS_TL

197: recinfo c%rowtype;
198:
199: cursor c1 is select
200: USER_PARAMETER_NAME
201: from FND_FLEXBUILDER_PARAMS_TL
202: where APPLICATION_ID = X_APPLICATION_ID
203: and FUNCTION_CODE = X_FUNCTION_CODE
204: and SEQUENCE = X_SEQUENCE
205: and PARAMETER_NAME = X_PARAMETER_NAME

Line 337: update FND_FLEXBUILDER_PARAMS_TL set

333: if (sql%notfound) then
334: raise no_data_found;
335: end if;
336:
337: update FND_FLEXBUILDER_PARAMS_TL set
338: USER_PARAMETER_NAME = X_USER_PARAMETER_NAME,
339: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
340: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
341: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 371: delete from FND_FLEXBUILDER_PARAMS_TL

367: if (sql%notfound) then
368: raise no_data_found;
369: end if;
370:
371: delete from FND_FLEXBUILDER_PARAMS_TL
372: where APPLICATION_ID = X_APPLICATION_ID
373: and FUNCTION_CODE = X_FUNCTION_CODE
374: and SEQUENCE = X_SEQUENCE
375: and PARAMETER_NAME = X_PARAMETER_NAME;

Line 391: delete from FND_FLEXBUILDER_PARAMS_TL T

387: /* as a quick workaround to fix the time-consuming table handler issue */
388: /* Eventually we'll need to turn them into a separate fix_language procedure */
389: /*
390:
391: delete from FND_FLEXBUILDER_PARAMS_TL T
392: where not exists
393: (select NULL
394: from FND_FLEXBUILDER_PARAMETERS B
395: where B.APPLICATION_ID = T.APPLICATION_ID

Line 401: update FND_FLEXBUILDER_PARAMS_TL T set (

397: and B.SEQUENCE = T.SEQUENCE
398: and B.PARAMETER_NAME = T.PARAMETER_NAME
399: );
400:
401: update FND_FLEXBUILDER_PARAMS_TL T set (
402: USER_PARAMETER_NAME
403: ) = (select
404: B.USER_PARAMETER_NAME
405: from FND_FLEXBUILDER_PARAMS_TL B

Line 405: from FND_FLEXBUILDER_PARAMS_TL B

401: update FND_FLEXBUILDER_PARAMS_TL T set (
402: USER_PARAMETER_NAME
403: ) = (select
404: B.USER_PARAMETER_NAME
405: from FND_FLEXBUILDER_PARAMS_TL B
406: where B.APPLICATION_ID = T.APPLICATION_ID
407: and B.FUNCTION_CODE = T.FUNCTION_CODE
408: and B.SEQUENCE = T.SEQUENCE
409: and B.PARAMETER_NAME = T.PARAMETER_NAME

Line 423: from FND_FLEXBUILDER_PARAMS_TL SUBB, FND_FLEXBUILDER_PARAMS_TL SUBT

419: SUBT.FUNCTION_CODE,
420: SUBT.SEQUENCE,
421: SUBT.PARAMETER_NAME,
422: SUBT.LANGUAGE
423: from FND_FLEXBUILDER_PARAMS_TL SUBB, FND_FLEXBUILDER_PARAMS_TL SUBT
424: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
425: and SUBB.FUNCTION_CODE = SUBT.FUNCTION_CODE
426: and SUBB.SEQUENCE = SUBT.SEQUENCE
427: and SUBB.PARAMETER_NAME = SUBT.PARAMETER_NAME

Line 433: insert into FND_FLEXBUILDER_PARAMS_TL (

429: and (SUBB.USER_PARAMETER_NAME <> SUBT.USER_PARAMETER_NAME
430: ));
431: */
432:
433: insert into FND_FLEXBUILDER_PARAMS_TL (
434: APPLICATION_ID,
435: FUNCTION_CODE,
436: SEQUENCE,
437: PARAMETER_NAME,

Line 459: from FND_FLEXBUILDER_PARAMS_TL B, FND_LANGUAGES L

455: B.CREATED_BY,
456: B.LAST_UPDATE_LOGIN,
457: L.LANGUAGE_CODE,
458: B.SOURCE_LANG
459: from FND_FLEXBUILDER_PARAMS_TL B, FND_LANGUAGES L
460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL

Line 464: from FND_FLEXBUILDER_PARAMS_TL T

460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL
464: from FND_FLEXBUILDER_PARAMS_TL T
465: where T.APPLICATION_ID = B.APPLICATION_ID
466: and T.FUNCTION_CODE = B.FUNCTION_CODE
467: and T.SEQUENCE = B.SEQUENCE
468: and T.PARAMETER_NAME = B.PARAMETER_NAME