APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_EXTRACTS_TL

Line 55: insert into IBY_EXTRACTS_TL (

51: X_LAST_UPDATED_BY,
52: X_LAST_UPDATE_LOGIN
53: );
54:
55: insert into IBY_EXTRACTS_TL (
56: EXTRACT_DESC,
57: EXTRACT_ID,
58: CREATED_BY,
59: CREATION_DATE,

Line 81: from IBY_EXTRACTS_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from IBY_EXTRACTS_TL T
82: where T.EXTRACT_ID = X_EXTRACT_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 127: update IBY_EXTRACTS_TL set

123: if (sql%notfound) then
124: raise no_data_found;
125: end if;
126:
127: update IBY_EXTRACTS_TL set
128: EXTRACT_DESC = X_EXTRACT_DESC,
129: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
130: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
131: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 145: delete from IBY_EXTRACTS_TL

141: procedure EXTRACT_DELETE_ROW (
142: X_EXTRACT_ID in NUMBER
143: ) is
144: begin
145: delete from IBY_EXTRACTS_TL
146: where EXTRACT_ID = X_EXTRACT_ID;
147:
148: if (sql%notfound) then
149: raise no_data_found;

Line 163: delete from IBY_EXTRACTS_TL T

159:
160: procedure EXTRACT_ADD_LANGUAGE
161: is
162: begin
163: delete from IBY_EXTRACTS_TL T
164: where not exists
165: (select NULL
166: from IBY_EXTRACTS_B B
167: where B.EXTRACT_ID = T.EXTRACT_ID

Line 170: update IBY_EXTRACTS_TL T set (

166: from IBY_EXTRACTS_B B
167: where B.EXTRACT_ID = T.EXTRACT_ID
168: );
169:
170: update IBY_EXTRACTS_TL T set (
171: EXTRACT_DESC
172: ) = (select
173: B.EXTRACT_DESC
174: from IBY_EXTRACTS_TL B

Line 174: from IBY_EXTRACTS_TL B

170: update IBY_EXTRACTS_TL T set (
171: EXTRACT_DESC
172: ) = (select
173: B.EXTRACT_DESC
174: from IBY_EXTRACTS_TL B
175: where B.EXTRACT_ID = T.EXTRACT_ID
176: and B.LANGUAGE = T.SOURCE_LANG)
177: where (
178: T.EXTRACT_ID,

Line 183: from IBY_EXTRACTS_TL SUBB, IBY_EXTRACTS_TL SUBT

179: T.LANGUAGE
180: ) in (select
181: SUBT.EXTRACT_ID,
182: SUBT.LANGUAGE
183: from IBY_EXTRACTS_TL SUBB, IBY_EXTRACTS_TL SUBT
184: where SUBB.EXTRACT_ID = SUBT.EXTRACT_ID
185: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
186: and (SUBB.EXTRACT_DESC <> SUBT.EXTRACT_DESC
187: or (SUBB.EXTRACT_DESC is null and SUBT.EXTRACT_DESC is not null)

Line 191: insert into IBY_EXTRACTS_TL (

187: or (SUBB.EXTRACT_DESC is null and SUBT.EXTRACT_DESC is not null)
188: or (SUBB.EXTRACT_DESC is not null and SUBT.EXTRACT_DESC is null)
189: ));
190:
191: insert into IBY_EXTRACTS_TL (
192: EXTRACT_DESC,
193: EXTRACT_ID,
194: CREATED_BY,
195: CREATION_DATE,

Line 213: from IBY_EXTRACTS_TL B, FND_LANGUAGES L

209: B.LAST_UPDATE_LOGIN,
210: B.OBJECT_VERSION_NUMBER,
211: L.LANGUAGE_CODE,
212: B.SOURCE_LANG
213: from IBY_EXTRACTS_TL B, FND_LANGUAGES L
214: where L.INSTALLED_FLAG in ('I', 'B')
215: and B.LANGUAGE = userenv('LANG')
216: and not exists
217: (select NULL

Line 218: from IBY_EXTRACTS_TL T

214: where L.INSTALLED_FLAG in ('I', 'B')
215: and B.LANGUAGE = userenv('LANG')
216: and not exists
217: (select NULL
218: from IBY_EXTRACTS_TL T
219: where T.EXTRACT_ID = B.EXTRACT_ID
220: and T.LANGUAGE = L.LANGUAGE_CODE);
221: end EXTRACT_ADD_LANGUAGE;
222:

Line 279: update iby_extracts_tl set

275: X_LAST_UPDATE_DATE in DATE,
276: X_OWNER in VARCHAR2)
277: is
278: begin
279: update iby_extracts_tl set
280: EXTRACT_DESC = X_EXTRACT_DESC,
281: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
282: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
283: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,