APPS.FND_FORM_FUNCTIONS_PKG dependencies on FND_FORM_FUNCTIONS_TL

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 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 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 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 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 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,