APPS.JTF_UM_APPROVALS_PKG dependencies on JTF_UM_APPROVALS_TL

Line 51: insert into JTF_UM_APPROVALS_TL (

47: X_LAST_UPDATE_LOGIN,
48: X_USE_PENDING_REQ_FLAG
49: ) RETURNING APPROVAL_ID INTO X_APPROVAL_ID;
50:
51: insert into JTF_UM_APPROVALS_TL (
52: LAST_UPDATE_LOGIN,
53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: DESCRIPTION,

Line 79: from JTF_UM_APPROVALS_TL T

75: from FND_LANGUAGES L
76: where L.INSTALLED_FLAG in ('I', 'B')
77: and not exists
78: (select NULL
79: from JTF_UM_APPROVALS_TL T
80: where T.APPROVAL_ID = X_APPROVAL_ID
81: and T.LANGUAGE = L.LANGUAGE_CODE);
82:
83: end INSERT_ROW;

Line 156: from JTF_UM_APPROVALS_TL

152: cursor c1 is select
153: APPROVAL_NAME,
154: DESCRIPTION,
155: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
156: from JTF_UM_APPROVALS_TL
157: where APPROVAL_ID = X_APPROVAL_ID
158: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
159: for update of APPROVAL_ID nowait;
160: begin

Line 230: update JTF_UM_APPROVALS_TL set

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: update JTF_UM_APPROVALS_TL set
231: APPROVAL_NAME = X_APPROVAL_NAME,
232: DESCRIPTION = X_DESCRIPTION,
233: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
234: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 544: delete from JTF_UM_APPROVALS_TL

540: procedure DELETE_ROW (
541: X_APPROVAL_ID in NUMBER
542: ) is
543: begin
544: delete from JTF_UM_APPROVALS_TL
545: where APPROVAL_ID = X_APPROVAL_ID;
546:
547: if (sql%notfound) then
548: raise no_data_found;

Line 574: delete from JTF_UM_APPROVALS_TL T

570:
571: procedure ADD_LANGUAGE
572: is
573: begin
574: delete from JTF_UM_APPROVALS_TL T
575: where not exists
576: (select NULL
577: from JTF_UM_APPROVALS_B B
578: where B.APPROVAL_ID = T.APPROVAL_ID

Line 581: update JTF_UM_APPROVALS_TL T set (

577: from JTF_UM_APPROVALS_B B
578: where B.APPROVAL_ID = T.APPROVAL_ID
579: );
580:
581: update JTF_UM_APPROVALS_TL T set (
582: APPROVAL_NAME,
583: DESCRIPTION
584: ) = (select
585: B.APPROVAL_NAME,

Line 587: from JTF_UM_APPROVALS_TL B

583: DESCRIPTION
584: ) = (select
585: B.APPROVAL_NAME,
586: B.DESCRIPTION
587: from JTF_UM_APPROVALS_TL B
588: where B.APPROVAL_ID = T.APPROVAL_ID
589: and B.LANGUAGE = T.SOURCE_LANG)
590: where (
591: T.APPROVAL_ID,

Line 596: from JTF_UM_APPROVALS_TL SUBB, JTF_UM_APPROVALS_TL SUBT

592: T.LANGUAGE
593: ) in (select
594: SUBT.APPROVAL_ID,
595: SUBT.LANGUAGE
596: from JTF_UM_APPROVALS_TL SUBB, JTF_UM_APPROVALS_TL SUBT
597: where SUBB.APPROVAL_ID = SUBT.APPROVAL_ID
598: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
599: and (SUBB.APPROVAL_NAME <> SUBT.APPROVAL_NAME
600: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 605: insert into JTF_UM_APPROVALS_TL (

601: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
602: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
603: ));
604:
605: insert into JTF_UM_APPROVALS_TL (
606: LAST_UPDATE_LOGIN,
607: LAST_UPDATED_BY,
608: LAST_UPDATE_DATE,
609: DESCRIPTION,

Line 629: from JTF_UM_APPROVALS_TL B, FND_LANGUAGES L

625: B.APPROVAL_NAME,
626: B.APPLICATION_ID,
627: L.LANGUAGE_CODE,
628: B.SOURCE_LANG
629: from JTF_UM_APPROVALS_TL B, FND_LANGUAGES L
630: where L.INSTALLED_FLAG in ('I', 'B')
631: and B.LANGUAGE = userenv('LANG')
632: and not exists
633: (select NULL

Line 634: from JTF_UM_APPROVALS_TL T

630: where L.INSTALLED_FLAG in ('I', 'B')
631: and B.LANGUAGE = userenv('LANG')
632: and not exists
633: (select NULL
634: from JTF_UM_APPROVALS_TL T
635: where T.APPROVAL_ID = B.APPROVAL_ID
636: and T.LANGUAGE = L.LANGUAGE_CODE);
637: end ADD_LANGUAGE;
638:

Line 666: FROM JTF_UM_APPROVALS_TL

662: -- there is a row for this app_id and this app_short_name
663: -- Exception is thrown otherwise.
664: select LAST_UPDATED_BY, LAST_UPDATE_DATE
665: into db_luby, db_ludate
666: FROM JTF_UM_APPROVALS_TL
667: where APPROVAL_ID = X_APPROVAL_ID
668: and LANGUAGE = userenv('LANG');
669:
670: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 672: update JTF_UM_APPROVALS_TL set

668: and LANGUAGE = userenv('LANG');
669:
670: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
671: db_ludate, X_CUSTOM_MODE)) then
672: update JTF_UM_APPROVALS_TL set
673: APPROVAL_NAME = X_APPROVAL_NAME,
674: DESCRIPTION = X_DESCRIPTION,
675: LAST_UPDATE_DATE = f_ludate,
676: LAST_UPDATED_BY = f_luby,