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_XPI_PVT dependencies on OKL_EXT_PAY_INVS_TL

Line 454: DELETE FROM OKL_EXT_PAY_INVS_TL T

450: -- PROCEDURE add_language
451: ---------------------------------------------------------------------------
452: PROCEDURE add_language IS
453: BEGIN
454: DELETE FROM OKL_EXT_PAY_INVS_TL T
455: WHERE NOT EXISTS (
456: SELECT NULL
457: FROM OKL_EXT_PAY_INVS_ALL_B B
458: WHERE B.ID = T.ID

Line 462: UPDATE OKL_EXT_PAY_INVS_TL T SET (

458: WHERE B.ID = T.ID
459: AND T.LANGUAGE = USERENV('LANG')
460: );
461:
462: UPDATE OKL_EXT_PAY_INVS_TL T SET (
463: DESCRIPTION,
464: SOURCE,
465: STREAM_TYPE) = (SELECT
466: B.DESCRIPTION,

Line 469: FROM OKL_EXT_PAY_INVS_TL B

465: STREAM_TYPE) = (SELECT
466: B.DESCRIPTION,
467: B.SOURCE,
468: B.STREAM_TYPE
469: FROM OKL_EXT_PAY_INVS_TL B
470: WHERE B.ID = T.ID
471: AND B.LANGUAGE = T.SOURCE_LANG)
472: WHERE (
473: T.ID,

Line 478: FROM OKL_EXT_PAY_INVS_TL SUBB, OKL_EXT_PAY_INVS_TL SUBT

474: T.LANGUAGE)
475: IN (SELECT
476: SUBT.ID,
477: SUBT.LANGUAGE
478: FROM OKL_EXT_PAY_INVS_TL SUBB, OKL_EXT_PAY_INVS_TL SUBT
479: WHERE SUBB.ID = SUBT.ID
480: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
481: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
482: OR SUBB.SOURCE <> SUBT.SOURCE

Line 492: INSERT INTO OKL_EXT_PAY_INVS_TL (

488: OR (SUBB.STREAM_TYPE IS NULL AND SUBT.STREAM_TYPE IS NOT NULL)
489: OR (SUBB.STREAM_TYPE IS NOT NULL AND SUBT.STREAM_TYPE IS NULL)
490: ));
491:
492: INSERT INTO OKL_EXT_PAY_INVS_TL (
493: ID,
494: LANGUAGE,
495: SOURCE_LANG,
496: SFWT_FLAG,

Line 519: FROM OKL_EXT_PAY_INVS_TL B, FND_LANGUAGES L

515: B.CREATION_DATE,
516: B.LAST_UPDATED_BY,
517: B.LAST_UPDATE_DATE,
518: B.LAST_UPDATE_LOGIN
519: FROM OKL_EXT_PAY_INVS_TL B, FND_LANGUAGES L
520: WHERE L.INSTALLED_FLAG IN ('I', 'B')
521: AND B.LANGUAGE = USERENV('LANG')
522: AND NOT EXISTS(
523: SELECT NULL

Line 524: FROM OKL_EXT_PAY_INVS_TL T

520: WHERE L.INSTALLED_FLAG IN ('I', 'B')
521: AND B.LANGUAGE = USERENV('LANG')
522: AND NOT EXISTS(
523: SELECT NULL
524: FROM OKL_EXT_PAY_INVS_TL T
525: WHERE T.ID = B.ID
526: AND T.LANGUAGE = L.LANGUAGE_CODE
527: );
528:

Line 672: -- FUNCTION get_rec for: OKL_EXT_PAY_INVS_TL

668: BEGIN
669: RETURN(get_rec(p_xpi_rec, l_row_notfound));
670: END get_rec;
671: ---------------------------------------------------------------------------
672: -- FUNCTION get_rec for: OKL_EXT_PAY_INVS_TL
673: ---------------------------------------------------------------------------
674: FUNCTION get_rec (
675: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
676: x_no_data_found OUT NOCOPY BOOLEAN

Line 675: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,

671: ---------------------------------------------------------------------------
672: -- FUNCTION get_rec for: OKL_EXT_PAY_INVS_TL
673: ---------------------------------------------------------------------------
674: FUNCTION get_rec (
675: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
676: x_no_data_found OUT NOCOPY BOOLEAN
677: ) RETURN okl_ext_pay_invs_tl_rec_type IS
678: CURSOR okl_ext_pay_invs_tl_pk_csr (p_id IN NUMBER,
679: p_language IN VARCHAR2) IS

Line 677: ) RETURN okl_ext_pay_invs_tl_rec_type IS

673: ---------------------------------------------------------------------------
674: FUNCTION get_rec (
675: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
676: x_no_data_found OUT NOCOPY BOOLEAN
677: ) RETURN okl_ext_pay_invs_tl_rec_type IS
678: CURSOR okl_ext_pay_invs_tl_pk_csr (p_id IN NUMBER,
679: p_language IN VARCHAR2) IS
680: SELECT
681: ID,

Line 678: CURSOR okl_ext_pay_invs_tl_pk_csr (p_id IN NUMBER,

674: FUNCTION get_rec (
675: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
676: x_no_data_found OUT NOCOPY BOOLEAN
677: ) RETURN okl_ext_pay_invs_tl_rec_type IS
678: CURSOR okl_ext_pay_invs_tl_pk_csr (p_id IN NUMBER,
679: p_language IN VARCHAR2) IS
680: SELECT
681: ID,
682: LANGUAGE,

Line 693: FROM Okl_Ext_Pay_Invs_Tl

689: CREATION_DATE,
690: LAST_UPDATED_BY,
691: LAST_UPDATE_DATE,
692: LAST_UPDATE_LOGIN
693: FROM Okl_Ext_Pay_Invs_Tl
694: WHERE okl_ext_pay_invs_tl.id = p_id
695: AND okl_ext_pay_invs_tl.language = p_language;
696: l_okl_ext_pay_invs_tl_pk okl_ext_pay_invs_tl_pk_csr%ROWTYPE;
697: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

Line 694: WHERE okl_ext_pay_invs_tl.id = p_id

690: LAST_UPDATED_BY,
691: LAST_UPDATE_DATE,
692: LAST_UPDATE_LOGIN
693: FROM Okl_Ext_Pay_Invs_Tl
694: WHERE okl_ext_pay_invs_tl.id = p_id
695: AND okl_ext_pay_invs_tl.language = p_language;
696: l_okl_ext_pay_invs_tl_pk okl_ext_pay_invs_tl_pk_csr%ROWTYPE;
697: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
698: BEGIN

Line 695: AND okl_ext_pay_invs_tl.language = p_language;

691: LAST_UPDATE_DATE,
692: LAST_UPDATE_LOGIN
693: FROM Okl_Ext_Pay_Invs_Tl
694: WHERE okl_ext_pay_invs_tl.id = p_id
695: AND okl_ext_pay_invs_tl.language = p_language;
696: l_okl_ext_pay_invs_tl_pk okl_ext_pay_invs_tl_pk_csr%ROWTYPE;
697: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
698: BEGIN
699: x_no_data_found := TRUE;

Line 696: l_okl_ext_pay_invs_tl_pk okl_ext_pay_invs_tl_pk_csr%ROWTYPE;

692: LAST_UPDATE_LOGIN
693: FROM Okl_Ext_Pay_Invs_Tl
694: WHERE okl_ext_pay_invs_tl.id = p_id
695: AND okl_ext_pay_invs_tl.language = p_language;
696: l_okl_ext_pay_invs_tl_pk okl_ext_pay_invs_tl_pk_csr%ROWTYPE;
697: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
698: BEGIN
699: x_no_data_found := TRUE;
700: -- Get current database values

Line 697: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

693: FROM Okl_Ext_Pay_Invs_Tl
694: WHERE okl_ext_pay_invs_tl.id = p_id
695: AND okl_ext_pay_invs_tl.language = p_language;
696: l_okl_ext_pay_invs_tl_pk okl_ext_pay_invs_tl_pk_csr%ROWTYPE;
697: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
698: BEGIN
699: x_no_data_found := TRUE;
700: -- Get current database values
701: OPEN okl_ext_pay_invs_tl_pk_csr (p_okl_ext_pay_invs_tl_rec.id,

Line 701: OPEN okl_ext_pay_invs_tl_pk_csr (p_okl_ext_pay_invs_tl_rec.id,

697: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
698: BEGIN
699: x_no_data_found := TRUE;
700: -- Get current database values
701: OPEN okl_ext_pay_invs_tl_pk_csr (p_okl_ext_pay_invs_tl_rec.id,
702: p_okl_ext_pay_invs_tl_rec.language);
703: FETCH okl_ext_pay_invs_tl_pk_csr INTO
704: l_okl_ext_pay_invs_tl_rec.ID,
705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,

Line 702: p_okl_ext_pay_invs_tl_rec.language);

698: BEGIN
699: x_no_data_found := TRUE;
700: -- Get current database values
701: OPEN okl_ext_pay_invs_tl_pk_csr (p_okl_ext_pay_invs_tl_rec.id,
702: p_okl_ext_pay_invs_tl_rec.language);
703: FETCH okl_ext_pay_invs_tl_pk_csr INTO
704: l_okl_ext_pay_invs_tl_rec.ID,
705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,
706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,

Line 703: FETCH okl_ext_pay_invs_tl_pk_csr INTO

699: x_no_data_found := TRUE;
700: -- Get current database values
701: OPEN okl_ext_pay_invs_tl_pk_csr (p_okl_ext_pay_invs_tl_rec.id,
702: p_okl_ext_pay_invs_tl_rec.language);
703: FETCH okl_ext_pay_invs_tl_pk_csr INTO
704: l_okl_ext_pay_invs_tl_rec.ID,
705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,
706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,
707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,

Line 704: l_okl_ext_pay_invs_tl_rec.ID,

700: -- Get current database values
701: OPEN okl_ext_pay_invs_tl_pk_csr (p_okl_ext_pay_invs_tl_rec.id,
702: p_okl_ext_pay_invs_tl_rec.language);
703: FETCH okl_ext_pay_invs_tl_pk_csr INTO
704: l_okl_ext_pay_invs_tl_rec.ID,
705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,
706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,
707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,
708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,

Line 705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,

701: OPEN okl_ext_pay_invs_tl_pk_csr (p_okl_ext_pay_invs_tl_rec.id,
702: p_okl_ext_pay_invs_tl_rec.language);
703: FETCH okl_ext_pay_invs_tl_pk_csr INTO
704: l_okl_ext_pay_invs_tl_rec.ID,
705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,
706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,
707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,
708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,
709: l_okl_ext_pay_invs_tl_rec.SOURCE,

Line 706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,

702: p_okl_ext_pay_invs_tl_rec.language);
703: FETCH okl_ext_pay_invs_tl_pk_csr INTO
704: l_okl_ext_pay_invs_tl_rec.ID,
705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,
706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,
707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,
708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,
709: l_okl_ext_pay_invs_tl_rec.SOURCE,
710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,

Line 707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,

703: FETCH okl_ext_pay_invs_tl_pk_csr INTO
704: l_okl_ext_pay_invs_tl_rec.ID,
705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,
706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,
707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,
708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,
709: l_okl_ext_pay_invs_tl_rec.SOURCE,
710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,
711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,

Line 708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,

704: l_okl_ext_pay_invs_tl_rec.ID,
705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,
706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,
707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,
708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,
709: l_okl_ext_pay_invs_tl_rec.SOURCE,
710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,
711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,
712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,

Line 709: l_okl_ext_pay_invs_tl_rec.SOURCE,

705: l_okl_ext_pay_invs_tl_rec.LANGUAGE,
706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,
707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,
708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,
709: l_okl_ext_pay_invs_tl_rec.SOURCE,
710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,
711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,
712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,
713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,

Line 710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,

706: l_okl_ext_pay_invs_tl_rec.SOURCE_LANG,
707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,
708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,
709: l_okl_ext_pay_invs_tl_rec.SOURCE,
710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,
711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,
712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,
713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,
714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,

Line 711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,

707: l_okl_ext_pay_invs_tl_rec.SFWT_FLAG,
708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,
709: l_okl_ext_pay_invs_tl_rec.SOURCE,
710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,
711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,
712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,
713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,
714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,
715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;

Line 712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,

708: l_okl_ext_pay_invs_tl_rec.DESCRIPTION,
709: l_okl_ext_pay_invs_tl_rec.SOURCE,
710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,
711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,
712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,
713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,
714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,
715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;
716: x_no_data_found := okl_ext_pay_invs_tl_pk_csr%NOTFOUND;

Line 713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,

709: l_okl_ext_pay_invs_tl_rec.SOURCE,
710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,
711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,
712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,
713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,
714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,
715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;
716: x_no_data_found := okl_ext_pay_invs_tl_pk_csr%NOTFOUND;
717: CLOSE okl_ext_pay_invs_tl_pk_csr;

Line 714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,

710: l_okl_ext_pay_invs_tl_rec.STREAM_TYPE,
711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,
712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,
713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,
714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,
715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;
716: x_no_data_found := okl_ext_pay_invs_tl_pk_csr%NOTFOUND;
717: CLOSE okl_ext_pay_invs_tl_pk_csr;
718: RETURN(l_okl_ext_pay_invs_tl_rec);

Line 715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;

711: l_okl_ext_pay_invs_tl_rec.CREATED_BY,
712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,
713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,
714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,
715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;
716: x_no_data_found := okl_ext_pay_invs_tl_pk_csr%NOTFOUND;
717: CLOSE okl_ext_pay_invs_tl_pk_csr;
718: RETURN(l_okl_ext_pay_invs_tl_rec);
719: END get_rec;

Line 716: x_no_data_found := okl_ext_pay_invs_tl_pk_csr%NOTFOUND;

712: l_okl_ext_pay_invs_tl_rec.CREATION_DATE,
713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,
714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,
715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;
716: x_no_data_found := okl_ext_pay_invs_tl_pk_csr%NOTFOUND;
717: CLOSE okl_ext_pay_invs_tl_pk_csr;
718: RETURN(l_okl_ext_pay_invs_tl_rec);
719: END get_rec;
720:

Line 717: CLOSE okl_ext_pay_invs_tl_pk_csr;

713: l_okl_ext_pay_invs_tl_rec.LAST_UPDATED_BY,
714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,
715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;
716: x_no_data_found := okl_ext_pay_invs_tl_pk_csr%NOTFOUND;
717: CLOSE okl_ext_pay_invs_tl_pk_csr;
718: RETURN(l_okl_ext_pay_invs_tl_rec);
719: END get_rec;
720:
721: FUNCTION get_rec (

Line 718: RETURN(l_okl_ext_pay_invs_tl_rec);

714: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_DATE,
715: l_okl_ext_pay_invs_tl_rec.LAST_UPDATE_LOGIN;
716: x_no_data_found := okl_ext_pay_invs_tl_pk_csr%NOTFOUND;
717: CLOSE okl_ext_pay_invs_tl_pk_csr;
718: RETURN(l_okl_ext_pay_invs_tl_rec);
719: END get_rec;
720:
721: FUNCTION get_rec (
722: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type

Line 722: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type

718: RETURN(l_okl_ext_pay_invs_tl_rec);
719: END get_rec;
720:
721: FUNCTION get_rec (
722: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type
723: ) RETURN okl_ext_pay_invs_tl_rec_type IS
724: l_row_notfound BOOLEAN := TRUE;
725: BEGIN
726: RETURN(get_rec(p_okl_ext_pay_invs_tl_rec, l_row_notfound));

Line 723: ) RETURN okl_ext_pay_invs_tl_rec_type IS

719: END get_rec;
720:
721: FUNCTION get_rec (
722: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type
723: ) RETURN okl_ext_pay_invs_tl_rec_type IS
724: l_row_notfound BOOLEAN := TRUE;
725: BEGIN
726: RETURN(get_rec(p_okl_ext_pay_invs_tl_rec, l_row_notfound));
727: END get_rec;

Line 726: RETURN(get_rec(p_okl_ext_pay_invs_tl_rec, l_row_notfound));

722: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type
723: ) RETURN okl_ext_pay_invs_tl_rec_type IS
724: l_row_notfound BOOLEAN := TRUE;
725: BEGIN
726: RETURN(get_rec(p_okl_ext_pay_invs_tl_rec, l_row_notfound));
727: END get_rec;
728: ---------------------------------------------------------------------------
729: -- FUNCTION get_rec for: OKL_EXT_PAY_INVS_V
730: ---------------------------------------------------------------------------

Line 1332: p_to IN OUT NOCOPY okl_ext_pay_invs_tl_rec_type -- PostGen-11

1328:
1329: END migrate;
1330: PROCEDURE migrate (
1331: p_from IN xpiv_rec_type,
1332: p_to IN OUT NOCOPY okl_ext_pay_invs_tl_rec_type -- PostGen-11
1333: ) IS
1334: BEGIN
1335: p_to.id := p_from.id;
1336: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1347: p_from IN okl_ext_pay_invs_tl_rec_type,

1343: p_to.last_update_date := p_from.last_update_date;
1344: p_to.last_update_login := p_from.last_update_login;
1345: END migrate;
1346: PROCEDURE migrate (
1347: p_from IN okl_ext_pay_invs_tl_rec_type,
1348: p_to IN OUT NOCOPY xpiv_rec_type -- PostGen-11
1349: ) IS
1350: BEGIN
1351: p_to.id := p_from.id;

Line 1382: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

1378: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1379: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1380: l_xpiv_rec xpiv_rec_type := p_xpiv_rec;
1381: l_xpi_rec xpi_rec_type;
1382: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
1383: BEGIN
1384: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1385: G_PKG_NAME,
1386: p_init_msg_list,

Line 1720: -- insert_row for:OKL_EXT_PAY_INVS_TL --

1716: '_PVT'
1717: );
1718: END insert_row;
1719: ----------------------------------------
1720: -- insert_row for:OKL_EXT_PAY_INVS_TL --
1721: ----------------------------------------
1722: PROCEDURE insert_row(
1723: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1724: x_return_status OUT NOCOPY VARCHAR2,

Line 1727: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,

1723: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1724: x_return_status OUT NOCOPY VARCHAR2,
1725: x_msg_count OUT NOCOPY NUMBER,
1726: x_msg_data OUT NOCOPY VARCHAR2,
1727: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
1728: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type) IS
1729:
1730: l_api_version CONSTANT NUMBER := 1;
1731: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1728: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type) IS

1724: x_return_status OUT NOCOPY VARCHAR2,
1725: x_msg_count OUT NOCOPY NUMBER,
1726: x_msg_data OUT NOCOPY VARCHAR2,
1727: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
1728: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type) IS
1729:
1730: l_api_version CONSTANT NUMBER := 1;
1731: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1732: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1733: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type := p_okl_ext_pay_invs_tl_rec;

1729:
1730: l_api_version CONSTANT NUMBER := 1;
1731: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1732: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1733: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type := p_okl_ext_pay_invs_tl_rec;
1734: ldefoklextpayinvstlrec okl_ext_pay_invs_tl_rec_type;
1735: CURSOR get_languages IS
1736: SELECT *
1737: FROM FND_LANGUAGES

Line 1734: ldefoklextpayinvstlrec okl_ext_pay_invs_tl_rec_type;

1730: l_api_version CONSTANT NUMBER := 1;
1731: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1732: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1733: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type := p_okl_ext_pay_invs_tl_rec;
1734: ldefoklextpayinvstlrec okl_ext_pay_invs_tl_rec_type;
1735: CURSOR get_languages IS
1736: SELECT *
1737: FROM FND_LANGUAGES
1738: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1740: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --

1736: SELECT *
1737: FROM FND_LANGUAGES
1738: WHERE INSTALLED_FLAG IN ('I', 'B');
1739: --------------------------------------------
1740: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
1741: --------------------------------------------
1742: FUNCTION Set_Attributes (
1743: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
1744: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type

Line 1743: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,

1739: --------------------------------------------
1740: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
1741: --------------------------------------------
1742: FUNCTION Set_Attributes (
1743: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
1744: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
1745: ) RETURN VARCHAR2 IS
1746: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1747: BEGIN

Line 1744: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type

1740: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
1741: --------------------------------------------
1742: FUNCTION Set_Attributes (
1743: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
1744: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
1745: ) RETURN VARCHAR2 IS
1746: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1747: BEGIN
1748: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;

Line 1748: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;

1744: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
1745: ) RETURN VARCHAR2 IS
1746: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1747: BEGIN
1748: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
1749: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');
1750: x_okl_ext_pay_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
1751: RETURN(l_return_status);
1752: END Set_Attributes;

Line 1749: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');

1745: ) RETURN VARCHAR2 IS
1746: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1747: BEGIN
1748: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
1749: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');
1750: x_okl_ext_pay_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
1751: RETURN(l_return_status);
1752: END Set_Attributes;
1753: BEGIN

