APPS.OKC_RESP_PARTIES_PKG dependencies on OKC_RESP_PARTIES_TL

Line 49: insert into OKC_RESP_PARTIES_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into OKC_RESP_PARTIES_TL (
50: DOCUMENT_TYPE_CLASS,
51: RESP_PARTY_CODE,
52: INTENT,
53: NAME,

Line 81: from OKC_RESP_PARTIES_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from OKC_RESP_PARTIES_TL T
82: where T.DOCUMENT_TYPE_CLASS = X_DOCUMENT_TYPE_CLASS
83: and T.RESP_PARTY_CODE = X_RESP_PARTY_CODE
84: and T.INTENT = X_INTENT
85: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 122: from OKC_RESP_PARTIES_TL

118: NAME,
119: ALTERNATE_NAME,
120: DESCRIPTION,
121: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
122: from OKC_RESP_PARTIES_TL
123: where DOCUMENT_TYPE_CLASS = X_DOCUMENT_TYPE_CLASS
124: and RESP_PARTY_CODE = X_RESP_PARTY_CODE
125: and INTENT = X_INTENT
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 193: update OKC_RESP_PARTIES_TL set

189: if (sql%notfound) then
190: raise no_data_found;
191: end if;
192:
193: update OKC_RESP_PARTIES_TL set
194: NAME = X_NAME,
195: ALTERNATE_NAME = X_ALTERNATE_NAME,
196: DESCRIPTION = X_DESCRIPTION,
197: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 217: delete from OKC_RESP_PARTIES_TL

213: X_RESP_PARTY_CODE in VARCHAR2,
214: X_INTENT in VARCHAR2
215: ) is
216: begin
217: delete from OKC_RESP_PARTIES_TL
218: where DOCUMENT_TYPE_CLASS = X_DOCUMENT_TYPE_CLASS
219: and RESP_PARTY_CODE = X_RESP_PARTY_CODE
220: and INTENT = X_INTENT;
221:

Line 239: delete from OKC_RESP_PARTIES_TL T

235:
236: procedure ADD_LANGUAGE
237: is
238: begin
239: delete from OKC_RESP_PARTIES_TL T
240: where not exists
241: (select NULL
242: from OKC_RESP_PARTIES_B B
243: where B.DOCUMENT_TYPE_CLASS = T.DOCUMENT_TYPE_CLASS

Line 248: update OKC_RESP_PARTIES_TL T set (

244: and B.RESP_PARTY_CODE = T.RESP_PARTY_CODE
245: and B.INTENT = T.INTENT
246: );
247:
248: update OKC_RESP_PARTIES_TL T set (
249: NAME,
250: ALTERNATE_NAME,
251: DESCRIPTION
252: ) = (select

Line 256: from OKC_RESP_PARTIES_TL B

252: ) = (select
253: B.NAME,
254: B.ALTERNATE_NAME,
255: B.DESCRIPTION
256: from OKC_RESP_PARTIES_TL B
257: where B.DOCUMENT_TYPE_CLASS = T.DOCUMENT_TYPE_CLASS
258: and B.RESP_PARTY_CODE = T.RESP_PARTY_CODE
259: and B.INTENT = T.INTENT
260: and B.LANGUAGE = T.SOURCE_LANG)

Line 271: from OKC_RESP_PARTIES_TL SUBB, OKC_RESP_PARTIES_TL SUBT

267: SUBT.DOCUMENT_TYPE_CLASS,
268: SUBT.RESP_PARTY_CODE,
269: SUBT.INTENT,
270: SUBT.LANGUAGE
271: from OKC_RESP_PARTIES_TL SUBB, OKC_RESP_PARTIES_TL SUBT
272: where SUBB.DOCUMENT_TYPE_CLASS = SUBT.DOCUMENT_TYPE_CLASS
273: and SUBB.RESP_PARTY_CODE = SUBT.RESP_PARTY_CODE
274: and SUBB.INTENT = SUBT.INTENT
275: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 285: insert into OKC_RESP_PARTIES_TL (

281: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
282: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
283: ));
284:
285: insert into OKC_RESP_PARTIES_TL (
286: DOCUMENT_TYPE_CLASS,
287: RESP_PARTY_CODE,
288: INTENT,
289: NAME,

Line 313: from OKC_RESP_PARTIES_TL B, FND_LANGUAGES L

309: B.LAST_UPDATE_DATE,
310: B.LAST_UPDATE_LOGIN,
311: L.LANGUAGE_CODE,
312: B.SOURCE_LANG
313: from OKC_RESP_PARTIES_TL B, FND_LANGUAGES L
314: where L.INSTALLED_FLAG in ('I', 'B')
315: and B.LANGUAGE = userenv('LANG')
316: and not exists
317: (select NULL

Line 318: from OKC_RESP_PARTIES_TL T

314: where L.INSTALLED_FLAG in ('I', 'B')
315: and B.LANGUAGE = userenv('LANG')
316: and not exists
317: (select NULL
318: from OKC_RESP_PARTIES_TL T
319: where T.DOCUMENT_TYPE_CLASS = B.DOCUMENT_TYPE_CLASS
320: and T.RESP_PARTY_CODE = B.RESP_PARTY_CODE
321: and T.INTENT = B.INTENT
322: and T.LANGUAGE = L.LANGUAGE_CODE);