APPS.OZF_REQUEST_HEADERS_ALL_PKG dependencies on OZF_REQUEST_HEADERS_ALL_TL

Line 349: insert into OZF_REQUEST_HEADERS_ALL_TL (

345: X_ATTRIBUTE15,X_ORG_ID,
346: X_SECURITY_GROUP_ID
347: );
348:
349: insert into OZF_REQUEST_HEADERS_ALL_TL (
350: REQUEST_HEADER_ID,
351: LAST_UPDATE_DATE,
352: LAST_UPDATED_BY,
353: CREATION_DATE,

Line 381: from OZF_REQUEST_HEADERS_ALL_TL T

377: from FND_LANGUAGES L
378: where L.INSTALLED_FLAG in ('I', 'B')
379: and not exists
380: (select NULL
381: from OZF_REQUEST_HEADERS_ALL_TL T
382: where T.REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
383: and T.LANGUAGE = L.LANGUAGE_CODE);
384:
385: open c;

Line 623: from OZF_REQUEST_HEADERS_ALL_TL

619: cursor c1 is select
620: REQUEST_NAME,
621: REQUEST_DESCRIPTION,COMMENTS,
622: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
623: from OZF_REQUEST_HEADERS_ALL_TL
624: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
625: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
626: for update of REQUEST_HEADER_ID nowait;
627: begin

Line 1068: update OZF_REQUEST_HEADERS_ALL_TL set

1064: if (sql%notfound) then
1065: raise no_data_found;
1066: end if;
1067:
1068: update OZF_REQUEST_HEADERS_ALL_TL set
1069: REQUEST_NAME = X_REQUEST_NAME,
1070: REQUEST_DESCRIPTION = X_REQUEST_DESCRIPTION,
1071: COMMENTS = X_COMMENTS,
1072: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 1088: delete from OZF_REQUEST_HEADERS_ALL_TL

1084: procedure DELETE_ROW (
1085: X_REQUEST_HEADER_ID in NUMBER
1086: ) is
1087: begin
1088: delete from OZF_REQUEST_HEADERS_ALL_TL
1089: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
1090:
1091: if (sql%notfound) then
1092: raise no_data_found;

Line 1106: delete from OZF_REQUEST_HEADERS_ALL_TL T

1102:
1103: procedure ADD_LANGUAGE
1104: is
1105: begin
1106: delete from OZF_REQUEST_HEADERS_ALL_TL T
1107: where not exists
1108: (select NULL
1109: from OZF_REQUEST_HEADERS_ALL_B B
1110: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID

Line 1113: update OZF_REQUEST_HEADERS_ALL_TL T set (

1109: from OZF_REQUEST_HEADERS_ALL_B B
1110: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
1111: );
1112:
1113: update OZF_REQUEST_HEADERS_ALL_TL T set (
1114: REQUEST_NAME,
1115: REQUEST_DESCRIPTION,COMMENTS
1116: ) = (select
1117: B.REQUEST_NAME,

Line 1119: from OZF_REQUEST_HEADERS_ALL_TL B

1115: REQUEST_DESCRIPTION,COMMENTS
1116: ) = (select
1117: B.REQUEST_NAME,
1118: B.REQUEST_DESCRIPTION,B.COMMENTS
1119: from OZF_REQUEST_HEADERS_ALL_TL B
1120: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
1121: and B.LANGUAGE = T.SOURCE_LANG)
1122: where (
1123: T.REQUEST_HEADER_ID,

Line 1128: from OZF_REQUEST_HEADERS_ALL_TL SUBB, OZF_REQUEST_HEADERS_ALL_TL SUBT

1124: T.LANGUAGE
1125: ) in (select
1126: SUBT.REQUEST_HEADER_ID,
1127: SUBT.LANGUAGE
1128: from OZF_REQUEST_HEADERS_ALL_TL SUBB, OZF_REQUEST_HEADERS_ALL_TL SUBT
1129: where SUBB.REQUEST_HEADER_ID = SUBT.REQUEST_HEADER_ID
1130: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1131: and (SUBB.REQUEST_NAME <> SUBT.REQUEST_NAME
1132: or (SUBB.REQUEST_NAME is null and SUBT.REQUEST_NAME is not null)

Line 1142: insert into OZF_REQUEST_HEADERS_ALL_TL (

1138: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
1139: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
1140: ));
1141:
1142: insert into OZF_REQUEST_HEADERS_ALL_TL (
1143: REQUEST_HEADER_ID,
1144: LAST_UPDATE_DATE,
1145: LAST_UPDATED_BY,
1146: CREATION_DATE,

Line 1168: from OZF_REQUEST_HEADERS_ALL_TL B, FND_LANGUAGES L

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

Line 1173: from OZF_REQUEST_HEADERS_ALL_TL T

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