eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_PROFILE_OPTIONS_PKG dependencies on FND_PROFILE_OPTIONS

Line 1: package body FND_PROFILE_OPTIONS_PKG as

1: package body FND_PROFILE_OPTIONS_PKG as
2: /* $Header: AFPOMPOB.pls 120.4 2008/01/24 16:14:07 pdeluna ship $ */
3:
4: -- ### OVERLOADED!
5: procedure INSERT_ROW (

Line 42: cursor C is select ROWID from FND_PROFILE_OPTIONS

38: X_SERVERRESP_UPD_ALLOW_FL in VARCHAR2
39: ) is
40:
41: L_PROFILE_OPTION_NAME VARCHAR2(80) := UPPER(X_PROFILE_OPTION_NAME);
42: cursor C is select ROWID from FND_PROFILE_OPTIONS
43: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME;
44: begin
45:
46: insert into FND_PROFILE_OPTIONS (

Line 46: insert into FND_PROFILE_OPTIONS (

42: cursor C is select ROWID from FND_PROFILE_OPTIONS
43: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME;
44: begin
45:
46: insert into FND_PROFILE_OPTIONS (
47: APPLICATION_ID,
48: PROFILE_OPTION_ID,
49: PROFILE_OPTION_NAME,
50: WRITE_ALLOWED_FLAG,

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 185: fnd_profile_options_pkg.INSERT_ROW(

181: X_ORG_ENABLED_FLAG in VARCHAR2 default 'N',
182: X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N'
183: ) is
184: begin
185: fnd_profile_options_pkg.INSERT_ROW(
186: X_ROWID => X_ROWID,
187: X_PROFILE_OPTION_NAME => X_PROFILE_OPTION_NAME,
188: X_APPLICATION_ID => X_APPLICATION_ID,
189: X_PROFILE_OPTION_ID => X_PROFILE_OPTION_ID,

Line 251: fnd_profile_options_pkg.LOCK_ROW(

247: X_ORG_ENABLED_FLAG in VARCHAR2 default 'N',
248: X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N'
249: ) is
250: begin
251: fnd_profile_options_pkg.LOCK_ROW(
252: X_PROFILE_OPTION_NAME => X_PROFILE_OPTION_NAME,
253: X_APPLICATION_ID => X_APPLICATION_ID,
254: X_PROFILE_OPTION_ID => X_PROFILE_OPTION_ID,
255: X_WRITE_ALLOWED_FLAG => X_WRITE_ALLOWED_FLAG,

Line 339: from FND_PROFILE_OPTIONS

335: ORG_ENABLED_FLAG,
336: ORG_UPDATE_ALLOWED_FLAG,
337: SERVERRESP_ENABLED_FLAG,
338: SERVERRESP_UPDATE_ALLOWED_FLAG
339: from FND_PROFILE_OPTIONS
340: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME
341: for update of PROFILE_OPTION_NAME nowait;
342: recinfo c%rowtype;
343:

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 493: update FND_PROFILE_OPTIONS set

489: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN,
490: X_MODE => X_HIERARCHY_SWITCH_MODE
491: );
492:
493: update FND_PROFILE_OPTIONS set
494: APPLICATION_ID = X_APPLICATION_ID,
495: PROFILE_OPTION_ID = X_PROFILE_OPTION_ID,
496: WRITE_ALLOWED_FLAG = X_WRITE_ALLOWED_FLAG,
497: READ_ALLOWED_FLAG = X_READ_ALLOWED_FLAG,

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 578: fnd_profile_options_pkg.update_row(

574: ) is
575:
576: begin
577:
578: fnd_profile_options_pkg.update_row(
579: X_PROFILE_OPTION_NAME => X_PROFILE_OPTION_NAME,
580: X_APPLICATION_ID => X_APPLICATION_ID,
581: X_PROFILE_OPTION_ID => X_PROFILE_OPTION_ID,
582: X_WRITE_ALLOWED_FLAG => X_WRITE_ALLOWED_FLAG,

Line 647: fnd_profile_options_pkg.update_row(

643: X_SERVERRESP_ENABLED_FLAG in VARCHAR2,
644: X_SERVERRESP_UPD_ALLOW_FL in VARCHAR2
645: ) is
646: begin
647: fnd_profile_options_pkg.update_row(
648: X_PROFILE_OPTION_NAME => X_PROFILE_OPTION_NAME ,
649: X_APPLICATION_ID => X_APPLICATION_ID ,
650: X_PROFILE_OPTION_ID => X_PROFILE_OPTION_ID ,
651: X_WRITE_ALLOWED_FLAG => X_WRITE_ALLOWED_FLAG ,

Line 748: from FND_PROFILE_OPTIONS_VL

744: SERVERRESP_ENABLED_FLAG,
745: SERVERRESP_UPDATE_ALLOWED_FLAG,
746: USER_PROFILE_OPTION_NAME,
747: DESCRIPTION
748: from FND_PROFILE_OPTIONS_VL
749: where PROFILE_OPTION_NAME=prof_name;
750:
751: profname_val profname_cursor%ROWTYPE;
752: begin

Line 868: FND_PROFILE_OPTIONS_PKG.UPDATE_ROW (

864: end if;
865: end if;
866:
867: -- invoke table handler to update the profile
868: FND_PROFILE_OPTIONS_PKG.UPDATE_ROW (
869: X_PROFILE_OPTION_NAME => prof_name,
870: X_APPLICATION_ID => profname_val.application_id,
871: X_PROFILE_OPTION_ID => profname_val.profile_option_id,
872: X_WRITE_ALLOWED_FLAG => profname_val.WRITE_ALLOWED_FLAG,

Line 909: fnd_profile_options_pkg.translate_row(

905: x_owner in varchar2,
906: x_user_profile_option_name in varchar2,
907: x_description in varchar2) is
908: begin
909: fnd_profile_options_pkg.translate_row(
910: x_profile_name => x_profile_name,
911: x_owner => x_owner,
912: x_user_profile_option_name => x_user_profile_option_name,
913: x_description => x_description,

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 991: fnd_profile_options_pkg.load_row(

987: x_end_date_active in varchar2,
988: x_sql_validation in varchar2)
989: is
990: begin
991: fnd_profile_options_pkg.load_row(
992: x_profile_name => x_profile_name,
993: x_owner => x_owner,
994: x_application_short_name => x_application_short_name,
995: x_user_profile_option_name => x_user_profile_option_name,

Line 1052: fnd_profile_options_pkg.load_row(

1048: x_org_enabled_flag in varchar2,
1049: x_org_update_allowed_flag in varchar2)
1050: is
1051: begin
1052: fnd_profile_options_pkg.load_row(
1053: x_profile_name => x_profile_name,
1054: x_owner => x_owner,
1055: x_application_short_name => x_application_short_name,
1056: x_user_profile_option_name => x_user_profile_option_name,

Line 1193: from FND_PROFILE_OPTIONS

1189:
1190: begin
1191: select PROFILE_OPTION_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
1192: into profo_id, db_luby, db_ludate
1193: from FND_PROFILE_OPTIONS
1194: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME;
1195:
1196: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1197: db_ludate, X_CUSTOM_MODE)) then

Line 1199: fnd_profile_options_pkg.update_row(

1195:
1196: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1197: db_ludate, X_CUSTOM_MODE)) then
1198:
1199: fnd_profile_options_pkg.update_row(
1200: x_profile_option_name=> L_PROFILE_OPTION_NAME,
1201: x_application_id => app_id,
1202: x_profile_option_id => profo_id,
1203: x_write_allowed_flag => x_write_allowed_flag,

Line 1234: select fnd_profile_options_s.nextval

1230:
1231: end if;
1232: exception
1233: when no_data_found then
1234: select fnd_profile_options_s.nextval
1235: into profo_id
1236: from dual;
1237:
1238: fnd_profile_options_pkg.insert_row (

Line 1238: fnd_profile_options_pkg.insert_row (

1234: select fnd_profile_options_s.nextval
1235: into profo_id
1236: from dual;
1237:
1238: fnd_profile_options_pkg.insert_row (
1239: x_rowid => row_id,
1240: x_profile_option_name => L_PROFILE_OPTION_NAME,
1241: x_application_id => app_id,
1242: x_profile_option_id => profo_id,

Line 1287: delete from FND_PROFILE_OPTIONS

1283: -- a dependency to FND_PROFILE_OPTION_VALUES_PKG.
1284: FND_PROFILE_OPTION_VALUES_PKG.DELETE_PROFILE_OPTION_VALUES(
1285: L_PROFILE_OPTION_NAME);
1286:
1287: delete from FND_PROFILE_OPTIONS
1288: where PROFILE_OPTION_NAME = L_PROFILE_OPTION_NAME;
1289:
1290: if (sql%notfound) then
1291: raise no_data_found;

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 1314: from FND_PROFILE_OPTIONS B

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
1316: );
1317:
1318: update FND_PROFILE_OPTIONS_TL T set (

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:

Line 1406: from fnd_profile_options

1402:
1403: BEGIN
1404: select application_id
1405: into db_appl_id
1406: from fnd_profile_options
1407: where profile_option_name = L_PROFILE_OPTION_NAME;
1408:
1409:
1410: if (db_appl_id = x_appl_id) then

Line 1422: result:=Fnd_Dictionary_Pkg.UpdatePKColumns('FND','FND_PROFILE_OPTIONS',

1418: old_val(2) := null;
1419: new_val(0) := x_appl_id;
1420: new_val(1) := x_profile_id;
1421: new_val(2) := null;
1422: result:=Fnd_Dictionary_Pkg.UpdatePKColumns('FND','FND_PROFILE_OPTIONS',
1423: col, old_val, new_val
1424: );
1425: end if;
1426: EXCEPTION

Line 1472: from fnd_profile_options

1468: PRAGMA EXCEPTION_INIT(TAB_NOT_FOUND, -942);
1469: BEGIN
1470: select application_id
1471: into db_appl_id
1472: from fnd_profile_options
1473: where profile_option_name = L_PROFILE_OPTION_NAME;
1474:
1475: begin
1476: SELECT profile_option_application_id

Line 1502: end FND_PROFILE_OPTIONS_PKG;

1498: when no_data_found then
1499: return;
1500: END UPDATE_CAT_OPTIONS_APPL_ID;
1501:
1502: end FND_PROFILE_OPTIONS_PKG;