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.

APPS.OKL_TLD_PVT dependencies on OKL_TXD_AR_LN_DTLS_TL

Line 509: DELETE FROM OKL_TXD_AR_LN_DTLS_TL T

505: -- PROCEDURE add_language
506: ---------------------------------------------------------------------------
507: PROCEDURE add_language IS
508: BEGIN
509: DELETE FROM OKL_TXD_AR_LN_DTLS_TL T
510: WHERE NOT EXISTS (
511: SELECT NULL
512: FROM OKL_TXD_AR_LN_DTLS_B B
513: WHERE B.ID = T.ID

Line 517: UPDATE OKL_TXD_AR_LN_DTLS_TL T SET (

513: WHERE B.ID = T.ID
514: AND T.LANGUAGE = USERENV('LANG')
515: );
516:
517: UPDATE OKL_TXD_AR_LN_DTLS_TL T SET (
518: DESCRIPTION) = (SELECT
519: B.DESCRIPTION
520: FROM OKL_TXD_AR_LN_DTLS_TL B
521: WHERE B.ID = T.ID

Line 520: FROM OKL_TXD_AR_LN_DTLS_TL B

516:
517: UPDATE OKL_TXD_AR_LN_DTLS_TL T SET (
518: DESCRIPTION) = (SELECT
519: B.DESCRIPTION
520: FROM OKL_TXD_AR_LN_DTLS_TL B
521: WHERE B.ID = T.ID
522: AND B.LANGUAGE = T.SOURCE_LANG)
523: WHERE (
524: T.ID,

Line 529: FROM OKL_TXD_AR_LN_DTLS_TL SUBB, OKL_TXD_AR_LN_DTLS_TL SUBT

525: T.LANGUAGE)
526: IN (SELECT
527: SUBT.ID,
528: SUBT.LANGUAGE
529: FROM OKL_TXD_AR_LN_DTLS_TL SUBB, OKL_TXD_AR_LN_DTLS_TL SUBT
530: WHERE SUBB.ID = SUBT.ID
531: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
532: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
533: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 537: INSERT INTO OKL_TXD_AR_LN_DTLS_TL (

533: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
534: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
535: ));
536:
537: INSERT INTO OKL_TXD_AR_LN_DTLS_TL (
538: ID,
539: LANGUAGE,
540: SOURCE_LANG,
541: ERROR_MESSAGE,

Line 561: FROM OKL_TXD_AR_LN_DTLS_TL B, FND_LANGUAGES L

557: B.CREATION_DATE,
558: B.LAST_UPDATED_BY,
559: B.LAST_UPDATE_DATE,
560: B.LAST_UPDATE_LOGIN
561: FROM OKL_TXD_AR_LN_DTLS_TL B, FND_LANGUAGES L
562: WHERE L.INSTALLED_FLAG IN ('I', 'B')
563: AND B.LANGUAGE = USERENV('LANG')
564: AND NOT EXISTS(
565: SELECT NULL

Line 566: FROM OKL_TXD_AR_LN_DTLS_TL T

562: WHERE L.INSTALLED_FLAG IN ('I', 'B')
563: AND B.LANGUAGE = USERENV('LANG')
564: AND NOT EXISTS(
565: SELECT NULL
566: FROM OKL_TXD_AR_LN_DTLS_TL T
567: WHERE T.ID = B.ID
568: AND T.LANGUAGE = L.LANGUAGE_CODE
569: );
570:

Line 742: -- FUNCTION get_rec for: OKL_TXD_AR_LN_DTLS_TL

738: BEGIN
739: RETURN(get_rec(p_tld_rec, l_row_notfound));
740: END get_rec;
741: ---------------------------------------------------------------------------
742: -- FUNCTION get_rec for: OKL_TXD_AR_LN_DTLS_TL
743: ---------------------------------------------------------------------------
744: FUNCTION get_rec (
745: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
746: x_no_data_found OUT NOCOPY BOOLEAN

Line 745: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,

741: ---------------------------------------------------------------------------
742: -- FUNCTION get_rec for: OKL_TXD_AR_LN_DTLS_TL
743: ---------------------------------------------------------------------------
744: FUNCTION get_rec (
745: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
746: x_no_data_found OUT NOCOPY BOOLEAN
747: ) RETURN okl_txd_ar_ln_dtls_tl_rec_type IS
748: CURSOR okl_txd_ar_ln_dtls_tl_pk_csr (p_id IN NUMBER,
749: p_language IN VARCHAR2) IS

Line 747: ) RETURN okl_txd_ar_ln_dtls_tl_rec_type IS

743: ---------------------------------------------------------------------------
744: FUNCTION get_rec (
745: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
746: x_no_data_found OUT NOCOPY BOOLEAN
747: ) RETURN okl_txd_ar_ln_dtls_tl_rec_type IS
748: CURSOR okl_txd_ar_ln_dtls_tl_pk_csr (p_id IN NUMBER,
749: p_language IN VARCHAR2) IS
750: SELECT
751: ID,

Line 748: CURSOR okl_txd_ar_ln_dtls_tl_pk_csr (p_id IN NUMBER,

744: FUNCTION get_rec (
745: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
746: x_no_data_found OUT NOCOPY BOOLEAN
747: ) RETURN okl_txd_ar_ln_dtls_tl_rec_type IS
748: CURSOR okl_txd_ar_ln_dtls_tl_pk_csr (p_id IN NUMBER,
749: p_language IN VARCHAR2) IS
750: SELECT
751: ID,
752: LANGUAGE,

Line 762: FROM Okl_Txd_Ar_Ln_Dtls_Tl

758: CREATION_DATE,
759: LAST_UPDATED_BY,
760: LAST_UPDATE_DATE,
761: LAST_UPDATE_LOGIN
762: FROM Okl_Txd_Ar_Ln_Dtls_Tl
763: WHERE okl_txd_ar_ln_dtls_tl.id = p_id
764: AND okl_txd_ar_ln_dtls_tl.LANGUAGE = p_language;
765: l_okl_txd_ar_ln_dtls_tl_pk okl_txd_ar_ln_dtls_tl_pk_csr%ROWTYPE;
766: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

Line 763: WHERE okl_txd_ar_ln_dtls_tl.id = p_id

759: LAST_UPDATED_BY,
760: LAST_UPDATE_DATE,
761: LAST_UPDATE_LOGIN
762: FROM Okl_Txd_Ar_Ln_Dtls_Tl
763: WHERE okl_txd_ar_ln_dtls_tl.id = p_id
764: AND okl_txd_ar_ln_dtls_tl.LANGUAGE = p_language;
765: l_okl_txd_ar_ln_dtls_tl_pk okl_txd_ar_ln_dtls_tl_pk_csr%ROWTYPE;
766: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
767: BEGIN

Line 764: AND okl_txd_ar_ln_dtls_tl.LANGUAGE = p_language;

760: LAST_UPDATE_DATE,
761: LAST_UPDATE_LOGIN
762: FROM Okl_Txd_Ar_Ln_Dtls_Tl
763: WHERE okl_txd_ar_ln_dtls_tl.id = p_id
764: AND okl_txd_ar_ln_dtls_tl.LANGUAGE = p_language;
765: l_okl_txd_ar_ln_dtls_tl_pk okl_txd_ar_ln_dtls_tl_pk_csr%ROWTYPE;
766: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
767: BEGIN
768: x_no_data_found := TRUE;

Line 765: l_okl_txd_ar_ln_dtls_tl_pk okl_txd_ar_ln_dtls_tl_pk_csr%ROWTYPE;

761: LAST_UPDATE_LOGIN
762: FROM Okl_Txd_Ar_Ln_Dtls_Tl
763: WHERE okl_txd_ar_ln_dtls_tl.id = p_id
764: AND okl_txd_ar_ln_dtls_tl.LANGUAGE = p_language;
765: l_okl_txd_ar_ln_dtls_tl_pk okl_txd_ar_ln_dtls_tl_pk_csr%ROWTYPE;
766: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
767: BEGIN
768: x_no_data_found := TRUE;
769: -- Get current database values

Line 766: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

762: FROM Okl_Txd_Ar_Ln_Dtls_Tl
763: WHERE okl_txd_ar_ln_dtls_tl.id = p_id
764: AND okl_txd_ar_ln_dtls_tl.LANGUAGE = p_language;
765: l_okl_txd_ar_ln_dtls_tl_pk okl_txd_ar_ln_dtls_tl_pk_csr%ROWTYPE;
766: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
767: BEGIN
768: x_no_data_found := TRUE;
769: -- Get current database values
770: OPEN okl_txd_ar_ln_dtls_tl_pk_csr (p_okl_txd_ar_ln_dtls_tl_rec.id,

Line 770: OPEN okl_txd_ar_ln_dtls_tl_pk_csr (p_okl_txd_ar_ln_dtls_tl_rec.id,

766: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
767: BEGIN
768: x_no_data_found := TRUE;
769: -- Get current database values
770: OPEN okl_txd_ar_ln_dtls_tl_pk_csr (p_okl_txd_ar_ln_dtls_tl_rec.id,
771: p_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE);
772: FETCH okl_txd_ar_ln_dtls_tl_pk_csr INTO
773: l_okl_txd_ar_ln_dtls_tl_rec.ID,
774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,

Line 771: p_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE);

767: BEGIN
768: x_no_data_found := TRUE;
769: -- Get current database values
770: OPEN okl_txd_ar_ln_dtls_tl_pk_csr (p_okl_txd_ar_ln_dtls_tl_rec.id,
771: p_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE);
772: FETCH okl_txd_ar_ln_dtls_tl_pk_csr INTO
773: l_okl_txd_ar_ln_dtls_tl_rec.ID,
774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,

Line 772: FETCH okl_txd_ar_ln_dtls_tl_pk_csr INTO

768: x_no_data_found := TRUE;
769: -- Get current database values
770: OPEN okl_txd_ar_ln_dtls_tl_pk_csr (p_okl_txd_ar_ln_dtls_tl_rec.id,
771: p_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE);
772: FETCH okl_txd_ar_ln_dtls_tl_pk_csr INTO
773: l_okl_txd_ar_ln_dtls_tl_rec.ID,
774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,
776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,

Line 773: l_okl_txd_ar_ln_dtls_tl_rec.ID,

769: -- Get current database values
770: OPEN okl_txd_ar_ln_dtls_tl_pk_csr (p_okl_txd_ar_ln_dtls_tl_rec.id,
771: p_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE);
772: FETCH okl_txd_ar_ln_dtls_tl_pk_csr INTO
773: l_okl_txd_ar_ln_dtls_tl_rec.ID,
774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,
776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,
777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,

Line 774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,

770: OPEN okl_txd_ar_ln_dtls_tl_pk_csr (p_okl_txd_ar_ln_dtls_tl_rec.id,
771: p_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE);
772: FETCH okl_txd_ar_ln_dtls_tl_pk_csr INTO
773: l_okl_txd_ar_ln_dtls_tl_rec.ID,
774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,
776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,
777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,
778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,

Line 775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,

771: p_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE);
772: FETCH okl_txd_ar_ln_dtls_tl_pk_csr INTO
773: l_okl_txd_ar_ln_dtls_tl_rec.ID,
774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,
776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,
777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,
778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,
779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,

Line 776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,

772: FETCH okl_txd_ar_ln_dtls_tl_pk_csr INTO
773: l_okl_txd_ar_ln_dtls_tl_rec.ID,
774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,
776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,
777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,
778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,
779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,
780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,

Line 777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,

773: l_okl_txd_ar_ln_dtls_tl_rec.ID,
774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,
776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,
777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,
778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,
779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,
780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,
781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,

Line 778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,

774: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,
776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,
777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,
778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,
779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,
780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,
781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,
782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,

Line 779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,

775: l_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG,
776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,
777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,
778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,
779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,
780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,
781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,
782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,
783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;

Line 780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,

776: l_okl_txd_ar_ln_dtls_tl_rec.ERROR_MESSAGE,
777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,
778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,
779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,
780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,
781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,
782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,
783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;
784: x_no_data_found := okl_txd_ar_ln_dtls_tl_pk_csr%NOTFOUND;

Line 781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,

777: l_okl_txd_ar_ln_dtls_tl_rec.SFWT_FLAG,
778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,
779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,
780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,
781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,
782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,
783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;
784: x_no_data_found := okl_txd_ar_ln_dtls_tl_pk_csr%NOTFOUND;
785: CLOSE okl_txd_ar_ln_dtls_tl_pk_csr;

Line 782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,

778: l_okl_txd_ar_ln_dtls_tl_rec.DESCRIPTION,
779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,
780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,
781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,
782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,
783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;
784: x_no_data_found := okl_txd_ar_ln_dtls_tl_pk_csr%NOTFOUND;
785: CLOSE okl_txd_ar_ln_dtls_tl_pk_csr;
786: RETURN(l_okl_txd_ar_ln_dtls_tl_rec);

Line 783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;

779: l_okl_txd_ar_ln_dtls_tl_rec.CREATED_BY,
780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,
781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,
782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,
783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;
784: x_no_data_found := okl_txd_ar_ln_dtls_tl_pk_csr%NOTFOUND;
785: CLOSE okl_txd_ar_ln_dtls_tl_pk_csr;
786: RETURN(l_okl_txd_ar_ln_dtls_tl_rec);
787: END get_rec;

Line 784: x_no_data_found := okl_txd_ar_ln_dtls_tl_pk_csr%NOTFOUND;

780: l_okl_txd_ar_ln_dtls_tl_rec.CREATION_DATE,
781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,
782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,
783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;
784: x_no_data_found := okl_txd_ar_ln_dtls_tl_pk_csr%NOTFOUND;
785: CLOSE okl_txd_ar_ln_dtls_tl_pk_csr;
786: RETURN(l_okl_txd_ar_ln_dtls_tl_rec);
787: END get_rec;
788:

Line 785: CLOSE okl_txd_ar_ln_dtls_tl_pk_csr;

781: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATED_BY,
782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,
783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;
784: x_no_data_found := okl_txd_ar_ln_dtls_tl_pk_csr%NOTFOUND;
785: CLOSE okl_txd_ar_ln_dtls_tl_pk_csr;
786: RETURN(l_okl_txd_ar_ln_dtls_tl_rec);
787: END get_rec;
788:
789: FUNCTION get_rec (

Line 786: RETURN(l_okl_txd_ar_ln_dtls_tl_rec);

782: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_DATE,
783: l_okl_txd_ar_ln_dtls_tl_rec.LAST_UPDATE_LOGIN;
784: x_no_data_found := okl_txd_ar_ln_dtls_tl_pk_csr%NOTFOUND;
785: CLOSE okl_txd_ar_ln_dtls_tl_pk_csr;
786: RETURN(l_okl_txd_ar_ln_dtls_tl_rec);
787: END get_rec;
788:
789: FUNCTION get_rec (
790: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type

Line 790: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type

786: RETURN(l_okl_txd_ar_ln_dtls_tl_rec);
787: END get_rec;
788:
789: FUNCTION get_rec (
790: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type
791: ) RETURN okl_txd_ar_ln_dtls_tl_rec_type IS
792: l_row_notfound BOOLEAN := TRUE;
793: BEGIN
794: RETURN(get_rec(p_okl_txd_ar_ln_dtls_tl_rec, l_row_notfound));

Line 791: ) RETURN okl_txd_ar_ln_dtls_tl_rec_type IS

787: END get_rec;
788:
789: FUNCTION get_rec (
790: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type
791: ) RETURN okl_txd_ar_ln_dtls_tl_rec_type IS
792: l_row_notfound BOOLEAN := TRUE;
793: BEGIN
794: RETURN(get_rec(p_okl_txd_ar_ln_dtls_tl_rec, l_row_notfound));
795: END get_rec;

Line 794: RETURN(get_rec(p_okl_txd_ar_ln_dtls_tl_rec, l_row_notfound));

790: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type
791: ) RETURN okl_txd_ar_ln_dtls_tl_rec_type IS
792: l_row_notfound BOOLEAN := TRUE;
793: BEGIN
794: RETURN(get_rec(p_okl_txd_ar_ln_dtls_tl_rec, l_row_notfound));
795: END get_rec;
796: ---------------------------------------------------------------------------
797: -- FUNCTION get_rec for: OKL_TXD_AR_LN_DTLS_V
798: ---------------------------------------------------------------------------

Line 1534: p_to IN OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type

1530: p_to.last_update_login := p_from.last_update_login;
1531: END migrate;
1532: PROCEDURE migrate (
1533: p_from IN tldv_rec_type,
1534: p_to IN OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
1535: ) IS
1536: BEGIN
1537: p_to.id := p_from.id;
1538: p_to.error_message := p_from.error_message;

Line 1548: p_from IN okl_txd_ar_ln_dtls_tl_rec_type,

1544: p_to.last_update_date := p_from.last_update_date;
1545: p_to.last_update_login := p_from.last_update_login;
1546: END migrate;
1547: PROCEDURE migrate (
1548: p_from IN okl_txd_ar_ln_dtls_tl_rec_type,
1549: p_to IN OUT NOCOPY tldv_rec_type
1550: ) IS
1551: BEGIN
1552: p_to.id := p_from.id;

Line 1582: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

1578: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1579: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1580: l_tldv_rec tldv_rec_type := p_tldv_rec;
1581: l_tld_rec tld_rec_type;
1582: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
1583: BEGIN
1584: l_return_status := Okl_api.START_ACTIVITY(l_api_name,
1585: G_PKG_NAME,
1586: p_init_msg_list,

Line 1953: -- insert_row for:OKL_TXD_AR_LN_DTLS_TL --

1949: '_PVT'
1950: );
1951: END insert_row;
1952: ------------------------------------------
1953: -- insert_row for:OKL_TXD_AR_LN_DTLS_TL --
1954: ------------------------------------------
1955: PROCEDURE insert_row(
1956: p_init_msg_list IN VARCHAR2,
1957: x_return_status OUT NOCOPY VARCHAR2,

Line 1960: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,

1956: p_init_msg_list IN VARCHAR2,
1957: x_return_status OUT NOCOPY VARCHAR2,
1958: x_msg_count OUT NOCOPY NUMBER,
1959: x_msg_data OUT NOCOPY VARCHAR2,
1960: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
1961: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type) IS
1962:
1963: l_api_version CONSTANT NUMBER := 1;
1964: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1961: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type) IS

1957: x_return_status OUT NOCOPY VARCHAR2,
1958: x_msg_count OUT NOCOPY NUMBER,
1959: x_msg_data OUT NOCOPY VARCHAR2,
1960: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
1961: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type) IS
1962:
1963: l_api_version CONSTANT NUMBER := 1;
1964: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1965: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;

Line 1966: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type := p_okl_txd_ar_ln_dtls_tl_rec;

1962:
1963: l_api_version CONSTANT NUMBER := 1;
1964: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1965: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1966: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type := p_okl_txd_ar_ln_dtls_tl_rec;
1967: ldefokltxdarlndtlstlrec okl_txd_ar_ln_dtls_tl_rec_type;
1968: CURSOR get_languages IS
1969: SELECT *
1970: FROM FND_LANGUAGES

Line 1967: ldefokltxdarlndtlstlrec okl_txd_ar_ln_dtls_tl_rec_type;

1963: l_api_version CONSTANT NUMBER := 1;
1964: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1965: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1966: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type := p_okl_txd_ar_ln_dtls_tl_rec;
1967: ldefokltxdarlndtlstlrec okl_txd_ar_ln_dtls_tl_rec_type;
1968: CURSOR get_languages IS
1969: SELECT *
1970: FROM FND_LANGUAGES
1971: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1973: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --

1969: SELECT *
1970: FROM FND_LANGUAGES
1971: WHERE INSTALLED_FLAG IN ('I', 'B');
1972: ----------------------------------------------
1973: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
1974: ----------------------------------------------
1975: FUNCTION Set_Attributes (
1976: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
1977: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type

Line 1976: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,

1972: ----------------------------------------------
1973: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
1974: ----------------------------------------------
1975: FUNCTION Set_Attributes (
1976: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
1977: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
1978: ) RETURN VARCHAR2 IS
1979: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1980: BEGIN

Line 1977: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type

1973: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
1974: ----------------------------------------------
1975: FUNCTION Set_Attributes (
1976: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
1977: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
1978: ) RETURN VARCHAR2 IS
1979: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1980: BEGIN
1981: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;

Line 1981: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;

1977: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
1978: ) RETURN VARCHAR2 IS
1979: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1980: BEGIN
1981: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
1982: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');
1983: x_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG := USERENV('LANG');
1984: RETURN(l_return_status);
1985: END Set_Attributes;

Line 1982: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');

1978: ) RETURN VARCHAR2 IS
1979: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1980: BEGIN
1981: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
1982: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');
1983: x_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG := USERENV('LANG');
1984: RETURN(l_return_status);
1985: END Set_Attributes;
1986: BEGIN

Line 1983: x_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG := USERENV('LANG');

1979: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1980: BEGIN
1981: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
1982: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');
1983: x_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG := USERENV('LANG');
1984: RETURN(l_return_status);
1985: END Set_Attributes;
1986: BEGIN
1987: l_return_status := Okl_api.START_ACTIVITY(l_api_name,

Line 1998: p_okl_txd_ar_ln_dtls_tl_rec, -- IN

1994: RAISE Okl_api.G_EXCEPTION_ERROR;
1995: END IF;
1996: --- Setting item attributes
1997: l_return_status := Set_Attributes(
1998: p_okl_txd_ar_ln_dtls_tl_rec, -- IN
1999: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT
2000: --- If any errors happen abort API
2001: IF (l_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
2002: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1999: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT

1995: END IF;
1996: --- Setting item attributes
1997: l_return_status := Set_Attributes(
1998: p_okl_txd_ar_ln_dtls_tl_rec, -- IN
1999: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT
2000: --- If any errors happen abort API
2001: IF (l_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
2002: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2003: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN

Line 2007: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_lang_rec.language_code;

2003: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
2004: RAISE Okl_api.G_EXCEPTION_ERROR;
2005: END IF;
2006: FOR l_lang_rec IN get_languages LOOP
2007: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_lang_rec.language_code;
2008: INSERT INTO OKL_TXD_AR_LN_DTLS_TL(
2009: id,
2010: LANGUAGE,
2011: source_lang,

Line 2008: INSERT INTO OKL_TXD_AR_LN_DTLS_TL(

2004: RAISE Okl_api.G_EXCEPTION_ERROR;
2005: END IF;
2006: FOR l_lang_rec IN get_languages LOOP
2007: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_lang_rec.language_code;
2008: INSERT INTO OKL_TXD_AR_LN_DTLS_TL(
2009: id,
2010: LANGUAGE,
2011: source_lang,
2012: error_message,

Line 2021: l_okl_txd_ar_ln_dtls_tl_rec.id,

2017: last_updated_by,
2018: last_update_date,
2019: last_update_login)
2020: VALUES (
2021: l_okl_txd_ar_ln_dtls_tl_rec.id,
2022: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
2023: l_okl_txd_ar_ln_dtls_tl_rec.source_lang,
2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,
2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,

Line 2022: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,

2018: last_update_date,
2019: last_update_login)
2020: VALUES (
2021: l_okl_txd_ar_ln_dtls_tl_rec.id,
2022: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
2023: l_okl_txd_ar_ln_dtls_tl_rec.source_lang,
2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,
2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,
2026: l_okl_txd_ar_ln_dtls_tl_rec.description,

Line 2023: l_okl_txd_ar_ln_dtls_tl_rec.source_lang,

2019: last_update_login)
2020: VALUES (
2021: l_okl_txd_ar_ln_dtls_tl_rec.id,
2022: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
2023: l_okl_txd_ar_ln_dtls_tl_rec.source_lang,
2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,
2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,
2026: l_okl_txd_ar_ln_dtls_tl_rec.description,
2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,

Line 2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,

2020: VALUES (
2021: l_okl_txd_ar_ln_dtls_tl_rec.id,
2022: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
2023: l_okl_txd_ar_ln_dtls_tl_rec.source_lang,
2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,
2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,
2026: l_okl_txd_ar_ln_dtls_tl_rec.description,
2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,
2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,

Line 2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,

2021: l_okl_txd_ar_ln_dtls_tl_rec.id,
2022: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
2023: l_okl_txd_ar_ln_dtls_tl_rec.source_lang,
2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,
2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,
2026: l_okl_txd_ar_ln_dtls_tl_rec.description,
2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,
2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,
2029: l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by,

Line 2026: l_okl_txd_ar_ln_dtls_tl_rec.description,

2022: l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE,
2023: l_okl_txd_ar_ln_dtls_tl_rec.source_lang,
2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,
2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,
2026: l_okl_txd_ar_ln_dtls_tl_rec.description,
2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,
2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,
2029: l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by,
2030: l_okl_txd_ar_ln_dtls_tl_rec.last_update_date,

Line 2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,

2023: l_okl_txd_ar_ln_dtls_tl_rec.source_lang,
2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,
2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,
2026: l_okl_txd_ar_ln_dtls_tl_rec.description,
2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,
2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,
2029: l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by,
2030: l_okl_txd_ar_ln_dtls_tl_rec.last_update_date,
2031: l_okl_txd_ar_ln_dtls_tl_rec.last_update_login);

Line 2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,

2024: l_okl_txd_ar_ln_dtls_tl_rec.error_message,
2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,
2026: l_okl_txd_ar_ln_dtls_tl_rec.description,
2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,
2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,
2029: l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by,
2030: l_okl_txd_ar_ln_dtls_tl_rec.last_update_date,
2031: l_okl_txd_ar_ln_dtls_tl_rec.last_update_login);
2032: END LOOP;

Line 2029: l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by,

2025: l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag,
2026: l_okl_txd_ar_ln_dtls_tl_rec.description,
2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,
2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,
2029: l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by,
2030: l_okl_txd_ar_ln_dtls_tl_rec.last_update_date,
2031: l_okl_txd_ar_ln_dtls_tl_rec.last_update_login);
2032: END LOOP;
2033: -- Set OUT values

Line 2030: l_okl_txd_ar_ln_dtls_tl_rec.last_update_date,

2026: l_okl_txd_ar_ln_dtls_tl_rec.description,
2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,
2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,
2029: l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by,
2030: l_okl_txd_ar_ln_dtls_tl_rec.last_update_date,
2031: l_okl_txd_ar_ln_dtls_tl_rec.last_update_login);
2032: END LOOP;
2033: -- Set OUT values
2034: x_okl_txd_ar_ln_dtls_tl_rec := l_okl_txd_ar_ln_dtls_tl_rec;

Line 2031: l_okl_txd_ar_ln_dtls_tl_rec.last_update_login);

2027: l_okl_txd_ar_ln_dtls_tl_rec.created_by,
2028: l_okl_txd_ar_ln_dtls_tl_rec.creation_date,
2029: l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by,
2030: l_okl_txd_ar_ln_dtls_tl_rec.last_update_date,
2031: l_okl_txd_ar_ln_dtls_tl_rec.last_update_login);
2032: END LOOP;
2033: -- Set OUT values
2034: x_okl_txd_ar_ln_dtls_tl_rec := l_okl_txd_ar_ln_dtls_tl_rec;
2035: Okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2034: x_okl_txd_ar_ln_dtls_tl_rec := l_okl_txd_ar_ln_dtls_tl_rec;

2030: l_okl_txd_ar_ln_dtls_tl_rec.last_update_date,
2031: l_okl_txd_ar_ln_dtls_tl_rec.last_update_login);
2032: END LOOP;
2033: -- Set OUT values
2034: x_okl_txd_ar_ln_dtls_tl_rec := l_okl_txd_ar_ln_dtls_tl_rec;
2035: Okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2036: EXCEPTION
2037: WHEN Okl_api.G_EXCEPTION_ERROR THEN
2038: x_return_status := Okl_api.HANDLE_EXCEPTIONS

Line 2087: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

2083: l_tldv_rec tldv_rec_type;
2084: l_def_tldv_rec tldv_rec_type;
2085: l_tld_rec tld_rec_type;
2086: lx_tld_rec tld_rec_type;
2087: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
2088: lx_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
2089: -------------------------------
2090: -- FUNCTION fill_who_columns --
2091: -------------------------------

Line 2088: lx_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

2084: l_def_tldv_rec tldv_rec_type;
2085: l_tld_rec tld_rec_type;
2086: lx_tld_rec tld_rec_type;
2087: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
2088: lx_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
2089: -------------------------------
2090: -- FUNCTION fill_who_columns --
2091: -------------------------------
2092: FUNCTION fill_who_columns (

Line 2178: migrate(l_def_tldv_rec, l_okl_txd_ar_ln_dtls_tl_rec);

2174: --------------------------------------
2175: -- Move VIEW record to "Child" records
2176: --------------------------------------
2177: migrate(l_def_tldv_rec, l_tld_rec);
2178: migrate(l_def_tldv_rec, l_okl_txd_ar_ln_dtls_tl_rec);
2179: --------------------------------------------
2180: -- Call the INSERT_ROW for each child record
2181: --------------------------------------------
2182: insert_row(

Line 2201: l_okl_txd_ar_ln_dtls_tl_rec,

2197: p_init_msg_list,
2198: x_return_status,
2199: x_msg_count,
2200: x_msg_data,
2201: l_okl_txd_ar_ln_dtls_tl_rec,
2202: lx_okl_txd_ar_ln_dtls_tl_rec
2203: );
2204: IF (x_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
2205: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2202: lx_okl_txd_ar_ln_dtls_tl_rec

2198: x_return_status,
2199: x_msg_count,
2200: x_msg_data,
2201: l_okl_txd_ar_ln_dtls_tl_rec,
2202: lx_okl_txd_ar_ln_dtls_tl_rec
2203: );
2204: IF (x_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
2205: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2206: ELSIF (x_return_status = Okl_api.G_RET_STS_ERROR) THEN

Line 2209: migrate(lx_okl_txd_ar_ln_dtls_tl_rec, l_def_tldv_rec);

2205: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2206: ELSIF (x_return_status = Okl_api.G_RET_STS_ERROR) THEN
2207: RAISE Okl_api.G_EXCEPTION_ERROR;
2208: END IF;
2209: migrate(lx_okl_txd_ar_ln_dtls_tl_rec, l_def_tldv_rec);
2210: -- Set OUT values
2211: x_tldv_rec := l_def_tldv_rec;
2212: Okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2213: EXCEPTION

Line 2439: -- lock_row for:OKL_TXD_AR_LN_DTLS_TL --

2435: '_PVT'
2436: );
2437: END lock_row;
2438: ----------------------------------------
2439: -- lock_row for:OKL_TXD_AR_LN_DTLS_TL --
2440: ----------------------------------------
2441: PROCEDURE lock_row(
2442: p_init_msg_list IN VARCHAR2,
2443: x_return_status OUT NOCOPY VARCHAR2,

Line 2446: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS

2442: p_init_msg_list IN VARCHAR2,
2443: x_return_status OUT NOCOPY VARCHAR2,
2444: x_msg_count OUT NOCOPY NUMBER,
2445: x_msg_data OUT NOCOPY VARCHAR2,
2446: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS
2447:
2448: E_Resource_Busy EXCEPTION;
2449: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2450: CURSOR lock_csr (p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS

Line 2450: CURSOR lock_csr (p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS

2446: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS
2447:
2448: E_Resource_Busy EXCEPTION;
2449: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2450: CURSOR lock_csr (p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS
2451: SELECT *
2452: FROM OKL_TXD_AR_LN_DTLS_TL
2453: WHERE ID = p_okl_txd_ar_ln_dtls_tl_rec.id
2454: FOR UPDATE NOWAIT;

Line 2452: FROM OKL_TXD_AR_LN_DTLS_TL

2448: E_Resource_Busy EXCEPTION;
2449: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2450: CURSOR lock_csr (p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS
2451: SELECT *
2452: FROM OKL_TXD_AR_LN_DTLS_TL
2453: WHERE ID = p_okl_txd_ar_ln_dtls_tl_rec.id
2454: FOR UPDATE NOWAIT;
2455:
2456: l_api_version CONSTANT NUMBER := 1;

Line 2453: WHERE ID = p_okl_txd_ar_ln_dtls_tl_rec.id

2449: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2450: CURSOR lock_csr (p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS
2451: SELECT *
2452: FROM OKL_TXD_AR_LN_DTLS_TL
2453: WHERE ID = p_okl_txd_ar_ln_dtls_tl_rec.id
2454: FOR UPDATE NOWAIT;
2455:
2456: l_api_version CONSTANT NUMBER := 1;
2457: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2473: OPEN lock_csr(p_okl_txd_ar_ln_dtls_tl_rec);

2469: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
2470: RAISE Okl_api.G_EXCEPTION_ERROR;
2471: END IF;
2472: BEGIN
2473: OPEN lock_csr(p_okl_txd_ar_ln_dtls_tl_rec);
2474: FETCH lock_csr INTO l_lock_var;
2475: l_row_notfound := lock_csr%NOTFOUND;
2476: CLOSE lock_csr;
2477: EXCEPTION

Line 2538: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

2534: l_api_version CONSTANT NUMBER := 1;
2535: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2536: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
2537: l_tld_rec tld_rec_type;
2538: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
2539: BEGIN
2540: l_return_status := Okl_api.START_ACTIVITY(l_api_name,
2541: G_PKG_NAME,
2542: p_init_msg_list,

Line 2556: migrate(p_tldv_rec, l_okl_txd_ar_ln_dtls_tl_rec);

2552: --------------------------------------
2553: -- Move VIEW record to "Child" records
2554: --------------------------------------
2555: migrate(p_tldv_rec, l_tld_rec);
2556: migrate(p_tldv_rec, l_okl_txd_ar_ln_dtls_tl_rec);
2557: --------------------------------------------
2558: -- Call the LOCK_ROW for each child record
2559: --------------------------------------------
2560: lock_row(

Line 2577: l_okl_txd_ar_ln_dtls_tl_rec

2573: p_init_msg_list,
2574: x_return_status,
2575: x_msg_count,
2576: x_msg_data,
2577: l_okl_txd_ar_ln_dtls_tl_rec
2578: );
2579: IF (x_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
2580: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2581: ELSIF (x_return_status = Okl_api.G_RET_STS_ERROR) THEN

Line 3145: -- update_row for:OKL_TXD_AR_LN_DTLS_TL --

3141: '_PVT'
3142: );
3143: END update_row;
3144: ------------------------------------------
3145: -- update_row for:OKL_TXD_AR_LN_DTLS_TL --
3146: ------------------------------------------
3147: PROCEDURE update_row(
3148: p_init_msg_list IN VARCHAR2,
3149: x_return_status OUT NOCOPY VARCHAR2,

Line 3152: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,

3148: p_init_msg_list IN VARCHAR2,
3149: x_return_status OUT NOCOPY VARCHAR2,
3150: x_msg_count OUT NOCOPY NUMBER,
3151: x_msg_data OUT NOCOPY VARCHAR2,
3152: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3153: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type) IS
3154:
3155: l_api_version CONSTANT NUMBER := 1;
3156: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 3153: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type) IS

3149: x_return_status OUT NOCOPY VARCHAR2,
3150: x_msg_count OUT NOCOPY NUMBER,
3151: x_msg_data OUT NOCOPY VARCHAR2,
3152: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3153: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type) IS
3154:
3155: l_api_version CONSTANT NUMBER := 1;
3156: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3157: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;

Line 3158: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type := p_okl_txd_ar_ln_dtls_tl_rec;

3154:
3155: l_api_version CONSTANT NUMBER := 1;
3156: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3157: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3158: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type := p_okl_txd_ar_ln_dtls_tl_rec;
3159: ldefokltxdarlndtlstlrec okl_txd_ar_ln_dtls_tl_rec_type;
3160: l_row_notfound BOOLEAN := TRUE;
3161: ----------------------------------
3162: -- FUNCTION populate_new_record --

Line 3159: ldefokltxdarlndtlstlrec okl_txd_ar_ln_dtls_tl_rec_type;

3155: l_api_version CONSTANT NUMBER := 1;
3156: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
3157: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3158: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type := p_okl_txd_ar_ln_dtls_tl_rec;
3159: ldefokltxdarlndtlstlrec okl_txd_ar_ln_dtls_tl_rec_type;
3160: l_row_notfound BOOLEAN := TRUE;
3161: ----------------------------------
3162: -- FUNCTION populate_new_record --
3163: ----------------------------------

Line 3165: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,

3161: ----------------------------------
3162: -- FUNCTION populate_new_record --
3163: ----------------------------------
3164: FUNCTION populate_new_record (
3165: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3166: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3167: ) RETURN VARCHAR2 IS
3168: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
3169: l_row_notfound BOOLEAN := TRUE;

Line 3166: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type

3162: -- FUNCTION populate_new_record --
3163: ----------------------------------
3164: FUNCTION populate_new_record (
3165: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3166: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3167: ) RETURN VARCHAR2 IS
3168: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
3169: l_row_notfound BOOLEAN := TRUE;
3170: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;

Line 3168: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

3164: FUNCTION populate_new_record (
3165: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3166: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3167: ) RETURN VARCHAR2 IS
3168: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
3169: l_row_notfound BOOLEAN := TRUE;
3170: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3171: BEGIN
3172: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;

Line 3172: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;

3168: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
3169: l_row_notfound BOOLEAN := TRUE;
3170: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3171: BEGIN
3172: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
3173: -- Get current database values
3174: l_okl_txd_ar_ln_dtls_tl_rec := get_rec(p_okl_txd_ar_ln_dtls_tl_rec, l_row_notfound);
3175: IF (l_row_notfound) THEN
3176: l_return_status := Okl_api.G_RET_STS_UNEXP_ERROR;

Line 3174: l_okl_txd_ar_ln_dtls_tl_rec := get_rec(p_okl_txd_ar_ln_dtls_tl_rec, l_row_notfound);

3170: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3171: BEGIN
3172: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
3173: -- Get current database values
3174: l_okl_txd_ar_ln_dtls_tl_rec := get_rec(p_okl_txd_ar_ln_dtls_tl_rec, l_row_notfound);
3175: IF (l_row_notfound) THEN
3176: l_return_status := Okl_api.G_RET_STS_UNEXP_ERROR;
3177: END IF;
3178: IF (x_okl_txd_ar_ln_dtls_tl_rec.id = Okl_api.G_MISS_NUM)

Line 3178: IF (x_okl_txd_ar_ln_dtls_tl_rec.id = Okl_api.G_MISS_NUM)

3174: l_okl_txd_ar_ln_dtls_tl_rec := get_rec(p_okl_txd_ar_ln_dtls_tl_rec, l_row_notfound);
3175: IF (l_row_notfound) THEN
3176: l_return_status := Okl_api.G_RET_STS_UNEXP_ERROR;
3177: END IF;
3178: IF (x_okl_txd_ar_ln_dtls_tl_rec.id = Okl_api.G_MISS_NUM)
3179: THEN
3180: x_okl_txd_ar_ln_dtls_tl_rec.id := l_okl_txd_ar_ln_dtls_tl_rec.id;
3181: END IF;
3182: IF (x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE = Okl_api.G_MISS_CHAR)

Line 3180: x_okl_txd_ar_ln_dtls_tl_rec.id := l_okl_txd_ar_ln_dtls_tl_rec.id;

3176: l_return_status := Okl_api.G_RET_STS_UNEXP_ERROR;
3177: END IF;
3178: IF (x_okl_txd_ar_ln_dtls_tl_rec.id = Okl_api.G_MISS_NUM)
3179: THEN
3180: x_okl_txd_ar_ln_dtls_tl_rec.id := l_okl_txd_ar_ln_dtls_tl_rec.id;
3181: END IF;
3182: IF (x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE = Okl_api.G_MISS_CHAR)
3183: THEN
3184: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE;

Line 3182: IF (x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE = Okl_api.G_MISS_CHAR)

3178: IF (x_okl_txd_ar_ln_dtls_tl_rec.id = Okl_api.G_MISS_NUM)
3179: THEN
3180: x_okl_txd_ar_ln_dtls_tl_rec.id := l_okl_txd_ar_ln_dtls_tl_rec.id;
3181: END IF;
3182: IF (x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE = Okl_api.G_MISS_CHAR)
3183: THEN
3184: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE;
3185: END IF;
3186: IF (x_okl_txd_ar_ln_dtls_tl_rec.source_lang = Okl_api.G_MISS_CHAR)

Line 3184: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE;

3180: x_okl_txd_ar_ln_dtls_tl_rec.id := l_okl_txd_ar_ln_dtls_tl_rec.id;
3181: END IF;
3182: IF (x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE = Okl_api.G_MISS_CHAR)
3183: THEN
3184: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE;
3185: END IF;
3186: IF (x_okl_txd_ar_ln_dtls_tl_rec.source_lang = Okl_api.G_MISS_CHAR)
3187: THEN
3188: x_okl_txd_ar_ln_dtls_tl_rec.source_lang := l_okl_txd_ar_ln_dtls_tl_rec.source_lang;

Line 3186: IF (x_okl_txd_ar_ln_dtls_tl_rec.source_lang = Okl_api.G_MISS_CHAR)

3182: IF (x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE = Okl_api.G_MISS_CHAR)
3183: THEN
3184: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE;
3185: END IF;
3186: IF (x_okl_txd_ar_ln_dtls_tl_rec.source_lang = Okl_api.G_MISS_CHAR)
3187: THEN
3188: x_okl_txd_ar_ln_dtls_tl_rec.source_lang := l_okl_txd_ar_ln_dtls_tl_rec.source_lang;
3189: END IF;
3190: IF (x_okl_txd_ar_ln_dtls_tl_rec.error_message = Okl_api.G_MISS_CHAR)

Line 3188: x_okl_txd_ar_ln_dtls_tl_rec.source_lang := l_okl_txd_ar_ln_dtls_tl_rec.source_lang;

3184: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := l_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE;
3185: END IF;
3186: IF (x_okl_txd_ar_ln_dtls_tl_rec.source_lang = Okl_api.G_MISS_CHAR)
3187: THEN
3188: x_okl_txd_ar_ln_dtls_tl_rec.source_lang := l_okl_txd_ar_ln_dtls_tl_rec.source_lang;
3189: END IF;
3190: IF (x_okl_txd_ar_ln_dtls_tl_rec.error_message = Okl_api.G_MISS_CHAR)
3191: THEN
3192: x_okl_txd_ar_ln_dtls_tl_rec.error_message := l_okl_txd_ar_ln_dtls_tl_rec.error_message;

Line 3190: IF (x_okl_txd_ar_ln_dtls_tl_rec.error_message = Okl_api.G_MISS_CHAR)

3186: IF (x_okl_txd_ar_ln_dtls_tl_rec.source_lang = Okl_api.G_MISS_CHAR)
3187: THEN
3188: x_okl_txd_ar_ln_dtls_tl_rec.source_lang := l_okl_txd_ar_ln_dtls_tl_rec.source_lang;
3189: END IF;
3190: IF (x_okl_txd_ar_ln_dtls_tl_rec.error_message = Okl_api.G_MISS_CHAR)
3191: THEN
3192: x_okl_txd_ar_ln_dtls_tl_rec.error_message := l_okl_txd_ar_ln_dtls_tl_rec.error_message;
3193: END IF;
3194: IF (x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag = Okl_api.G_MISS_CHAR)

Line 3192: x_okl_txd_ar_ln_dtls_tl_rec.error_message := l_okl_txd_ar_ln_dtls_tl_rec.error_message;

3188: x_okl_txd_ar_ln_dtls_tl_rec.source_lang := l_okl_txd_ar_ln_dtls_tl_rec.source_lang;
3189: END IF;
3190: IF (x_okl_txd_ar_ln_dtls_tl_rec.error_message = Okl_api.G_MISS_CHAR)
3191: THEN
3192: x_okl_txd_ar_ln_dtls_tl_rec.error_message := l_okl_txd_ar_ln_dtls_tl_rec.error_message;
3193: END IF;
3194: IF (x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag = Okl_api.G_MISS_CHAR)
3195: THEN
3196: x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag := l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag;

Line 3194: IF (x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag = Okl_api.G_MISS_CHAR)

3190: IF (x_okl_txd_ar_ln_dtls_tl_rec.error_message = Okl_api.G_MISS_CHAR)
3191: THEN
3192: x_okl_txd_ar_ln_dtls_tl_rec.error_message := l_okl_txd_ar_ln_dtls_tl_rec.error_message;
3193: END IF;
3194: IF (x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag = Okl_api.G_MISS_CHAR)
3195: THEN
3196: x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag := l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag;
3197: END IF;
3198: IF (x_okl_txd_ar_ln_dtls_tl_rec.description = Okl_api.G_MISS_CHAR)

Line 3196: x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag := l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag;

3192: x_okl_txd_ar_ln_dtls_tl_rec.error_message := l_okl_txd_ar_ln_dtls_tl_rec.error_message;
3193: END IF;
3194: IF (x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag = Okl_api.G_MISS_CHAR)
3195: THEN
3196: x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag := l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag;
3197: END IF;
3198: IF (x_okl_txd_ar_ln_dtls_tl_rec.description = Okl_api.G_MISS_CHAR)
3199: THEN
3200: x_okl_txd_ar_ln_dtls_tl_rec.description := l_okl_txd_ar_ln_dtls_tl_rec.description;

Line 3198: IF (x_okl_txd_ar_ln_dtls_tl_rec.description = Okl_api.G_MISS_CHAR)

3194: IF (x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag = Okl_api.G_MISS_CHAR)
3195: THEN
3196: x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag := l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag;
3197: END IF;
3198: IF (x_okl_txd_ar_ln_dtls_tl_rec.description = Okl_api.G_MISS_CHAR)
3199: THEN
3200: x_okl_txd_ar_ln_dtls_tl_rec.description := l_okl_txd_ar_ln_dtls_tl_rec.description;
3201: END IF;
3202: IF (x_okl_txd_ar_ln_dtls_tl_rec.created_by = Okl_api.G_MISS_NUM)

Line 3200: x_okl_txd_ar_ln_dtls_tl_rec.description := l_okl_txd_ar_ln_dtls_tl_rec.description;

3196: x_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag := l_okl_txd_ar_ln_dtls_tl_rec.sfwt_flag;
3197: END IF;
3198: IF (x_okl_txd_ar_ln_dtls_tl_rec.description = Okl_api.G_MISS_CHAR)
3199: THEN
3200: x_okl_txd_ar_ln_dtls_tl_rec.description := l_okl_txd_ar_ln_dtls_tl_rec.description;
3201: END IF;
3202: IF (x_okl_txd_ar_ln_dtls_tl_rec.created_by = Okl_api.G_MISS_NUM)
3203: THEN
3204: x_okl_txd_ar_ln_dtls_tl_rec.created_by := l_okl_txd_ar_ln_dtls_tl_rec.created_by;

Line 3202: IF (x_okl_txd_ar_ln_dtls_tl_rec.created_by = Okl_api.G_MISS_NUM)

3198: IF (x_okl_txd_ar_ln_dtls_tl_rec.description = Okl_api.G_MISS_CHAR)
3199: THEN
3200: x_okl_txd_ar_ln_dtls_tl_rec.description := l_okl_txd_ar_ln_dtls_tl_rec.description;
3201: END IF;
3202: IF (x_okl_txd_ar_ln_dtls_tl_rec.created_by = Okl_api.G_MISS_NUM)
3203: THEN
3204: x_okl_txd_ar_ln_dtls_tl_rec.created_by := l_okl_txd_ar_ln_dtls_tl_rec.created_by;
3205: END IF;
3206: IF (x_okl_txd_ar_ln_dtls_tl_rec.creation_date = Okl_api.G_MISS_DATE)

Line 3204: x_okl_txd_ar_ln_dtls_tl_rec.created_by := l_okl_txd_ar_ln_dtls_tl_rec.created_by;

3200: x_okl_txd_ar_ln_dtls_tl_rec.description := l_okl_txd_ar_ln_dtls_tl_rec.description;
3201: END IF;
3202: IF (x_okl_txd_ar_ln_dtls_tl_rec.created_by = Okl_api.G_MISS_NUM)
3203: THEN
3204: x_okl_txd_ar_ln_dtls_tl_rec.created_by := l_okl_txd_ar_ln_dtls_tl_rec.created_by;
3205: END IF;
3206: IF (x_okl_txd_ar_ln_dtls_tl_rec.creation_date = Okl_api.G_MISS_DATE)
3207: THEN
3208: x_okl_txd_ar_ln_dtls_tl_rec.creation_date := l_okl_txd_ar_ln_dtls_tl_rec.creation_date;

Line 3206: IF (x_okl_txd_ar_ln_dtls_tl_rec.creation_date = Okl_api.G_MISS_DATE)

3202: IF (x_okl_txd_ar_ln_dtls_tl_rec.created_by = Okl_api.G_MISS_NUM)
3203: THEN
3204: x_okl_txd_ar_ln_dtls_tl_rec.created_by := l_okl_txd_ar_ln_dtls_tl_rec.created_by;
3205: END IF;
3206: IF (x_okl_txd_ar_ln_dtls_tl_rec.creation_date = Okl_api.G_MISS_DATE)
3207: THEN
3208: x_okl_txd_ar_ln_dtls_tl_rec.creation_date := l_okl_txd_ar_ln_dtls_tl_rec.creation_date;
3209: END IF;
3210: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by = Okl_api.G_MISS_NUM)

Line 3208: x_okl_txd_ar_ln_dtls_tl_rec.creation_date := l_okl_txd_ar_ln_dtls_tl_rec.creation_date;

3204: x_okl_txd_ar_ln_dtls_tl_rec.created_by := l_okl_txd_ar_ln_dtls_tl_rec.created_by;
3205: END IF;
3206: IF (x_okl_txd_ar_ln_dtls_tl_rec.creation_date = Okl_api.G_MISS_DATE)
3207: THEN
3208: x_okl_txd_ar_ln_dtls_tl_rec.creation_date := l_okl_txd_ar_ln_dtls_tl_rec.creation_date;
3209: END IF;
3210: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by = Okl_api.G_MISS_NUM)
3211: THEN
3212: x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by := l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by;

Line 3210: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by = Okl_api.G_MISS_NUM)

3206: IF (x_okl_txd_ar_ln_dtls_tl_rec.creation_date = Okl_api.G_MISS_DATE)
3207: THEN
3208: x_okl_txd_ar_ln_dtls_tl_rec.creation_date := l_okl_txd_ar_ln_dtls_tl_rec.creation_date;
3209: END IF;
3210: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by = Okl_api.G_MISS_NUM)
3211: THEN
3212: x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by := l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by;
3213: END IF;
3214: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_date = Okl_api.G_MISS_DATE)

Line 3212: x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by := l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by;

3208: x_okl_txd_ar_ln_dtls_tl_rec.creation_date := l_okl_txd_ar_ln_dtls_tl_rec.creation_date;
3209: END IF;
3210: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by = Okl_api.G_MISS_NUM)
3211: THEN
3212: x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by := l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by;
3213: END IF;
3214: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_date = Okl_api.G_MISS_DATE)
3215: THEN
3216: x_okl_txd_ar_ln_dtls_tl_rec.last_update_date := l_okl_txd_ar_ln_dtls_tl_rec.last_update_date;

Line 3214: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_date = Okl_api.G_MISS_DATE)

3210: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by = Okl_api.G_MISS_NUM)
3211: THEN
3212: x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by := l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by;
3213: END IF;
3214: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_date = Okl_api.G_MISS_DATE)
3215: THEN
3216: x_okl_txd_ar_ln_dtls_tl_rec.last_update_date := l_okl_txd_ar_ln_dtls_tl_rec.last_update_date;
3217: END IF;
3218: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_login = Okl_api.G_MISS_NUM)

Line 3216: x_okl_txd_ar_ln_dtls_tl_rec.last_update_date := l_okl_txd_ar_ln_dtls_tl_rec.last_update_date;

3212: x_okl_txd_ar_ln_dtls_tl_rec.last_updated_by := l_okl_txd_ar_ln_dtls_tl_rec.last_updated_by;
3213: END IF;
3214: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_date = Okl_api.G_MISS_DATE)
3215: THEN
3216: x_okl_txd_ar_ln_dtls_tl_rec.last_update_date := l_okl_txd_ar_ln_dtls_tl_rec.last_update_date;
3217: END IF;
3218: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_login = Okl_api.G_MISS_NUM)
3219: THEN
3220: x_okl_txd_ar_ln_dtls_tl_rec.last_update_login := l_okl_txd_ar_ln_dtls_tl_rec.last_update_login;

Line 3218: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_login = Okl_api.G_MISS_NUM)

3214: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_date = Okl_api.G_MISS_DATE)
3215: THEN
3216: x_okl_txd_ar_ln_dtls_tl_rec.last_update_date := l_okl_txd_ar_ln_dtls_tl_rec.last_update_date;
3217: END IF;
3218: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_login = Okl_api.G_MISS_NUM)
3219: THEN
3220: x_okl_txd_ar_ln_dtls_tl_rec.last_update_login := l_okl_txd_ar_ln_dtls_tl_rec.last_update_login;
3221: END IF;
3222: RETURN(l_return_status);

