APPS.FND_PROFILE_OPTIONS_PKG dependencies on FND_PROFILE_OPTIONS_TL

Line 110: insert into FND_PROFILE_OPTIONS_TL (

106: X_SERVERRESP_ENABLED_FLAG,
107: X_SERVERRESP_UPD_ALLOW_FL
108: );
109:
110: insert into FND_PROFILE_OPTIONS_TL (
111: PROFILE_OPTION_NAME,
112: USER_PROFILE_OPTION_NAME,
113: DESCRIPTION,
114: CREATED_BY,

Line 136: from FND_PROFILE_OPTIONS_TL T

132: from FND_LANGUAGES L
133: where L.INSTALLED_FLAG in ('I', 'B')
134: and not exists
135: (select NULL
136: from FND_PROFILE_OPTIONS_TL T
137: where T.PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME
138: and T.LANGUAGE = L.LANGUAGE_CODE);
139:
140: open c;

Line 347: from FND_PROFILE_OPTIONS_TL

343:
344: cursor c1 is select
345: USER_PROFILE_OPTION_NAME,
346: DESCRIPTION
347: from FND_PROFILE_OPTIONS_TL
348: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME
349: and LANGUAGE = userenv('LANG')
350: for update of PROFILE_OPTION_NAME nowait;
351: tlinfo c1%rowtype;

Line 527: update FND_PROFILE_OPTIONS_TL set

523: if (sql%notfound) then
524: raise no_data_found;
525: end if;
526:
527: update FND_PROFILE_OPTIONS_TL set
528: USER_PROFILE_OPTION_NAME = X_USER_PROFILE_OPTION_NAME,
529: DESCRIPTION = X_DESCRIPTION,
530: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
531: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 944: from FND_PROFILE_OPTIONS_TL

940:
941: begin
942: select LAST_UPDATED_BY, LAST_UPDATE_DATE
943: into db_luby, db_ludate
944: from FND_PROFILE_OPTIONS_TL
945: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME
946: and LANGUAGE = userenv('LANG');
947:
948: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 950: update FND_PROFILE_OPTIONS_TL set

946: and LANGUAGE = userenv('LANG');
947:
948: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
949: db_ludate, X_CUSTOM_MODE)) then
950: update FND_PROFILE_OPTIONS_TL set
951: USER_PROFILE_OPTION_NAME = nvl(x_user_profile_option_name,
952: USER_PROFILE_OPTION_NAME),
953: DESCRIPTION = nvl(x_description, DESCRIPTION),
954: SOURCE_LANG = userenv('LANG'),

Line 1294: delete from FND_PROFILE_OPTIONS_TL

1290: if (sql%notfound) then
1291: raise no_data_found;
1292: end if;
1293:
1294: delete from FND_PROFILE_OPTIONS_TL
1295: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME;
1296:
1297: if (sql%notfound) then
1298: raise no_data_found;

Line 1311: delete from FND_PROFILE_OPTIONS_TL T

1307: /* as a quick workaround to fix the time-consuming table handler issue */
1308: /* Eventually we'll need to turn them into a separate fix_language procedure */
1309: /*
1310:
1311: delete from FND_PROFILE_OPTIONS_TL T
1312: where not exists
1313: (select NULL
1314: from FND_PROFILE_OPTIONS B
1315: where B.PROFILE_OPTION_NAME = T.PROFILE_OPTION_NAME

Line 1318: update FND_PROFILE_OPTIONS_TL T set (

1314: from FND_PROFILE_OPTIONS B
1315: where B.PROFILE_OPTION_NAME = T.PROFILE_OPTION_NAME
1316: );
1317:
1318: update FND_PROFILE_OPTIONS_TL T set (
1319: USER_PROFILE_OPTION_NAME,
1320: DESCRIPTION
1321: ) = (select
1322: B.USER_PROFILE_OPTION_NAME,

Line 1324: from FND_PROFILE_OPTIONS_TL B

1320: DESCRIPTION
1321: ) = (select
1322: B.USER_PROFILE_OPTION_NAME,
1323: B.DESCRIPTION
1324: from FND_PROFILE_OPTIONS_TL B
1325: where B.PROFILE_OPTION_NAME = T.PROFILE_OPTION_NAME
1326: and B.LANGUAGE = T.SOURCE_LANG)
1327: where (
1328: T.PROFILE_OPTION_NAME,

Line 1333: from FND_PROFILE_OPTIONS_TL SUBB, FND_PROFILE_OPTIONS_TL SUBT

1329: T.LANGUAGE
1330: ) in (select
1331: SUBT.PROFILE_OPTION_NAME,
1332: SUBT.LANGUAGE
1333: from FND_PROFILE_OPTIONS_TL SUBB, FND_PROFILE_OPTIONS_TL SUBT
1334: where SUBB.PROFILE_OPTION_NAME = SUBT.PROFILE_OPTION_NAME
1335: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1336: and (SUBB.USER_PROFILE_OPTION_NAME <> SUBT.USER_PROFILE_OPTION_NAME
1337: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 1343: insert into FND_PROFILE_OPTIONS_TL (

1339: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
1340: ));
1341: */
1342:
1343: insert into FND_PROFILE_OPTIONS_TL (
1344: PROFILE_OPTION_NAME,
1345: USER_PROFILE_OPTION_NAME,
1346: DESCRIPTION,
1347: CREATED_BY,

Line 1365: from FND_PROFILE_OPTIONS_TL B, FND_LANGUAGES L

1361: B.LAST_UPDATE_DATE,
1362: B.LAST_UPDATE_LOGIN,
1363: L.LANGUAGE_CODE,
1364: B.SOURCE_LANG
1365: from FND_PROFILE_OPTIONS_TL B, FND_LANGUAGES L
1366: where L.INSTALLED_FLAG in ('I', 'B')
1367: and B.LANGUAGE = userenv('LANG')
1368: and not exists
1369: (select NULL

Line 1370: from FND_PROFILE_OPTIONS_TL T

1366: where L.INSTALLED_FLAG in ('I', 'B')
1367: and B.LANGUAGE = userenv('LANG')
1368: and not exists
1369: (select NULL
1370: from FND_PROFILE_OPTIONS_TL T
1371: where T.PROFILE_OPTION_NAME = B.PROFILE_OPTION_NAME
1372: and T.LANGUAGE = L.LANGUAGE_CODE);
1373: end ADD_LANGUAGE;
1374: