APPS.OZF_REASON_CODES_ALL_PKG dependencies on OZF_REASON_CODES_ALL_TL

Line 158: INSERT INTO OZF_REASON_CODES_ALL_TL (

154: p_INVOICING_REASON_CODE,
155: px_ORDER_TYPE_ID,
156: p_PARTNER_ACCESS_FLAG );
157:
158: INSERT INTO OZF_REASON_CODES_ALL_TL (
159: REASON_CODE_ID,
160: LAST_UPDATE_DATE,
161: LAST_UPDATED_BY,
162: CREATION_DATE,

Line 186: from OZF_REASON_CODES_ALL_TL T

182: from FND_LANGUAGES L
183: where L.INSTALLED_FLAG in ('I', 'B')
184: and not exists
185: (select NULL
186: from OZF_REASON_CODES_ALL_TL T
187: where T.REASON_CODE_ID = px_REASON_CODE_ID
188: and T.LANGUAGE = L.LANGUAGE_CODE);
189:
190: OPEN C;

Line 276: update OZF_REASON_CODES_ALL_TL set

272: If (SQL%NOTFOUND) then
273: RAISE NO_DATA_FOUND;
274: End If;
275:
276: update OZF_REASON_CODES_ALL_TL set
277: NAME = p_NAME,
278: DESCRIPTION = p_DESCRIPTION,
279: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
280: LAST_UPDATED_BY = p_LAST_UPDATED_BY,

Line 296: delete from OZF_REASON_CODES_ALL_TL

292: PROCEDURE Delete_Row(
293: p_REASON_CODE_ID NUMBER)
294: IS
295: BEGIN
296: delete from OZF_REASON_CODES_ALL_TL
297: where REASON_CODE_ID = p_REASON_CODE_ID;
298:
299: if (sql%notfound) then
300: raise no_data_found;

Line 359: from OZF_REASON_CODES_ALL_TL

355: cursor c1 is select
356: NAME,
357: DESCRIPTION,
358: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
359: from OZF_REASON_CODES_ALL_TL
360: where REASON_CODE_ID = p_REASON_CODE_ID
361: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
362: for update of REASON_CODE_ID nowait;
363: BEGIN

Line 495: delete from OZF_REASON_CODES_ALL_TL T

491:
492: procedure ADD_LANGUAGE
493: is
494: begin
495: delete from OZF_REASON_CODES_ALL_TL T
496: where not exists
497: (select NULL
498: from OZF_REASON_CODES_ALL_B B
499: where B.REASON_CODE_ID = T.REASON_CODE_ID

Line 506: update OZF_REASON_CODES_ALL_TL T set (

502: NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
503: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
504: );
505:
506: update OZF_REASON_CODES_ALL_TL T set (
507: NAME,
508: DESCRIPTION
509: ) = (select
510: B.NAME,

Line 512: from OZF_REASON_CODES_ALL_TL B

508: DESCRIPTION
509: ) = (select
510: B.NAME,
511: B.DESCRIPTION
512: from OZF_REASON_CODES_ALL_TL B
513: where B.REASON_CODE_ID = T.REASON_CODE_ID
514: and B.LANGUAGE = T.SOURCE_LANG
515: and NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
516: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 525: from OZF_REASON_CODES_ALL_TL SUBB, OZF_REASON_CODES_ALL_TL SUBT

521: T.LANGUAGE
522: ) in (select
523: SUBT.REASON_CODE_ID,
524: SUBT.LANGUAGE
525: from OZF_REASON_CODES_ALL_TL SUBB, OZF_REASON_CODES_ALL_TL SUBT
526: where SUBB.REASON_CODE_ID = SUBT.REASON_CODE_ID
527: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
528: and NVL(SUBB.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
529: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 538: insert into OZF_REASON_CODES_ALL_TL (

534: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
535: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
536: ));
537:
538: insert into OZF_REASON_CODES_ALL_TL (
539: ORG_ID,
540: REASON_CODE_ID,
541: LAST_UPDATE_DATE,
542: LAST_UPDATED_BY,

Line 562: from OZF_REASON_CODES_ALL_TL B, FND_LANGUAGES L

558: B.NAME,
559: B.DESCRIPTION,
560: L.LANGUAGE_CODE,
561: B.SOURCE_LANG
562: from OZF_REASON_CODES_ALL_TL B, FND_LANGUAGES L
563: where L.INSTALLED_FLAG in ('I', 'B')
564: and B.LANGUAGE = userenv('LANG')
565: and not exists
566: (select NULL

Line 567: from OZF_REASON_CODES_ALL_TL T

563: where L.INSTALLED_FLAG in ('I', 'B')
564: and B.LANGUAGE = userenv('LANG')
565: and not exists
566: (select NULL
567: from OZF_REASON_CODES_ALL_TL T
568: where T.REASON_CODE_ID = B.REASON_CODE_ID
569: and T.LANGUAGE = L.LANGUAGE_CODE
570: and NVL(T.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
571: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 587: update ozf_reason_codes_all_tl

583: -- note org_id is not used here because in NLS mode it is important
584: -- update a line id across all orgs because data will be translated
585: -- only once for a single org
586:
587: update ozf_reason_codes_all_tl
588: set name = X_NAME,
589: description = X_DESCRIPTION,
590: source_lang = userenv('LANG'),
591: last_update_date = sysdate,