APPS.GMO_INSTR_TASK_ATTR_COLS_PKG dependencies on GMO_INSTR_TASK_ATTR_COLS_TL

Line 42: insert into GMO_INSTR_TASK_ATTR_COLS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into GMO_INSTR_TASK_ATTR_COLS_TL (
43: LAST_UPDATE_LOGIN,
44: LAST_UPDATED_BY,
45: CREATION_DATE,
46: CREATED_BY,

Line 66: from GMO_INSTR_TASK_ATTR_COLS_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from GMO_INSTR_TASK_ATTR_COLS_TL T
67: where T.ATTR_COL_SEQ = X_ATTR_COL_SEQ
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from GMO_INSTR_TASK_ATTR_COLS_TL

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

Line 160: update GMO_INSTR_TASK_ATTR_COLS_TL set

156: if (sql%notfound) then
157: raise no_data_found;
158: end if;
159:
160: update GMO_INSTR_TASK_ATTR_COLS_TL set
161: COLUMN_HEADING = X_COLUMN_HEADING,
162: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
164: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 178: delete from GMO_INSTR_TASK_ATTR_COLS_TL

174: procedure DELETE_ROW (
175: X_ATTR_COL_SEQ in NUMBER
176: ) is
177: begin
178: delete from GMO_INSTR_TASK_ATTR_COLS_TL
179: where ATTR_COL_SEQ = X_ATTR_COL_SEQ;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 196: delete from GMO_INSTR_TASK_ATTR_COLS_TL T

192:
193: procedure ADD_LANGUAGE
194: is
195: begin
196: delete from GMO_INSTR_TASK_ATTR_COLS_TL T
197: where not exists
198: (select NULL
199: from GMO_INSTR_TASK_ATTR_COLS_B B
200: where B.ATTR_COL_SEQ = T.ATTR_COL_SEQ

Line 203: update GMO_INSTR_TASK_ATTR_COLS_TL T set (

199: from GMO_INSTR_TASK_ATTR_COLS_B B
200: where B.ATTR_COL_SEQ = T.ATTR_COL_SEQ
201: );
202:
203: update GMO_INSTR_TASK_ATTR_COLS_TL T set (
204: COLUMN_HEADING
205: ) = (select
206: B.COLUMN_HEADING
207: from GMO_INSTR_TASK_ATTR_COLS_TL B

Line 207: from GMO_INSTR_TASK_ATTR_COLS_TL B

203: update GMO_INSTR_TASK_ATTR_COLS_TL T set (
204: COLUMN_HEADING
205: ) = (select
206: B.COLUMN_HEADING
207: from GMO_INSTR_TASK_ATTR_COLS_TL B
208: where B.ATTR_COL_SEQ = T.ATTR_COL_SEQ
209: and B.LANGUAGE = T.SOURCE_LANG)
210: where (
211: T.ATTR_COL_SEQ,

Line 216: from GMO_INSTR_TASK_ATTR_COLS_TL SUBB, GMO_INSTR_TASK_ATTR_COLS_TL SUBT

212: T.LANGUAGE
213: ) in (select
214: SUBT.ATTR_COL_SEQ,
215: SUBT.LANGUAGE
216: from GMO_INSTR_TASK_ATTR_COLS_TL SUBB, GMO_INSTR_TASK_ATTR_COLS_TL SUBT
217: where SUBB.ATTR_COL_SEQ = SUBT.ATTR_COL_SEQ
218: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
219: and (SUBB.COLUMN_HEADING <> SUBT.COLUMN_HEADING
220: ));

Line 222: insert into GMO_INSTR_TASK_ATTR_COLS_TL (

218: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
219: and (SUBB.COLUMN_HEADING <> SUBT.COLUMN_HEADING
220: ));
221:
222: insert into GMO_INSTR_TASK_ATTR_COLS_TL (
223: LAST_UPDATE_LOGIN,
224: LAST_UPDATED_BY,
225: CREATION_DATE,
226: CREATED_BY,

Line 242: from GMO_INSTR_TASK_ATTR_COLS_TL B, FND_LANGUAGES L

238: B.ATTR_COL_SEQ,
239: B.COLUMN_HEADING,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from GMO_INSTR_TASK_ATTR_COLS_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 GMO_INSTR_TASK_ATTR_COLS_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 GMO_INSTR_TASK_ATTR_COLS_TL T
248: where T.ATTR_COL_SEQ = B.ATTR_COL_SEQ
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250:
251: end ADD_LANGUAGE;