eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_PTM_PVT dependencies on OKL_PROCESS_TMPLTS_TL

Line 620: DELETE FROM okl_process_tmplts_tl T

616: -- PROCEDURE add_language
617: ---------------------------------------------------------------------------
618: PROCEDURE add_language IS
619: BEGIN
620: DELETE FROM okl_process_tmplts_tl T
621: WHERE NOT EXISTS (
622: SELECT NULL
623: FROM OKL_PROCESS_TMPLTS_ALL_B B --Changed _tl to _b by rvaduri for MLS compliance
624: WHERE B.ID = T.ID

Line 627: UPDATE okl_process_tmplts_tl T SET (

623: FROM OKL_PROCESS_TMPLTS_ALL_B B --Changed _tl to _b by rvaduri for MLS compliance
624: WHERE B.ID = T.ID
625: );
626:
627: UPDATE okl_process_tmplts_tl T SET (
628: EMAIL_SUBJECT_LINE) = (SELECT
629: B.EMAIL_SUBJECT_LINE
630: FROM okl_process_tmplts_tl B
631: WHERE B.ID = T.ID

Line 630: FROM okl_process_tmplts_tl B

626:
627: UPDATE okl_process_tmplts_tl T SET (
628: EMAIL_SUBJECT_LINE) = (SELECT
629: B.EMAIL_SUBJECT_LINE
630: FROM okl_process_tmplts_tl B
631: WHERE B.ID = T.ID
632: AND B.LANGUAGE = T.SOURCE_LANG)
633: WHERE (
634: T.ID,

Line 639: FROM okl_process_tmplts_tl SUBB, okl_process_tmplts_tl SUBT

635: T.LANGUAGE)
636: IN (SELECT
637: SUBT.ID,
638: SUBT.LANGUAGE
639: FROM okl_process_tmplts_tl SUBB, okl_process_tmplts_tl SUBT
640: WHERE SUBB.ID = SUBT.ID
641: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
642: AND (SUBB.EMAIL_SUBJECT_LINE <> SUBT.EMAIL_SUBJECT_LINE
643: OR (SUBB.EMAIL_SUBJECT_LINE IS NULL AND SUBT.EMAIL_SUBJECT_LINE IS NOT NULL)

Line 647: INSERT INTO okl_process_tmplts_tl (

643: OR (SUBB.EMAIL_SUBJECT_LINE IS NULL AND SUBT.EMAIL_SUBJECT_LINE IS NOT NULL)
644: OR (SUBB.EMAIL_SUBJECT_LINE IS NOT NULL AND SUBT.EMAIL_SUBJECT_LINE IS NULL)
645: ));
646:
647: INSERT INTO okl_process_tmplts_tl (
648: ID,
649: LANGUAGE,
650: SOURCE_LANG,
651: SFWT_FLAG,

Line 669: FROM okl_process_tmplts_tl B, FND_LANGUAGES L

665: B.CREATION_DATE,
666: B.LAST_UPDATED_BY,
667: B.LAST_UPDATE_DATE,
668: B.LAST_UPDATE_LOGIN
669: FROM okl_process_tmplts_tl B, FND_LANGUAGES L
670: WHERE L.INSTALLED_FLAG IN ('I', 'B')
671: AND B.LANGUAGE = USERENV('LANG')
672: AND NOT EXISTS(
673: SELECT NULL

Line 674: FROM okl_process_tmplts_tl T

670: WHERE L.INSTALLED_FLAG IN ('I', 'B')
671: AND B.LANGUAGE = USERENV('LANG')
672: AND NOT EXISTS(
673: SELECT NULL
674: FROM okl_process_tmplts_tl T
675: WHERE T.ID = B.ID
676: AND T.LANGUAGE = L.LANGUAGE_CODE
677: );
678:

Line 786: -- FUNCTION get_rec for: okl_process_tmplts_tl

782: END get_rec;
783:
784:
785: ---------------------------------------------------------------------------
786: -- FUNCTION get_rec for: okl_process_tmplts_tl
787: ---------------------------------------------------------------------------
788: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
789: x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_process_tmplts_tl_rec_type IS
790:

Line 788: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,

784:
785: ---------------------------------------------------------------------------
786: -- FUNCTION get_rec for: okl_process_tmplts_tl
787: ---------------------------------------------------------------------------
788: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
789: x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_process_tmplts_tl_rec_type IS
790:
791: CURSOR okl_process_tmplts_tl_pk_csr (p_id IN NUMBER,
792: p_language IN VARCHAR2) IS

Line 789: x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_process_tmplts_tl_rec_type IS

785: ---------------------------------------------------------------------------
786: -- FUNCTION get_rec for: okl_process_tmplts_tl
787: ---------------------------------------------------------------------------
788: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
789: x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_process_tmplts_tl_rec_type IS
790:
791: CURSOR okl_process_tmplts_tl_pk_csr (p_id IN NUMBER,
792: p_language IN VARCHAR2) IS
793: SELECT

Line 791: CURSOR okl_process_tmplts_tl_pk_csr (p_id IN NUMBER,

787: ---------------------------------------------------------------------------
788: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
789: x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_process_tmplts_tl_rec_type IS
790:
791: CURSOR okl_process_tmplts_tl_pk_csr (p_id IN NUMBER,
792: p_language IN VARCHAR2) IS
793: SELECT
794: ID,
795: LANGUAGE,

Line 804: FROM okl_process_tmplts_tl

800: CREATION_DATE,
801: LAST_UPDATED_BY,
802: LAST_UPDATE_DATE,
803: LAST_UPDATE_LOGIN
804: FROM okl_process_tmplts_tl
805: WHERE okl_process_tmplts_tl.id = p_id
806: AND okl_process_tmplts_tl.LANGUAGE = p_language;
807:
808: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

Line 805: WHERE okl_process_tmplts_tl.id = p_id

801: LAST_UPDATED_BY,
802: LAST_UPDATE_DATE,
803: LAST_UPDATE_LOGIN
804: FROM okl_process_tmplts_tl
805: WHERE okl_process_tmplts_tl.id = p_id
806: AND okl_process_tmplts_tl.LANGUAGE = p_language;
807:
808: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
809:

Line 806: AND okl_process_tmplts_tl.LANGUAGE = p_language;

802: LAST_UPDATE_DATE,
803: LAST_UPDATE_LOGIN
804: FROM okl_process_tmplts_tl
805: WHERE okl_process_tmplts_tl.id = p_id
806: AND okl_process_tmplts_tl.LANGUAGE = p_language;
807:
808: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
809:
810: BEGIN

Line 808: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

804: FROM okl_process_tmplts_tl
805: WHERE okl_process_tmplts_tl.id = p_id
806: AND okl_process_tmplts_tl.LANGUAGE = p_language;
807:
808: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
809:
810: BEGIN
811:
812: OPEN okl_process_tmplts_tl_pk_csr (p_okl_process_tmplts_tl_rec.id,

Line 812: OPEN okl_process_tmplts_tl_pk_csr (p_okl_process_tmplts_tl_rec.id,

808: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
809:
810: BEGIN
811:
812: OPEN okl_process_tmplts_tl_pk_csr (p_okl_process_tmplts_tl_rec.id,
813: p_okl_process_tmplts_tl_rec.LANGUAGE);
814:
815: FETCH okl_process_tmplts_tl_pk_csr INTO
816: l_okl_process_tmplts_tl_rec.ID,

Line 813: p_okl_process_tmplts_tl_rec.LANGUAGE);

809:
810: BEGIN
811:
812: OPEN okl_process_tmplts_tl_pk_csr (p_okl_process_tmplts_tl_rec.id,
813: p_okl_process_tmplts_tl_rec.LANGUAGE);
814:
815: FETCH okl_process_tmplts_tl_pk_csr INTO
816: l_okl_process_tmplts_tl_rec.ID,
817: l_okl_process_tmplts_tl_rec.LANGUAGE,

Line 815: FETCH okl_process_tmplts_tl_pk_csr INTO

811:
812: OPEN okl_process_tmplts_tl_pk_csr (p_okl_process_tmplts_tl_rec.id,
813: p_okl_process_tmplts_tl_rec.LANGUAGE);
814:
815: FETCH okl_process_tmplts_tl_pk_csr INTO
816: l_okl_process_tmplts_tl_rec.ID,
817: l_okl_process_tmplts_tl_rec.LANGUAGE,
818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,
819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,

Line 816: l_okl_process_tmplts_tl_rec.ID,

812: OPEN okl_process_tmplts_tl_pk_csr (p_okl_process_tmplts_tl_rec.id,
813: p_okl_process_tmplts_tl_rec.LANGUAGE);
814:
815: FETCH okl_process_tmplts_tl_pk_csr INTO
816: l_okl_process_tmplts_tl_rec.ID,
817: l_okl_process_tmplts_tl_rec.LANGUAGE,
818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,
819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,
820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,

Line 817: l_okl_process_tmplts_tl_rec.LANGUAGE,

813: p_okl_process_tmplts_tl_rec.LANGUAGE);
814:
815: FETCH okl_process_tmplts_tl_pk_csr INTO
816: l_okl_process_tmplts_tl_rec.ID,
817: l_okl_process_tmplts_tl_rec.LANGUAGE,
818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,
819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,
820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,
821: l_okl_process_tmplts_tl_rec.CREATED_BY,

Line 818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,

814:
815: FETCH okl_process_tmplts_tl_pk_csr INTO
816: l_okl_process_tmplts_tl_rec.ID,
817: l_okl_process_tmplts_tl_rec.LANGUAGE,
818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,
819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,
820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,
821: l_okl_process_tmplts_tl_rec.CREATED_BY,
822: l_okl_process_tmplts_tl_rec.CREATION_DATE,

Line 819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,

815: FETCH okl_process_tmplts_tl_pk_csr INTO
816: l_okl_process_tmplts_tl_rec.ID,
817: l_okl_process_tmplts_tl_rec.LANGUAGE,
818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,
819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,
820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,
821: l_okl_process_tmplts_tl_rec.CREATED_BY,
822: l_okl_process_tmplts_tl_rec.CREATION_DATE,
823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,

Line 820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,

816: l_okl_process_tmplts_tl_rec.ID,
817: l_okl_process_tmplts_tl_rec.LANGUAGE,
818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,
819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,
820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,
821: l_okl_process_tmplts_tl_rec.CREATED_BY,
822: l_okl_process_tmplts_tl_rec.CREATION_DATE,
823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,
824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,

Line 821: l_okl_process_tmplts_tl_rec.CREATED_BY,

817: l_okl_process_tmplts_tl_rec.LANGUAGE,
818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,
819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,
820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,
821: l_okl_process_tmplts_tl_rec.CREATED_BY,
822: l_okl_process_tmplts_tl_rec.CREATION_DATE,
823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,
824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,
825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;

Line 822: l_okl_process_tmplts_tl_rec.CREATION_DATE,

818: l_okl_process_tmplts_tl_rec.SOURCE_LANG,
819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,
820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,
821: l_okl_process_tmplts_tl_rec.CREATED_BY,
822: l_okl_process_tmplts_tl_rec.CREATION_DATE,
823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,
824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,
825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;
826:

Line 823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,

819: l_okl_process_tmplts_tl_rec.SFWT_FLAG,
820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,
821: l_okl_process_tmplts_tl_rec.CREATED_BY,
822: l_okl_process_tmplts_tl_rec.CREATION_DATE,
823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,
824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,
825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;
826:
827: x_no_data_found := okl_process_tmplts_tl_pk_csr%NOTFOUND;

Line 824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,

820: l_okl_process_tmplts_tl_rec.EMAIL_SUBJECT_LINE,
821: l_okl_process_tmplts_tl_rec.CREATED_BY,
822: l_okl_process_tmplts_tl_rec.CREATION_DATE,
823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,
824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,
825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;
826:
827: x_no_data_found := okl_process_tmplts_tl_pk_csr%NOTFOUND;
828: CLOSE okl_process_tmplts_tl_pk_csr;

Line 825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;

821: l_okl_process_tmplts_tl_rec.CREATED_BY,
822: l_okl_process_tmplts_tl_rec.CREATION_DATE,
823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,
824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,
825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;
826:
827: x_no_data_found := okl_process_tmplts_tl_pk_csr%NOTFOUND;
828: CLOSE okl_process_tmplts_tl_pk_csr;
829: RETURN(l_okl_process_tmplts_tl_rec);

Line 827: x_no_data_found := okl_process_tmplts_tl_pk_csr%NOTFOUND;

823: l_okl_process_tmplts_tl_rec.LAST_UPDATED_BY,
824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,
825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;
826:
827: x_no_data_found := okl_process_tmplts_tl_pk_csr%NOTFOUND;
828: CLOSE okl_process_tmplts_tl_pk_csr;
829: RETURN(l_okl_process_tmplts_tl_rec);
830:
831: END get_rec;

Line 828: CLOSE okl_process_tmplts_tl_pk_csr;

824: l_okl_process_tmplts_tl_rec.LAST_UPDATE_DATE,
825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;
826:
827: x_no_data_found := okl_process_tmplts_tl_pk_csr%NOTFOUND;
828: CLOSE okl_process_tmplts_tl_pk_csr;
829: RETURN(l_okl_process_tmplts_tl_rec);
830:
831: END get_rec;
832:

Line 829: RETURN(l_okl_process_tmplts_tl_rec);

825: l_okl_process_tmplts_tl_rec.LAST_UPDATE_LOGIN;
826:
827: x_no_data_found := okl_process_tmplts_tl_pk_csr%NOTFOUND;
828: CLOSE okl_process_tmplts_tl_pk_csr;
829: RETURN(l_okl_process_tmplts_tl_rec);
830:
831: END get_rec;
832:
833: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type)

Line 833: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type)

829: RETURN(l_okl_process_tmplts_tl_rec);
830:
831: END get_rec;
832:
833: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type)
834: RETURN okl_process_tmplts_tl_rec_type IS
835:
836: l_row_notfound BOOLEAN;
837:

Line 834: RETURN okl_process_tmplts_tl_rec_type IS

830:
831: END get_rec;
832:
833: FUNCTION get_rec (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type)
834: RETURN okl_process_tmplts_tl_rec_type IS
835:
836: l_row_notfound BOOLEAN;
837:
838: BEGIN

Line 839: RETURN(get_rec(p_okl_process_tmplts_tl_rec, l_row_notfound));

835:
836: l_row_notfound BOOLEAN;
837:
838: BEGIN
839: RETURN(get_rec(p_okl_process_tmplts_tl_rec, l_row_notfound));
840: END get_rec;
841:
842:
843: ---------------------------------------------------------------------------

Line 1351: p_to IN OUT NOCOPY okl_process_tmplts_tl_rec_type) IS

1347: ---------------------------------------------------------------------------
1348: -- PROCEDURE Migrate (from V Record to TL Record)
1349: ---------------------------------------------------------------------------
1350: PROCEDURE migrate (p_from IN ptmv_rec_type,
1351: p_to IN OUT NOCOPY okl_process_tmplts_tl_rec_type) IS
1352: BEGIN
1353:
1354: p_to.id := p_from.id;
1355: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1368: PROCEDURE migrate (p_from IN okl_process_tmplts_tl_rec_type,

1364:
1365: ---------------------------------------------------------------------------
1366: -- PROCEDURE Migrate (from TL Record to V Record)
1367: ---------------------------------------------------------------------------
1368: PROCEDURE migrate (p_from IN okl_process_tmplts_tl_rec_type,
1369: p_to IN OUT NOCOPY ptmv_rec_type) IS
1370:
1371: BEGIN
1372:

Line 1707: -- insert_row for: OKL_PROCESS_TMPLTS_TL --

1703: END insert_row;
1704:
1705:
1706: ------------------------------------------
1707: -- insert_row for: OKL_PROCESS_TMPLTS_TL --
1708: ------------------------------------------
1709:
1710: PROCEDURE insert_row(
1711: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1715: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,

1711: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1712: x_return_status OUT NOCOPY VARCHAR2,
1713: x_msg_count OUT NOCOPY NUMBER,
1714: x_msg_data OUT NOCOPY VARCHAR2,
1715: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
1716: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type) IS
1717:
1718: l_api_version CONSTANT NUMBER := 1;
1719: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1716: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type) IS

1712: x_return_status OUT NOCOPY VARCHAR2,
1713: x_msg_count OUT NOCOPY NUMBER,
1714: x_msg_data OUT NOCOPY VARCHAR2,
1715: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
1716: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type) IS
1717:
1718: l_api_version CONSTANT NUMBER := 1;
1719: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1720: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1721: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type := p_okl_process_tmplts_tl_rec;

1717:
1718: l_api_version CONSTANT NUMBER := 1;
1719: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1720: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1721: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type := p_okl_process_tmplts_tl_rec;
1722: ldefoklprocesstmpltstlrec okl_process_tmplts_tl_rec_type;
1723:
1724: CURSOR get_languages IS
1725: SELECT *

Line 1722: ldefoklprocesstmpltstlrec okl_process_tmplts_tl_rec_type;

1718: l_api_version CONSTANT NUMBER := 1;
1719: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1720: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1721: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type := p_okl_process_tmplts_tl_rec;
1722: ldefoklprocesstmpltstlrec okl_process_tmplts_tl_rec_type;
1723:
1724: CURSOR get_languages IS
1725: SELECT *
1726: FROM FND_LANGUAGES

Line 1730: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --

1726: FROM FND_LANGUAGES
1727: WHERE INSTALLED_FLAG IN ('I', 'B');
1728:
1729: ----------------------------------------------
1730: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
1731: ----------------------------------------------
1732: FUNCTION Set_Attributes (
1733: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
1734: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type

Line 1733: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,

1729: ----------------------------------------------
1730: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
1731: ----------------------------------------------
1732: FUNCTION Set_Attributes (
1733: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
1734: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
1735: ) RETURN VARCHAR2 IS
1736: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1737: BEGIN

Line 1734: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type

1730: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
1731: ----------------------------------------------
1732: FUNCTION Set_Attributes (
1733: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
1734: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
1735: ) RETURN VARCHAR2 IS
1736: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1737: BEGIN
1738: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;

Line 1738: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;

1734: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
1735: ) RETURN VARCHAR2 IS
1736: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1737: BEGIN
1738: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
1739: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG'); -- Harmless but nonetheless incorrect
1740: x_okl_process_tmplts_tl_rec.SOURCE_LANG := USERENV('LANG');
1741: RETURN(l_return_status);
1742: END Set_Attributes;

Line 1739: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG'); -- Harmless but nonetheless incorrect

1735: ) RETURN VARCHAR2 IS
1736: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1737: BEGIN
1738: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
1739: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG'); -- Harmless but nonetheless incorrect
1740: x_okl_process_tmplts_tl_rec.SOURCE_LANG := USERENV('LANG');
1741: RETURN(l_return_status);
1742: END Set_Attributes;
1743:

Line 1740: x_okl_process_tmplts_tl_rec.SOURCE_LANG := USERENV('LANG');

1736: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1737: BEGIN
1738: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
1739: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG'); -- Harmless but nonetheless incorrect
1740: x_okl_process_tmplts_tl_rec.SOURCE_LANG := USERENV('LANG');
1741: RETURN(l_return_status);
1742: END Set_Attributes;
1743:
1744: BEGIN

Line 1757: l_return_status := Set_Attributes(p_okl_process_tmplts_tl_rec, l_okl_process_tmplts_tl_rec);

1753: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_ERROR;
1755: END IF;
1756:
1757: l_return_status := Set_Attributes(p_okl_process_tmplts_tl_rec, l_okl_process_tmplts_tl_rec);
1758: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1760: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1761: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1766: l_okl_process_tmplts_tl_rec.LANGUAGE := l_lang_rec.language_code;

1762: END IF;
1763:
1764: FOR l_lang_rec IN get_languages LOOP
1765:
1766: l_okl_process_tmplts_tl_rec.LANGUAGE := l_lang_rec.language_code;
1767:
1768: INSERT INTO OKL_PROCESS_TMPLTS_TL(
1769: id,
1770: LANGUAGE,

Line 1768: INSERT INTO OKL_PROCESS_TMPLTS_TL(

1764: FOR l_lang_rec IN get_languages LOOP
1765:
1766: l_okl_process_tmplts_tl_rec.LANGUAGE := l_lang_rec.language_code;
1767:
1768: INSERT INTO OKL_PROCESS_TMPLTS_TL(
1769: id,
1770: LANGUAGE,
1771: source_lang,
1772: sfwt_flag,

Line 1780: l_okl_process_tmplts_tl_rec.id,

1776: last_updated_by,
1777: last_update_date,
1778: last_update_login)
1779: VALUES (
1780: l_okl_process_tmplts_tl_rec.id,
1781: l_okl_process_tmplts_tl_rec.LANGUAGE,
1782: l_okl_process_tmplts_tl_rec.source_lang,
1783: l_okl_process_tmplts_tl_rec.sfwt_flag,
1784: l_okl_process_tmplts_tl_rec.email_subject_line,

Line 1781: l_okl_process_tmplts_tl_rec.LANGUAGE,

1777: last_update_date,
1778: last_update_login)
1779: VALUES (
1780: l_okl_process_tmplts_tl_rec.id,
1781: l_okl_process_tmplts_tl_rec.LANGUAGE,
1782: l_okl_process_tmplts_tl_rec.source_lang,
1783: l_okl_process_tmplts_tl_rec.sfwt_flag,
1784: l_okl_process_tmplts_tl_rec.email_subject_line,
1785: l_okl_process_tmplts_tl_rec.created_by,

Line 1782: l_okl_process_tmplts_tl_rec.source_lang,

1778: last_update_login)
1779: VALUES (
1780: l_okl_process_tmplts_tl_rec.id,
1781: l_okl_process_tmplts_tl_rec.LANGUAGE,
1782: l_okl_process_tmplts_tl_rec.source_lang,
1783: l_okl_process_tmplts_tl_rec.sfwt_flag,
1784: l_okl_process_tmplts_tl_rec.email_subject_line,
1785: l_okl_process_tmplts_tl_rec.created_by,
1786: l_okl_process_tmplts_tl_rec.creation_date,

Line 1783: l_okl_process_tmplts_tl_rec.sfwt_flag,

1779: VALUES (
1780: l_okl_process_tmplts_tl_rec.id,
1781: l_okl_process_tmplts_tl_rec.LANGUAGE,
1782: l_okl_process_tmplts_tl_rec.source_lang,
1783: l_okl_process_tmplts_tl_rec.sfwt_flag,
1784: l_okl_process_tmplts_tl_rec.email_subject_line,
1785: l_okl_process_tmplts_tl_rec.created_by,
1786: l_okl_process_tmplts_tl_rec.creation_date,
1787: l_okl_process_tmplts_tl_rec.last_updated_by,

Line 1784: l_okl_process_tmplts_tl_rec.email_subject_line,

1780: l_okl_process_tmplts_tl_rec.id,
1781: l_okl_process_tmplts_tl_rec.LANGUAGE,
1782: l_okl_process_tmplts_tl_rec.source_lang,
1783: l_okl_process_tmplts_tl_rec.sfwt_flag,
1784: l_okl_process_tmplts_tl_rec.email_subject_line,
1785: l_okl_process_tmplts_tl_rec.created_by,
1786: l_okl_process_tmplts_tl_rec.creation_date,
1787: l_okl_process_tmplts_tl_rec.last_updated_by,
1788: l_okl_process_tmplts_tl_rec.last_update_date,

Line 1785: l_okl_process_tmplts_tl_rec.created_by,

1781: l_okl_process_tmplts_tl_rec.LANGUAGE,
1782: l_okl_process_tmplts_tl_rec.source_lang,
1783: l_okl_process_tmplts_tl_rec.sfwt_flag,
1784: l_okl_process_tmplts_tl_rec.email_subject_line,
1785: l_okl_process_tmplts_tl_rec.created_by,
1786: l_okl_process_tmplts_tl_rec.creation_date,
1787: l_okl_process_tmplts_tl_rec.last_updated_by,
1788: l_okl_process_tmplts_tl_rec.last_update_date,
1789: l_okl_process_tmplts_tl_rec.last_update_login);

Line 1786: l_okl_process_tmplts_tl_rec.creation_date,

1782: l_okl_process_tmplts_tl_rec.source_lang,
1783: l_okl_process_tmplts_tl_rec.sfwt_flag,
1784: l_okl_process_tmplts_tl_rec.email_subject_line,
1785: l_okl_process_tmplts_tl_rec.created_by,
1786: l_okl_process_tmplts_tl_rec.creation_date,
1787: l_okl_process_tmplts_tl_rec.last_updated_by,
1788: l_okl_process_tmplts_tl_rec.last_update_date,
1789: l_okl_process_tmplts_tl_rec.last_update_login);
1790: END LOOP;

Line 1787: l_okl_process_tmplts_tl_rec.last_updated_by,

1783: l_okl_process_tmplts_tl_rec.sfwt_flag,
1784: l_okl_process_tmplts_tl_rec.email_subject_line,
1785: l_okl_process_tmplts_tl_rec.created_by,
1786: l_okl_process_tmplts_tl_rec.creation_date,
1787: l_okl_process_tmplts_tl_rec.last_updated_by,
1788: l_okl_process_tmplts_tl_rec.last_update_date,
1789: l_okl_process_tmplts_tl_rec.last_update_login);
1790: END LOOP;
1791:

Line 1788: l_okl_process_tmplts_tl_rec.last_update_date,

1784: l_okl_process_tmplts_tl_rec.email_subject_line,
1785: l_okl_process_tmplts_tl_rec.created_by,
1786: l_okl_process_tmplts_tl_rec.creation_date,
1787: l_okl_process_tmplts_tl_rec.last_updated_by,
1788: l_okl_process_tmplts_tl_rec.last_update_date,
1789: l_okl_process_tmplts_tl_rec.last_update_login);
1790: END LOOP;
1791:
1792: x_okl_process_tmplts_tl_rec := l_okl_process_tmplts_tl_rec;

Line 1789: l_okl_process_tmplts_tl_rec.last_update_login);

1785: l_okl_process_tmplts_tl_rec.created_by,
1786: l_okl_process_tmplts_tl_rec.creation_date,
1787: l_okl_process_tmplts_tl_rec.last_updated_by,
1788: l_okl_process_tmplts_tl_rec.last_update_date,
1789: l_okl_process_tmplts_tl_rec.last_update_login);
1790: END LOOP;
1791:
1792: x_okl_process_tmplts_tl_rec := l_okl_process_tmplts_tl_rec;
1793:

Line 1792: x_okl_process_tmplts_tl_rec := l_okl_process_tmplts_tl_rec;

1788: l_okl_process_tmplts_tl_rec.last_update_date,
1789: l_okl_process_tmplts_tl_rec.last_update_login);
1790: END LOOP;
1791:
1792: x_okl_process_tmplts_tl_rec := l_okl_process_tmplts_tl_rec;
1793:
1794: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1795:
1796: EXCEPTION

Line 1851: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

1847: l_ptmv_rec ptmv_rec_type;
1848: l_def_ptmv_rec ptmv_rec_type;
1849: l_ptm_rec ptm_rec_type;
1850: lx_ptm_rec ptm_rec_type;
1851: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
1852: lx_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
1853:
1854: -------------------------------
1855: -- FUNCTION fill_who_columns --

