APPS.OKC_REP_CONTACT_ROLES_PKG dependencies on OKC_REP_CONTACT_ROLES_TL

Line 43: insert into OKC_REP_CONTACT_ROLES_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into OKC_REP_CONTACT_ROLES_TL (
44: CONTACT_ROLE_ID,
45: NAME,
46: DESCRIPTION,
47: CREATED_BY,

Line 69: from OKC_REP_CONTACT_ROLES_TL T

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

Line 104: from OKC_REP_CONTACT_ROLES_TL

100: cursor c1 is select
101: NAME,
102: DESCRIPTION,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from OKC_REP_CONTACT_ROLES_TL
105: where CONTACT_ROLE_ID = X_CONTACT_ROLE_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of CONTACT_ROLE_ID nowait;
108: begin

Line 169: update OKC_REP_CONTACT_ROLES_TL set

165: if (sql%notfound) then
166: raise no_data_found;
167: end if;
168:
169: update OKC_REP_CONTACT_ROLES_TL set
170: NAME = X_NAME,
171: DESCRIPTION = X_DESCRIPTION,
172: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
173: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 188: delete from OKC_REP_CONTACT_ROLES_TL

184: procedure DELETE_ROW (
185: X_CONTACT_ROLE_ID in NUMBER
186: ) is
187: begin
188: delete from OKC_REP_CONTACT_ROLES_TL
189: where CONTACT_ROLE_ID = X_CONTACT_ROLE_ID;
190:
191: if (sql%notfound) then
192: raise no_data_found;

Line 206: delete from OKC_REP_CONTACT_ROLES_TL T

202:
203: procedure ADD_LANGUAGE
204: is
205: begin
206: delete from OKC_REP_CONTACT_ROLES_TL T
207: where not exists
208: (select NULL
209: from OKC_REP_CONTACT_ROLES_B B
210: where B.CONTACT_ROLE_ID = T.CONTACT_ROLE_ID

Line 213: update OKC_REP_CONTACT_ROLES_TL T set (

209: from OKC_REP_CONTACT_ROLES_B B
210: where B.CONTACT_ROLE_ID = T.CONTACT_ROLE_ID
211: );
212:
213: update OKC_REP_CONTACT_ROLES_TL T set (
214: NAME,
215: DESCRIPTION
216: ) = (select
217: B.NAME,

Line 219: from OKC_REP_CONTACT_ROLES_TL B

215: DESCRIPTION
216: ) = (select
217: B.NAME,
218: B.DESCRIPTION
219: from OKC_REP_CONTACT_ROLES_TL B
220: where B.CONTACT_ROLE_ID = T.CONTACT_ROLE_ID
221: and B.LANGUAGE = T.SOURCE_LANG)
222: where (
223: T.CONTACT_ROLE_ID,

Line 228: from OKC_REP_CONTACT_ROLES_TL SUBB, OKC_REP_CONTACT_ROLES_TL SUBT

224: T.LANGUAGE
225: ) in (select
226: SUBT.CONTACT_ROLE_ID,
227: SUBT.LANGUAGE
228: from OKC_REP_CONTACT_ROLES_TL SUBB, OKC_REP_CONTACT_ROLES_TL SUBT
229: where SUBB.CONTACT_ROLE_ID = SUBT.CONTACT_ROLE_ID
230: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
231: and (SUBB.NAME <> SUBT.NAME
232: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 237: insert into OKC_REP_CONTACT_ROLES_TL (

233: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
234: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
235: ));
236:
237: insert into OKC_REP_CONTACT_ROLES_TL (
238: CONTACT_ROLE_ID,
239: NAME,
240: DESCRIPTION,
241: CREATED_BY,

Line 259: from OKC_REP_CONTACT_ROLES_TL B, FND_LANGUAGES L

255: B.LAST_UPDATE_DATE,
256: B.LAST_UPDATE_LOGIN,
257: L.LANGUAGE_CODE,
258: B.SOURCE_LANG
259: from OKC_REP_CONTACT_ROLES_TL B, FND_LANGUAGES L
260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL

Line 264: from OKC_REP_CONTACT_ROLES_TL T

260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL
264: from OKC_REP_CONTACT_ROLES_TL T
265: where T.CONTACT_ROLE_ID = B.CONTACT_ROLE_ID
266: and T.LANGUAGE = L.LANGUAGE_CODE);
267: end ADD_LANGUAGE;
268: