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_FORM_FUNCTIONS_PKG dependencies on FND_FORM_FUNCTIONS

Line 1: package body FND_FORM_FUNCTIONS_PKG as

1: package body FND_FORM_FUNCTIONS_PKG as
2: /* $Header: AFFMFUNB.pls 120.2 2006/02/17 09:19:42 jvalenti ship $ */
3:
4: -- private
5: function FUNCTION_VALIDATION (application_id in out nocopy number,

Line 536: fnd_form_functions_pkg.INSERT_ROW(

532: X_LAST_UPDATED_BY in NUMBER,
533: X_LAST_UPDATE_LOGIN in NUMBER
534: ) is
535: begin
536: fnd_form_functions_pkg.INSERT_ROW(
537: X_ROWID => X_ROWID,
538: X_FUNCTION_ID => X_FUNCTION_ID,
539: X_WEB_HOST_NAME => X_WEB_HOST_NAME,
540: X_WEB_AGENT_NAME => X_WEB_AGENT_NAME,

Line 585: fnd_form_functions_pkg.LOCK_ROW(

581: X_USER_FUNCTION_NAME in VARCHAR2,
582: X_DESCRIPTION in VARCHAR2
583: ) is
584: begin
585: fnd_form_functions_pkg.LOCK_ROW(
586: X_FUNCTION_ID => X_FUNCTION_ID,
587: X_WEB_HOST_NAME => X_WEB_HOST_NAME,
588: X_WEB_AGENT_NAME => X_WEB_AGENT_NAME,
589: X_WEB_HTML_CALL => X_WEB_HTML_CALL,

Line 632: fnd_form_functions_pkg.UPDATE_ROW(

628: X_LAST_UPDATED_BY in NUMBER,
629: X_LAST_UPDATE_LOGIN in NUMBER
630: ) is
631: begin
632: fnd_form_functions_pkg.UPDATE_ROW(
633: X_FUNCTION_ID => X_FUNCTION_ID,
634: X_WEB_HOST_NAME => X_WEB_HOST_NAME,
635: X_WEB_AGENT_NAME => X_WEB_AGENT_NAME,
636: X_WEB_HTML_CALL => X_WEB_HTML_CALL,

Line 680: fnd_form_functions_pkg.LOAD_ROW (

676: X_OWNER in VARCHAR2,
677: X_CUSTOM_MODE in VARCHAR2
678: ) is
679: begin
680: fnd_form_functions_pkg.LOAD_ROW (
681: X_FUNCTION_NAME => X_FUNCTION_NAME,
682: X_APPLICATION_SHORT_NAME => X_APPLICATION_SHORT_NAME,
683: X_FORM_NAME => X_FORM_NAME,
684: X_PARAMETERS => X_PARAMETERS,

Line 861: from fnd_form_functions

857: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
858:
859: select function_id, last_updated_by, last_update_date
860: into fun_id, db_luby, db_ludate
861: from fnd_form_functions
862: where function_name = X_FUNCTION_NAME;
863:
864: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
865: db_ludate, X_CUSTOM_MODE)) then

Line 866: fnd_form_functions_pkg.UPDATE_ROW (

862: where function_name = X_FUNCTION_NAME;
863:
864: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
865: db_ludate, X_CUSTOM_MODE)) then
866: fnd_form_functions_pkg.UPDATE_ROW (
867: X_FUNCTION_ID => fun_id,
868: X_WEB_HOST_NAME => l_WEB_HOST_NAME,
869: X_WEB_AGENT_NAME => l_WEB_AGENT_NAME,
870: X_WEB_HTML_CALL => l_WEB_HTML_CALL,

Line 895: select fnd_form_functions_s.nextval into fun_id from dual;

891:
892: exception
893: when NO_DATA_FOUND then
894:
895: select fnd_form_functions_s.nextval into fun_id from dual;
896:
897: fnd_form_functions_pkg.INSERT_ROW(
898: X_ROWID => row_id,
899: X_FUNCTION_ID => fun_id,

Line 897: fnd_form_functions_pkg.INSERT_ROW(

893: when NO_DATA_FOUND then
894:
895: select fnd_form_functions_s.nextval into fun_id from dual;
896:
897: fnd_form_functions_pkg.INSERT_ROW(
898: X_ROWID => row_id,
899: X_FUNCTION_ID => fun_id,
900: X_WEB_HOST_NAME => l_WEB_HOST_NAME,
901: X_WEB_AGENT_NAME => l_WEB_AGENT_NAME,

Line 930: delete from FND_FORM_FUNCTIONS

926: procedure DELETE_ROW (
927: X_FUNCTION_ID in NUMBER
928: ) is
929: begin
930: delete from FND_FORM_FUNCTIONS
931: where FUNCTION_ID = X_FUNCTION_ID;
932:
933: if (sql%notfound) then
934: raise no_data_found;

Line 941: delete from FND_FORM_FUNCTIONS_TL

937: -- Added for Function Security Cache Invalidation Project
938: fnd_function_security_cache.delete_function(X_FUNCTION_ID);
939: end if;
940:
941: delete from FND_FORM_FUNCTIONS_TL
942: where FUNCTION_ID = X_FUNCTION_ID;
943:
944: if (sql%notfound) then
945: raise no_data_found;

Line 958: delete from FND_FORM_FUNCTIONS_TL T

954: /* as a quick workaround to fix the time-consuming table handler issue */
955: /* Eventually we'll need to turn them into a separate fix_language procedure */
956: /*
957:
958: delete from FND_FORM_FUNCTIONS_TL T
959: where not exists
960: (select NULL
961: from FND_FORM_FUNCTIONS B
962: where B.FUNCTION_ID = T.FUNCTION_ID

Line 961: from FND_FORM_FUNCTIONS B

957:
958: delete from FND_FORM_FUNCTIONS_TL T
959: where not exists
960: (select NULL
961: from FND_FORM_FUNCTIONS B
962: where B.FUNCTION_ID = T.FUNCTION_ID
963: );
964:
965: update FND_FORM_FUNCTIONS_TL T set (

Line 965: update FND_FORM_FUNCTIONS_TL T set (

961: from FND_FORM_FUNCTIONS B
962: where B.FUNCTION_ID = T.FUNCTION_ID
963: );
964:
965: update FND_FORM_FUNCTIONS_TL T set (
966: USER_FUNCTION_NAME,
967: DESCRIPTION
968: ) = (select
969: B.USER_FUNCTION_NAME,

Line 971: from FND_FORM_FUNCTIONS_TL B

967: DESCRIPTION
968: ) = (select
969: B.USER_FUNCTION_NAME,
970: B.DESCRIPTION
971: from FND_FORM_FUNCTIONS_TL B
972: where B.FUNCTION_ID = T.FUNCTION_ID
973: and B.LANGUAGE = T.SOURCE_LANG)
974: where (
975: T.FUNCTION_ID,

Line 980: from FND_FORM_FUNCTIONS_TL SUBB, FND_FORM_FUNCTIONS_TL SUBT

976: T.LANGUAGE
977: ) in (select
978: SUBT.FUNCTION_ID,
979: SUBT.LANGUAGE
980: from FND_FORM_FUNCTIONS_TL SUBB, FND_FORM_FUNCTIONS_TL SUBT
981: where SUBB.FUNCTION_ID = SUBT.FUNCTION_ID
982: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
983: and (SUBB.USER_FUNCTION_NAME <> SUBT.USER_FUNCTION_NAME
984: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 991: FND_FORM_FUNCTIONS_TL TT(

987: ));
988: */
989:
990: insert /*+ append parallel(TT) */ into
991: FND_FORM_FUNCTIONS_TL TT(
992: FUNCTION_ID,
993: USER_FUNCTION_NAME,
994: CREATION_DATE,
995: CREATED_BY,

Line 1014: from FND_FORM_FUNCTIONS_TL B, FND_LANGUAGES L

1010: B.LAST_UPDATE_LOGIN,
1011: B.DESCRIPTION,
1012: L.LANGUAGE_CODE,
1013: B.SOURCE_LANG
1014: from FND_FORM_FUNCTIONS_TL B, FND_LANGUAGES L
1015: where L.INSTALLED_FLAG in ('I', 'B')
1016: and B.LANGUAGE = userenv('LANG')
1017: )V, FND_FORM_FUNCTIONS_TL T
1018: where T.function_id(+) = V.function_id

Line 1017: )V, FND_FORM_FUNCTIONS_TL T

1013: B.SOURCE_LANG
1014: from FND_FORM_FUNCTIONS_TL B, FND_LANGUAGES L
1015: where L.INSTALLED_FLAG in ('I', 'B')
1016: and B.LANGUAGE = userenv('LANG')
1017: )V, FND_FORM_FUNCTIONS_TL T
1018: where T.function_id(+) = V.function_id
1019: and T.language(+) = V.language_code
1020: and T.function_id is NULL;
1021: end ADD_LANGUAGE;

Line 1032: fnd_form_functions_pkg.TRANSLATE_ROW (

1028: X_OWNER in VARCHAR2,
1029: X_CUSTOM_MODE in VARCHAR2
1030: ) is
1031: begin
1032: fnd_form_functions_pkg.TRANSLATE_ROW (
1033: X_FUNCTION_ID => X_FUNCTION_ID,
1034: X_USER_FUNCTION_NAME => X_USER_FUNCTION_NAME,
1035: X_DESCRIPTION => X_DESCRIPTION,
1036: X_OWNER => X_OWNER,

Line 1064: from FND_FORM_FUNCTIONS_TL

1060: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
1061:
1062: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1063: into db_luby, db_ludate
1064: from FND_FORM_FUNCTIONS_TL
1065: where FUNCTION_ID = X_FUNCTION_ID
1066: and userenv('LANG') = LANGUAGE;
1067:
1068: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 1070: update FND_FORM_FUNCTIONS_TL set

1066: and userenv('LANG') = LANGUAGE;
1067:
1068: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1069: db_ludate, X_CUSTOM_MODE)) then
1070: update FND_FORM_FUNCTIONS_TL set
1071: USER_FUNCTION_NAME = X_USER_FUNCTION_NAME,
1072: DESCRIPTION = X_DESCRIPTION,
1073: LAST_UPDATE_DATE = f_ludate,
1074: LAST_UPDATED_BY = f_luby,

Line 1114: cursor C is select ROWID from FND_FORM_FUNCTIONS

1110: X_MAINTENANCE_MODE_SUPPORT in VARCHAR2, /* NULL='NONE' */
1111: X_CONTEXT_DEPENDENCE in VARCHAR2, /* NULL='RESP' */
1112: X_JRAD_REF_PATH in VARCHAR2 default NULL
1113: ) is
1114: cursor C is select ROWID from FND_FORM_FUNCTIONS
1115: where FUNCTION_ID = X_FUNCTION_ID;
1116: L_MAINTENANCE_MODE_SUPPORT VARCHAR2(8) := X_MAINTENANCE_MODE_SUPPORT;
1117: L_CONTEXT_DEPENDENCE VARCHAR2(8) := X_CONTEXT_DEPENDENCE;
1118:

Line 1157: insert into FND_FORM_FUNCTIONS (

1153: L_REGION_APPLICATION_ID,
1154: L_REGION_CODE,
1155: X_FUNCTION_NAME);
1156:
1157: insert into FND_FORM_FUNCTIONS (
1158: WEB_ICON,
1159: WEB_HOST_NAME,
1160: WEB_AGENT_NAME,
1161: WEB_HTML_CALL,

Line 1218: insert into FND_FORM_FUNCTIONS_TL (

1214: fnd_message.set_token('NAME', X_FUNCTION_NAME);
1215: fnd_message.set_token('COLUMNS', columns_name);
1216: end if;
1217:
1218: insert into FND_FORM_FUNCTIONS_TL (
1219: FUNCTION_ID,
1220: USER_FUNCTION_NAME,
1221: CREATION_DATE,
1222: CREATED_BY,

Line 1244: from FND_FORM_FUNCTIONS_TL T

1240: from FND_LANGUAGES L
1241: where L.INSTALLED_FLAG in ('I', 'B')
1242: and not exists
1243: (select NULL
1244: from FND_FORM_FUNCTIONS_TL T
1245: where T.FUNCTION_ID = X_FUNCTION_ID
1246: and T.LANGUAGE = L.LANGUAGE_CODE);
1247:
1248: open c;

Line 1299: from FND_FORM_FUNCTIONS

1295: TYPE,
1296: MAINTENANCE_MODE_SUPPORT,
1297: CONTEXT_DEPENDENCE,
1298: JRAD_REF_PATH
1299: from FND_FORM_FUNCTIONS
1300: where FUNCTION_ID = X_FUNCTION_ID
1301: for update of FUNCTION_ID nowait;
1302: recinfo c%rowtype;
1303:

Line 1307: from FND_FORM_FUNCTIONS_TL

1303:
1304: cursor c1 is select
1305: USER_FUNCTION_NAME,
1306: DESCRIPTION
1307: from FND_FORM_FUNCTIONS_TL
1308: where FUNCTION_ID = X_FUNCTION_ID
1309: and LANGUAGE = userenv('LANG')
1310: for update of FUNCTION_ID nowait;
1311: tlinfo c1%rowtype;

Line 1455: update FND_FORM_FUNCTIONS set

1451: L_REGION_APPLICATION_ID,
1452: L_REGION_CODE,
1453: X_FUNCTION_NAME);
1454:
1455: update FND_FORM_FUNCTIONS set
1456: WEB_ICON = X_WEB_ICON,
1457: WEB_HOST_NAME = X_WEB_HOST_NAME,
1458: WEB_AGENT_NAME = X_WEB_AGENT_NAME,
1459: WEB_HTML_CALL = L_WEB_HTML_CALL,

Line 1493: update FND_FORM_FUNCTIONS_TL set

1489: -- Added for Function Security Cache Invalidation Project
1490: fnd_function_security_cache.update_function(X_FUNCTION_ID);
1491: end if;
1492:
1493: update FND_FORM_FUNCTIONS_TL set
1494: USER_FUNCTION_NAME = X_USER_FUNCTION_NAME,
1495: DESCRIPTION = X_DESCRIPTION,
1496: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1497: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1532: update fnd_form_functions

1528: fnd_message.set_token('MODE', x_function_mode);
1529: app_exception.raise_exception;
1530: end;
1531:
1532: update fnd_form_functions
1533: set maintenance_mode_support = x_function_mode
1534: where function_name like x_function_name;
1535:
1536: -- Function name does not exist

Line 1548: end FND_FORM_FUNCTIONS_PKG;

1544: end SET_FUNCTION_MODE;
1545:
1546:
1547:
1548: end FND_FORM_FUNCTIONS_PKG;