Line 1852: lx_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

1848: l_def_ptmv_rec ptmv_rec_type;
1849: l_ptm_rec ptm_rec_type;
1850: lx_ptm_rec ptm_rec_type;
1851: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
1852: lx_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
1853:
1854: -------------------------------
1855: -- FUNCTION fill_who_columns --
1856: -------------------------------

Line 1953: migrate(l_def_ptmv_rec, l_okl_process_tmplts_tl_rec);

1949: --------------------------------------
1950: -- Move VIEW record to "Child" records
1951: --------------------------------------
1952: migrate(l_def_ptmv_rec, l_ptm_rec);
1953: migrate(l_def_ptmv_rec, l_okl_process_tmplts_tl_rec);
1954:
1955:
1956: --------------------------------------------
1957: -- Call the INSERT_ROW for each child record

Line 1980: l_okl_process_tmplts_tl_rec,

1976: insert_row(p_init_msg_list,
1977: x_return_status,
1978: x_msg_count,
1979: x_msg_data,
1980: l_okl_process_tmplts_tl_rec,
1981: lx_okl_process_tmplts_tl_rec);
1982:
1983:
1984:

Line 1981: lx_okl_process_tmplts_tl_rec);

1977: x_return_status,
1978: x_msg_count,
1979: x_msg_data,
1980: l_okl_process_tmplts_tl_rec,
1981: lx_okl_process_tmplts_tl_rec);
1982:
1983:
1984:
1985: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1991: migrate(lx_okl_process_tmplts_tl_rec, l_def_ptmv_rec);

1987: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1988: RAISE OKL_API.G_EXCEPTION_ERROR;
1989: END IF;
1990:
1991: migrate(lx_okl_process_tmplts_tl_rec, l_def_ptmv_rec);
1992:
1993: x_ptmv_rec := l_def_ptmv_rec;
1994:
1995: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2211: -- lock_row for:OKL_PROCESS_TMPLTS_TL --

2207: END lock_row;
2208:
2209:
2210: ----------------------------------------
2211: -- lock_row for:OKL_PROCESS_TMPLTS_TL --
2212: ----------------------------------------
2213: PROCEDURE lock_row(
2214: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2215: x_return_status OUT NOCOPY VARCHAR2,

Line 2218: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS

2214: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2215: x_return_status OUT NOCOPY VARCHAR2,
2216: x_msg_count OUT NOCOPY NUMBER,
2217: x_msg_data OUT NOCOPY VARCHAR2,
2218: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS
2219:
2220: E_Resource_Busy EXCEPTION;
2221: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2222: CURSOR lock_csr (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS

Line 2222: CURSOR lock_csr (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS

2218: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS
2219:
2220: E_Resource_Busy EXCEPTION;
2221: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2222: CURSOR lock_csr (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS
2223: SELECT *
2224: FROM OKL_PROCESS_TMPLTS_TL
2225: WHERE ID = p_okl_process_tmplts_tl_rec.id
2226: FOR UPDATE NOWAIT;

Line 2224: FROM OKL_PROCESS_TMPLTS_TL

2220: E_Resource_Busy EXCEPTION;
2221: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2222: CURSOR lock_csr (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS
2223: SELECT *
2224: FROM OKL_PROCESS_TMPLTS_TL
2225: WHERE ID = p_okl_process_tmplts_tl_rec.id
2226: FOR UPDATE NOWAIT;
2227:
2228: l_api_version CONSTANT NUMBER := 1;

Line 2225: WHERE ID = p_okl_process_tmplts_tl_rec.id

2221: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2222: CURSOR lock_csr (p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS
2223: SELECT *
2224: FROM OKL_PROCESS_TMPLTS_TL
2225: WHERE ID = p_okl_process_tmplts_tl_rec.id
2226: FOR UPDATE NOWAIT;
2227:
2228: l_api_version CONSTANT NUMBER := 1;
2229: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2245: OPEN lock_csr(p_okl_process_tmplts_tl_rec);

2241: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2242: RAISE OKL_API.G_EXCEPTION_ERROR;
2243: END IF;
2244: BEGIN
2245: OPEN lock_csr(p_okl_process_tmplts_tl_rec);
2246: FETCH lock_csr INTO l_lock_var;
2247: l_row_notfound := lock_csr%NOTFOUND;
2248: CLOSE lock_csr;
2249: EXCEPTION

Line 2311: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

2307: l_api_version CONSTANT NUMBER := 1;
2308: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2309: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2310: l_ptm_rec ptm_rec_type;
2311: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2312: BEGIN
2313: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2314: G_PKG_NAME,
2315: p_init_msg_list,

Line 2329: migrate(p_ptmv_rec, l_okl_process_tmplts_tl_rec);

2325: --------------------------------------
2326: -- Move VIEW record to "Child" records
2327: --------------------------------------
2328: migrate(p_ptmv_rec, l_ptm_rec);
2329: migrate(p_ptmv_rec, l_okl_process_tmplts_tl_rec);
2330: --------------------------------------------
2331: -- Call the LOCK_ROW for each child record
2332: --------------------------------------------
2333: lock_row(

Line 2350: l_okl_process_tmplts_tl_rec

2346: p_init_msg_list,
2347: x_return_status,
2348: x_msg_count,
2349: x_msg_data,
2350: l_okl_process_tmplts_tl_rec
2351: );
2352: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2353: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2354: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2734: -- update_row for:OKL_PROCESS_TMPLTS_TL --

2730: );
2731: END update_row;
2732:
2733: ------------------------------------------
2734: -- update_row for:OKL_PROCESS_TMPLTS_TL --
2735: ------------------------------------------
2736: PROCEDURE update_row(
2737: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2738: x_return_status OUT NOCOPY VARCHAR2,

Line 2741: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,

2737: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2738: x_return_status OUT NOCOPY VARCHAR2,
2739: x_msg_count OUT NOCOPY NUMBER,
2740: x_msg_data OUT NOCOPY VARCHAR2,
2741: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
2742: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type) IS
2743:
2744: l_api_version CONSTANT NUMBER := 1;
2745: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2742: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type) IS

2738: x_return_status OUT NOCOPY VARCHAR2,
2739: x_msg_count OUT NOCOPY NUMBER,
2740: x_msg_data OUT NOCOPY VARCHAR2,
2741: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
2742: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type) IS
2743:
2744: l_api_version CONSTANT NUMBER := 1;
2745: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2746: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2747: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type := p_okl_process_tmplts_tl_rec;

2743:
2744: l_api_version CONSTANT NUMBER := 1;
2745: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2746: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2747: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type := p_okl_process_tmplts_tl_rec;
2748: ldefoklprocesstmpltstlrec okl_process_tmplts_tl_rec_type;
2749: l_row_notfound BOOLEAN := TRUE;
2750: ----------------------------------
2751: -- FUNCTION populate_new_record --

Line 2748: ldefoklprocesstmpltstlrec okl_process_tmplts_tl_rec_type;

2744: l_api_version CONSTANT NUMBER := 1;
2745: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2746: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2747: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type := p_okl_process_tmplts_tl_rec;
2748: ldefoklprocesstmpltstlrec okl_process_tmplts_tl_rec_type;
2749: l_row_notfound BOOLEAN := TRUE;
2750: ----------------------------------
2751: -- FUNCTION populate_new_record --
2752: ----------------------------------

Line 2754: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,

2750: ----------------------------------
2751: -- FUNCTION populate_new_record --
2752: ----------------------------------
2753: FUNCTION populate_new_record (
2754: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
2755: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
2756: ) RETURN VARCHAR2 IS
2757: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2758: l_row_notfound BOOLEAN := TRUE;

Line 2755: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type

2751: -- FUNCTION populate_new_record --
2752: ----------------------------------
2753: FUNCTION populate_new_record (
2754: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
2755: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
2756: ) RETURN VARCHAR2 IS
2757: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2758: l_row_notfound BOOLEAN := TRUE;
2759: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2757: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

2753: FUNCTION populate_new_record (
2754: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
2755: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
2756: ) RETURN VARCHAR2 IS
2757: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2758: l_row_notfound BOOLEAN := TRUE;
2759: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2760: BEGIN
2761: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;

Line 2761: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;

2757: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2758: l_row_notfound BOOLEAN := TRUE;
2759: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2760: BEGIN
2761: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
2762: -- Get current database values
2763: l_okl_process_tmplts_tl_rec := get_rec(p_okl_process_tmplts_tl_rec, l_row_notfound);
2764: IF (l_row_notfound) THEN
2765: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2763: l_okl_process_tmplts_tl_rec := get_rec(p_okl_process_tmplts_tl_rec, l_row_notfound);

2759: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2760: BEGIN
2761: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
2762: -- Get current database values
2763: l_okl_process_tmplts_tl_rec := get_rec(p_okl_process_tmplts_tl_rec, l_row_notfound);
2764: IF (l_row_notfound) THEN
2765: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2766: END IF;
2767: IF (x_okl_process_tmplts_tl_rec.id = OKL_API.G_MISS_NUM)

Line 2767: IF (x_okl_process_tmplts_tl_rec.id = OKL_API.G_MISS_NUM)

2763: l_okl_process_tmplts_tl_rec := get_rec(p_okl_process_tmplts_tl_rec, l_row_notfound);
2764: IF (l_row_notfound) THEN
2765: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2766: END IF;
2767: IF (x_okl_process_tmplts_tl_rec.id = OKL_API.G_MISS_NUM)
2768: THEN
2769: x_okl_process_tmplts_tl_rec.id := l_okl_process_tmplts_tl_rec.id;
2770: END IF;
2771: IF (x_okl_process_tmplts_tl_rec.LANGUAGE = OKL_API.G_MISS_CHAR)

Line 2769: x_okl_process_tmplts_tl_rec.id := l_okl_process_tmplts_tl_rec.id;

2765: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2766: END IF;
2767: IF (x_okl_process_tmplts_tl_rec.id = OKL_API.G_MISS_NUM)
2768: THEN
2769: x_okl_process_tmplts_tl_rec.id := l_okl_process_tmplts_tl_rec.id;
2770: END IF;
2771: IF (x_okl_process_tmplts_tl_rec.LANGUAGE = OKL_API.G_MISS_CHAR)
2772: THEN
2773: x_okl_process_tmplts_tl_rec.LANGUAGE := l_okl_process_tmplts_tl_rec.LANGUAGE;

Line 2771: IF (x_okl_process_tmplts_tl_rec.LANGUAGE = OKL_API.G_MISS_CHAR)

2767: IF (x_okl_process_tmplts_tl_rec.id = OKL_API.G_MISS_NUM)
2768: THEN
2769: x_okl_process_tmplts_tl_rec.id := l_okl_process_tmplts_tl_rec.id;
2770: END IF;
2771: IF (x_okl_process_tmplts_tl_rec.LANGUAGE = OKL_API.G_MISS_CHAR)
2772: THEN
2773: x_okl_process_tmplts_tl_rec.LANGUAGE := l_okl_process_tmplts_tl_rec.LANGUAGE;
2774: END IF;
2775: IF (x_okl_process_tmplts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

Line 2773: x_okl_process_tmplts_tl_rec.LANGUAGE := l_okl_process_tmplts_tl_rec.LANGUAGE;

2769: x_okl_process_tmplts_tl_rec.id := l_okl_process_tmplts_tl_rec.id;
2770: END IF;
2771: IF (x_okl_process_tmplts_tl_rec.LANGUAGE = OKL_API.G_MISS_CHAR)
2772: THEN
2773: x_okl_process_tmplts_tl_rec.LANGUAGE := l_okl_process_tmplts_tl_rec.LANGUAGE;
2774: END IF;
2775: IF (x_okl_process_tmplts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2776: THEN
2777: x_okl_process_tmplts_tl_rec.source_lang := l_okl_process_tmplts_tl_rec.source_lang;

Line 2775: IF (x_okl_process_tmplts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

2771: IF (x_okl_process_tmplts_tl_rec.LANGUAGE = OKL_API.G_MISS_CHAR)
2772: THEN
2773: x_okl_process_tmplts_tl_rec.LANGUAGE := l_okl_process_tmplts_tl_rec.LANGUAGE;
2774: END IF;
2775: IF (x_okl_process_tmplts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2776: THEN
2777: x_okl_process_tmplts_tl_rec.source_lang := l_okl_process_tmplts_tl_rec.source_lang;
2778: END IF;
2779: IF (x_okl_process_tmplts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

Line 2777: x_okl_process_tmplts_tl_rec.source_lang := l_okl_process_tmplts_tl_rec.source_lang;

2773: x_okl_process_tmplts_tl_rec.LANGUAGE := l_okl_process_tmplts_tl_rec.LANGUAGE;
2774: END IF;
2775: IF (x_okl_process_tmplts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2776: THEN
2777: x_okl_process_tmplts_tl_rec.source_lang := l_okl_process_tmplts_tl_rec.source_lang;
2778: END IF;
2779: IF (x_okl_process_tmplts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2780: THEN
2781: x_okl_process_tmplts_tl_rec.sfwt_flag := l_okl_process_tmplts_tl_rec.sfwt_flag;

Line 2779: IF (x_okl_process_tmplts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

2775: IF (x_okl_process_tmplts_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2776: THEN
2777: x_okl_process_tmplts_tl_rec.source_lang := l_okl_process_tmplts_tl_rec.source_lang;
2778: END IF;
2779: IF (x_okl_process_tmplts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2780: THEN
2781: x_okl_process_tmplts_tl_rec.sfwt_flag := l_okl_process_tmplts_tl_rec.sfwt_flag;
2782: END IF;
2783: IF (x_okl_process_tmplts_tl_rec.email_subject_line = OKL_API.G_MISS_CHAR)

Line 2781: x_okl_process_tmplts_tl_rec.sfwt_flag := l_okl_process_tmplts_tl_rec.sfwt_flag;

2777: x_okl_process_tmplts_tl_rec.source_lang := l_okl_process_tmplts_tl_rec.source_lang;
2778: END IF;
2779: IF (x_okl_process_tmplts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2780: THEN
2781: x_okl_process_tmplts_tl_rec.sfwt_flag := l_okl_process_tmplts_tl_rec.sfwt_flag;
2782: END IF;
2783: IF (x_okl_process_tmplts_tl_rec.email_subject_line = OKL_API.G_MISS_CHAR)
2784: THEN
2785: x_okl_process_tmplts_tl_rec.email_subject_line := l_okl_process_tmplts_tl_rec.email_subject_line;

Line 2783: IF (x_okl_process_tmplts_tl_rec.email_subject_line = OKL_API.G_MISS_CHAR)

2779: IF (x_okl_process_tmplts_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2780: THEN
2781: x_okl_process_tmplts_tl_rec.sfwt_flag := l_okl_process_tmplts_tl_rec.sfwt_flag;
2782: END IF;
2783: IF (x_okl_process_tmplts_tl_rec.email_subject_line = OKL_API.G_MISS_CHAR)
2784: THEN
2785: x_okl_process_tmplts_tl_rec.email_subject_line := l_okl_process_tmplts_tl_rec.email_subject_line;
2786: END IF;
2787: IF (x_okl_process_tmplts_tl_rec.created_by = OKL_API.G_MISS_NUM)

Line 2785: x_okl_process_tmplts_tl_rec.email_subject_line := l_okl_process_tmplts_tl_rec.email_subject_line;

2781: x_okl_process_tmplts_tl_rec.sfwt_flag := l_okl_process_tmplts_tl_rec.sfwt_flag;
2782: END IF;
2783: IF (x_okl_process_tmplts_tl_rec.email_subject_line = OKL_API.G_MISS_CHAR)
2784: THEN
2785: x_okl_process_tmplts_tl_rec.email_subject_line := l_okl_process_tmplts_tl_rec.email_subject_line;
2786: END IF;
2787: IF (x_okl_process_tmplts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2788: THEN
2789: x_okl_process_tmplts_tl_rec.created_by := l_okl_process_tmplts_tl_rec.created_by;

Line 2787: IF (x_okl_process_tmplts_tl_rec.created_by = OKL_API.G_MISS_NUM)

2783: IF (x_okl_process_tmplts_tl_rec.email_subject_line = OKL_API.G_MISS_CHAR)
2784: THEN
2785: x_okl_process_tmplts_tl_rec.email_subject_line := l_okl_process_tmplts_tl_rec.email_subject_line;
2786: END IF;
2787: IF (x_okl_process_tmplts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2788: THEN
2789: x_okl_process_tmplts_tl_rec.created_by := l_okl_process_tmplts_tl_rec.created_by;
2790: END IF;
2791: IF (x_okl_process_tmplts_tl_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2789: x_okl_process_tmplts_tl_rec.created_by := l_okl_process_tmplts_tl_rec.created_by;

2785: x_okl_process_tmplts_tl_rec.email_subject_line := l_okl_process_tmplts_tl_rec.email_subject_line;
2786: END IF;
2787: IF (x_okl_process_tmplts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2788: THEN
2789: x_okl_process_tmplts_tl_rec.created_by := l_okl_process_tmplts_tl_rec.created_by;
2790: END IF;
2791: IF (x_okl_process_tmplts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2792: THEN
2793: x_okl_process_tmplts_tl_rec.creation_date := l_okl_process_tmplts_tl_rec.creation_date;

Line 2791: IF (x_okl_process_tmplts_tl_rec.creation_date = OKL_API.G_MISS_DATE)

2787: IF (x_okl_process_tmplts_tl_rec.created_by = OKL_API.G_MISS_NUM)
2788: THEN
2789: x_okl_process_tmplts_tl_rec.created_by := l_okl_process_tmplts_tl_rec.created_by;
2790: END IF;
2791: IF (x_okl_process_tmplts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2792: THEN
2793: x_okl_process_tmplts_tl_rec.creation_date := l_okl_process_tmplts_tl_rec.creation_date;
2794: END IF;
2795: IF (x_okl_process_tmplts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2793: x_okl_process_tmplts_tl_rec.creation_date := l_okl_process_tmplts_tl_rec.creation_date;

2789: x_okl_process_tmplts_tl_rec.created_by := l_okl_process_tmplts_tl_rec.created_by;
2790: END IF;
2791: IF (x_okl_process_tmplts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2792: THEN
2793: x_okl_process_tmplts_tl_rec.creation_date := l_okl_process_tmplts_tl_rec.creation_date;
2794: END IF;
2795: IF (x_okl_process_tmplts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2796: THEN
2797: x_okl_process_tmplts_tl_rec.last_updated_by := l_okl_process_tmplts_tl_rec.last_updated_by;

Line 2795: IF (x_okl_process_tmplts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

2791: IF (x_okl_process_tmplts_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2792: THEN
2793: x_okl_process_tmplts_tl_rec.creation_date := l_okl_process_tmplts_tl_rec.creation_date;
2794: END IF;
2795: IF (x_okl_process_tmplts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2796: THEN
2797: x_okl_process_tmplts_tl_rec.last_updated_by := l_okl_process_tmplts_tl_rec.last_updated_by;
2798: END IF;
2799: IF (x_okl_process_tmplts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2797: x_okl_process_tmplts_tl_rec.last_updated_by := l_okl_process_tmplts_tl_rec.last_updated_by;

2793: x_okl_process_tmplts_tl_rec.creation_date := l_okl_process_tmplts_tl_rec.creation_date;
2794: END IF;
2795: IF (x_okl_process_tmplts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2796: THEN
2797: x_okl_process_tmplts_tl_rec.last_updated_by := l_okl_process_tmplts_tl_rec.last_updated_by;
2798: END IF;
2799: IF (x_okl_process_tmplts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2800: THEN
2801: x_okl_process_tmplts_tl_rec.last_update_date := l_okl_process_tmplts_tl_rec.last_update_date;

Line 2799: IF (x_okl_process_tmplts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

2795: IF (x_okl_process_tmplts_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2796: THEN
2797: x_okl_process_tmplts_tl_rec.last_updated_by := l_okl_process_tmplts_tl_rec.last_updated_by;
2798: END IF;
2799: IF (x_okl_process_tmplts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2800: THEN
2801: x_okl_process_tmplts_tl_rec.last_update_date := l_okl_process_tmplts_tl_rec.last_update_date;
2802: END IF;
2803: IF (x_okl_process_tmplts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2801: x_okl_process_tmplts_tl_rec.last_update_date := l_okl_process_tmplts_tl_rec.last_update_date;

2797: x_okl_process_tmplts_tl_rec.last_updated_by := l_okl_process_tmplts_tl_rec.last_updated_by;
2798: END IF;
2799: IF (x_okl_process_tmplts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2800: THEN
2801: x_okl_process_tmplts_tl_rec.last_update_date := l_okl_process_tmplts_tl_rec.last_update_date;
2802: END IF;
2803: IF (x_okl_process_tmplts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2804: THEN
2805: x_okl_process_tmplts_tl_rec.last_update_login := l_okl_process_tmplts_tl_rec.last_update_login;

Line 2803: IF (x_okl_process_tmplts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

2799: IF (x_okl_process_tmplts_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2800: THEN
2801: x_okl_process_tmplts_tl_rec.last_update_date := l_okl_process_tmplts_tl_rec.last_update_date;
2802: END IF;
2803: IF (x_okl_process_tmplts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2804: THEN
2805: x_okl_process_tmplts_tl_rec.last_update_login := l_okl_process_tmplts_tl_rec.last_update_login;
2806: END IF;
2807: RETURN(l_return_status);

Line 2805: x_okl_process_tmplts_tl_rec.last_update_login := l_okl_process_tmplts_tl_rec.last_update_login;

2801: x_okl_process_tmplts_tl_rec.last_update_date := l_okl_process_tmplts_tl_rec.last_update_date;
2802: END IF;
2803: IF (x_okl_process_tmplts_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2804: THEN
2805: x_okl_process_tmplts_tl_rec.last_update_login := l_okl_process_tmplts_tl_rec.last_update_login;
2806: END IF;
2807: RETURN(l_return_status);
2808: END populate_new_record;
2809: ----------------------------------------------

Line 2810: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --

2806: END IF;
2807: RETURN(l_return_status);
2808: END populate_new_record;
2809: ----------------------------------------------
2810: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
2811: ----------------------------------------------
2812: FUNCTION Set_Attributes (
2813: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
2814: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type

Line 2813: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,

2809: ----------------------------------------------
2810: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
2811: ----------------------------------------------
2812: FUNCTION Set_Attributes (
2813: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
2814: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
2815: ) RETURN VARCHAR2 IS
2816: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2817: BEGIN

Line 2814: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type

2810: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
2811: ----------------------------------------------
2812: FUNCTION Set_Attributes (
2813: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
2814: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
2815: ) RETURN VARCHAR2 IS
2816: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2817: BEGIN
2818: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;

Line 2818: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;

2814: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
2815: ) RETURN VARCHAR2 IS
2816: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2817: BEGIN
2818: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
2819: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG');
2820: x_okl_process_tmplts_tl_rec.SOURCE_LANG := USERENV('LANG');
2821: RETURN(l_return_status);
2822: END Set_Attributes;

Line 2819: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG');

2815: ) RETURN VARCHAR2 IS
2816: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2817: BEGIN
2818: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
2819: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG');
2820: x_okl_process_tmplts_tl_rec.SOURCE_LANG := USERENV('LANG');
2821: RETURN(l_return_status);
2822: END Set_Attributes;
2823: BEGIN

Line 2820: x_okl_process_tmplts_tl_rec.SOURCE_LANG := USERENV('LANG');

2816: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2817: BEGIN
2818: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
2819: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG');
2820: x_okl_process_tmplts_tl_rec.SOURCE_LANG := USERENV('LANG');
2821: RETURN(l_return_status);
2822: END Set_Attributes;
2823: BEGIN
2824: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2835: p_okl_process_tmplts_tl_rec, -- IN

2831: RAISE OKL_API.G_EXCEPTION_ERROR;
2832: END IF;
2833: --- Setting item attributes
2834: l_return_status := Set_Attributes(
2835: p_okl_process_tmplts_tl_rec, -- IN
2836: l_okl_process_tmplts_tl_rec); -- OUT
2837: --- If any errors happen abort API
2838: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2839: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2836: l_okl_process_tmplts_tl_rec); -- OUT

2832: END IF;
2833: --- Setting item attributes
2834: l_return_status := Set_Attributes(
2835: p_okl_process_tmplts_tl_rec, -- IN
2836: l_okl_process_tmplts_tl_rec); -- OUT
2837: --- If any errors happen abort API
2838: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2839: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2840: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2843: l_return_status := populate_new_record(l_okl_process_tmplts_tl_rec, ldefoklprocesstmpltstlrec);

2839: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2840: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2841: RAISE OKL_API.G_EXCEPTION_ERROR;
2842: END IF;
2843: l_return_status := populate_new_record(l_okl_process_tmplts_tl_rec, ldefoklprocesstmpltstlrec);
2844: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2849: UPDATE OKL_PROCESS_TMPLTS_TL

2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;
2849: UPDATE OKL_PROCESS_TMPLTS_TL
2850: SET EMAIL_SUBJECT_LINE = ldefoklprocesstmpltstlrec.email_subject_line,
2851: SOURCE_LANG = ldefoklprocesstmpltstlrec.source_lang, --Fix for bug 3637102
2852: CREATED_BY = ldefoklprocesstmpltstlrec.created_by,
2853: CREATION_DATE = ldefoklprocesstmpltstlrec.creation_date,

Line 2861: UPDATE OKL_PROCESS_TMPLTS_TL

2857: WHERE ID = ldefoklprocesstmpltstlrec.id
2858: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
2859: --AND SOURCE_LANG = USERENV('LANG');
2860:
2861: UPDATE OKL_PROCESS_TMPLTS_TL
2862: SET SFWT_FLAG = 'Y'
2863: WHERE ID = ldefoklprocesstmpltstlrec.id
2864: AND SOURCE_LANG <> USERENV('LANG');
2865:

Line 2866: x_okl_process_tmplts_tl_rec := ldefoklprocesstmpltstlrec;

2862: SET SFWT_FLAG = 'Y'
2863: WHERE ID = ldefoklprocesstmpltstlrec.id
2864: AND SOURCE_LANG <> USERENV('LANG');
2865:
2866: x_okl_process_tmplts_tl_rec := ldefoklprocesstmpltstlrec;
2867: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2868:
2869: EXCEPTION
2870:

Line 2921: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

2917: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2918: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2919: l_ptmv_rec ptmv_rec_type := p_ptmv_rec;
2920: l_def_ptmv_rec ptmv_rec_type;
2921: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2922: lx_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2923: l_ptm_rec ptm_rec_type;
2924: lx_ptm_rec ptm_rec_type;
2925: -------------------------------

Line 2922: lx_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

2918: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2919: l_ptmv_rec ptmv_rec_type := p_ptmv_rec;
2920: l_def_ptmv_rec ptmv_rec_type;
2921: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2922: lx_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
2923: l_ptm_rec ptm_rec_type;
2924: lx_ptm_rec ptm_rec_type;
2925: -------------------------------
2926: -- FUNCTION fill_who_columns --

Line 3168: migrate(l_def_ptmv_rec, l_okl_process_tmplts_tl_rec);

3164:
3165: --------------------------------------
3166: -- Move VIEW record to "Child" records
3167: --------------------------------------
3168: migrate(l_def_ptmv_rec, l_okl_process_tmplts_tl_rec);
3169: migrate(l_def_ptmv_rec, l_ptm_rec);
3170: --------------------------------------------
3171: -- Call the UPDATE_ROW for each child record
3172: --------------------------------------------

Line 3177: l_okl_process_tmplts_tl_rec,

3173: update_row(p_init_msg_list,
3174: x_return_status,
3175: x_msg_count,
3176: x_msg_data,
3177: l_okl_process_tmplts_tl_rec,
3178: lx_okl_process_tmplts_tl_rec);
3179:
3180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3178: lx_okl_process_tmplts_tl_rec);

3174: x_return_status,
3175: x_msg_count,
3176: x_msg_data,
3177: l_okl_process_tmplts_tl_rec,
3178: lx_okl_process_tmplts_tl_rec);
3179:
3180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3186: migrate(lx_okl_process_tmplts_tl_rec, l_def_ptmv_rec);

3182: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3183: RAISE OKL_API.G_EXCEPTION_ERROR;
3184: END IF;
3185:
3186: migrate(lx_okl_process_tmplts_tl_rec, l_def_ptmv_rec);
3187:
3188: update_row(p_init_msg_list,
3189: x_return_status,
3190: x_msg_count,

Line 3378: -- delete_row for:OKL_PROCESS_TMPLTS_TL --

3374: );
3375: END delete_row;
3376:
3377: ------------------------------------------
3378: -- delete_row for:OKL_PROCESS_TMPLTS_TL --
3379: ------------------------------------------
3380: PROCEDURE delete_row(
3381: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3382: x_return_status OUT NOCOPY VARCHAR2,

Line 3385: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS

3381: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3382: x_return_status OUT NOCOPY VARCHAR2,
3383: x_msg_count OUT NOCOPY NUMBER,
3384: x_msg_data OUT NOCOPY VARCHAR2,
3385: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type) IS
3386:
3387: l_api_version CONSTANT NUMBER := 1;
3388: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3389: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3390: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type:= p_okl_process_tmplts_tl_rec;

3386:
3387: l_api_version CONSTANT NUMBER := 1;
3388: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3389: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3390: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type:= p_okl_process_tmplts_tl_rec;
3391: l_row_notfound BOOLEAN := TRUE;
3392: ----------------------------------------------
3393: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
3394: ----------------------------------------------

Line 3393: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --

3389: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3390: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type:= p_okl_process_tmplts_tl_rec;
3391: l_row_notfound BOOLEAN := TRUE;
3392: ----------------------------------------------
3393: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
3394: ----------------------------------------------
3395: FUNCTION Set_Attributes (
3396: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
3397: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type

Line 3396: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,

3392: ----------------------------------------------
3393: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
3394: ----------------------------------------------
3395: FUNCTION Set_Attributes (
3396: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
3397: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
3398: ) RETURN VARCHAR2 IS
3399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3400: BEGIN

Line 3397: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type

3393: -- Set_Attributes for:OKL_PROCESS_TMPLTS_TL --
3394: ----------------------------------------------
3395: FUNCTION Set_Attributes (
3396: p_okl_process_tmplts_tl_rec IN okl_process_tmplts_tl_rec_type,
3397: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
3398: ) RETURN VARCHAR2 IS
3399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3400: BEGIN
3401: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;

Line 3401: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;

3397: x_okl_process_tmplts_tl_rec OUT NOCOPY okl_process_tmplts_tl_rec_type
3398: ) RETURN VARCHAR2 IS
3399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3400: BEGIN
3401: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
3402: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG');
3403: RETURN(l_return_status);
3404: END Set_Attributes;
3405: BEGIN

Line 3402: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG');

3398: ) RETURN VARCHAR2 IS
3399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3400: BEGIN
3401: x_okl_process_tmplts_tl_rec := p_okl_process_tmplts_tl_rec;
3402: x_okl_process_tmplts_tl_rec.LANGUAGE := USERENV('LANG');
3403: RETURN(l_return_status);
3404: END Set_Attributes;
3405: BEGIN
3406: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3417: p_okl_process_tmplts_tl_rec, -- IN

3413: RAISE OKL_API.G_EXCEPTION_ERROR;
3414: END IF;
3415: --- Setting item attributes
3416: l_return_status := Set_Attributes(
3417: p_okl_process_tmplts_tl_rec, -- IN
3418: l_okl_process_tmplts_tl_rec); -- OUT
3419: --- If any errors happen abort API
3420: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3418: l_okl_process_tmplts_tl_rec); -- OUT

3414: END IF;
3415: --- Setting item attributes
3416: l_return_status := Set_Attributes(
3417: p_okl_process_tmplts_tl_rec, -- IN
3418: l_okl_process_tmplts_tl_rec); -- OUT
3419: --- If any errors happen abort API
3420: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3422: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3425: DELETE FROM OKL_PROCESS_TMPLTS_TL

3421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3422: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3423: RAISE OKL_API.G_EXCEPTION_ERROR;
3424: END IF;
3425: DELETE FROM OKL_PROCESS_TMPLTS_TL
3426: WHERE ID = l_okl_process_tmplts_tl_rec.id;
3427:
3428: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3429: EXCEPTION

Line 3426: WHERE ID = l_okl_process_tmplts_tl_rec.id;

3422: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3423: RAISE OKL_API.G_EXCEPTION_ERROR;
3424: END IF;
3425: DELETE FROM OKL_PROCESS_TMPLTS_TL
3426: WHERE ID = l_okl_process_tmplts_tl_rec.id;
3427:
3428: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3429: EXCEPTION
3430: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3476: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;

3472: l_api_version CONSTANT NUMBER := 1;
3473: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3474: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3475: l_ptmv_rec ptmv_rec_type := p_ptmv_rec;
3476: l_okl_process_tmplts_tl_rec okl_process_tmplts_tl_rec_type;
3477: l_ptm_rec ptm_rec_type;
3478: BEGIN
3479: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3480: G_PKG_NAME,

Line 3494: migrate(l_ptmv_rec, l_okl_process_tmplts_tl_rec);

3490: END IF;
3491: --------------------------------------
3492: -- Move VIEW record to "Child" records
3493: --------------------------------------
3494: migrate(l_ptmv_rec, l_okl_process_tmplts_tl_rec);
3495: migrate(l_ptmv_rec, l_ptm_rec);
3496: --------------------------------------------
3497: -- Call the DELETE_ROW for each child record
3498: --------------------------------------------

Line 3504: l_okl_process_tmplts_tl_rec

3500: p_init_msg_list,
3501: x_return_status,
3502: x_msg_count,
3503: x_msg_data,
3504: l_okl_process_tmplts_tl_rec
3505: );
3506: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3508: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN