APPS.IEC_G_REP_REPORTS_PKG dependencies on IEC_G_REP_REPORTS_TL

Line 42: insert into IEC_G_REP_REPORTS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into IEC_G_REP_REPORTS_TL (
43: REPORT_TITLE,
44: REPORT_ID,
45: CREATED_BY,
46: CREATION_DATE,

Line 68: from IEC_G_REP_REPORTS_TL T

64: from FND_LANGUAGES L
65: where L.INSTALLED_FLAG in ('I', 'B')
66: and not exists
67: (select NULL
68: from IEC_G_REP_REPORTS_TL T
69: where T.REPORT_ID = X_REPORT_ID
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 99: from IEC_G_REP_REPORTS_TL

95:
96: cursor c1 is select
97: REPORT_TITLE,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from IEC_G_REP_REPORTS_TL
100: where REPORT_ID = X_REPORT_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of REPORT_ID nowait;
103: begin

Line 158: update IEC_G_REP_REPORTS_TL set

154: if (sql%notfound) then
155: raise no_data_found;
156: end if;
157:
158: update IEC_G_REP_REPORTS_TL set
159: REPORT_TITLE = X_REPORT_TITLE,
160: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
161: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
162: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 176: delete from IEC_G_REP_REPORTS_TL

172: procedure DELETE_ROW (
173: X_REPORT_ID in NUMBER
174: ) is
175: begin
176: delete from IEC_G_REP_REPORTS_TL
177: where REPORT_ID = X_REPORT_ID;
178:
179: if (sql%notfound) then
180: raise no_data_found;

Line 194: delete from IEC_G_REP_REPORTS_TL T

190:
191: procedure ADD_LANGUAGE
192: is
193: begin
194: delete from IEC_G_REP_REPORTS_TL T
195: where not exists
196: (select NULL
197: from IEC_G_REP_REPORTS_B B
198: where B.REPORT_ID = T.REPORT_ID

Line 201: update IEC_G_REP_REPORTS_TL T set (

197: from IEC_G_REP_REPORTS_B B
198: where B.REPORT_ID = T.REPORT_ID
199: );
200:
201: update IEC_G_REP_REPORTS_TL T set (
202: REPORT_TITLE
203: ) = (select
204: B.REPORT_TITLE
205: from IEC_G_REP_REPORTS_TL B

Line 205: from IEC_G_REP_REPORTS_TL B

201: update IEC_G_REP_REPORTS_TL T set (
202: REPORT_TITLE
203: ) = (select
204: B.REPORT_TITLE
205: from IEC_G_REP_REPORTS_TL B
206: where B.REPORT_ID = T.REPORT_ID
207: and B.LANGUAGE = T.SOURCE_LANG)
208: where (
209: T.REPORT_ID,

Line 214: from IEC_G_REP_REPORTS_TL SUBB, IEC_G_REP_REPORTS_TL SUBT

210: T.LANGUAGE
211: ) in (select
212: SUBT.REPORT_ID,
213: SUBT.LANGUAGE
214: from IEC_G_REP_REPORTS_TL SUBB, IEC_G_REP_REPORTS_TL SUBT
215: where SUBB.REPORT_ID = SUBT.REPORT_ID
216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
217: and (SUBB.REPORT_TITLE <> SUBT.REPORT_TITLE
218: ));

Line 220: insert into IEC_G_REP_REPORTS_TL (

216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
217: and (SUBB.REPORT_TITLE <> SUBT.REPORT_TITLE
218: ));
219:
220: insert into IEC_G_REP_REPORTS_TL (
221: REPORT_TITLE,
222: REPORT_ID,
223: CREATED_BY,
224: CREATION_DATE,

Line 242: from IEC_G_REP_REPORTS_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_LOGIN,
239: B.OBJECT_VERSION_NUMBER,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from IEC_G_REP_REPORTS_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from IEC_G_REP_REPORTS_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from IEC_G_REP_REPORTS_TL T
248: where T.REPORT_ID = B.REPORT_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251:

Line 284: update IEC_G_REP_REPORTS_TL set

280: begin
281:
282: -- only UPDATE rows that have not been altered by user
283:
284: update IEC_G_REP_REPORTS_TL set
285: REPORT_TITLE = X_REPORT_TITLE,
286: SOURCE_LANG = userenv('LANG'),
287: LAST_UPDATE_DATE = SYSDATE,
288: LAST_UPDATED_BY = DECODE(X_OWNER, 'SEED', 1, 0),