APPS.RRS_TRADE_AREA_GROUPS_PKG dependencies on RRS_TRADE_AREA_GROUPS_TL

Line 58: insert into RRS_TRADE_AREA_GROUPS_TL (

54: X_LAST_UPDATED_BY,
55: X_LAST_UPDATE_LOGIN
56: );
57:
58: insert into RRS_TRADE_AREA_GROUPS_TL (
59: GROUP_ID,
60: NAME,
61: DESCRIPTION,
62: CREATED_BY,

Line 84: from RRS_TRADE_AREA_GROUPS_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from RRS_TRADE_AREA_GROUPS_TL T
85: where T.GROUP_ID = L_GROUP_ID
86: and T.LANGUAGE = L.LANGUAGE_CODE);
87:
88: open c;

Line 123: from RRS_TRADE_AREA_GROUPS_TL

119: cursor c1 is select
120: NAME,
121: DESCRIPTION,
122: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
123: from RRS_TRADE_AREA_GROUPS_TL
124: where GROUP_ID = X_GROUP_ID
125: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
126: for update of GROUP_ID nowait;
127: begin

Line 194: update RRS_TRADE_AREA_GROUPS_TL set

190: if (sql%notfound) then
191: raise no_data_found;
192: end if;
193:
194: update RRS_TRADE_AREA_GROUPS_TL set
195: NAME = X_NAME,
196: DESCRIPTION = X_DESCRIPTION,
197: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
198: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 213: delete from RRS_TRADE_AREA_GROUPS_TL

209: procedure DELETE_ROW (
210: X_GROUP_ID in NUMBER
211: ) is
212: begin
213: delete from RRS_TRADE_AREA_GROUPS_TL
214: where GROUP_ID = X_GROUP_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 231: delete from RRS_TRADE_AREA_GROUPS_TL T

227:
228: procedure ADD_LANGUAGE
229: is
230: begin
231: delete from RRS_TRADE_AREA_GROUPS_TL T
232: where not exists
233: (select NULL
234: from RRS_TRADE_AREA_GROUPS_B B
235: where B.GROUP_ID = T.GROUP_ID

Line 238: update RRS_TRADE_AREA_GROUPS_TL T set (

234: from RRS_TRADE_AREA_GROUPS_B B
235: where B.GROUP_ID = T.GROUP_ID
236: );
237:
238: update RRS_TRADE_AREA_GROUPS_TL T set (
239: NAME,
240: DESCRIPTION
241: ) = (select
242: B.NAME,

Line 244: from RRS_TRADE_AREA_GROUPS_TL B

240: DESCRIPTION
241: ) = (select
242: B.NAME,
243: B.DESCRIPTION
244: from RRS_TRADE_AREA_GROUPS_TL B
245: where B.GROUP_ID = T.GROUP_ID
246: and B.LANGUAGE = T.SOURCE_LANG)
247: where (
248: T.GROUP_ID,

Line 253: from RRS_TRADE_AREA_GROUPS_TL SUBB, RRS_TRADE_AREA_GROUPS_TL SUBT

249: T.LANGUAGE
250: ) in (select
251: SUBT.GROUP_ID,
252: SUBT.LANGUAGE
253: from RRS_TRADE_AREA_GROUPS_TL SUBB, RRS_TRADE_AREA_GROUPS_TL SUBT
254: where SUBB.GROUP_ID = SUBT.GROUP_ID
255: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
256: and (SUBB.NAME <> SUBT.NAME
257: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 262: insert into RRS_TRADE_AREA_GROUPS_TL (

258: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
259: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
260: ));
261:
262: insert into RRS_TRADE_AREA_GROUPS_TL (
263: GROUP_ID,
264: NAME,
265: DESCRIPTION,
266: CREATED_BY,

Line 284: from RRS_TRADE_AREA_GROUPS_TL B, FND_LANGUAGES L

280: B.LAST_UPDATE_DATE,
281: B.LAST_UPDATE_LOGIN,
282: L.LANGUAGE_CODE,
283: B.SOURCE_LANG
284: from RRS_TRADE_AREA_GROUPS_TL B, FND_LANGUAGES L
285: where L.INSTALLED_FLAG in ('I', 'B')
286: and B.LANGUAGE = userenv('LANG')
287: and not exists
288: (select NULL

Line 289: from RRS_TRADE_AREA_GROUPS_TL T

285: where L.INSTALLED_FLAG in ('I', 'B')
286: and B.LANGUAGE = userenv('LANG')
287: and not exists
288: (select NULL
289: from RRS_TRADE_AREA_GROUPS_TL T
290: where T.GROUP_ID = B.GROUP_ID
291: and T.LANGUAGE = L.LANGUAGE_CODE);
292: end ADD_LANGUAGE;
293: