APPS.OZF_CLAIM_TYPES_ALL_PKG dependencies on OZF_CLAIM_TYPES_ALL_TL

Line 155: insert into ozf_claim_types_all_tl (

151: X_NEG_WO_REC_TRX_ID,
152: X_GL_BALANCING_FLEX_VALUE
153: );
154:
155: insert into ozf_claim_types_all_tl (
156: ORG_ID,
157: CLAIM_TYPE_ID,
158: LAST_UPDATE_DATE,
159: LAST_UPDATED_BY,

Line 183: from ozf_claim_types_all_tl T

179: from FND_LANGUAGES L
180: where L.INSTALLED_FLAG in ('I', 'B')
181: and not exists
182: (select NULL
183: from ozf_claim_types_all_tl T
184: where T.CLAIM_TYPE_ID = X_CLAIM_TYPE_ID
185: and T.LANGUAGE = L.LANGUAGE_CODE
186: and ORG_ID = X_ORG_ID);
187:

Line 298: from ozf_claim_types_all_tl

294: cursor c1 is select
295: NAME,
296: DESCRIPTION,
297: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
298: from ozf_claim_types_all_tl
299: where CLAIM_TYPE_ID = X_CLAIM_TYPE_ID
300: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
301: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
302: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 526: update ozf_claim_types_all_tl set

522: if (sql%notfound) then
523: raise no_data_found;
524: end if;
525:
526: update ozf_claim_types_all_tl set
527: NAME = X_NAME,
528: DESCRIPTION = X_DESCRIPTION,
529: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
530: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 552: delete from ozf_claim_types_all_tl

548: X_CLAIM_TYPE_ID in NUMBER,
549: X_ORG_ID in NUMBER
550: ) is
551: begin
552: delete from ozf_claim_types_all_tl
553: where CLAIM_TYPE_ID = X_CLAIM_TYPE_ID
554: and ORG_ID = X_ORG_ID;
555:
556: if (sql%notfound) then

Line 572: delete from ozf_claim_types_all_tl T

568:
569: procedure ADD_LANGUAGE
570: is
571: begin
572: delete from ozf_claim_types_all_tl T
573: where not exists
574: (select NULL
575: from ozf_claim_types_all_b B
576: where B.CLAIM_TYPE_ID = T.CLAIM_TYPE_ID

Line 580: update ozf_claim_types_all_tl T set (

576: where B.CLAIM_TYPE_ID = T.CLAIM_TYPE_ID
577: and B.ORG_ID = T.ORG_ID
578: );
579:
580: update ozf_claim_types_all_tl T set (
581: NAME,
582: DESCRIPTION
583: ) = (select
584: B.NAME,

Line 586: from ozf_claim_types_all_tl B

582: DESCRIPTION
583: ) = (select
584: B.NAME,
585: B.DESCRIPTION
586: from ozf_claim_types_all_tl B
587: where B.CLAIM_TYPE_ID = T.CLAIM_TYPE_ID
588: and B.LANGUAGE = T.SOURCE_LANG
589: and B.ORG_ID = T.ORG_ID)
590: where (

Line 596: from ozf_claim_types_all_b SUBB, ozf_claim_types_all_tl SUBT

592: T.LANGUAGE
593: ) in (select
594: SUBT.CLAIM_TYPE_ID,
595: SUBT.LANGUAGE
596: from ozf_claim_types_all_b SUBB, ozf_claim_types_all_tl SUBT
597: where SUBB.CLAIM_TYPE_ID = SUBT.CLAIM_TYPE_ID
598: and SUBB.ORG_ID = SUBT.ORG_ID
599: );
600:

Line 601: insert into ozf_claim_types_all_tl (

597: where SUBB.CLAIM_TYPE_ID = SUBT.CLAIM_TYPE_ID
598: and SUBB.ORG_ID = SUBT.ORG_ID
599: );
600:
601: insert into ozf_claim_types_all_tl (
602: ORG_ID,
603: CLAIM_TYPE_ID,
604: LAST_UPDATE_DATE,
605: LAST_UPDATED_BY,

Line 625: from ozf_claim_types_all_tl B, FND_LANGUAGES L

621: B.DESCRIPTION,
622: B.NAME,
623: L.LANGUAGE_CODE,
624: B.SOURCE_LANG
625: from ozf_claim_types_all_tl B, FND_LANGUAGES L
626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL

Line 630: from ozf_claim_types_all_tl T

626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL
630: from ozf_claim_types_all_tl T
631: where T.CLAIM_TYPE_ID = B.CLAIM_TYPE_ID
632: and T.LANGUAGE = L.LANGUAGE_CODE
633: and B.ORG_ID = T.ORG_ID );
634: end ADD_LANGUAGE;

Line 933: update ozf_claim_types_all_tl

929: -- note org_id is not used here because in NLS mode it is important
930: -- update a line id across all orgs because data will be translated
931: -- only once for a single org
932:
933: update ozf_claim_types_all_tl
934: set name = X_NAME,
935: description = X_DESCRIPTION,
936: source_lang = userenv('LANG'),
937: last_update_date = sysdate,