Line 1750: x_okl_ext_pay_invs_tl_rec.SOURCE_LANG := USERENV('LANG');

1746: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1747: BEGIN
1748: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
1749: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');
1750: x_okl_ext_pay_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
1751: RETURN(l_return_status);
1752: END Set_Attributes;
1753: BEGIN
1754: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1765: p_okl_ext_pay_invs_tl_rec, -- IN

1761: RAISE OKL_API.G_EXCEPTION_ERROR;
1762: END IF;
1763: --- Setting item attributes
1764: l_return_status := Set_Attributes(
1765: p_okl_ext_pay_invs_tl_rec, -- IN
1766: l_okl_ext_pay_invs_tl_rec); -- OUT
1767: --- If any errors happen abort API
1768: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1766: l_okl_ext_pay_invs_tl_rec); -- OUT

1762: END IF;
1763: --- Setting item attributes
1764: l_return_status := Set_Attributes(
1765: p_okl_ext_pay_invs_tl_rec, -- IN
1766: l_okl_ext_pay_invs_tl_rec); -- OUT
1767: --- If any errors happen abort API
1768: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1770: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1774: l_okl_ext_pay_invs_tl_rec.language := l_lang_rec.language_code;

1770: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1771: RAISE OKL_API.G_EXCEPTION_ERROR;
1772: END IF;
1773: FOR l_lang_rec IN get_languages LOOP
1774: l_okl_ext_pay_invs_tl_rec.language := l_lang_rec.language_code;
1775: INSERT INTO OKL_EXT_PAY_INVS_TL(
1776: id,
1777: language,
1778: source_lang,

Line 1775: INSERT INTO OKL_EXT_PAY_INVS_TL(

1771: RAISE OKL_API.G_EXCEPTION_ERROR;
1772: END IF;
1773: FOR l_lang_rec IN get_languages LOOP
1774: l_okl_ext_pay_invs_tl_rec.language := l_lang_rec.language_code;
1775: INSERT INTO OKL_EXT_PAY_INVS_TL(
1776: id,
1777: language,
1778: source_lang,
1779: sfwt_flag,

Line 1789: l_okl_ext_pay_invs_tl_rec.id,

1785: last_updated_by,
1786: last_update_date,
1787: last_update_login)
1788: VALUES (
1789: l_okl_ext_pay_invs_tl_rec.id,
1790: l_okl_ext_pay_invs_tl_rec.language,
1791: l_okl_ext_pay_invs_tl_rec.source_lang,
1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,
1793: l_okl_ext_pay_invs_tl_rec.description,

Line 1790: l_okl_ext_pay_invs_tl_rec.language,

1786: last_update_date,
1787: last_update_login)
1788: VALUES (
1789: l_okl_ext_pay_invs_tl_rec.id,
1790: l_okl_ext_pay_invs_tl_rec.language,
1791: l_okl_ext_pay_invs_tl_rec.source_lang,
1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,
1793: l_okl_ext_pay_invs_tl_rec.description,
1794: l_okl_ext_pay_invs_tl_rec.source,

Line 1791: l_okl_ext_pay_invs_tl_rec.source_lang,

1787: last_update_login)
1788: VALUES (
1789: l_okl_ext_pay_invs_tl_rec.id,
1790: l_okl_ext_pay_invs_tl_rec.language,
1791: l_okl_ext_pay_invs_tl_rec.source_lang,
1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,
1793: l_okl_ext_pay_invs_tl_rec.description,
1794: l_okl_ext_pay_invs_tl_rec.source,
1795: l_okl_ext_pay_invs_tl_rec.stream_type,

Line 1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,

1788: VALUES (
1789: l_okl_ext_pay_invs_tl_rec.id,
1790: l_okl_ext_pay_invs_tl_rec.language,
1791: l_okl_ext_pay_invs_tl_rec.source_lang,
1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,
1793: l_okl_ext_pay_invs_tl_rec.description,
1794: l_okl_ext_pay_invs_tl_rec.source,
1795: l_okl_ext_pay_invs_tl_rec.stream_type,
1796: l_okl_ext_pay_invs_tl_rec.created_by,

Line 1793: l_okl_ext_pay_invs_tl_rec.description,

1789: l_okl_ext_pay_invs_tl_rec.id,
1790: l_okl_ext_pay_invs_tl_rec.language,
1791: l_okl_ext_pay_invs_tl_rec.source_lang,
1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,
1793: l_okl_ext_pay_invs_tl_rec.description,
1794: l_okl_ext_pay_invs_tl_rec.source,
1795: l_okl_ext_pay_invs_tl_rec.stream_type,
1796: l_okl_ext_pay_invs_tl_rec.created_by,
1797: l_okl_ext_pay_invs_tl_rec.creation_date,

Line 1794: l_okl_ext_pay_invs_tl_rec.source,

1790: l_okl_ext_pay_invs_tl_rec.language,
1791: l_okl_ext_pay_invs_tl_rec.source_lang,
1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,
1793: l_okl_ext_pay_invs_tl_rec.description,
1794: l_okl_ext_pay_invs_tl_rec.source,
1795: l_okl_ext_pay_invs_tl_rec.stream_type,
1796: l_okl_ext_pay_invs_tl_rec.created_by,
1797: l_okl_ext_pay_invs_tl_rec.creation_date,
1798: l_okl_ext_pay_invs_tl_rec.last_updated_by,

Line 1795: l_okl_ext_pay_invs_tl_rec.stream_type,

1791: l_okl_ext_pay_invs_tl_rec.source_lang,
1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,
1793: l_okl_ext_pay_invs_tl_rec.description,
1794: l_okl_ext_pay_invs_tl_rec.source,
1795: l_okl_ext_pay_invs_tl_rec.stream_type,
1796: l_okl_ext_pay_invs_tl_rec.created_by,
1797: l_okl_ext_pay_invs_tl_rec.creation_date,
1798: l_okl_ext_pay_invs_tl_rec.last_updated_by,
1799: l_okl_ext_pay_invs_tl_rec.last_update_date,

Line 1796: l_okl_ext_pay_invs_tl_rec.created_by,

1792: l_okl_ext_pay_invs_tl_rec.sfwt_flag,
1793: l_okl_ext_pay_invs_tl_rec.description,
1794: l_okl_ext_pay_invs_tl_rec.source,
1795: l_okl_ext_pay_invs_tl_rec.stream_type,
1796: l_okl_ext_pay_invs_tl_rec.created_by,
1797: l_okl_ext_pay_invs_tl_rec.creation_date,
1798: l_okl_ext_pay_invs_tl_rec.last_updated_by,
1799: l_okl_ext_pay_invs_tl_rec.last_update_date,
1800: l_okl_ext_pay_invs_tl_rec.last_update_login);

Line 1797: l_okl_ext_pay_invs_tl_rec.creation_date,

1793: l_okl_ext_pay_invs_tl_rec.description,
1794: l_okl_ext_pay_invs_tl_rec.source,
1795: l_okl_ext_pay_invs_tl_rec.stream_type,
1796: l_okl_ext_pay_invs_tl_rec.created_by,
1797: l_okl_ext_pay_invs_tl_rec.creation_date,
1798: l_okl_ext_pay_invs_tl_rec.last_updated_by,
1799: l_okl_ext_pay_invs_tl_rec.last_update_date,
1800: l_okl_ext_pay_invs_tl_rec.last_update_login);
1801: END LOOP;

Line 1798: l_okl_ext_pay_invs_tl_rec.last_updated_by,

1794: l_okl_ext_pay_invs_tl_rec.source,
1795: l_okl_ext_pay_invs_tl_rec.stream_type,
1796: l_okl_ext_pay_invs_tl_rec.created_by,
1797: l_okl_ext_pay_invs_tl_rec.creation_date,
1798: l_okl_ext_pay_invs_tl_rec.last_updated_by,
1799: l_okl_ext_pay_invs_tl_rec.last_update_date,
1800: l_okl_ext_pay_invs_tl_rec.last_update_login);
1801: END LOOP;
1802: -- Set OUT values

Line 1799: l_okl_ext_pay_invs_tl_rec.last_update_date,

1795: l_okl_ext_pay_invs_tl_rec.stream_type,
1796: l_okl_ext_pay_invs_tl_rec.created_by,
1797: l_okl_ext_pay_invs_tl_rec.creation_date,
1798: l_okl_ext_pay_invs_tl_rec.last_updated_by,
1799: l_okl_ext_pay_invs_tl_rec.last_update_date,
1800: l_okl_ext_pay_invs_tl_rec.last_update_login);
1801: END LOOP;
1802: -- Set OUT values
1803: x_okl_ext_pay_invs_tl_rec := l_okl_ext_pay_invs_tl_rec;

Line 1800: l_okl_ext_pay_invs_tl_rec.last_update_login);

1796: l_okl_ext_pay_invs_tl_rec.created_by,
1797: l_okl_ext_pay_invs_tl_rec.creation_date,
1798: l_okl_ext_pay_invs_tl_rec.last_updated_by,
1799: l_okl_ext_pay_invs_tl_rec.last_update_date,
1800: l_okl_ext_pay_invs_tl_rec.last_update_login);
1801: END LOOP;
1802: -- Set OUT values
1803: x_okl_ext_pay_invs_tl_rec := l_okl_ext_pay_invs_tl_rec;
1804: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1803: x_okl_ext_pay_invs_tl_rec := l_okl_ext_pay_invs_tl_rec;

1799: l_okl_ext_pay_invs_tl_rec.last_update_date,
1800: l_okl_ext_pay_invs_tl_rec.last_update_login);
1801: END LOOP;
1802: -- Set OUT values
1803: x_okl_ext_pay_invs_tl_rec := l_okl_ext_pay_invs_tl_rec;
1804: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1805: EXCEPTION
1806: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1807: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1856: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

1852: l_xpiv_rec xpiv_rec_type;
1853: l_def_xpiv_rec xpiv_rec_type;
1854: l_xpi_rec xpi_rec_type;
1855: lx_xpi_rec xpi_rec_type;
1856: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
1857: lx_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
1858: -------------------------------
1859: -- FUNCTION fill_who_columns --
1860: -------------------------------