Line 3220: x_okl_txd_ar_ln_dtls_tl_rec.last_update_login := l_okl_txd_ar_ln_dtls_tl_rec.last_update_login;

3216: x_okl_txd_ar_ln_dtls_tl_rec.last_update_date := l_okl_txd_ar_ln_dtls_tl_rec.last_update_date;
3217: END IF;
3218: IF (x_okl_txd_ar_ln_dtls_tl_rec.last_update_login = Okl_api.G_MISS_NUM)
3219: THEN
3220: x_okl_txd_ar_ln_dtls_tl_rec.last_update_login := l_okl_txd_ar_ln_dtls_tl_rec.last_update_login;
3221: END IF;
3222: RETURN(l_return_status);
3223: END populate_new_record;
3224: ----------------------------------------------

Line 3225: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --

3221: END IF;
3222: RETURN(l_return_status);
3223: END populate_new_record;
3224: ----------------------------------------------
3225: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
3226: ----------------------------------------------
3227: FUNCTION Set_Attributes (
3228: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3229: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type

Line 3228: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,

3224: ----------------------------------------------
3225: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
3226: ----------------------------------------------
3227: FUNCTION Set_Attributes (
3228: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3229: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3230: ) RETURN VARCHAR2 IS
3231: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3232: BEGIN

Line 3229: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type

3225: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
3226: ----------------------------------------------
3227: FUNCTION Set_Attributes (
3228: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3229: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3230: ) RETURN VARCHAR2 IS
3231: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3232: BEGIN
3233: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;

Line 3233: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;

3229: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3230: ) RETURN VARCHAR2 IS
3231: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3232: BEGIN
3233: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
3234: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');
3235: x_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG := USERENV('LANG');
3236: RETURN(l_return_status);
3237: END Set_Attributes;

Line 3234: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');

3230: ) RETURN VARCHAR2 IS
3231: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3232: BEGIN
3233: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
3234: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');
3235: x_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG := USERENV('LANG');
3236: RETURN(l_return_status);
3237: END Set_Attributes;
3238: BEGIN

Line 3235: x_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG := USERENV('LANG');

3231: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3232: BEGIN
3233: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
3234: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');
3235: x_okl_txd_ar_ln_dtls_tl_rec.SOURCE_LANG := USERENV('LANG');
3236: RETURN(l_return_status);
3237: END Set_Attributes;
3238: BEGIN
3239: l_return_status := Okl_api.START_ACTIVITY(l_api_name,

Line 3250: p_okl_txd_ar_ln_dtls_tl_rec, -- IN

3246: RAISE Okl_api.G_EXCEPTION_ERROR;
3247: END IF;
3248: --- Setting item attributes
3249: l_return_status := Set_Attributes(
3250: p_okl_txd_ar_ln_dtls_tl_rec, -- IN
3251: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT
3252: --- If any errors happen abort API
3253: IF (l_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
3254: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3251: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT

3247: END IF;
3248: --- Setting item attributes
3249: l_return_status := Set_Attributes(
3250: p_okl_txd_ar_ln_dtls_tl_rec, -- IN
3251: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT
3252: --- If any errors happen abort API
3253: IF (l_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
3254: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3255: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN

Line 3258: l_return_status := populate_new_record(l_okl_txd_ar_ln_dtls_tl_rec, ldefokltxdarlndtlstlrec);

3254: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3255: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
3256: RAISE Okl_api.G_EXCEPTION_ERROR;
3257: END IF;
3258: l_return_status := populate_new_record(l_okl_txd_ar_ln_dtls_tl_rec, ldefokltxdarlndtlstlrec);
3259: IF (l_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
3260: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3261: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
3262: RAISE Okl_api.G_EXCEPTION_ERROR;

Line 3264: UPDATE OKL_TXD_AR_LN_DTLS_TL

3260: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3261: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
3262: RAISE Okl_api.G_EXCEPTION_ERROR;
3263: END IF;
3264: UPDATE OKL_TXD_AR_LN_DTLS_TL
3265: SET DESCRIPTION = ldefokltxdarlndtlstlrec.description,
3266: ERROR_MESSAGE = ldefokltxdarlndtlstlrec.error_message,
3267: SOURCE_LANG = ldefokltxdarlndtlstlrec.source_lang,
3268: CREATED_BY = ldefokltxdarlndtlstlrec.created_by,

Line 3276: UPDATE OKL_TXD_AR_LN_DTLS_TL

3272: LAST_UPDATE_LOGIN = ldefokltxdarlndtlstlrec.last_update_login
3273: WHERE ID = ldefokltxdarlndtlstlrec.id
3274: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
3275:
3276: UPDATE OKL_TXD_AR_LN_DTLS_TL
3277: SET SFWT_FLAG = 'Y'
3278: WHERE ID = ldefokltxdarlndtlstlrec.id
3279: AND SOURCE_LANG <> USERENV('LANG');
3280:

Line 3281: x_okl_txd_ar_ln_dtls_tl_rec := ldefokltxdarlndtlstlrec;

3277: SET SFWT_FLAG = 'Y'
3278: WHERE ID = ldefokltxdarlndtlstlrec.id
3279: AND SOURCE_LANG <> USERENV('LANG');
3280:
3281: x_okl_txd_ar_ln_dtls_tl_rec := ldefokltxdarlndtlstlrec;
3282: Okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3283: EXCEPTION
3284: WHEN Okl_api.G_EXCEPTION_ERROR THEN
3285: x_return_status := Okl_api.HANDLE_EXCEPTIONS

Line 3332: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

3328: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3329: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3330: l_tldv_rec tldv_rec_type := p_tldv_rec;
3331: l_def_tldv_rec tldv_rec_type;
3332: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
3333: lx_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
3334: l_tld_rec tld_rec_type;
3335: lx_tld_rec tld_rec_type;
3336: -------------------------------

Line 3333: lx_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

3329: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3330: l_tldv_rec tldv_rec_type := p_tldv_rec;
3331: l_def_tldv_rec tldv_rec_type;
3332: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
3333: lx_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
3334: l_tld_rec tld_rec_type;
3335: lx_tld_rec tld_rec_type;
3336: -------------------------------
3337: -- FUNCTION fill_who_columns --

Line 3728: migrate(l_def_tldv_rec, l_okl_txd_ar_ln_dtls_tl_rec);

3724:
3725: --------------------------------------
3726: -- Move VIEW record to "Child" records
3727: --------------------------------------
3728: migrate(l_def_tldv_rec, l_okl_txd_ar_ln_dtls_tl_rec);
3729: migrate(l_def_tldv_rec, l_tld_rec);
3730: --------------------------------------------
3731: -- Call the UPDATE_ROW for each child record
3732: --------------------------------------------

Line 3738: l_okl_txd_ar_ln_dtls_tl_rec,

3734: p_init_msg_list,
3735: x_return_status,
3736: x_msg_count,
3737: x_msg_data,
3738: l_okl_txd_ar_ln_dtls_tl_rec,
3739: lx_okl_txd_ar_ln_dtls_tl_rec
3740: );
3741: IF (x_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
3742: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3739: lx_okl_txd_ar_ln_dtls_tl_rec

3735: x_return_status,
3736: x_msg_count,
3737: x_msg_data,
3738: l_okl_txd_ar_ln_dtls_tl_rec,
3739: lx_okl_txd_ar_ln_dtls_tl_rec
3740: );
3741: IF (x_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
3742: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3743: ELSIF (x_return_status = Okl_api.G_RET_STS_ERROR) THEN

Line 3746: migrate(lx_okl_txd_ar_ln_dtls_tl_rec, l_def_tldv_rec);

3742: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3743: ELSIF (x_return_status = Okl_api.G_RET_STS_ERROR) THEN
3744: RAISE Okl_api.G_EXCEPTION_ERROR;
3745: END IF;
3746: migrate(lx_okl_txd_ar_ln_dtls_tl_rec, l_def_tldv_rec);
3747: update_row(
3748: p_init_msg_list,
3749: x_return_status,
3750: x_msg_count,

Line 3943: -- delete_row for:OKL_TXD_AR_LN_DTLS_TL --

3939: '_PVT'
3940: );
3941: END delete_row;
3942: ------------------------------------------
3943: -- delete_row for:OKL_TXD_AR_LN_DTLS_TL --
3944: ------------------------------------------
3945: PROCEDURE delete_row(
3946: p_init_msg_list IN VARCHAR2,
3947: x_return_status OUT NOCOPY VARCHAR2,

Line 3950: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS

3946: p_init_msg_list IN VARCHAR2,
3947: x_return_status OUT NOCOPY VARCHAR2,
3948: x_msg_count OUT NOCOPY NUMBER,
3949: x_msg_data OUT NOCOPY VARCHAR2,
3950: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type) IS
3951:
3952: l_api_version CONSTANT NUMBER := 1;
3953: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3954: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;

Line 3955: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type:= p_okl_txd_ar_ln_dtls_tl_rec;

3951:
3952: l_api_version CONSTANT NUMBER := 1;
3953: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3954: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3955: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type:= p_okl_txd_ar_ln_dtls_tl_rec;
3956: l_row_notfound BOOLEAN := TRUE;
3957: ----------------------------------------------
3958: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
3959: ----------------------------------------------

Line 3958: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --

3954: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3955: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type:= p_okl_txd_ar_ln_dtls_tl_rec;
3956: l_row_notfound BOOLEAN := TRUE;
3957: ----------------------------------------------
3958: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
3959: ----------------------------------------------
3960: FUNCTION Set_Attributes (
3961: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3962: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type

Line 3961: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,

3957: ----------------------------------------------
3958: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
3959: ----------------------------------------------
3960: FUNCTION Set_Attributes (
3961: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3962: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3963: ) RETURN VARCHAR2 IS
3964: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3965: BEGIN

Line 3962: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type

3958: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_TL --
3959: ----------------------------------------------
3960: FUNCTION Set_Attributes (
3961: p_okl_txd_ar_ln_dtls_tl_rec IN okl_txd_ar_ln_dtls_tl_rec_type,
3962: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3963: ) RETURN VARCHAR2 IS
3964: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3965: BEGIN
3966: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;

Line 3966: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;

3962: x_okl_txd_ar_ln_dtls_tl_rec OUT NOCOPY okl_txd_ar_ln_dtls_tl_rec_type
3963: ) RETURN VARCHAR2 IS
3964: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3965: BEGIN
3966: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
3967: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');
3968: RETURN(l_return_status);
3969: END Set_Attributes;
3970: BEGIN

Line 3967: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');

3963: ) RETURN VARCHAR2 IS
3964: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
3965: BEGIN
3966: x_okl_txd_ar_ln_dtls_tl_rec := p_okl_txd_ar_ln_dtls_tl_rec;
3967: x_okl_txd_ar_ln_dtls_tl_rec.LANGUAGE := USERENV('LANG');
3968: RETURN(l_return_status);
3969: END Set_Attributes;
3970: BEGIN
3971: l_return_status := Okl_api.START_ACTIVITY(l_api_name,

Line 3982: p_okl_txd_ar_ln_dtls_tl_rec, -- IN

3978: RAISE Okl_api.G_EXCEPTION_ERROR;
3979: END IF;
3980: --- Setting item attributes
3981: l_return_status := Set_Attributes(
3982: p_okl_txd_ar_ln_dtls_tl_rec, -- IN
3983: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT
3984: --- If any errors happen abort API
3985: IF (l_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
3986: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3983: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT

3979: END IF;
3980: --- Setting item attributes
3981: l_return_status := Set_Attributes(
3982: p_okl_txd_ar_ln_dtls_tl_rec, -- IN
3983: l_okl_txd_ar_ln_dtls_tl_rec); -- OUT
3984: --- If any errors happen abort API
3985: IF (l_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
3986: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3987: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN

Line 3990: DELETE FROM OKL_TXD_AR_LN_DTLS_TL

3986: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3987: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
3988: RAISE Okl_api.G_EXCEPTION_ERROR;
3989: END IF;
3990: DELETE FROM OKL_TXD_AR_LN_DTLS_TL
3991: WHERE ID = l_okl_txd_ar_ln_dtls_tl_rec.id;
3992:
3993: Okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3994: EXCEPTION

Line 3991: WHERE ID = l_okl_txd_ar_ln_dtls_tl_rec.id;

3987: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
3988: RAISE Okl_api.G_EXCEPTION_ERROR;
3989: END IF;
3990: DELETE FROM OKL_TXD_AR_LN_DTLS_TL
3991: WHERE ID = l_okl_txd_ar_ln_dtls_tl_rec.id;
3992:
3993: Okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3994: EXCEPTION
3995: WHEN Okl_api.G_EXCEPTION_ERROR THEN

Line 4041: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;

4037: l_api_version CONSTANT NUMBER := 1;
4038: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
4039: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
4040: l_tldv_rec tldv_rec_type := p_tldv_rec;
4041: l_okl_txd_ar_ln_dtls_tl_rec okl_txd_ar_ln_dtls_tl_rec_type;
4042: l_tld_rec tld_rec_type;
4043: BEGIN
4044: l_return_status := Okl_api.START_ACTIVITY(l_api_name,
4045: G_PKG_NAME,

Line 4059: migrate(l_tldv_rec, l_okl_txd_ar_ln_dtls_tl_rec);

4055: END IF;
4056: --------------------------------------
4057: -- Move VIEW record to "Child" records
4058: --------------------------------------
4059: migrate(l_tldv_rec, l_okl_txd_ar_ln_dtls_tl_rec);
4060: migrate(l_tldv_rec, l_tld_rec);
4061: --------------------------------------------
4062: -- Call the DELETE_ROW for each child record
4063: --------------------------------------------

Line 4069: l_okl_txd_ar_ln_dtls_tl_rec

4065: p_init_msg_list,
4066: x_return_status,
4067: x_msg_count,
4068: x_msg_data,
4069: l_okl_txd_ar_ln_dtls_tl_rec
4070: );
4071: IF (x_return_status = Okl_api.G_RET_STS_UNEXP_ERROR) THEN
4072: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
4073: ELSIF (x_return_status = Okl_api.G_RET_STS_ERROR) THEN