APPS.FND_CONCURRENT_PROGRAMS_PKG dependencies on FND_CONCURRENT_PROGRAMS_TL

Line 171: insert into FND_CONCURRENT_PROGRAMS_TL (

167: X_MULTI_ORG_CATEGORY
168: );
169:
170:
171: insert into FND_CONCURRENT_PROGRAMS_TL (
172: APPLICATION_ID,
173: CONCURRENT_PROGRAM_ID,
174: USER_CONCURRENT_PROGRAM_NAME,
175: CREATION_DATE,

Line 199: from FND_CONCURRENT_PROGRAMS_TL T

195: from FND_LANGUAGES L
196: where L.INSTALLED_FLAG in ('I', 'B')
197: and not exists
198: (select NULL
199: from FND_CONCURRENT_PROGRAMS_TL T
200: where T.APPLICATION_ID = X_APPLICATION_ID
201: and T.CONCURRENT_PROGRAM_ID = X_CONCURRENT_PROGRAM_ID
202: and T.LANGUAGE = L.LANGUAGE_CODE);
203:

Line 320: from FND_CONCURRENT_PROGRAMS_TL

316: cursor c1 is select
317: USER_CONCURRENT_PROGRAM_NAME,
318: DESCRIPTION,
319: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
320: from FND_CONCURRENT_PROGRAMS_TL
321: where APPLICATION_ID = X_APPLICATION_ID
322: and CONCURRENT_PROGRAM_ID = X_CONCURRENT_PROGRAM_ID
323: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
324: for update of APPLICATION_ID nowait;

Line 540: update FND_CONCURRENT_PROGRAMS_TL set

536: if (sql%notfound) then
537: raise no_data_found;
538: end if;
539:
540: update FND_CONCURRENT_PROGRAMS_TL set
541: USER_CONCURRENT_PROGRAM_NAME = X_USER_CONCURRENT_PROGRAM_NAME,
542: DESCRIPTION = X_DESCRIPTION,
543: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
544: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 613: from FND_CONCURRENT_PROGRAMS_TL

609:
610: begin
611: select LAST_UPDATED_BY, LAST_UPDATE_DATE
612: into db_luby, db_ludate
613: from FND_CONCURRENT_PROGRAMS_TL
614: where APPLICATION_ID = app_id
615: and CONCURRENT_PROGRAM_ID = key_id
616: and LANGUAGE = userenv('LANG');
617:

Line 630: update FND_CONCURRENT_PROGRAMS_TL set

626: p_db_id => db_luby,
627: p_db_lud => db_ludate,
628: p_custom_mode => x_custom_mode))
629: then
630: update FND_CONCURRENT_PROGRAMS_TL set
631: USER_CONCURRENT_PROGRAM_NAME =
632: nvl(x_user_concurrent_program_name, USER_CONCURRENT_PROGRAM_NAME),
633: DESCRIPTION = nvl(x_description, DESCRIPTION),
634: SOURCE_LANG = userenv('LANG'),

Line 994: update fnd_concurrent_programs_tl set

990:
991: where APPLICATION_ID = app_id
992: and CONCURRENT_PROGRAM_ID = key_id;
993:
994: update fnd_concurrent_programs_tl set
995: source_lang=userenv('LANG'),
996: USER_CONCURRENT_PROGRAM_NAME =
997: nvl(x_user_concurrent_program_name, USER_CONCURRENT_PROGRAM_NAME),
998: DESCRIPTION = nvl(x_description, DESCRIPTION),

Line 1078: insert into FND_CONCURRENT_PROGRAMS_TL

1074: x_template_appl_short_name, x_template_code,
1075: x_multi_org_category
1076: from DUAL;
1077:
1078: insert into FND_CONCURRENT_PROGRAMS_TL
1079: (CONCURRENT_PROGRAM_ID, APPLICATION_ID, CREATION_DATE,
1080: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1081: LAST_UPDATE_LOGIN, DESCRIPTION,USER_CONCURRENT_PROGRAM_NAME,
1082: LANGUAGE, SOURCE_LANG)

Line 1091: from FND_CONCURRENT_PROGRAMS_TL T

1087: from FND_LANGUAGES L
1088: where L.INSTALLED_FLAG in ('I', 'B')
1089: and not exists
1090: (select NULL
1091: from FND_CONCURRENT_PROGRAMS_TL T
1092: where T.APPLICATION_ID = app_id
1093: and T.CONCURRENT_PROGRAM_ID =key_id
1094: and T.LANGUAGE = L.LANGUAGE_CODE);
1095:

Line 1108: delete from FND_CONCURRENT_PROGRAMS_TL T

1104: /* The following delete and update statements are commented out */
1105: /* as a quick workaround to fix the time-consuming table handler issue */
1106: /* Eventually we'll need to turn them into a separate fix_language procedure */
1107: /*
1108: delete from FND_CONCURRENT_PROGRAMS_TL T
1109: where not exists
1110: (select NULL
1111: from FND_CONCURRENT_PROGRAMS B
1112: where B.APPLICATION_ID = T.APPLICATION_ID

Line 1116: update FND_CONCURRENT_PROGRAMS_TL T set (

1112: where B.APPLICATION_ID = T.APPLICATION_ID
1113: and B.CONCURRENT_PROGRAM_ID = T.CONCURRENT_PROGRAM_ID
1114: );
1115:
1116: update FND_CONCURRENT_PROGRAMS_TL T set (
1117: USER_CONCURRENT_PROGRAM_NAME,
1118: DESCRIPTION
1119: ) = (select
1120: B.USER_CONCURRENT_PROGRAM_NAME,

Line 1122: from FND_CONCURRENT_PROGRAMS_TL B

1118: DESCRIPTION
1119: ) = (select
1120: B.USER_CONCURRENT_PROGRAM_NAME,
1121: B.DESCRIPTION
1122: from FND_CONCURRENT_PROGRAMS_TL B
1123: where B.APPLICATION_ID = T.APPLICATION_ID
1124: and B.CONCURRENT_PROGRAM_ID = T.CONCURRENT_PROGRAM_ID
1125: and B.LANGUAGE = T.SOURCE_LANG)
1126: where (

Line 1134: from FND_CONCURRENT_PROGRAMS_TL SUBB, FND_CONCURRENT_PROGRAMS_TL SUBT

1130: ) in (select
1131: SUBT.APPLICATION_ID,
1132: SUBT.CONCURRENT_PROGRAM_ID,
1133: SUBT.LANGUAGE
1134: from FND_CONCURRENT_PROGRAMS_TL SUBB, FND_CONCURRENT_PROGRAMS_TL SUBT
1135: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
1136: and SUBB.CONCURRENT_PROGRAM_ID = SUBT.CONCURRENT_PROGRAM_ID
1137: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1138: and (SUBB.USER_CONCURRENT_PROGRAM_NAME <> SUBT.USER_CONCURRENT_PROGRAM_NAME

Line 1145: insert into FND_CONCURRENT_PROGRAMS_TL (

1141: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
1142: ));
1143: */
1144:
1145: insert into FND_CONCURRENT_PROGRAMS_TL (
1146: APPLICATION_ID,
1147: CONCURRENT_PROGRAM_ID,
1148: USER_CONCURRENT_PROGRAM_NAME,
1149: CREATION_DATE,

Line 1169: from FND_CONCURRENT_PROGRAMS_TL B, FND_LANGUAGES L

1165: B.LAST_UPDATE_LOGIN,
1166: B.DESCRIPTION,
1167: L.LANGUAGE_CODE,
1168: B.SOURCE_LANG
1169: from FND_CONCURRENT_PROGRAMS_TL B, FND_LANGUAGES L
1170: where L.INSTALLED_FLAG in ('I', 'B')
1171: and B.LANGUAGE = userenv('LANG')
1172: and not exists
1173: (select NULL

Line 1174: from FND_CONCURRENT_PROGRAMS_TL T

1170: where L.INSTALLED_FLAG in ('I', 'B')
1171: and B.LANGUAGE = userenv('LANG')
1172: and not exists
1173: (select NULL
1174: from FND_CONCURRENT_PROGRAMS_TL T
1175: where T.APPLICATION_ID = B.APPLICATION_ID
1176: and T.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID
1177: and T.LANGUAGE = L.LANGUAGE_CODE);
1178: end ADD_LANGUAGE;