APPS.JTF_IAPP_FAMILIES_PKG dependencies on JTF_IAPP_FAMILIES_TL

Line 72: insert into JTF_IAPP_FAMILIES_TL (

68: l_last_updated_by,
69: G_LOGIN_ID
70: );
71:
72: insert into JTF_IAPP_FAMILIES_TL (
73: APP_FAMILY_ID,
74: APP_FAMILY_DISPLAY_NAME,
75: APP_FAMILY_DESCRIPTION,
76: CREATED_BY,

Line 98: from JTF_IAPP_FAMILIES_TL T

94: from FND_LANGUAGES L
95: where L.INSTALLED_FLAG in ('I', 'B')
96: and not exists
97: (select NULL
98: from JTF_IAPP_FAMILIES_TL T
99: where T.APP_FAMILY_ID = X_APP_FAMILY_ID
100: and T.LANGUAGE = L.LANGUAGE_CODE);
101:
102: open c;

Line 147: update JTF_IAPP_FAMILIES_TL set

143: else
144: l_last_updated_by := G_USER_ID;
145: end if;
146:
147: update JTF_IAPP_FAMILIES_TL set
148: APP_FAMILY_DISPLAY_NAME = X_APP_FAMILY_DISPLAY_NAME,
149: APP_FAMILY_DESCRIPTION = X_APP_FAMILY_DESCRIPTION,
150: LAST_UPDATE_DATE = SYSDATE,
151: LAST_UPDATED_BY = l_last_updated_by,

Line 166: delete from JTF_IAPP_FAMILIES_TL

162: procedure DELETE_ROW (
163: X_APP_FAMILY_ID in NUMBER
164: ) is
165: begin
166: delete from JTF_IAPP_FAMILIES_TL
167: where APP_FAMILY_ID = X_APP_FAMILY_ID;
168:
169: if (sql%notfound) then
170: raise no_data_found;

Line 515: update JTF_IAPP_FAMILIES_TL set

511: x_OWNER in VARCHAR2
512: )is
513:
514: begin
515: update JTF_IAPP_FAMILIES_TL set
516: APP_FAMILY_DISPLAY_NAME = x_APP_FAMILY_DISPLAY_NAME,
517: APP_FAMILY_DESCRIPTION = x_APP_FAMILY_DESCRIPTION,
518: LAST_UPDATE_DATE = sysdate,
519: LAST_UPDATED_BY = decode(x_OWNER, 'SEED', 1, 0),

Line 531: delete from JTF_IAPP_FAMILIES_TL T

527:
528: procedure ADD_LANGUAGE
529: is
530: begin
531: delete from JTF_IAPP_FAMILIES_TL T
532: where not exists
533: (select NULL
534: from JTF_IAPP_FAMILIES_B B
535: where B.APP_FAMILY_ID = T.APP_FAMILY_ID

Line 538: update JTF_IAPP_FAMILIES_TL T set (

534: from JTF_IAPP_FAMILIES_B B
535: where B.APP_FAMILY_ID = T.APP_FAMILY_ID
536: );
537:
538: update JTF_IAPP_FAMILIES_TL T set (
539: APP_FAMILY_DISPLAY_NAME,
540: APP_FAMILY_DESCRIPTION
541: ) = (select
542: B.APP_FAMILY_DISPLAY_NAME,

Line 544: from JTF_IAPP_FAMILIES_TL B

540: APP_FAMILY_DESCRIPTION
541: ) = (select
542: B.APP_FAMILY_DISPLAY_NAME,
543: B.APP_FAMILY_DESCRIPTION
544: from JTF_IAPP_FAMILIES_TL B
545: where B.APP_FAMILY_ID = T.APP_FAMILY_ID
546: and B.LANGUAGE = T.SOURCE_LANG)
547: where (
548: T.APP_FAMILY_ID,

Line 553: from JTF_IAPP_FAMILIES_TL SUBB, JTF_IAPP_FAMILIES_TL SUBT

549: T.LANGUAGE
550: ) in (select
551: SUBT.APP_FAMILY_ID,
552: SUBT.LANGUAGE
553: from JTF_IAPP_FAMILIES_TL SUBB, JTF_IAPP_FAMILIES_TL SUBT
554: where SUBB.APP_FAMILY_ID = SUBT.APP_FAMILY_ID
555: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
556: and (SUBB.APP_FAMILY_DISPLAY_NAME <> SUBT.APP_FAMILY_DISPLAY_NAME
557: or SUBB.APP_FAMILY_DESCRIPTION <> SUBT.APP_FAMILY_DESCRIPTION

Line 562: insert into JTF_IAPP_FAMILIES_TL (

558: or (SUBB.APP_FAMILY_DESCRIPTION is null and SUBT.APP_FAMILY_DESCRIPTION is not null)
559: or (SUBB.APP_FAMILY_DESCRIPTION is not null and SUBT.APP_FAMILY_DESCRIPTION is null)
560: ));
561:
562: insert into JTF_IAPP_FAMILIES_TL (
563: APP_FAMILY_ID,
564: APP_FAMILY_DISPLAY_NAME,
565: APP_FAMILY_DESCRIPTION,
566: CREATED_BY,

Line 584: from JTF_IAPP_FAMILIES_TL B, FND_LANGUAGES L

580: B.LAST_UPDATED_BY,
581: B.LAST_UPDATE_LOGIN,
582: L.LANGUAGE_CODE,
583: B.SOURCE_LANG
584: from JTF_IAPP_FAMILIES_TL B, FND_LANGUAGES L
585: where L.INSTALLED_FLAG in ('I', 'B')
586: and B.LANGUAGE = userenv('LANG')
587: and not exists
588: (select NULL

Line 589: from JTF_IAPP_FAMILIES_TL T

585: where L.INSTALLED_FLAG in ('I', 'B')
586: and B.LANGUAGE = userenv('LANG')
587: and not exists
588: (select NULL
589: from JTF_IAPP_FAMILIES_TL T
590: where T.APP_FAMILY_ID = B.APP_FAMILY_ID
591: and T.LANGUAGE = L.LANGUAGE_CODE);
592: end ADD_LANGUAGE;
593: