APPS.FND_REQUEST_SET_STAGES_PKG dependencies on FND_REQUEST_SET_STAGES_TL

Line 85: insert into FND_REQUEST_SET_STAGES_TL (

81: X_LAST_UPDATED_BY,
82: X_LAST_UPDATE_LOGIN
83: );
84:
85: insert into FND_REQUEST_SET_STAGES_TL (
86: SET_APPLICATION_ID,
87: REQUEST_SET_ID,
88: REQUEST_SET_STAGE_ID,
89: CREATION_DATE,

Line 115: from FND_REQUEST_SET_STAGES_TL T

111: from FND_LANGUAGES L
112: where L.INSTALLED_FLAG in ('I', 'B')
113: and not exists
114: (select NULL
115: from FND_REQUEST_SET_STAGES_TL T
116: where T.REQUEST_SET_ID = X_REQUEST_SET_ID
117: and T.SET_APPLICATION_ID = X_SET_APPLICATION_ID
118: and T.REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 177: from FND_REQUEST_SET_STAGES_TL

173:
174: cursor c1 is select
175: USER_STAGE_NAME,
176: DESCRIPTION
177: from FND_REQUEST_SET_STAGES_TL
178: where REQUEST_SET_ID = X_REQUEST_SET_ID
179: and SET_APPLICATION_ID = X_SET_APPLICATION_ID
180: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID
181: and LANGUAGE = userenv('LANG')

Line 295: update FND_REQUEST_SET_STAGES_TL set

291: if (sql%notfound) then
292: raise no_data_found;
293: end if;
294:
295: update FND_REQUEST_SET_STAGES_TL set
296: USER_STAGE_NAME = X_USER_STAGE_NAME,
297: DESCRIPTION = X_DESCRIPTION,
298: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
299: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 446: delete from FND_REQUEST_SET_STAGES_TL

442: if (sql%notfound) then
443: raise no_data_found;
444: end if;
445:
446: delete from FND_REQUEST_SET_STAGES_TL
447: where SET_APPLICATION_ID = X_SET_APPLICATION_ID
448: and REQUEST_SET_ID = X_REQUEST_SET_ID
449: and REQUEST_SET_STAGE_ID = X_REQUEST_SET_STAGE_ID;
450:

Line 466: delete from FND_REQUEST_SET_STAGES_TL T

462: /* as a quick workaround to fix the time-consuming table handler issue */
463: /* Eventually we'll need to turn them into a separate fix_language procedure */
464: /*
465:
466: delete from FND_REQUEST_SET_STAGES_TL T
467: where not exists
468: (select NULL
469: from FND_REQUEST_SET_STAGES B
470: where B.REQUEST_SET_ID = T.REQUEST_SET_ID

Line 475: update FND_REQUEST_SET_STAGES_TL T set (

471: and B.SET_APPLICATION_ID = T.SET_APPLICATION_ID
472: and B.REQUEST_SET_STAGE_ID = T.REQUEST_SET_STAGE_ID
473: );
474:
475: update FND_REQUEST_SET_STAGES_TL T set (
476: USER_STAGE_NAME,
477: DESCRIPTION
478: ) = (select
479: B.USER_STAGE_NAME,

Line 481: from FND_REQUEST_SET_STAGES_TL B

477: DESCRIPTION
478: ) = (select
479: B.USER_STAGE_NAME,
480: B.DESCRIPTION
481: from FND_REQUEST_SET_STAGES_TL B
482: where B.REQUEST_SET_ID = T.REQUEST_SET_ID
483: and B.SET_APPLICATION_ID = T.SET_APPLICATION_ID
484: and B.REQUEST_SET_STAGE_ID = T.REQUEST_SET_STAGE_ID
485: and B.LANGUAGE = T.SOURCE_LANG)

Line 496: from FND_REQUEST_SET_STAGES_TL SUBB, FND_REQUEST_SET_STAGES_TL SUBT

492: SUBT.REQUEST_SET_ID,
493: SUBT.SET_APPLICATION_ID,
494: SUBT.REQUEST_SET_STAGE_ID,
495: SUBT.LANGUAGE
496: from FND_REQUEST_SET_STAGES_TL SUBB, FND_REQUEST_SET_STAGES_TL SUBT
497: where SUBB.REQUEST_SET_ID = SUBT.REQUEST_SET_ID
498: and SUBB.SET_APPLICATION_ID = SUBT.SET_APPLICATION_ID
499: and SUBB.REQUEST_SET_STAGE_ID = SUBT.REQUEST_SET_STAGE_ID
500: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 508: insert into FND_REQUEST_SET_STAGES_TL (

504: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
505: ));
506: */
507:
508: insert into FND_REQUEST_SET_STAGES_TL (
509: SET_APPLICATION_ID,
510: REQUEST_SET_ID,
511: REQUEST_SET_STAGE_ID,
512: CREATION_DATE,

Line 534: from FND_REQUEST_SET_STAGES_TL B, FND_LANGUAGES L

530: B.USER_STAGE_NAME,
531: B.DESCRIPTION,
532: L.LANGUAGE_CODE,
533: B.SOURCE_LANG
534: from FND_REQUEST_SET_STAGES_TL B, FND_LANGUAGES L
535: where L.INSTALLED_FLAG in ('I', 'B')
536: and B.LANGUAGE = userenv('LANG')
537: and not exists
538: (select NULL

Line 539: from FND_REQUEST_SET_STAGES_TL T

535: where L.INSTALLED_FLAG in ('I', 'B')
536: and B.LANGUAGE = userenv('LANG')
537: and not exists
538: (select NULL
539: from FND_REQUEST_SET_STAGES_TL T
540: where T.REQUEST_SET_ID = B.REQUEST_SET_ID
541: and T.SET_APPLICATION_ID = B.SET_APPLICATION_ID
542: and T.REQUEST_SET_STAGE_ID = B.REQUEST_SET_STAGE_ID
543: and T.LANGUAGE = L.LANGUAGE_CODE);