Line 1857: lx_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

1853: l_def_xpiv_rec xpiv_rec_type;
1854: l_xpi_rec xpi_rec_type;
1855: lx_xpi_rec xpi_rec_type;
1856: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
1857: lx_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
1858: -------------------------------
1859: -- FUNCTION fill_who_columns --
1860: -------------------------------
1861: FUNCTION fill_who_columns (

Line 1947: migrate(l_def_xpiv_rec, l_okl_ext_pay_invs_tl_rec);

1943: --------------------------------------
1944: -- Move VIEW record to "Child" records
1945: --------------------------------------
1946: migrate(l_def_xpiv_rec, l_xpi_rec);
1947: migrate(l_def_xpiv_rec, l_okl_ext_pay_invs_tl_rec);
1948: --------------------------------------------
1949: -- Call the INSERT_ROW for each child record
1950: --------------------------------------------
1951: insert_row(

Line 1970: l_okl_ext_pay_invs_tl_rec,

1966: p_init_msg_list,
1967: x_return_status,
1968: x_msg_count,
1969: x_msg_data,
1970: l_okl_ext_pay_invs_tl_rec,
1971: lx_okl_ext_pay_invs_tl_rec
1972: );
1973: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1974: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1971: lx_okl_ext_pay_invs_tl_rec

1967: x_return_status,
1968: x_msg_count,
1969: x_msg_data,
1970: l_okl_ext_pay_invs_tl_rec,
1971: lx_okl_ext_pay_invs_tl_rec
1972: );
1973: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1974: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1975: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1978: migrate(lx_okl_ext_pay_invs_tl_rec, l_def_xpiv_rec);

1974: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1975: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1976: RAISE OKL_API.G_EXCEPTION_ERROR;
1977: END IF;
1978: migrate(lx_okl_ext_pay_invs_tl_rec, l_def_xpiv_rec);
1979: -- Set OUT values
1980: x_xpiv_rec := l_def_xpiv_rec;
1981: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1982: EXCEPTION

Line 2203: -- lock_row for:OKL_EXT_PAY_INVS_TL --

2199: '_PVT'
2200: );
2201: END lock_row;
2202: --------------------------------------
2203: -- lock_row for:OKL_EXT_PAY_INVS_TL --
2204: --------------------------------------
2205: PROCEDURE lock_row(
2206: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2207: x_return_status OUT NOCOPY VARCHAR2,

Line 2210: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS

2206: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2207: x_return_status OUT NOCOPY VARCHAR2,
2208: x_msg_count OUT NOCOPY NUMBER,
2209: x_msg_data OUT NOCOPY VARCHAR2,
2210: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS
2211:
2212: E_Resource_Busy EXCEPTION;
2213: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2214: CURSOR lock_csr (p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS

Line 2214: CURSOR lock_csr (p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS

2210: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS
2211:
2212: E_Resource_Busy EXCEPTION;
2213: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2214: CURSOR lock_csr (p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS
2215: SELECT *
2216: FROM OKL_EXT_PAY_INVS_TL
2217: WHERE ID = p_okl_ext_pay_invs_tl_rec.id
2218: FOR UPDATE NOWAIT;

Line 2216: FROM OKL_EXT_PAY_INVS_TL

2212: E_Resource_Busy EXCEPTION;
2213: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2214: CURSOR lock_csr (p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS
2215: SELECT *
2216: FROM OKL_EXT_PAY_INVS_TL
2217: WHERE ID = p_okl_ext_pay_invs_tl_rec.id
2218: FOR UPDATE NOWAIT;
2219:
2220: l_api_version CONSTANT NUMBER := 1;

Line 2217: WHERE ID = p_okl_ext_pay_invs_tl_rec.id

2213: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2214: CURSOR lock_csr (p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS
2215: SELECT *
2216: FROM OKL_EXT_PAY_INVS_TL
2217: WHERE ID = p_okl_ext_pay_invs_tl_rec.id
2218: FOR UPDATE NOWAIT;
2219:
2220: l_api_version CONSTANT NUMBER := 1;
2221: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2237: OPEN lock_csr(p_okl_ext_pay_invs_tl_rec);

2233: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2234: RAISE OKL_API.G_EXCEPTION_ERROR;
2235: END IF;
2236: BEGIN
2237: OPEN lock_csr(p_okl_ext_pay_invs_tl_rec);
2238: FETCH lock_csr INTO l_lock_var;
2239: l_row_notfound := lock_csr%NOTFOUND;
2240: CLOSE lock_csr;
2241: EXCEPTION

Line 2302: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

2298: l_api_version CONSTANT NUMBER := 1;
2299: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2300: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2301: l_xpi_rec xpi_rec_type;
2302: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
2303: BEGIN
2304: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2305: G_PKG_NAME,
2306: p_init_msg_list,

Line 2320: migrate(p_xpiv_rec, l_okl_ext_pay_invs_tl_rec);

2316: --------------------------------------
2317: -- Move VIEW record to "Child" records
2318: --------------------------------------
2319: migrate(p_xpiv_rec, l_xpi_rec);
2320: migrate(p_xpiv_rec, l_okl_ext_pay_invs_tl_rec);
2321: --------------------------------------------
2322: -- Call the LOCK_ROW for each child record
2323: --------------------------------------------
2324: lock_row(

Line 2341: l_okl_ext_pay_invs_tl_rec

2337: p_init_msg_list,
2338: x_return_status,
2339: x_msg_count,
2340: x_msg_data,
2341: l_okl_ext_pay_invs_tl_rec
2342: );
2343: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2345: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2846: -- update_row for:OKL_EXT_PAY_INVS_TL --

2842: '_PVT'
2843: );
2844: END update_row;
2845: ----------------------------------------
2846: -- update_row for:OKL_EXT_PAY_INVS_TL --
2847: ----------------------------------------
2848: PROCEDURE update_row(
2849: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2850: x_return_status OUT NOCOPY VARCHAR2,

Line 2853: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,

2849: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2850: x_return_status OUT NOCOPY VARCHAR2,
2851: x_msg_count OUT NOCOPY NUMBER,
2852: x_msg_data OUT NOCOPY VARCHAR2,
2853: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
2854: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type) IS
2855:
2856: l_api_version CONSTANT NUMBER := 1;
2857: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2854: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type) IS

2850: x_return_status OUT NOCOPY VARCHAR2,
2851: x_msg_count OUT NOCOPY NUMBER,
2852: x_msg_data OUT NOCOPY VARCHAR2,
2853: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
2854: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type) IS
2855:
2856: l_api_version CONSTANT NUMBER := 1;
2857: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2858: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2859: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type := p_okl_ext_pay_invs_tl_rec;

2855:
2856: l_api_version CONSTANT NUMBER := 1;
2857: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2858: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2859: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type := p_okl_ext_pay_invs_tl_rec;
2860: ldefoklextpayinvstlrec okl_ext_pay_invs_tl_rec_type;
2861: l_row_notfound BOOLEAN := TRUE;
2862: ----------------------------------
2863: -- FUNCTION populate_new_record --

Line 2860: ldefoklextpayinvstlrec okl_ext_pay_invs_tl_rec_type;

2856: l_api_version CONSTANT NUMBER := 1;
2857: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2858: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2859: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type := p_okl_ext_pay_invs_tl_rec;
2860: ldefoklextpayinvstlrec okl_ext_pay_invs_tl_rec_type;
2861: l_row_notfound BOOLEAN := TRUE;
2862: ----------------------------------
2863: -- FUNCTION populate_new_record --
2864: ----------------------------------

Line 2866: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,

2862: ----------------------------------
2863: -- FUNCTION populate_new_record --
2864: ----------------------------------
2865: FUNCTION populate_new_record (
2866: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
2867: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
2868: ) RETURN VARCHAR2 IS
2869: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
2870: l_row_notfound BOOLEAN := TRUE;

Line 2867: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type

2863: -- FUNCTION populate_new_record --
2864: ----------------------------------
2865: FUNCTION populate_new_record (
2866: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
2867: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
2868: ) RETURN VARCHAR2 IS
2869: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
2870: l_row_notfound BOOLEAN := TRUE;
2871: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2869: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

2865: FUNCTION populate_new_record (
2866: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
2867: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
2868: ) RETURN VARCHAR2 IS
2869: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
2870: l_row_notfound BOOLEAN := TRUE;
2871: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2872: BEGIN
2873: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;

Line 2873: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;

2869: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
2870: l_row_notfound BOOLEAN := TRUE;
2871: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2872: BEGIN
2873: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
2874: -- Get current database values
2875: l_okl_ext_pay_invs_tl_rec := get_rec(p_okl_ext_pay_invs_tl_rec, l_row_notfound);
2876: IF (l_row_notfound) THEN
2877: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2875: l_okl_ext_pay_invs_tl_rec := get_rec(p_okl_ext_pay_invs_tl_rec, l_row_notfound);

2871: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2872: BEGIN
2873: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
2874: -- Get current database values
2875: l_okl_ext_pay_invs_tl_rec := get_rec(p_okl_ext_pay_invs_tl_rec, l_row_notfound);
2876: IF (l_row_notfound) THEN
2877: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2878: END IF;
2879: IF (x_okl_ext_pay_invs_tl_rec.id = OKL_API.G_MISS_NUM)

Line 2879: IF (x_okl_ext_pay_invs_tl_rec.id = OKL_API.G_MISS_NUM)

2875: l_okl_ext_pay_invs_tl_rec := get_rec(p_okl_ext_pay_invs_tl_rec, l_row_notfound);
2876: IF (l_row_notfound) THEN
2877: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2878: END IF;
2879: IF (x_okl_ext_pay_invs_tl_rec.id = OKL_API.G_MISS_NUM)
2880: THEN
2881: x_okl_ext_pay_invs_tl_rec.id := l_okl_ext_pay_invs_tl_rec.id;
2882: END IF;
2883: IF (x_okl_ext_pay_invs_tl_rec.language = OKL_API.G_MISS_CHAR)

Line 2881: x_okl_ext_pay_invs_tl_rec.id := l_okl_ext_pay_invs_tl_rec.id;

2877: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2878: END IF;
2879: IF (x_okl_ext_pay_invs_tl_rec.id = OKL_API.G_MISS_NUM)
2880: THEN
2881: x_okl_ext_pay_invs_tl_rec.id := l_okl_ext_pay_invs_tl_rec.id;
2882: END IF;
2883: IF (x_okl_ext_pay_invs_tl_rec.language = OKL_API.G_MISS_CHAR)
2884: THEN
2885: x_okl_ext_pay_invs_tl_rec.language := l_okl_ext_pay_invs_tl_rec.language;

Line 2883: IF (x_okl_ext_pay_invs_tl_rec.language = OKL_API.G_MISS_CHAR)

2879: IF (x_okl_ext_pay_invs_tl_rec.id = OKL_API.G_MISS_NUM)
2880: THEN
2881: x_okl_ext_pay_invs_tl_rec.id := l_okl_ext_pay_invs_tl_rec.id;
2882: END IF;
2883: IF (x_okl_ext_pay_invs_tl_rec.language = OKL_API.G_MISS_CHAR)
2884: THEN
2885: x_okl_ext_pay_invs_tl_rec.language := l_okl_ext_pay_invs_tl_rec.language;
2886: END IF;
2887: IF (x_okl_ext_pay_invs_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

Line 2885: x_okl_ext_pay_invs_tl_rec.language := l_okl_ext_pay_invs_tl_rec.language;

2881: x_okl_ext_pay_invs_tl_rec.id := l_okl_ext_pay_invs_tl_rec.id;
2882: END IF;
2883: IF (x_okl_ext_pay_invs_tl_rec.language = OKL_API.G_MISS_CHAR)
2884: THEN
2885: x_okl_ext_pay_invs_tl_rec.language := l_okl_ext_pay_invs_tl_rec.language;
2886: END IF;
2887: IF (x_okl_ext_pay_invs_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2888: THEN
2889: x_okl_ext_pay_invs_tl_rec.source_lang := l_okl_ext_pay_invs_tl_rec.source_lang;

Line 2887: IF (x_okl_ext_pay_invs_tl_rec.source_lang = OKL_API.G_MISS_CHAR)

2883: IF (x_okl_ext_pay_invs_tl_rec.language = OKL_API.G_MISS_CHAR)
2884: THEN
2885: x_okl_ext_pay_invs_tl_rec.language := l_okl_ext_pay_invs_tl_rec.language;
2886: END IF;
2887: IF (x_okl_ext_pay_invs_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2888: THEN
2889: x_okl_ext_pay_invs_tl_rec.source_lang := l_okl_ext_pay_invs_tl_rec.source_lang;
2890: END IF;
2891: IF (x_okl_ext_pay_invs_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

Line 2889: x_okl_ext_pay_invs_tl_rec.source_lang := l_okl_ext_pay_invs_tl_rec.source_lang;

2885: x_okl_ext_pay_invs_tl_rec.language := l_okl_ext_pay_invs_tl_rec.language;
2886: END IF;
2887: IF (x_okl_ext_pay_invs_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2888: THEN
2889: x_okl_ext_pay_invs_tl_rec.source_lang := l_okl_ext_pay_invs_tl_rec.source_lang;
2890: END IF;
2891: IF (x_okl_ext_pay_invs_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2892: THEN
2893: x_okl_ext_pay_invs_tl_rec.sfwt_flag := l_okl_ext_pay_invs_tl_rec.sfwt_flag;

Line 2891: IF (x_okl_ext_pay_invs_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)

2887: IF (x_okl_ext_pay_invs_tl_rec.source_lang = OKL_API.G_MISS_CHAR)
2888: THEN
2889: x_okl_ext_pay_invs_tl_rec.source_lang := l_okl_ext_pay_invs_tl_rec.source_lang;
2890: END IF;
2891: IF (x_okl_ext_pay_invs_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2892: THEN
2893: x_okl_ext_pay_invs_tl_rec.sfwt_flag := l_okl_ext_pay_invs_tl_rec.sfwt_flag;
2894: END IF;
2895: IF (x_okl_ext_pay_invs_tl_rec.description = OKL_API.G_MISS_CHAR)

Line 2893: x_okl_ext_pay_invs_tl_rec.sfwt_flag := l_okl_ext_pay_invs_tl_rec.sfwt_flag;

2889: x_okl_ext_pay_invs_tl_rec.source_lang := l_okl_ext_pay_invs_tl_rec.source_lang;
2890: END IF;
2891: IF (x_okl_ext_pay_invs_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2892: THEN
2893: x_okl_ext_pay_invs_tl_rec.sfwt_flag := l_okl_ext_pay_invs_tl_rec.sfwt_flag;
2894: END IF;
2895: IF (x_okl_ext_pay_invs_tl_rec.description = OKL_API.G_MISS_CHAR)
2896: THEN
2897: x_okl_ext_pay_invs_tl_rec.description := l_okl_ext_pay_invs_tl_rec.description;

Line 2895: IF (x_okl_ext_pay_invs_tl_rec.description = OKL_API.G_MISS_CHAR)

2891: IF (x_okl_ext_pay_invs_tl_rec.sfwt_flag = OKL_API.G_MISS_CHAR)
2892: THEN
2893: x_okl_ext_pay_invs_tl_rec.sfwt_flag := l_okl_ext_pay_invs_tl_rec.sfwt_flag;
2894: END IF;
2895: IF (x_okl_ext_pay_invs_tl_rec.description = OKL_API.G_MISS_CHAR)
2896: THEN
2897: x_okl_ext_pay_invs_tl_rec.description := l_okl_ext_pay_invs_tl_rec.description;
2898: END IF;
2899: IF (x_okl_ext_pay_invs_tl_rec.source = OKL_API.G_MISS_CHAR)

Line 2897: x_okl_ext_pay_invs_tl_rec.description := l_okl_ext_pay_invs_tl_rec.description;

2893: x_okl_ext_pay_invs_tl_rec.sfwt_flag := l_okl_ext_pay_invs_tl_rec.sfwt_flag;
2894: END IF;
2895: IF (x_okl_ext_pay_invs_tl_rec.description = OKL_API.G_MISS_CHAR)
2896: THEN
2897: x_okl_ext_pay_invs_tl_rec.description := l_okl_ext_pay_invs_tl_rec.description;
2898: END IF;
2899: IF (x_okl_ext_pay_invs_tl_rec.source = OKL_API.G_MISS_CHAR)
2900: THEN
2901: x_okl_ext_pay_invs_tl_rec.source := l_okl_ext_pay_invs_tl_rec.source;

Line 2899: IF (x_okl_ext_pay_invs_tl_rec.source = OKL_API.G_MISS_CHAR)

2895: IF (x_okl_ext_pay_invs_tl_rec.description = OKL_API.G_MISS_CHAR)
2896: THEN
2897: x_okl_ext_pay_invs_tl_rec.description := l_okl_ext_pay_invs_tl_rec.description;
2898: END IF;
2899: IF (x_okl_ext_pay_invs_tl_rec.source = OKL_API.G_MISS_CHAR)
2900: THEN
2901: x_okl_ext_pay_invs_tl_rec.source := l_okl_ext_pay_invs_tl_rec.source;
2902: END IF;
2903: IF (x_okl_ext_pay_invs_tl_rec.stream_type = OKL_API.G_MISS_CHAR)

Line 2901: x_okl_ext_pay_invs_tl_rec.source := l_okl_ext_pay_invs_tl_rec.source;

2897: x_okl_ext_pay_invs_tl_rec.description := l_okl_ext_pay_invs_tl_rec.description;
2898: END IF;
2899: IF (x_okl_ext_pay_invs_tl_rec.source = OKL_API.G_MISS_CHAR)
2900: THEN
2901: x_okl_ext_pay_invs_tl_rec.source := l_okl_ext_pay_invs_tl_rec.source;
2902: END IF;
2903: IF (x_okl_ext_pay_invs_tl_rec.stream_type = OKL_API.G_MISS_CHAR)
2904: THEN
2905: x_okl_ext_pay_invs_tl_rec.stream_type := l_okl_ext_pay_invs_tl_rec.stream_type;

Line 2903: IF (x_okl_ext_pay_invs_tl_rec.stream_type = OKL_API.G_MISS_CHAR)

2899: IF (x_okl_ext_pay_invs_tl_rec.source = OKL_API.G_MISS_CHAR)
2900: THEN
2901: x_okl_ext_pay_invs_tl_rec.source := l_okl_ext_pay_invs_tl_rec.source;
2902: END IF;
2903: IF (x_okl_ext_pay_invs_tl_rec.stream_type = OKL_API.G_MISS_CHAR)
2904: THEN
2905: x_okl_ext_pay_invs_tl_rec.stream_type := l_okl_ext_pay_invs_tl_rec.stream_type;
2906: END IF;
2907: IF (x_okl_ext_pay_invs_tl_rec.created_by = OKL_API.G_MISS_NUM)

Line 2905: x_okl_ext_pay_invs_tl_rec.stream_type := l_okl_ext_pay_invs_tl_rec.stream_type;

2901: x_okl_ext_pay_invs_tl_rec.source := l_okl_ext_pay_invs_tl_rec.source;
2902: END IF;
2903: IF (x_okl_ext_pay_invs_tl_rec.stream_type = OKL_API.G_MISS_CHAR)
2904: THEN
2905: x_okl_ext_pay_invs_tl_rec.stream_type := l_okl_ext_pay_invs_tl_rec.stream_type;
2906: END IF;
2907: IF (x_okl_ext_pay_invs_tl_rec.created_by = OKL_API.G_MISS_NUM)
2908: THEN
2909: x_okl_ext_pay_invs_tl_rec.created_by := l_okl_ext_pay_invs_tl_rec.created_by;

Line 2907: IF (x_okl_ext_pay_invs_tl_rec.created_by = OKL_API.G_MISS_NUM)

2903: IF (x_okl_ext_pay_invs_tl_rec.stream_type = OKL_API.G_MISS_CHAR)
2904: THEN
2905: x_okl_ext_pay_invs_tl_rec.stream_type := l_okl_ext_pay_invs_tl_rec.stream_type;
2906: END IF;
2907: IF (x_okl_ext_pay_invs_tl_rec.created_by = OKL_API.G_MISS_NUM)
2908: THEN
2909: x_okl_ext_pay_invs_tl_rec.created_by := l_okl_ext_pay_invs_tl_rec.created_by;
2910: END IF;
2911: IF (x_okl_ext_pay_invs_tl_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2909: x_okl_ext_pay_invs_tl_rec.created_by := l_okl_ext_pay_invs_tl_rec.created_by;

2905: x_okl_ext_pay_invs_tl_rec.stream_type := l_okl_ext_pay_invs_tl_rec.stream_type;
2906: END IF;
2907: IF (x_okl_ext_pay_invs_tl_rec.created_by = OKL_API.G_MISS_NUM)
2908: THEN
2909: x_okl_ext_pay_invs_tl_rec.created_by := l_okl_ext_pay_invs_tl_rec.created_by;
2910: END IF;
2911: IF (x_okl_ext_pay_invs_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2912: THEN
2913: x_okl_ext_pay_invs_tl_rec.creation_date := l_okl_ext_pay_invs_tl_rec.creation_date;

Line 2911: IF (x_okl_ext_pay_invs_tl_rec.creation_date = OKL_API.G_MISS_DATE)

2907: IF (x_okl_ext_pay_invs_tl_rec.created_by = OKL_API.G_MISS_NUM)
2908: THEN
2909: x_okl_ext_pay_invs_tl_rec.created_by := l_okl_ext_pay_invs_tl_rec.created_by;
2910: END IF;
2911: IF (x_okl_ext_pay_invs_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2912: THEN
2913: x_okl_ext_pay_invs_tl_rec.creation_date := l_okl_ext_pay_invs_tl_rec.creation_date;
2914: END IF;
2915: IF (x_okl_ext_pay_invs_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2913: x_okl_ext_pay_invs_tl_rec.creation_date := l_okl_ext_pay_invs_tl_rec.creation_date;

2909: x_okl_ext_pay_invs_tl_rec.created_by := l_okl_ext_pay_invs_tl_rec.created_by;
2910: END IF;
2911: IF (x_okl_ext_pay_invs_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2912: THEN
2913: x_okl_ext_pay_invs_tl_rec.creation_date := l_okl_ext_pay_invs_tl_rec.creation_date;
2914: END IF;
2915: IF (x_okl_ext_pay_invs_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2916: THEN
2917: x_okl_ext_pay_invs_tl_rec.last_updated_by := l_okl_ext_pay_invs_tl_rec.last_updated_by;

Line 2915: IF (x_okl_ext_pay_invs_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)

2911: IF (x_okl_ext_pay_invs_tl_rec.creation_date = OKL_API.G_MISS_DATE)
2912: THEN
2913: x_okl_ext_pay_invs_tl_rec.creation_date := l_okl_ext_pay_invs_tl_rec.creation_date;
2914: END IF;
2915: IF (x_okl_ext_pay_invs_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2916: THEN
2917: x_okl_ext_pay_invs_tl_rec.last_updated_by := l_okl_ext_pay_invs_tl_rec.last_updated_by;
2918: END IF;
2919: IF (x_okl_ext_pay_invs_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2917: x_okl_ext_pay_invs_tl_rec.last_updated_by := l_okl_ext_pay_invs_tl_rec.last_updated_by;

2913: x_okl_ext_pay_invs_tl_rec.creation_date := l_okl_ext_pay_invs_tl_rec.creation_date;
2914: END IF;
2915: IF (x_okl_ext_pay_invs_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2916: THEN
2917: x_okl_ext_pay_invs_tl_rec.last_updated_by := l_okl_ext_pay_invs_tl_rec.last_updated_by;
2918: END IF;
2919: IF (x_okl_ext_pay_invs_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2920: THEN
2921: x_okl_ext_pay_invs_tl_rec.last_update_date := l_okl_ext_pay_invs_tl_rec.last_update_date;

Line 2919: IF (x_okl_ext_pay_invs_tl_rec.last_update_date = OKL_API.G_MISS_DATE)

2915: IF (x_okl_ext_pay_invs_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
2916: THEN
2917: x_okl_ext_pay_invs_tl_rec.last_updated_by := l_okl_ext_pay_invs_tl_rec.last_updated_by;
2918: END IF;
2919: IF (x_okl_ext_pay_invs_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2920: THEN
2921: x_okl_ext_pay_invs_tl_rec.last_update_date := l_okl_ext_pay_invs_tl_rec.last_update_date;
2922: END IF;
2923: IF (x_okl_ext_pay_invs_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2921: x_okl_ext_pay_invs_tl_rec.last_update_date := l_okl_ext_pay_invs_tl_rec.last_update_date;

2917: x_okl_ext_pay_invs_tl_rec.last_updated_by := l_okl_ext_pay_invs_tl_rec.last_updated_by;
2918: END IF;
2919: IF (x_okl_ext_pay_invs_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2920: THEN
2921: x_okl_ext_pay_invs_tl_rec.last_update_date := l_okl_ext_pay_invs_tl_rec.last_update_date;
2922: END IF;
2923: IF (x_okl_ext_pay_invs_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2924: THEN
2925: x_okl_ext_pay_invs_tl_rec.last_update_login := l_okl_ext_pay_invs_tl_rec.last_update_login;

Line 2923: IF (x_okl_ext_pay_invs_tl_rec.last_update_login = OKL_API.G_MISS_NUM)

2919: IF (x_okl_ext_pay_invs_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
2920: THEN
2921: x_okl_ext_pay_invs_tl_rec.last_update_date := l_okl_ext_pay_invs_tl_rec.last_update_date;
2922: END IF;
2923: IF (x_okl_ext_pay_invs_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2924: THEN
2925: x_okl_ext_pay_invs_tl_rec.last_update_login := l_okl_ext_pay_invs_tl_rec.last_update_login;
2926: END IF;
2927: RETURN(l_return_status);

Line 2925: x_okl_ext_pay_invs_tl_rec.last_update_login := l_okl_ext_pay_invs_tl_rec.last_update_login;

2921: x_okl_ext_pay_invs_tl_rec.last_update_date := l_okl_ext_pay_invs_tl_rec.last_update_date;
2922: END IF;
2923: IF (x_okl_ext_pay_invs_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
2924: THEN
2925: x_okl_ext_pay_invs_tl_rec.last_update_login := l_okl_ext_pay_invs_tl_rec.last_update_login;
2926: END IF;
2927: RETURN(l_return_status);
2928: END populate_new_record;
2929: --------------------------------------------

Line 2930: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --

2926: END IF;
2927: RETURN(l_return_status);
2928: END populate_new_record;
2929: --------------------------------------------
2930: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
2931: --------------------------------------------
2932: FUNCTION Set_Attributes (
2933: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
2934: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type

Line 2933: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,

2929: --------------------------------------------
2930: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
2931: --------------------------------------------
2932: FUNCTION Set_Attributes (
2933: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
2934: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2937: BEGIN

Line 2934: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type

2930: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
2931: --------------------------------------------
2932: FUNCTION Set_Attributes (
2933: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
2934: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;

Line 2938: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;

2934: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
2939: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');
2940: x_okl_ext_pay_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
2941: RETURN(l_return_status);
2942: END Set_Attributes;

Line 2939: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');

2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
2939: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');
2940: x_okl_ext_pay_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
2941: RETURN(l_return_status);
2942: END Set_Attributes;
2943: BEGIN

Line 2940: x_okl_ext_pay_invs_tl_rec.SOURCE_LANG := USERENV('LANG');

2936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
2939: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');
2940: x_okl_ext_pay_invs_tl_rec.SOURCE_LANG := USERENV('LANG');
2941: RETURN(l_return_status);
2942: END Set_Attributes;
2943: BEGIN
2944: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2955: p_okl_ext_pay_invs_tl_rec, -- IN

2951: RAISE OKL_API.G_EXCEPTION_ERROR;
2952: END IF;
2953: --- Setting item attributes
2954: l_return_status := Set_Attributes(
2955: p_okl_ext_pay_invs_tl_rec, -- IN
2956: l_okl_ext_pay_invs_tl_rec); -- OUT
2957: --- If any errors happen abort API
2958: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2959: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2956: l_okl_ext_pay_invs_tl_rec); -- OUT

2952: END IF;
2953: --- Setting item attributes
2954: l_return_status := Set_Attributes(
2955: p_okl_ext_pay_invs_tl_rec, -- IN
2956: l_okl_ext_pay_invs_tl_rec); -- OUT
2957: --- If any errors happen abort API
2958: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2959: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2960: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2963: l_return_status := populate_new_record(l_okl_ext_pay_invs_tl_rec, ldefoklextpayinvstlrec);

2959: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2960: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2961: RAISE OKL_API.G_EXCEPTION_ERROR;
2962: END IF;
2963: l_return_status := populate_new_record(l_okl_ext_pay_invs_tl_rec, ldefoklextpayinvstlrec);
2964: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2965: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2966: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2967: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2969: UPDATE OKL_EXT_PAY_INVS_TL

2965: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2966: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2967: RAISE OKL_API.G_EXCEPTION_ERROR;
2968: END IF;
2969: UPDATE OKL_EXT_PAY_INVS_TL
2970: SET DESCRIPTION = ldefoklextpayinvstlrec.description,
2971: SOURCE = ldefoklextpayinvstlrec.source,
2972: STREAM_TYPE = ldefoklextpayinvstlrec.stream_type,
2973: SOURCE_LANG = ldefoklextpayinvstlrec.source_lang,

Line 2982: UPDATE OKL_EXT_PAY_INVS_TL

2978: LAST_UPDATE_LOGIN = ldefoklextpayinvstlrec.last_update_login
2979: WHERE ID = ldefoklextpayinvstlrec.id
2980: AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);
2981:
2982: UPDATE OKL_EXT_PAY_INVS_TL
2983: SET SFWT_FLAG = 'Y'
2984: WHERE ID = ldefoklextpayinvstlrec.id
2985: AND SOURCE_LANG <> USERENV('LANG');
2986:

Line 2987: x_okl_ext_pay_invs_tl_rec := ldefoklextpayinvstlrec;

2983: SET SFWT_FLAG = 'Y'
2984: WHERE ID = ldefoklextpayinvstlrec.id
2985: AND SOURCE_LANG <> USERENV('LANG');
2986:
2987: x_okl_ext_pay_invs_tl_rec := ldefoklextpayinvstlrec;
2988: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2989: EXCEPTION
2990: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2991: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 3038: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

3034: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3035: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3036: l_xpiv_rec xpiv_rec_type := p_xpiv_rec;
3037: l_def_xpiv_rec xpiv_rec_type;
3038: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
3039: lx_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
3040: l_xpi_rec xpi_rec_type;
3041: lx_xpi_rec xpi_rec_type;
3042: -------------------------------

Line 3039: lx_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

3035: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3036: l_xpiv_rec xpiv_rec_type := p_xpiv_rec;
3037: l_def_xpiv_rec xpiv_rec_type;
3038: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
3039: lx_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
3040: l_xpi_rec xpi_rec_type;
3041: lx_xpi_rec xpi_rec_type;
3042: -------------------------------
3043: -- FUNCTION fill_who_columns --

Line 3390: migrate(l_def_xpiv_rec, l_okl_ext_pay_invs_tl_rec);

3386:
3387: --------------------------------------
3388: -- Move VIEW record to "Child" records
3389: --------------------------------------
3390: migrate(l_def_xpiv_rec, l_okl_ext_pay_invs_tl_rec);
3391: migrate(l_def_xpiv_rec, l_xpi_rec);
3392: --------------------------------------------
3393: -- Call the UPDATE_ROW for each child record
3394: --------------------------------------------

Line 3400: l_okl_ext_pay_invs_tl_rec,

3396: p_init_msg_list,
3397: x_return_status,
3398: x_msg_count,
3399: x_msg_data,
3400: l_okl_ext_pay_invs_tl_rec,
3401: lx_okl_ext_pay_invs_tl_rec
3402: );
3403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3401: lx_okl_ext_pay_invs_tl_rec

3397: x_return_status,
3398: x_msg_count,
3399: x_msg_data,
3400: l_okl_ext_pay_invs_tl_rec,
3401: lx_okl_ext_pay_invs_tl_rec
3402: );
3403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3408: migrate(lx_okl_ext_pay_invs_tl_rec, l_def_xpiv_rec);

3404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3406: RAISE OKL_API.G_EXCEPTION_ERROR;
3407: END IF;
3408: migrate(lx_okl_ext_pay_invs_tl_rec, l_def_xpiv_rec);
3409: update_row(
3410: p_init_msg_list,
3411: x_return_status,
3412: x_msg_count,

Line 3601: -- delete_row for:OKL_EXT_PAY_INVS_TL --

3597: '_PVT'
3598: );
3599: END delete_row;
3600: ----------------------------------------
3601: -- delete_row for:OKL_EXT_PAY_INVS_TL --
3602: ----------------------------------------
3603: PROCEDURE delete_row(
3604: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3605: x_return_status OUT NOCOPY VARCHAR2,

Line 3608: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS

3604: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3605: x_return_status OUT NOCOPY VARCHAR2,
3606: x_msg_count OUT NOCOPY NUMBER,
3607: x_msg_data OUT NOCOPY VARCHAR2,
3608: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type) IS
3609:
3610: l_api_version CONSTANT NUMBER := 1;
3611: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3612: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3613: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type:= p_okl_ext_pay_invs_tl_rec;

3609:
3610: l_api_version CONSTANT NUMBER := 1;
3611: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3612: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3613: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type:= p_okl_ext_pay_invs_tl_rec;
3614: l_row_notfound BOOLEAN := TRUE;
3615: --------------------------------------------
3616: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
3617: --------------------------------------------

Line 3616: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --

3612: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3613: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type:= p_okl_ext_pay_invs_tl_rec;
3614: l_row_notfound BOOLEAN := TRUE;
3615: --------------------------------------------
3616: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
3617: --------------------------------------------
3618: FUNCTION Set_Attributes (
3619: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
3620: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type

Line 3619: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,

3615: --------------------------------------------
3616: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
3617: --------------------------------------------
3618: FUNCTION Set_Attributes (
3619: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
3620: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
3621: ) RETURN VARCHAR2 IS
3622: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3623: BEGIN

Line 3620: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type

3616: -- Set_Attributes for:OKL_EXT_PAY_INVS_TL --
3617: --------------------------------------------
3618: FUNCTION Set_Attributes (
3619: p_okl_ext_pay_invs_tl_rec IN okl_ext_pay_invs_tl_rec_type,
3620: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
3621: ) RETURN VARCHAR2 IS
3622: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3623: BEGIN
3624: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;

Line 3624: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;

3620: x_okl_ext_pay_invs_tl_rec OUT NOCOPY okl_ext_pay_invs_tl_rec_type
3621: ) RETURN VARCHAR2 IS
3622: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3623: BEGIN
3624: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
3625: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');
3626: RETURN(l_return_status);
3627: END Set_Attributes;
3628: BEGIN

Line 3625: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');

3621: ) RETURN VARCHAR2 IS
3622: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3623: BEGIN
3624: x_okl_ext_pay_invs_tl_rec := p_okl_ext_pay_invs_tl_rec;
3625: x_okl_ext_pay_invs_tl_rec.LANGUAGE := USERENV('LANG');
3626: RETURN(l_return_status);
3627: END Set_Attributes;
3628: BEGIN
3629: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3640: p_okl_ext_pay_invs_tl_rec, -- IN

3636: RAISE OKL_API.G_EXCEPTION_ERROR;
3637: END IF;
3638: --- Setting item attributes
3639: l_return_status := Set_Attributes(
3640: p_okl_ext_pay_invs_tl_rec, -- IN
3641: l_okl_ext_pay_invs_tl_rec); -- OUT
3642: --- If any errors happen abort API
3643: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3641: l_okl_ext_pay_invs_tl_rec); -- OUT

3637: END IF;
3638: --- Setting item attributes
3639: l_return_status := Set_Attributes(
3640: p_okl_ext_pay_invs_tl_rec, -- IN
3641: l_okl_ext_pay_invs_tl_rec); -- OUT
3642: --- If any errors happen abort API
3643: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3645: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3648: DELETE FROM OKL_EXT_PAY_INVS_TL

3644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3645: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3646: RAISE OKL_API.G_EXCEPTION_ERROR;
3647: END IF;
3648: DELETE FROM OKL_EXT_PAY_INVS_TL
3649: WHERE ID = l_okl_ext_pay_invs_tl_rec.id;
3650:
3651: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3652: EXCEPTION

Line 3649: WHERE ID = l_okl_ext_pay_invs_tl_rec.id;

3645: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3646: RAISE OKL_API.G_EXCEPTION_ERROR;
3647: END IF;
3648: DELETE FROM OKL_EXT_PAY_INVS_TL
3649: WHERE ID = l_okl_ext_pay_invs_tl_rec.id;
3650:
3651: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3652: EXCEPTION
3653: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3699: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;

3695: l_api_version CONSTANT NUMBER := 1;
3696: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3697: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3698: l_xpiv_rec xpiv_rec_type := p_xpiv_rec;
3699: l_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
3700: l_xpi_rec xpi_rec_type;
3701: BEGIN
3702: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3703: G_PKG_NAME,

Line 3717: migrate(l_xpiv_rec, l_okl_ext_pay_invs_tl_rec);

3713: END IF;
3714: --------------------------------------
3715: -- Move VIEW record to "Child" records
3716: --------------------------------------
3717: migrate(l_xpiv_rec, l_okl_ext_pay_invs_tl_rec);
3718: migrate(l_xpiv_rec, l_xpi_rec);
3719: --------------------------------------------
3720: -- Call the DELETE_ROW for each child record
3721: --------------------------------------------

Line 3727: l_okl_ext_pay_invs_tl_rec

3723: p_init_msg_list,
3724: x_return_status,
3725: x_msg_count,
3726: x_msg_data,
3727: l_okl_ext_pay_invs_tl_rec
3728: );
3729: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3730: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3731: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN