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_RPC_PVT dependencies on OKL_REPAIR_COSTS_TL

Line 648: DELETE FROM OKL_REPAIR_COSTS_TL T

644: -- PROCEDURE add_language
645: ---------------------------------------------------------------------------
646: PROCEDURE add_language IS
647: BEGIN
648: DELETE FROM OKL_REPAIR_COSTS_TL T
649: WHERE NOT EXISTS (
650: SELECT NULL
651: FROM OKL_REPAIR_COSTS_ALL_B B
652: WHERE B.ID = T.ID

Line 655: UPDATE OKL_REPAIR_COSTS_TL T SET (

651: FROM OKL_REPAIR_COSTS_ALL_B B
652: WHERE B.ID = T.ID
653: );
654:
655: UPDATE OKL_REPAIR_COSTS_TL T SET (
656: REPAIR_TYPE,
657: DESCRIPTION) = (SELECT
658: B.REPAIR_TYPE,
659: B.DESCRIPTION

Line 660: FROM OKL_REPAIR_COSTS_TL B

656: REPAIR_TYPE,
657: DESCRIPTION) = (SELECT
658: B.REPAIR_TYPE,
659: B.DESCRIPTION
660: FROM OKL_REPAIR_COSTS_TL B
661: WHERE B.ID = T.ID
662: AND B.LANGUAGE = T.SOURCE_LANG)
663: WHERE (
664: T.ID,

Line 669: FROM OKL_REPAIR_COSTS_TL SUBB, OKL_REPAIR_COSTS_TL SUBT

665: T.LANGUAGE)
666: IN (SELECT
667: SUBT.ID,
668: SUBT.LANGUAGE
669: FROM OKL_REPAIR_COSTS_TL SUBB, OKL_REPAIR_COSTS_TL SUBT
670: WHERE SUBB.ID = SUBT.ID
671: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
672: AND (SUBB.REPAIR_TYPE <> SUBT.REPAIR_TYPE
673: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 676: INSERT INTO OKL_REPAIR_COSTS_TL (

672: AND (SUBB.REPAIR_TYPE <> SUBT.REPAIR_TYPE
673: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
674: ));
675:
676: INSERT INTO OKL_REPAIR_COSTS_TL (
677: ID,
678: LANGUAGE,
679: SOURCE_LANG,
680: SFWT_FLAG,

Line 700: FROM OKL_REPAIR_COSTS_TL B, FND_LANGUAGES L

696: B.CREATION_DATE,
697: B.LAST_UPDATED_BY,
698: B.LAST_UPDATE_DATE,
699: B.LAST_UPDATE_LOGIN
700: FROM OKL_REPAIR_COSTS_TL B, FND_LANGUAGES L
701: WHERE L.INSTALLED_FLAG IN ('I', 'B')
702: AND B.LANGUAGE = USERENV('LANG')
703: AND NOT EXISTS(
704: SELECT NULL

Line 705: FROM OKL_REPAIR_COSTS_TL T

701: WHERE L.INSTALLED_FLAG IN ('I', 'B')
702: AND B.LANGUAGE = USERENV('LANG')
703: AND NOT EXISTS(
704: SELECT NULL
705: FROM OKL_REPAIR_COSTS_TL T
706: WHERE T.ID = B.ID
707: AND T.LANGUAGE = L.LANGUAGE_CODE
708: );
709:

Line 713: -- FUNCTION get_rec for: OKL_REPAIR_COSTS_TL

709:
710: END add_language;
711:
712: ---------------------------------------------------------------------------
713: -- FUNCTION get_rec for: OKL_REPAIR_COSTS_TL
714: ---------------------------------------------------------------------------
715: FUNCTION get_rec (
716: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
717: x_no_data_found OUT NOCOPY BOOLEAN

Line 716: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,

712: ---------------------------------------------------------------------------
713: -- FUNCTION get_rec for: OKL_REPAIR_COSTS_TL
714: ---------------------------------------------------------------------------
715: FUNCTION get_rec (
716: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
717: x_no_data_found OUT NOCOPY BOOLEAN
718: ) RETURN okl_repair_costs_tl_rec_type IS
719: CURSOR okl_repair_costs_tl_pk_csr (p_id IN NUMBER,
720: p_language IN VARCHAR2) IS

Line 718: ) RETURN okl_repair_costs_tl_rec_type IS

714: ---------------------------------------------------------------------------
715: FUNCTION get_rec (
716: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
717: x_no_data_found OUT NOCOPY BOOLEAN
718: ) RETURN okl_repair_costs_tl_rec_type IS
719: CURSOR okl_repair_costs_tl_pk_csr (p_id IN NUMBER,
720: p_language IN VARCHAR2) IS
721: SELECT
722: ID,

Line 719: CURSOR okl_repair_costs_tl_pk_csr (p_id IN NUMBER,

715: FUNCTION get_rec (
716: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
717: x_no_data_found OUT NOCOPY BOOLEAN
718: ) RETURN okl_repair_costs_tl_rec_type IS
719: CURSOR okl_repair_costs_tl_pk_csr (p_id IN NUMBER,
720: p_language IN VARCHAR2) IS
721: SELECT
722: ID,
723: LANGUAGE,

Line 733: FROM Okl_Repair_Costs_Tl

729: CREATION_DATE,
730: LAST_UPDATED_BY,
731: LAST_UPDATE_DATE,
732: LAST_UPDATE_LOGIN
733: FROM Okl_Repair_Costs_Tl
734: WHERE okl_repair_costs_tl.id = p_id
735: AND okl_repair_costs_tl.language = p_language;
736: l_okl_repair_costs_tl_pk okl_repair_costs_tl_pk_csr%ROWTYPE;
737: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

Line 734: WHERE okl_repair_costs_tl.id = p_id

730: LAST_UPDATED_BY,
731: LAST_UPDATE_DATE,
732: LAST_UPDATE_LOGIN
733: FROM Okl_Repair_Costs_Tl
734: WHERE okl_repair_costs_tl.id = p_id
735: AND okl_repair_costs_tl.language = p_language;
736: l_okl_repair_costs_tl_pk okl_repair_costs_tl_pk_csr%ROWTYPE;
737: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
738: BEGIN

Line 735: AND okl_repair_costs_tl.language = p_language;

731: LAST_UPDATE_DATE,
732: LAST_UPDATE_LOGIN
733: FROM Okl_Repair_Costs_Tl
734: WHERE okl_repair_costs_tl.id = p_id
735: AND okl_repair_costs_tl.language = p_language;
736: l_okl_repair_costs_tl_pk okl_repair_costs_tl_pk_csr%ROWTYPE;
737: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
738: BEGIN
739: x_no_data_found := TRUE;

Line 736: l_okl_repair_costs_tl_pk okl_repair_costs_tl_pk_csr%ROWTYPE;

732: LAST_UPDATE_LOGIN
733: FROM Okl_Repair_Costs_Tl
734: WHERE okl_repair_costs_tl.id = p_id
735: AND okl_repair_costs_tl.language = p_language;
736: l_okl_repair_costs_tl_pk okl_repair_costs_tl_pk_csr%ROWTYPE;
737: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
738: BEGIN
739: x_no_data_found := TRUE;
740: -- Get current database values

Line 737: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

733: FROM Okl_Repair_Costs_Tl
734: WHERE okl_repair_costs_tl.id = p_id
735: AND okl_repair_costs_tl.language = p_language;
736: l_okl_repair_costs_tl_pk okl_repair_costs_tl_pk_csr%ROWTYPE;
737: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
738: BEGIN
739: x_no_data_found := TRUE;
740: -- Get current database values
741: OPEN okl_repair_costs_tl_pk_csr (p_okl_repair_costs_tl_rec.id,

Line 741: OPEN okl_repair_costs_tl_pk_csr (p_okl_repair_costs_tl_rec.id,

737: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
738: BEGIN
739: x_no_data_found := TRUE;
740: -- Get current database values
741: OPEN okl_repair_costs_tl_pk_csr (p_okl_repair_costs_tl_rec.id,
742: p_okl_repair_costs_tl_rec.language);
743: FETCH okl_repair_costs_tl_pk_csr INTO
744: l_okl_repair_costs_tl_rec.ID,
745: l_okl_repair_costs_tl_rec.LANGUAGE,

Line 742: p_okl_repair_costs_tl_rec.language);

738: BEGIN
739: x_no_data_found := TRUE;
740: -- Get current database values
741: OPEN okl_repair_costs_tl_pk_csr (p_okl_repair_costs_tl_rec.id,
742: p_okl_repair_costs_tl_rec.language);
743: FETCH okl_repair_costs_tl_pk_csr INTO
744: l_okl_repair_costs_tl_rec.ID,
745: l_okl_repair_costs_tl_rec.LANGUAGE,
746: l_okl_repair_costs_tl_rec.SOURCE_LANG,

Line 743: FETCH okl_repair_costs_tl_pk_csr INTO

739: x_no_data_found := TRUE;
740: -- Get current database values
741: OPEN okl_repair_costs_tl_pk_csr (p_okl_repair_costs_tl_rec.id,
742: p_okl_repair_costs_tl_rec.language);
743: FETCH okl_repair_costs_tl_pk_csr INTO
744: l_okl_repair_costs_tl_rec.ID,
745: l_okl_repair_costs_tl_rec.LANGUAGE,
746: l_okl_repair_costs_tl_rec.SOURCE_LANG,
747: l_okl_repair_costs_tl_rec.SFWT_FLAG,

Line 744: l_okl_repair_costs_tl_rec.ID,

740: -- Get current database values
741: OPEN okl_repair_costs_tl_pk_csr (p_okl_repair_costs_tl_rec.id,
742: p_okl_repair_costs_tl_rec.language);
743: FETCH okl_repair_costs_tl_pk_csr INTO
744: l_okl_repair_costs_tl_rec.ID,
745: l_okl_repair_costs_tl_rec.LANGUAGE,
746: l_okl_repair_costs_tl_rec.SOURCE_LANG,
747: l_okl_repair_costs_tl_rec.SFWT_FLAG,
748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,

Line 745: l_okl_repair_costs_tl_rec.LANGUAGE,

741: OPEN okl_repair_costs_tl_pk_csr (p_okl_repair_costs_tl_rec.id,
742: p_okl_repair_costs_tl_rec.language);
743: FETCH okl_repair_costs_tl_pk_csr INTO
744: l_okl_repair_costs_tl_rec.ID,
745: l_okl_repair_costs_tl_rec.LANGUAGE,
746: l_okl_repair_costs_tl_rec.SOURCE_LANG,
747: l_okl_repair_costs_tl_rec.SFWT_FLAG,
748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,
749: l_okl_repair_costs_tl_rec.DESCRIPTION,

Line 746: l_okl_repair_costs_tl_rec.SOURCE_LANG,

742: p_okl_repair_costs_tl_rec.language);
743: FETCH okl_repair_costs_tl_pk_csr INTO
744: l_okl_repair_costs_tl_rec.ID,
745: l_okl_repair_costs_tl_rec.LANGUAGE,
746: l_okl_repair_costs_tl_rec.SOURCE_LANG,
747: l_okl_repair_costs_tl_rec.SFWT_FLAG,
748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,
749: l_okl_repair_costs_tl_rec.DESCRIPTION,
750: l_okl_repair_costs_tl_rec.CREATED_BY,

Line 747: l_okl_repair_costs_tl_rec.SFWT_FLAG,

743: FETCH okl_repair_costs_tl_pk_csr INTO
744: l_okl_repair_costs_tl_rec.ID,
745: l_okl_repair_costs_tl_rec.LANGUAGE,
746: l_okl_repair_costs_tl_rec.SOURCE_LANG,
747: l_okl_repair_costs_tl_rec.SFWT_FLAG,
748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,
749: l_okl_repair_costs_tl_rec.DESCRIPTION,
750: l_okl_repair_costs_tl_rec.CREATED_BY,
751: l_okl_repair_costs_tl_rec.CREATION_DATE,

Line 748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,

744: l_okl_repair_costs_tl_rec.ID,
745: l_okl_repair_costs_tl_rec.LANGUAGE,
746: l_okl_repair_costs_tl_rec.SOURCE_LANG,
747: l_okl_repair_costs_tl_rec.SFWT_FLAG,
748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,
749: l_okl_repair_costs_tl_rec.DESCRIPTION,
750: l_okl_repair_costs_tl_rec.CREATED_BY,
751: l_okl_repair_costs_tl_rec.CREATION_DATE,
752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,

Line 749: l_okl_repair_costs_tl_rec.DESCRIPTION,

745: l_okl_repair_costs_tl_rec.LANGUAGE,
746: l_okl_repair_costs_tl_rec.SOURCE_LANG,
747: l_okl_repair_costs_tl_rec.SFWT_FLAG,
748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,
749: l_okl_repair_costs_tl_rec.DESCRIPTION,
750: l_okl_repair_costs_tl_rec.CREATED_BY,
751: l_okl_repair_costs_tl_rec.CREATION_DATE,
752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,

Line 750: l_okl_repair_costs_tl_rec.CREATED_BY,

746: l_okl_repair_costs_tl_rec.SOURCE_LANG,
747: l_okl_repair_costs_tl_rec.SFWT_FLAG,
748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,
749: l_okl_repair_costs_tl_rec.DESCRIPTION,
750: l_okl_repair_costs_tl_rec.CREATED_BY,
751: l_okl_repair_costs_tl_rec.CREATION_DATE,
752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;

Line 751: l_okl_repair_costs_tl_rec.CREATION_DATE,

747: l_okl_repair_costs_tl_rec.SFWT_FLAG,
748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,
749: l_okl_repair_costs_tl_rec.DESCRIPTION,
750: l_okl_repair_costs_tl_rec.CREATED_BY,
751: l_okl_repair_costs_tl_rec.CREATION_DATE,
752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;
755: x_no_data_found := okl_repair_costs_tl_pk_csr%NOTFOUND;

Line 752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,

748: l_okl_repair_costs_tl_rec.REPAIR_TYPE,
749: l_okl_repair_costs_tl_rec.DESCRIPTION,
750: l_okl_repair_costs_tl_rec.CREATED_BY,
751: l_okl_repair_costs_tl_rec.CREATION_DATE,
752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;
755: x_no_data_found := okl_repair_costs_tl_pk_csr%NOTFOUND;
756: CLOSE okl_repair_costs_tl_pk_csr;

Line 753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,

749: l_okl_repair_costs_tl_rec.DESCRIPTION,
750: l_okl_repair_costs_tl_rec.CREATED_BY,
751: l_okl_repair_costs_tl_rec.CREATION_DATE,
752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;
755: x_no_data_found := okl_repair_costs_tl_pk_csr%NOTFOUND;
756: CLOSE okl_repair_costs_tl_pk_csr;
757: RETURN(l_okl_repair_costs_tl_rec);

Line 754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;

750: l_okl_repair_costs_tl_rec.CREATED_BY,
751: l_okl_repair_costs_tl_rec.CREATION_DATE,
752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;
755: x_no_data_found := okl_repair_costs_tl_pk_csr%NOTFOUND;
756: CLOSE okl_repair_costs_tl_pk_csr;
757: RETURN(l_okl_repair_costs_tl_rec);
758: END get_rec;

Line 755: x_no_data_found := okl_repair_costs_tl_pk_csr%NOTFOUND;

751: l_okl_repair_costs_tl_rec.CREATION_DATE,
752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;
755: x_no_data_found := okl_repair_costs_tl_pk_csr%NOTFOUND;
756: CLOSE okl_repair_costs_tl_pk_csr;
757: RETURN(l_okl_repair_costs_tl_rec);
758: END get_rec;
759:

Line 756: CLOSE okl_repair_costs_tl_pk_csr;

752: l_okl_repair_costs_tl_rec.LAST_UPDATED_BY,
753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;
755: x_no_data_found := okl_repair_costs_tl_pk_csr%NOTFOUND;
756: CLOSE okl_repair_costs_tl_pk_csr;
757: RETURN(l_okl_repair_costs_tl_rec);
758: END get_rec;
759:
760: FUNCTION get_rec (

Line 757: RETURN(l_okl_repair_costs_tl_rec);

753: l_okl_repair_costs_tl_rec.LAST_UPDATE_DATE,
754: l_okl_repair_costs_tl_rec.LAST_UPDATE_LOGIN;
755: x_no_data_found := okl_repair_costs_tl_pk_csr%NOTFOUND;
756: CLOSE okl_repair_costs_tl_pk_csr;
757: RETURN(l_okl_repair_costs_tl_rec);
758: END get_rec;
759:
760: FUNCTION get_rec (
761: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type

Line 761: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type

757: RETURN(l_okl_repair_costs_tl_rec);
758: END get_rec;
759:
760: FUNCTION get_rec (
761: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type
762: ) RETURN okl_repair_costs_tl_rec_type IS
763: l_row_notfound BOOLEAN := TRUE;
764: BEGIN
765: RETURN(get_rec(p_okl_repair_costs_tl_rec, l_row_notfound));

Line 762: ) RETURN okl_repair_costs_tl_rec_type IS

758: END get_rec;
759:
760: FUNCTION get_rec (
761: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type
762: ) RETURN okl_repair_costs_tl_rec_type IS
763: l_row_notfound BOOLEAN := TRUE;
764: BEGIN
765: RETURN(get_rec(p_okl_repair_costs_tl_rec, l_row_notfound));
766: END get_rec;

Line 765: RETURN(get_rec(p_okl_repair_costs_tl_rec, l_row_notfound));

761: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type
762: ) RETURN okl_repair_costs_tl_rec_type IS
763: l_row_notfound BOOLEAN := TRUE;
764: BEGIN
765: RETURN(get_rec(p_okl_repair_costs_tl_rec, l_row_notfound));
766: END get_rec;
767: ---------------------------------------------------------------------------
768: -- FUNCTION get_rec for: OKL_REPAIR_COSTS_B
769: ---------------------------------------------------------------------------

Line 1195: p_to IN OUT NOCOPY okl_repair_costs_tl_rec_type

1191: ---------------------------------------------------------------------------
1192:
1193: PROCEDURE migrate (
1194: p_from IN rpcv_rec_type,
1195: p_to IN OUT NOCOPY okl_repair_costs_tl_rec_type
1196: ) IS
1197: BEGIN
1198: p_to.id := p_from.id;
1199: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1209: p_from IN okl_repair_costs_tl_rec_type,

1205: p_to.last_update_date := p_from.last_update_date;
1206: p_to.last_update_login := p_from.last_update_login;
1207: END migrate;
1208: PROCEDURE migrate (
1209: p_from IN okl_repair_costs_tl_rec_type,
1210: p_to IN OUT NOCOPY rpcv_rec_type
1211: ) IS
1212: BEGIN
1213: p_to.id := p_from.id;

Line 1310: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

1306: l_api_version CONSTANT NUMBER := 1;
1307: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1308: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1309: l_rpcv_rec rpcv_rec_type := p_rpcv_rec;
1310: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
1311: l_rpc_rec rpc_rec_type;
1312: BEGIN
1313: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1314: G_PKG_NAME,

Line 1457: -- insert_row for:OKL_REPAIR_COSTS_TL --

1453: ---------------------------------------------------------------------------
1454: -- PROCEDURE insert_row
1455: ---------------------------------------------------------------------------
1456: ----------------------------------------
1457: -- insert_row for:OKL_REPAIR_COSTS_TL --
1458: ----------------------------------------
1459: PROCEDURE insert_row(
1460: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1461: x_return_status OUT NOCOPY VARCHAR2,

Line 1464: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,

1460: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1461: x_return_status OUT NOCOPY VARCHAR2,
1462: x_msg_count OUT NOCOPY NUMBER,
1463: x_msg_data OUT NOCOPY VARCHAR2,
1464: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
1465: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type) IS
1466:
1467: l_api_version CONSTANT NUMBER := 1;
1468: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1465: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type) IS

1461: x_return_status OUT NOCOPY VARCHAR2,
1462: x_msg_count OUT NOCOPY NUMBER,
1463: x_msg_data OUT NOCOPY VARCHAR2,
1464: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
1465: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type) IS
1466:
1467: l_api_version CONSTANT NUMBER := 1;
1468: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1469: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1470: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type := p_okl_repair_costs_tl_rec;

1466:
1467: l_api_version CONSTANT NUMBER := 1;
1468: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1469: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1470: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type := p_okl_repair_costs_tl_rec;
1471: ldefoklrepaircoststlrec okl_repair_costs_tl_rec_type;
1472: CURSOR get_languages IS
1473: SELECT *
1474: FROM FND_LANGUAGES

Line 1471: ldefoklrepaircoststlrec okl_repair_costs_tl_rec_type;

1467: l_api_version CONSTANT NUMBER := 1;
1468: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1469: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1470: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type := p_okl_repair_costs_tl_rec;
1471: ldefoklrepaircoststlrec okl_repair_costs_tl_rec_type;
1472: CURSOR get_languages IS
1473: SELECT *
1474: FROM FND_LANGUAGES
1475: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1477: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --

1473: SELECT *
1474: FROM FND_LANGUAGES
1475: WHERE INSTALLED_FLAG IN ('I', 'B');
1476: --------------------------------------------
1477: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
1478: --------------------------------------------
1479: FUNCTION Set_Attributes (
1480: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
1481: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type

Line 1480: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,

1476: --------------------------------------------
1477: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
1478: --------------------------------------------
1479: FUNCTION Set_Attributes (
1480: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
1481: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
1482: ) RETURN VARCHAR2 IS
1483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1484: BEGIN

Line 1481: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type

1477: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
1478: --------------------------------------------
1479: FUNCTION Set_Attributes (
1480: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
1481: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
1482: ) RETURN VARCHAR2 IS
1483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1484: BEGIN
1485: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;

Line 1485: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;

1481: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
1482: ) RETURN VARCHAR2 IS
1483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1484: BEGIN
1485: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
1486: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');
1487: x_okl_repair_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
1488: RETURN(l_return_status);
1489: END Set_Attributes;

Line 1486: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');

1482: ) RETURN VARCHAR2 IS
1483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1484: BEGIN
1485: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
1486: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');
1487: x_okl_repair_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
1488: RETURN(l_return_status);
1489: END Set_Attributes;
1490: BEGIN

Line 1487: x_okl_repair_costs_tl_rec.SOURCE_LANG := USERENV('LANG');

1483: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1484: BEGIN
1485: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
1486: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');
1487: x_okl_repair_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
1488: RETURN(l_return_status);
1489: END Set_Attributes;
1490: BEGIN
1491: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1502: p_okl_repair_costs_tl_rec, -- IN

1498: RAISE OKC_API.G_EXCEPTION_ERROR;
1499: END IF;
1500: --- Setting item attributes
1501: l_return_status := Set_Attributes(
1502: p_okl_repair_costs_tl_rec, -- IN
1503: l_okl_repair_costs_tl_rec); -- OUT
1504: --- If any errors happen abort API
1505: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1506: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1503: l_okl_repair_costs_tl_rec); -- OUT

1499: END IF;
1500: --- Setting item attributes
1501: l_return_status := Set_Attributes(
1502: p_okl_repair_costs_tl_rec, -- IN
1503: l_okl_repair_costs_tl_rec); -- OUT
1504: --- If any errors happen abort API
1505: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1506: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1507: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1511: l_okl_repair_costs_tl_rec.language := l_lang_rec.language_code;

1507: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1508: RAISE OKC_API.G_EXCEPTION_ERROR;
1509: END IF;
1510: FOR l_lang_rec IN get_languages LOOP
1511: l_okl_repair_costs_tl_rec.language := l_lang_rec.language_code;
1512: INSERT INTO OKL_REPAIR_COSTS_TL(
1513: id,
1514: language,
1515: source_lang,

Line 1512: INSERT INTO OKL_REPAIR_COSTS_TL(

1508: RAISE OKC_API.G_EXCEPTION_ERROR;
1509: END IF;
1510: FOR l_lang_rec IN get_languages LOOP
1511: l_okl_repair_costs_tl_rec.language := l_lang_rec.language_code;
1512: INSERT INTO OKL_REPAIR_COSTS_TL(
1513: id,
1514: language,
1515: source_lang,
1516: sfwt_flag,

Line 1525: l_okl_repair_costs_tl_rec.id,

1521: last_updated_by,
1522: last_update_date,
1523: last_update_login)
1524: VALUES (
1525: l_okl_repair_costs_tl_rec.id,
1526: l_okl_repair_costs_tl_rec.language,
1527: l_okl_repair_costs_tl_rec.source_lang,
1528: l_okl_repair_costs_tl_rec.sfwt_flag,
1529: l_okl_repair_costs_tl_rec.repair_type,

Line 1526: l_okl_repair_costs_tl_rec.language,

1522: last_update_date,
1523: last_update_login)
1524: VALUES (
1525: l_okl_repair_costs_tl_rec.id,
1526: l_okl_repair_costs_tl_rec.language,
1527: l_okl_repair_costs_tl_rec.source_lang,
1528: l_okl_repair_costs_tl_rec.sfwt_flag,
1529: l_okl_repair_costs_tl_rec.repair_type,
1530: l_okl_repair_costs_tl_rec.description,

Line 1527: l_okl_repair_costs_tl_rec.source_lang,

1523: last_update_login)
1524: VALUES (
1525: l_okl_repair_costs_tl_rec.id,
1526: l_okl_repair_costs_tl_rec.language,
1527: l_okl_repair_costs_tl_rec.source_lang,
1528: l_okl_repair_costs_tl_rec.sfwt_flag,
1529: l_okl_repair_costs_tl_rec.repair_type,
1530: l_okl_repair_costs_tl_rec.description,
1531: l_okl_repair_costs_tl_rec.created_by,

Line 1528: l_okl_repair_costs_tl_rec.sfwt_flag,

1524: VALUES (
1525: l_okl_repair_costs_tl_rec.id,
1526: l_okl_repair_costs_tl_rec.language,
1527: l_okl_repair_costs_tl_rec.source_lang,
1528: l_okl_repair_costs_tl_rec.sfwt_flag,
1529: l_okl_repair_costs_tl_rec.repair_type,
1530: l_okl_repair_costs_tl_rec.description,
1531: l_okl_repair_costs_tl_rec.created_by,
1532: l_okl_repair_costs_tl_rec.creation_date,

Line 1529: l_okl_repair_costs_tl_rec.repair_type,

1525: l_okl_repair_costs_tl_rec.id,
1526: l_okl_repair_costs_tl_rec.language,
1527: l_okl_repair_costs_tl_rec.source_lang,
1528: l_okl_repair_costs_tl_rec.sfwt_flag,
1529: l_okl_repair_costs_tl_rec.repair_type,
1530: l_okl_repair_costs_tl_rec.description,
1531: l_okl_repair_costs_tl_rec.created_by,
1532: l_okl_repair_costs_tl_rec.creation_date,
1533: l_okl_repair_costs_tl_rec.last_updated_by,

Line 1530: l_okl_repair_costs_tl_rec.description,

1526: l_okl_repair_costs_tl_rec.language,
1527: l_okl_repair_costs_tl_rec.source_lang,
1528: l_okl_repair_costs_tl_rec.sfwt_flag,
1529: l_okl_repair_costs_tl_rec.repair_type,
1530: l_okl_repair_costs_tl_rec.description,
1531: l_okl_repair_costs_tl_rec.created_by,
1532: l_okl_repair_costs_tl_rec.creation_date,
1533: l_okl_repair_costs_tl_rec.last_updated_by,
1534: l_okl_repair_costs_tl_rec.last_update_date,

Line 1531: l_okl_repair_costs_tl_rec.created_by,

1527: l_okl_repair_costs_tl_rec.source_lang,
1528: l_okl_repair_costs_tl_rec.sfwt_flag,
1529: l_okl_repair_costs_tl_rec.repair_type,
1530: l_okl_repair_costs_tl_rec.description,
1531: l_okl_repair_costs_tl_rec.created_by,
1532: l_okl_repair_costs_tl_rec.creation_date,
1533: l_okl_repair_costs_tl_rec.last_updated_by,
1534: l_okl_repair_costs_tl_rec.last_update_date,
1535: l_okl_repair_costs_tl_rec.last_update_login);

Line 1532: l_okl_repair_costs_tl_rec.creation_date,

1528: l_okl_repair_costs_tl_rec.sfwt_flag,
1529: l_okl_repair_costs_tl_rec.repair_type,
1530: l_okl_repair_costs_tl_rec.description,
1531: l_okl_repair_costs_tl_rec.created_by,
1532: l_okl_repair_costs_tl_rec.creation_date,
1533: l_okl_repair_costs_tl_rec.last_updated_by,
1534: l_okl_repair_costs_tl_rec.last_update_date,
1535: l_okl_repair_costs_tl_rec.last_update_login);
1536: END LOOP;

Line 1533: l_okl_repair_costs_tl_rec.last_updated_by,

1529: l_okl_repair_costs_tl_rec.repair_type,
1530: l_okl_repair_costs_tl_rec.description,
1531: l_okl_repair_costs_tl_rec.created_by,
1532: l_okl_repair_costs_tl_rec.creation_date,
1533: l_okl_repair_costs_tl_rec.last_updated_by,
1534: l_okl_repair_costs_tl_rec.last_update_date,
1535: l_okl_repair_costs_tl_rec.last_update_login);
1536: END LOOP;
1537: -- Set OUT values

Line 1534: l_okl_repair_costs_tl_rec.last_update_date,

1530: l_okl_repair_costs_tl_rec.description,
1531: l_okl_repair_costs_tl_rec.created_by,
1532: l_okl_repair_costs_tl_rec.creation_date,
1533: l_okl_repair_costs_tl_rec.last_updated_by,
1534: l_okl_repair_costs_tl_rec.last_update_date,
1535: l_okl_repair_costs_tl_rec.last_update_login);
1536: END LOOP;
1537: -- Set OUT values
1538: x_okl_repair_costs_tl_rec := l_okl_repair_costs_tl_rec;

Line 1535: l_okl_repair_costs_tl_rec.last_update_login);

1531: l_okl_repair_costs_tl_rec.created_by,
1532: l_okl_repair_costs_tl_rec.creation_date,
1533: l_okl_repair_costs_tl_rec.last_updated_by,
1534: l_okl_repair_costs_tl_rec.last_update_date,
1535: l_okl_repair_costs_tl_rec.last_update_login);
1536: END LOOP;
1537: -- Set OUT values
1538: x_okl_repair_costs_tl_rec := l_okl_repair_costs_tl_rec;
1539: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1538: x_okl_repair_costs_tl_rec := l_okl_repair_costs_tl_rec;

1534: l_okl_repair_costs_tl_rec.last_update_date,
1535: l_okl_repair_costs_tl_rec.last_update_login);
1536: END LOOP;
1537: -- Set OUT values
1538: x_okl_repair_costs_tl_rec := l_okl_repair_costs_tl_rec;
1539: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1540: EXCEPTION
1541: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1542: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1728: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

1724: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1725: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1726: l_rpcv_rec rpcv_rec_type;
1727: l_def_rpcv_rec rpcv_rec_type;
1728: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
1729: lx_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
1730: l_rpc_rec rpc_rec_type;
1731: lx_rpc_rec rpc_rec_type;
1732: -------------------------------

Line 1729: lx_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

1725: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1726: l_rpcv_rec rpcv_rec_type;
1727: l_def_rpcv_rec rpcv_rec_type;
1728: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
1729: lx_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
1730: l_rpc_rec rpc_rec_type;
1731: lx_rpc_rec rpc_rec_type;
1732: -------------------------------
1733: -- FUNCTION fill_who_columns --

Line 1830: migrate(l_def_rpcv_rec, l_okl_repair_costs_tl_rec);

1826: END IF;
1827: --------------------------------------
1828: -- Move VIEW record to "Child" records
1829: --------------------------------------
1830: migrate(l_def_rpcv_rec, l_okl_repair_costs_tl_rec);
1831: migrate(l_def_rpcv_rec, l_rpc_rec);
1832: --------------------------------------------
1833: -- Call the INSERT_ROW for each child record
1834: --------------------------------------------

Line 1840: l_okl_repair_costs_tl_rec,

1836: p_init_msg_list,
1837: x_return_status,
1838: x_msg_count,
1839: x_msg_data,
1840: l_okl_repair_costs_tl_rec,
1841: lx_okl_repair_costs_tl_rec
1842: );
1843: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1841: lx_okl_repair_costs_tl_rec

1837: x_return_status,
1838: x_msg_count,
1839: x_msg_data,
1840: l_okl_repair_costs_tl_rec,
1841: lx_okl_repair_costs_tl_rec
1842: );
1843: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1848: migrate(lx_okl_repair_costs_tl_rec, l_def_rpcv_rec);

1844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1846: RAISE OKC_API.G_EXCEPTION_ERROR;
1847: END IF;
1848: migrate(lx_okl_repair_costs_tl_rec, l_def_rpcv_rec);
1849: insert_row(
1850: p_init_msg_list,
1851: x_return_status,
1852: x_msg_count,

Line 1985: -- lock_row for:OKL_REPAIR_COSTS_TL --

1981: ---------------------------------------------------------------------------
1982: -- PROCEDURE lock_row
1983: ---------------------------------------------------------------------------
1984: --------------------------------------
1985: -- lock_row for:OKL_REPAIR_COSTS_TL --
1986: --------------------------------------
1987: PROCEDURE lock_row(
1988: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1989: x_return_status OUT NOCOPY VARCHAR2,

Line 1992: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS

1988: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1989: x_return_status OUT NOCOPY VARCHAR2,
1990: x_msg_count OUT NOCOPY NUMBER,
1991: x_msg_data OUT NOCOPY VARCHAR2,
1992: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS
1993:
1994: E_Resource_Busy EXCEPTION;
1995: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1996: CURSOR lock_csr (p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS

Line 1996: CURSOR lock_csr (p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS

1992: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS
1993:
1994: E_Resource_Busy EXCEPTION;
1995: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1996: CURSOR lock_csr (p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS
1997: SELECT *
1998: FROM OKL_REPAIR_COSTS_TL
1999: WHERE ID = p_okl_repair_costs_tl_rec.id
2000: FOR UPDATE NOWAIT;

Line 1998: FROM OKL_REPAIR_COSTS_TL

1994: E_Resource_Busy EXCEPTION;
1995: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1996: CURSOR lock_csr (p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS
1997: SELECT *
1998: FROM OKL_REPAIR_COSTS_TL
1999: WHERE ID = p_okl_repair_costs_tl_rec.id
2000: FOR UPDATE NOWAIT;
2001:
2002: l_api_version CONSTANT NUMBER := 1;

Line 1999: WHERE ID = p_okl_repair_costs_tl_rec.id

1995: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1996: CURSOR lock_csr (p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS
1997: SELECT *
1998: FROM OKL_REPAIR_COSTS_TL
1999: WHERE ID = p_okl_repair_costs_tl_rec.id
2000: FOR UPDATE NOWAIT;
2001:
2002: l_api_version CONSTANT NUMBER := 1;
2003: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2019: OPEN lock_csr(p_okl_repair_costs_tl_rec);

2015: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2016: RAISE OKC_API.G_EXCEPTION_ERROR;
2017: END IF;
2018: BEGIN
2019: OPEN lock_csr(p_okl_repair_costs_tl_rec);
2020: FETCH lock_csr INTO l_lock_var;
2021: l_row_notfound := lock_csr%NOTFOUND;
2022: CLOSE lock_csr;
2023: EXCEPTION

Line 2189: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

2185:
2186: l_api_version CONSTANT NUMBER := 1;
2187: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2188: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2189: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2190: l_rpc_rec rpc_rec_type;
2191: BEGIN
2192: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2193: G_PKG_NAME,

Line 2207: migrate(p_rpcv_rec, l_okl_repair_costs_tl_rec);

2203: END IF;
2204: --------------------------------------
2205: -- Move VIEW record to "Child" records
2206: --------------------------------------
2207: migrate(p_rpcv_rec, l_okl_repair_costs_tl_rec);
2208: migrate(p_rpcv_rec, l_rpc_rec);
2209: --------------------------------------------
2210: -- Call the LOCK_ROW for each child record
2211: --------------------------------------------

Line 2217: l_okl_repair_costs_tl_rec

2213: p_init_msg_list,
2214: x_return_status,
2215: x_msg_count,
2216: x_msg_data,
2217: l_okl_repair_costs_tl_rec
2218: );
2219: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2221: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2354: -- update_row for:OKL_REPAIR_COSTS_TL --

2350: ---------------------------------------------------------------------------
2351: -- PROCEDURE update_row
2352: ---------------------------------------------------------------------------
2353: ----------------------------------------
2354: -- update_row for:OKL_REPAIR_COSTS_TL --
2355: ----------------------------------------
2356: PROCEDURE update_row(
2357: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2358: x_return_status OUT NOCOPY VARCHAR2,

Line 2361: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,

2357: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2358: x_return_status OUT NOCOPY VARCHAR2,
2359: x_msg_count OUT NOCOPY NUMBER,
2360: x_msg_data OUT NOCOPY VARCHAR2,
2361: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
2362: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type) IS
2363:
2364: l_api_version CONSTANT NUMBER := 1;
2365: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2362: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type) IS

2358: x_return_status OUT NOCOPY VARCHAR2,
2359: x_msg_count OUT NOCOPY NUMBER,
2360: x_msg_data OUT NOCOPY VARCHAR2,
2361: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
2362: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type) IS
2363:
2364: l_api_version CONSTANT NUMBER := 1;
2365: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2367: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type := p_okl_repair_costs_tl_rec;

2363:
2364: l_api_version CONSTANT NUMBER := 1;
2365: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2367: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type := p_okl_repair_costs_tl_rec;
2368: ldefoklrepaircoststlrec okl_repair_costs_tl_rec_type;
2369: l_row_notfound BOOLEAN := TRUE;
2370: ----------------------------------
2371: -- FUNCTION populate_new_record --

Line 2368: ldefoklrepaircoststlrec okl_repair_costs_tl_rec_type;

2364: l_api_version CONSTANT NUMBER := 1;
2365: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2367: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type := p_okl_repair_costs_tl_rec;
2368: ldefoklrepaircoststlrec okl_repair_costs_tl_rec_type;
2369: l_row_notfound BOOLEAN := TRUE;
2370: ----------------------------------
2371: -- FUNCTION populate_new_record --
2372: ----------------------------------

Line 2374: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,

2370: ----------------------------------
2371: -- FUNCTION populate_new_record --
2372: ----------------------------------
2373: FUNCTION populate_new_record (
2374: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
2375: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
2376: ) RETURN VARCHAR2 IS
2377: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2378: l_row_notfound BOOLEAN := TRUE;

Line 2375: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type

2371: -- FUNCTION populate_new_record --
2372: ----------------------------------
2373: FUNCTION populate_new_record (
2374: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
2375: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
2376: ) RETURN VARCHAR2 IS
2377: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2378: l_row_notfound BOOLEAN := TRUE;
2379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2377: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

2373: FUNCTION populate_new_record (
2374: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
2375: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
2376: ) RETURN VARCHAR2 IS
2377: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2378: l_row_notfound BOOLEAN := TRUE;
2379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2380: BEGIN
2381: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;

Line 2381: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;

2377: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2378: l_row_notfound BOOLEAN := TRUE;
2379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2380: BEGIN
2381: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
2382: -- Get current database values
2383: l_okl_repair_costs_tl_rec := get_rec(p_okl_repair_costs_tl_rec, l_row_notfound);
2384: IF (l_row_notfound) THEN
2385: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2383: l_okl_repair_costs_tl_rec := get_rec(p_okl_repair_costs_tl_rec, l_row_notfound);

2379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2380: BEGIN
2381: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
2382: -- Get current database values
2383: l_okl_repair_costs_tl_rec := get_rec(p_okl_repair_costs_tl_rec, l_row_notfound);
2384: IF (l_row_notfound) THEN
2385: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2386: END IF;
2387: IF (x_okl_repair_costs_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2387: IF (x_okl_repair_costs_tl_rec.id = OKC_API.G_MISS_NUM)

2383: l_okl_repair_costs_tl_rec := get_rec(p_okl_repair_costs_tl_rec, l_row_notfound);
2384: IF (l_row_notfound) THEN
2385: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2386: END IF;
2387: IF (x_okl_repair_costs_tl_rec.id = OKC_API.G_MISS_NUM)
2388: THEN
2389: x_okl_repair_costs_tl_rec.id := l_okl_repair_costs_tl_rec.id;
2390: END IF;
2391: IF (x_okl_repair_costs_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2389: x_okl_repair_costs_tl_rec.id := l_okl_repair_costs_tl_rec.id;

2385: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2386: END IF;
2387: IF (x_okl_repair_costs_tl_rec.id = OKC_API.G_MISS_NUM)
2388: THEN
2389: x_okl_repair_costs_tl_rec.id := l_okl_repair_costs_tl_rec.id;
2390: END IF;
2391: IF (x_okl_repair_costs_tl_rec.language = OKC_API.G_MISS_CHAR)
2392: THEN
2393: x_okl_repair_costs_tl_rec.language := l_okl_repair_costs_tl_rec.language;

Line 2391: IF (x_okl_repair_costs_tl_rec.language = OKC_API.G_MISS_CHAR)

2387: IF (x_okl_repair_costs_tl_rec.id = OKC_API.G_MISS_NUM)
2388: THEN
2389: x_okl_repair_costs_tl_rec.id := l_okl_repair_costs_tl_rec.id;
2390: END IF;
2391: IF (x_okl_repair_costs_tl_rec.language = OKC_API.G_MISS_CHAR)
2392: THEN
2393: x_okl_repair_costs_tl_rec.language := l_okl_repair_costs_tl_rec.language;
2394: END IF;
2395: IF (x_okl_repair_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2393: x_okl_repair_costs_tl_rec.language := l_okl_repair_costs_tl_rec.language;

2389: x_okl_repair_costs_tl_rec.id := l_okl_repair_costs_tl_rec.id;
2390: END IF;
2391: IF (x_okl_repair_costs_tl_rec.language = OKC_API.G_MISS_CHAR)
2392: THEN
2393: x_okl_repair_costs_tl_rec.language := l_okl_repair_costs_tl_rec.language;
2394: END IF;
2395: IF (x_okl_repair_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2396: THEN
2397: x_okl_repair_costs_tl_rec.source_lang := l_okl_repair_costs_tl_rec.source_lang;

Line 2395: IF (x_okl_repair_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2391: IF (x_okl_repair_costs_tl_rec.language = OKC_API.G_MISS_CHAR)
2392: THEN
2393: x_okl_repair_costs_tl_rec.language := l_okl_repair_costs_tl_rec.language;
2394: END IF;
2395: IF (x_okl_repair_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2396: THEN
2397: x_okl_repair_costs_tl_rec.source_lang := l_okl_repair_costs_tl_rec.source_lang;
2398: END IF;
2399: IF (x_okl_repair_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2397: x_okl_repair_costs_tl_rec.source_lang := l_okl_repair_costs_tl_rec.source_lang;

2393: x_okl_repair_costs_tl_rec.language := l_okl_repair_costs_tl_rec.language;
2394: END IF;
2395: IF (x_okl_repair_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2396: THEN
2397: x_okl_repair_costs_tl_rec.source_lang := l_okl_repair_costs_tl_rec.source_lang;
2398: END IF;
2399: IF (x_okl_repair_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2400: THEN
2401: x_okl_repair_costs_tl_rec.sfwt_flag := l_okl_repair_costs_tl_rec.sfwt_flag;

Line 2399: IF (x_okl_repair_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2395: IF (x_okl_repair_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2396: THEN
2397: x_okl_repair_costs_tl_rec.source_lang := l_okl_repair_costs_tl_rec.source_lang;
2398: END IF;
2399: IF (x_okl_repair_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2400: THEN
2401: x_okl_repair_costs_tl_rec.sfwt_flag := l_okl_repair_costs_tl_rec.sfwt_flag;
2402: END IF;
2403: IF (x_okl_repair_costs_tl_rec.repair_type = OKC_API.G_MISS_CHAR)

Line 2401: x_okl_repair_costs_tl_rec.sfwt_flag := l_okl_repair_costs_tl_rec.sfwt_flag;

2397: x_okl_repair_costs_tl_rec.source_lang := l_okl_repair_costs_tl_rec.source_lang;
2398: END IF;
2399: IF (x_okl_repair_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2400: THEN
2401: x_okl_repair_costs_tl_rec.sfwt_flag := l_okl_repair_costs_tl_rec.sfwt_flag;
2402: END IF;
2403: IF (x_okl_repair_costs_tl_rec.repair_type = OKC_API.G_MISS_CHAR)
2404: THEN
2405: x_okl_repair_costs_tl_rec.repair_type := l_okl_repair_costs_tl_rec.repair_type;

Line 2403: IF (x_okl_repair_costs_tl_rec.repair_type = OKC_API.G_MISS_CHAR)

2399: IF (x_okl_repair_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2400: THEN
2401: x_okl_repair_costs_tl_rec.sfwt_flag := l_okl_repair_costs_tl_rec.sfwt_flag;
2402: END IF;
2403: IF (x_okl_repair_costs_tl_rec.repair_type = OKC_API.G_MISS_CHAR)
2404: THEN
2405: x_okl_repair_costs_tl_rec.repair_type := l_okl_repair_costs_tl_rec.repair_type;
2406: END IF;
2407: IF (x_okl_repair_costs_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 2405: x_okl_repair_costs_tl_rec.repair_type := l_okl_repair_costs_tl_rec.repair_type;

2401: x_okl_repair_costs_tl_rec.sfwt_flag := l_okl_repair_costs_tl_rec.sfwt_flag;
2402: END IF;
2403: IF (x_okl_repair_costs_tl_rec.repair_type = OKC_API.G_MISS_CHAR)
2404: THEN
2405: x_okl_repair_costs_tl_rec.repair_type := l_okl_repair_costs_tl_rec.repair_type;
2406: END IF;
2407: IF (x_okl_repair_costs_tl_rec.description = OKC_API.G_MISS_CHAR)
2408: THEN
2409: x_okl_repair_costs_tl_rec.description := l_okl_repair_costs_tl_rec.description;

Line 2407: IF (x_okl_repair_costs_tl_rec.description = OKC_API.G_MISS_CHAR)

2403: IF (x_okl_repair_costs_tl_rec.repair_type = OKC_API.G_MISS_CHAR)
2404: THEN
2405: x_okl_repair_costs_tl_rec.repair_type := l_okl_repair_costs_tl_rec.repair_type;
2406: END IF;
2407: IF (x_okl_repair_costs_tl_rec.description = OKC_API.G_MISS_CHAR)
2408: THEN
2409: x_okl_repair_costs_tl_rec.description := l_okl_repair_costs_tl_rec.description;
2410: END IF;
2411: IF (x_okl_repair_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2409: x_okl_repair_costs_tl_rec.description := l_okl_repair_costs_tl_rec.description;

2405: x_okl_repair_costs_tl_rec.repair_type := l_okl_repair_costs_tl_rec.repair_type;
2406: END IF;
2407: IF (x_okl_repair_costs_tl_rec.description = OKC_API.G_MISS_CHAR)
2408: THEN
2409: x_okl_repair_costs_tl_rec.description := l_okl_repair_costs_tl_rec.description;
2410: END IF;
2411: IF (x_okl_repair_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)
2412: THEN
2413: x_okl_repair_costs_tl_rec.created_by := l_okl_repair_costs_tl_rec.created_by;

Line 2411: IF (x_okl_repair_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)

2407: IF (x_okl_repair_costs_tl_rec.description = OKC_API.G_MISS_CHAR)
2408: THEN
2409: x_okl_repair_costs_tl_rec.description := l_okl_repair_costs_tl_rec.description;
2410: END IF;
2411: IF (x_okl_repair_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)
2412: THEN
2413: x_okl_repair_costs_tl_rec.created_by := l_okl_repair_costs_tl_rec.created_by;
2414: END IF;
2415: IF (x_okl_repair_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2413: x_okl_repair_costs_tl_rec.created_by := l_okl_repair_costs_tl_rec.created_by;

2409: x_okl_repair_costs_tl_rec.description := l_okl_repair_costs_tl_rec.description;
2410: END IF;
2411: IF (x_okl_repair_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)
2412: THEN
2413: x_okl_repair_costs_tl_rec.created_by := l_okl_repair_costs_tl_rec.created_by;
2414: END IF;
2415: IF (x_okl_repair_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2416: THEN
2417: x_okl_repair_costs_tl_rec.creation_date := l_okl_repair_costs_tl_rec.creation_date;

Line 2415: IF (x_okl_repair_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2411: IF (x_okl_repair_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)
2412: THEN
2413: x_okl_repair_costs_tl_rec.created_by := l_okl_repair_costs_tl_rec.created_by;
2414: END IF;
2415: IF (x_okl_repair_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2416: THEN
2417: x_okl_repair_costs_tl_rec.creation_date := l_okl_repair_costs_tl_rec.creation_date;
2418: END IF;
2419: IF (x_okl_repair_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2417: x_okl_repair_costs_tl_rec.creation_date := l_okl_repair_costs_tl_rec.creation_date;

2413: x_okl_repair_costs_tl_rec.created_by := l_okl_repair_costs_tl_rec.created_by;
2414: END IF;
2415: IF (x_okl_repair_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2416: THEN
2417: x_okl_repair_costs_tl_rec.creation_date := l_okl_repair_costs_tl_rec.creation_date;
2418: END IF;
2419: IF (x_okl_repair_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2420: THEN
2421: x_okl_repair_costs_tl_rec.last_updated_by := l_okl_repair_costs_tl_rec.last_updated_by;

Line 2419: IF (x_okl_repair_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2415: IF (x_okl_repair_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2416: THEN
2417: x_okl_repair_costs_tl_rec.creation_date := l_okl_repair_costs_tl_rec.creation_date;
2418: END IF;
2419: IF (x_okl_repair_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2420: THEN
2421: x_okl_repair_costs_tl_rec.last_updated_by := l_okl_repair_costs_tl_rec.last_updated_by;
2422: END IF;
2423: IF (x_okl_repair_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2421: x_okl_repair_costs_tl_rec.last_updated_by := l_okl_repair_costs_tl_rec.last_updated_by;

2417: x_okl_repair_costs_tl_rec.creation_date := l_okl_repair_costs_tl_rec.creation_date;
2418: END IF;
2419: IF (x_okl_repair_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2420: THEN
2421: x_okl_repair_costs_tl_rec.last_updated_by := l_okl_repair_costs_tl_rec.last_updated_by;
2422: END IF;
2423: IF (x_okl_repair_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2424: THEN
2425: x_okl_repair_costs_tl_rec.last_update_date := l_okl_repair_costs_tl_rec.last_update_date;

Line 2423: IF (x_okl_repair_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2419: IF (x_okl_repair_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2420: THEN
2421: x_okl_repair_costs_tl_rec.last_updated_by := l_okl_repair_costs_tl_rec.last_updated_by;
2422: END IF;
2423: IF (x_okl_repair_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2424: THEN
2425: x_okl_repair_costs_tl_rec.last_update_date := l_okl_repair_costs_tl_rec.last_update_date;
2426: END IF;
2427: IF (x_okl_repair_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2425: x_okl_repair_costs_tl_rec.last_update_date := l_okl_repair_costs_tl_rec.last_update_date;

2421: x_okl_repair_costs_tl_rec.last_updated_by := l_okl_repair_costs_tl_rec.last_updated_by;
2422: END IF;
2423: IF (x_okl_repair_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2424: THEN
2425: x_okl_repair_costs_tl_rec.last_update_date := l_okl_repair_costs_tl_rec.last_update_date;
2426: END IF;
2427: IF (x_okl_repair_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2428: THEN
2429: x_okl_repair_costs_tl_rec.last_update_login := l_okl_repair_costs_tl_rec.last_update_login;

Line 2427: IF (x_okl_repair_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2423: IF (x_okl_repair_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2424: THEN
2425: x_okl_repair_costs_tl_rec.last_update_date := l_okl_repair_costs_tl_rec.last_update_date;
2426: END IF;
2427: IF (x_okl_repair_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2428: THEN
2429: x_okl_repair_costs_tl_rec.last_update_login := l_okl_repair_costs_tl_rec.last_update_login;
2430: END IF;
2431: RETURN(l_return_status);

Line 2429: x_okl_repair_costs_tl_rec.last_update_login := l_okl_repair_costs_tl_rec.last_update_login;

2425: x_okl_repair_costs_tl_rec.last_update_date := l_okl_repair_costs_tl_rec.last_update_date;
2426: END IF;
2427: IF (x_okl_repair_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2428: THEN
2429: x_okl_repair_costs_tl_rec.last_update_login := l_okl_repair_costs_tl_rec.last_update_login;
2430: END IF;
2431: RETURN(l_return_status);
2432: END populate_new_record;
2433: --------------------------------------------

Line 2434: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --

2430: END IF;
2431: RETURN(l_return_status);
2432: END populate_new_record;
2433: --------------------------------------------
2434: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
2435: --------------------------------------------
2436: FUNCTION Set_Attributes (
2437: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
2438: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type

Line 2437: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,

2433: --------------------------------------------
2434: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
2435: --------------------------------------------
2436: FUNCTION Set_Attributes (
2437: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
2438: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
2439: ) RETURN VARCHAR2 IS
2440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2441: BEGIN

Line 2438: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type

2434: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
2435: --------------------------------------------
2436: FUNCTION Set_Attributes (
2437: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
2438: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
2439: ) RETURN VARCHAR2 IS
2440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2441: BEGIN
2442: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;

Line 2442: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;

2438: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
2439: ) RETURN VARCHAR2 IS
2440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2441: BEGIN
2442: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
2443: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');
2444: x_okl_repair_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
2445: RETURN(l_return_status);
2446: END Set_Attributes;

Line 2443: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');

2439: ) RETURN VARCHAR2 IS
2440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2441: BEGIN
2442: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
2443: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');
2444: x_okl_repair_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
2445: RETURN(l_return_status);
2446: END Set_Attributes;
2447: BEGIN

Line 2444: x_okl_repair_costs_tl_rec.SOURCE_LANG := USERENV('LANG');

2440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2441: BEGIN
2442: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
2443: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');
2444: x_okl_repair_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
2445: RETURN(l_return_status);
2446: END Set_Attributes;
2447: BEGIN
2448: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2459: p_okl_repair_costs_tl_rec, -- IN

2455: RAISE OKC_API.G_EXCEPTION_ERROR;
2456: END IF;
2457: --- Setting item attributes
2458: l_return_status := Set_Attributes(
2459: p_okl_repair_costs_tl_rec, -- IN
2460: l_okl_repair_costs_tl_rec); -- OUT
2461: --- If any errors happen abort API
2462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2460: l_okl_repair_costs_tl_rec); -- OUT

2456: END IF;
2457: --- Setting item attributes
2458: l_return_status := Set_Attributes(
2459: p_okl_repair_costs_tl_rec, -- IN
2460: l_okl_repair_costs_tl_rec); -- OUT
2461: --- If any errors happen abort API
2462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2467: l_return_status := populate_new_record(l_okl_repair_costs_tl_rec, ldefoklrepaircoststlrec);

2463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2465: RAISE OKC_API.G_EXCEPTION_ERROR;
2466: END IF;
2467: l_return_status := populate_new_record(l_okl_repair_costs_tl_rec, ldefoklrepaircoststlrec);
2468: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2471: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2473: UPDATE OKL_REPAIR_COSTS_TL

2469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2471: RAISE OKC_API.G_EXCEPTION_ERROR;
2472: END IF;
2473: UPDATE OKL_REPAIR_COSTS_TL
2474: SET REPAIR_TYPE = ldefoklrepaircoststlrec.repair_type,
2475: DESCRIPTION = ldefoklrepaircoststlrec.description,
2476: SOURCE_LANG = ldefoklrepaircoststlrec.source_lang, --Fix fro bug 3637102
2477: CREATED_BY = ldefoklrepaircoststlrec.created_by,

Line 2486: UPDATE OKL_REPAIR_COSTS_TL

2482: WHERE ID = ldefoklrepaircoststlrec.id
2483: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
2484: --AND SOURCE_LANG = USERENV('LANG');
2485:
2486: UPDATE OKL_REPAIR_COSTS_TL
2487: SET SFWT_FLAG = 'Y'
2488: WHERE ID = ldefoklrepaircoststlrec.id
2489: AND SOURCE_LANG <> USERENV('LANG');
2490:

Line 2491: x_okl_repair_costs_tl_rec := ldefoklrepaircoststlrec;

2487: SET SFWT_FLAG = 'Y'
2488: WHERE ID = ldefoklrepaircoststlrec.id
2489: AND SOURCE_LANG <> USERENV('LANG');
2490:
2491: x_okl_repair_costs_tl_rec := ldefoklrepaircoststlrec;
2492: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2493: EXCEPTION
2494: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2495: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2754: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

2750: l_rpcv_rec rpcv_rec_type := p_rpcv_rec;
2751: l_def_rpcv_rec rpcv_rec_type;
2752: l_rpc_rec rpc_rec_type;
2753: lx_rpc_rec rpc_rec_type;
2754: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2755: lx_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2756: -------------------------------
2757: -- FUNCTION fill_who_columns --
2758: -------------------------------

Line 2755: lx_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

2751: l_def_rpcv_rec rpcv_rec_type;
2752: l_rpc_rec rpc_rec_type;
2753: lx_rpc_rec rpc_rec_type;
2754: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2755: lx_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
2756: -------------------------------
2757: -- FUNCTION fill_who_columns --
2758: -------------------------------
2759: FUNCTION fill_who_columns (

Line 2929: migrate(l_def_rpcv_rec, l_okl_repair_costs_tl_rec);

2925: --------------------------------------
2926: -- Move VIEW record to "Child" records
2927: --------------------------------------
2928: migrate(l_def_rpcv_rec, l_rpc_rec);
2929: migrate(l_def_rpcv_rec, l_okl_repair_costs_tl_rec);
2930: --------------------------------------------
2931: -- Call the UPDATE_ROW for each child record
2932: --------------------------------------------
2933: update_row(

Line 2952: l_okl_repair_costs_tl_rec,

2948: p_init_msg_list,
2949: x_return_status,
2950: x_msg_count,
2951: x_msg_data,
2952: l_okl_repair_costs_tl_rec,
2953: lx_okl_repair_costs_tl_rec
2954: );
2955: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2956: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2953: lx_okl_repair_costs_tl_rec

2949: x_return_status,
2950: x_msg_count,
2951: x_msg_data,
2952: l_okl_repair_costs_tl_rec,
2953: lx_okl_repair_costs_tl_rec
2954: );
2955: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2956: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2957: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2960: migrate(lx_okl_repair_costs_tl_rec, l_def_rpcv_rec);

2956: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2957: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2958: RAISE OKC_API.G_EXCEPTION_ERROR;
2959: END IF;
2960: migrate(lx_okl_repair_costs_tl_rec, l_def_rpcv_rec);
2961: x_rpcv_rec := l_def_rpcv_rec;
2962: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2963: EXCEPTION
2964: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3082: -- delete_row for:OKL_REPAIR_COSTS_TL --

3078: ---------------------------------------------------------------------------
3079: -- PROCEDURE delete_row
3080: ---------------------------------------------------------------------------
3081: ----------------------------------------
3082: -- delete_row for:OKL_REPAIR_COSTS_TL --
3083: ----------------------------------------
3084: PROCEDURE delete_row(
3085: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3086: x_return_status OUT NOCOPY VARCHAR2,

Line 3089: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS

3085: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3086: x_return_status OUT NOCOPY VARCHAR2,
3087: x_msg_count OUT NOCOPY NUMBER,
3088: x_msg_data OUT NOCOPY VARCHAR2,
3089: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type) IS
3090:
3091: l_api_version CONSTANT NUMBER := 1;
3092: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3093: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3094: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type:= p_okl_repair_costs_tl_rec;

3090:
3091: l_api_version CONSTANT NUMBER := 1;
3092: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3093: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3094: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type:= p_okl_repair_costs_tl_rec;
3095: l_row_notfound BOOLEAN := TRUE;
3096: --------------------------------------------
3097: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
3098: --------------------------------------------

Line 3097: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --

3093: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3094: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type:= p_okl_repair_costs_tl_rec;
3095: l_row_notfound BOOLEAN := TRUE;
3096: --------------------------------------------
3097: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
3098: --------------------------------------------
3099: FUNCTION Set_Attributes (
3100: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
3101: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type

Line 3100: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,

3096: --------------------------------------------
3097: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
3098: --------------------------------------------
3099: FUNCTION Set_Attributes (
3100: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
3101: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
3102: ) RETURN VARCHAR2 IS
3103: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3104: BEGIN

Line 3101: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type

3097: -- Set_Attributes for:OKL_REPAIR_COSTS_TL --
3098: --------------------------------------------
3099: FUNCTION Set_Attributes (
3100: p_okl_repair_costs_tl_rec IN okl_repair_costs_tl_rec_type,
3101: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
3102: ) RETURN VARCHAR2 IS
3103: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3104: BEGIN
3105: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;

Line 3105: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;

3101: x_okl_repair_costs_tl_rec OUT NOCOPY okl_repair_costs_tl_rec_type
3102: ) RETURN VARCHAR2 IS
3103: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3104: BEGIN
3105: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
3106: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');
3107: RETURN(l_return_status);
3108: END Set_Attributes;
3109: BEGIN

Line 3106: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');

3102: ) RETURN VARCHAR2 IS
3103: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3104: BEGIN
3105: x_okl_repair_costs_tl_rec := p_okl_repair_costs_tl_rec;
3106: x_okl_repair_costs_tl_rec.LANGUAGE := USERENV('LANG');
3107: RETURN(l_return_status);
3108: END Set_Attributes;
3109: BEGIN
3110: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3121: p_okl_repair_costs_tl_rec, -- IN

3117: RAISE OKC_API.G_EXCEPTION_ERROR;
3118: END IF;
3119: --- Setting item attributes
3120: l_return_status := Set_Attributes(
3121: p_okl_repair_costs_tl_rec, -- IN
3122: l_okl_repair_costs_tl_rec); -- OUT
3123: --- If any errors happen abort API
3124: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3122: l_okl_repair_costs_tl_rec); -- OUT

3118: END IF;
3119: --- Setting item attributes
3120: l_return_status := Set_Attributes(
3121: p_okl_repair_costs_tl_rec, -- IN
3122: l_okl_repair_costs_tl_rec); -- OUT
3123: --- If any errors happen abort API
3124: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3126: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3129: DELETE FROM OKL_REPAIR_COSTS_TL

3125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3126: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3127: RAISE OKC_API.G_EXCEPTION_ERROR;
3128: END IF;
3129: DELETE FROM OKL_REPAIR_COSTS_TL
3130: WHERE ID = l_okl_repair_costs_tl_rec.id;
3131:
3132: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3133: EXCEPTION

Line 3130: WHERE ID = l_okl_repair_costs_tl_rec.id;

3126: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3127: RAISE OKC_API.G_EXCEPTION_ERROR;
3128: END IF;
3129: DELETE FROM OKL_REPAIR_COSTS_TL
3130: WHERE ID = l_okl_repair_costs_tl_rec.id;
3131:
3132: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3133: EXCEPTION
3134: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3242: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;

3238: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3239: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3240: l_rpcv_rec rpcv_rec_type := p_rpcv_rec;
3241: l_rpc_rec rpc_rec_type;
3242: l_okl_repair_costs_tl_rec okl_repair_costs_tl_rec_type;
3243: BEGIN
3244: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3245: G_PKG_NAME,
3246: p_init_msg_list,

Line 3260: migrate(l_rpcv_rec, l_okl_repair_costs_tl_rec);

3256: --------------------------------------
3257: -- Move VIEW record to "Child" records
3258: --------------------------------------
3259: migrate(l_rpcv_rec, l_rpc_rec);
3260: migrate(l_rpcv_rec, l_okl_repair_costs_tl_rec);
3261: --------------------------------------------
3262: -- Call the DELETE_ROW for each child record
3263: --------------------------------------------
3264: delete_row(

Line 3281: l_okl_repair_costs_tl_rec

3277: p_init_msg_list,
3278: x_return_status,
3279: x_msg_count,
3280: x_msg_data,
3281: l_okl_repair_costs_tl_rec
3282: );
3283: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3284: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3285: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN