APPS.IGW_ROLES_PKG dependencies on IGW_ROLES_TL

Line 42: insert into IGW_ROLES_TL (

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

Line 66: from IGW_ROLES_TL T

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

Line 99: from IGW_ROLES_TL

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

Line 162: update IGW_ROLES_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update IGW_ROLES_TL set
163: ROLE_NAME = X_ROLE_NAME,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
166: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 180: delete from IGW_ROLES_TL

176: procedure DELETE_ROW (
177: X_ROLE_ID in NUMBER
178: ) is
179: begin
180: delete from IGW_ROLES_TL
181: where ROLE_ID = X_ROLE_ID;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 198: delete from IGW_ROLES_TL T

194:
195: procedure ADD_LANGUAGE
196: is
197: begin
198: delete from IGW_ROLES_TL T
199: where not exists
200: (select NULL
201: from IGW_ROLES B
202: where B.ROLE_ID = T.ROLE_ID

Line 205: update IGW_ROLES_TL T set (

201: from IGW_ROLES B
202: where B.ROLE_ID = T.ROLE_ID
203: );
204:
205: update IGW_ROLES_TL T set (
206: ROLE_NAME
207: ) = (select
208: B.ROLE_NAME
209: from IGW_ROLES_TL B

Line 209: from IGW_ROLES_TL B

205: update IGW_ROLES_TL T set (
206: ROLE_NAME
207: ) = (select
208: B.ROLE_NAME
209: from IGW_ROLES_TL B
210: where B.ROLE_ID = T.ROLE_ID
211: and B.LANGUAGE = T.SOURCE_LANG)
212: where (
213: T.ROLE_ID,

Line 218: from IGW_ROLES_TL SUBB, IGW_ROLES_TL SUBT

214: T.LANGUAGE
215: ) in (select
216: SUBT.ROLE_ID,
217: SUBT.LANGUAGE
218: from IGW_ROLES_TL SUBB, IGW_ROLES_TL SUBT
219: where SUBB.ROLE_ID = SUBT.ROLE_ID
220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.ROLE_NAME <> SUBT.ROLE_NAME
222: ));

Line 224: insert into IGW_ROLES_TL (

220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.ROLE_NAME <> SUBT.ROLE_NAME
222: ));
223:
224: insert into IGW_ROLES_TL (
225: CREATION_DATE,
226: LAST_UPDATED_BY,
227: ROLE_NAME,
228: LAST_UPDATE_LOGIN,

Line 244: from IGW_ROLES_TL B, FND_LANGUAGES L

240: B.CREATED_BY,
241: B.LAST_UPDATE_DATE,
242: L.LANGUAGE_CODE,
243: B.SOURCE_LANG
244: from IGW_ROLES_TL B, FND_LANGUAGES L
245: where L.INSTALLED_FLAG in ('I', 'B')
246: and B.LANGUAGE = userenv('LANG')
247: and not exists
248: (select NULL

Line 249: from IGW_ROLES_TL T

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

Line 259: update igw_roles_tl set

255: X_ROLE_ID in NUMBER,
256: X_ROLE_NAME in VARCHAR2,
257: X_OWNER in VARCHAR2) is
258: begin
259: update igw_roles_tl set
260: role_name = nvl(X_ROLE_NAME, role_name),
261: last_update_date = sysdate,
262: last_updated_by = decode (X_OWNER, 'SEED', 1, 0),
263: last_update_login = 0,