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_RFC_PVT dependencies on OKL_REMARKTNG_COSTS_TL

Line 712: DELETE FROM OKL_REMARKTNG_COSTS_TL T

708: -- PROCEDURE add_language
709: ---------------------------------------------------------------------------
710: PROCEDURE add_language IS
711: BEGIN
712: DELETE FROM OKL_REMARKTNG_COSTS_TL T
713: WHERE NOT EXISTS (
714: SELECT NULL
715: FROM OKL_RMKTNG_COSTS_ALL_B B --fixed bug 3321017 by kmotepal
716: WHERE B.ID = T.ID

Line 719: UPDATE OKL_REMARKTNG_COSTS_TL T SET (

715: FROM OKL_RMKTNG_COSTS_ALL_B B --fixed bug 3321017 by kmotepal
716: WHERE B.ID = T.ID
717: );
718:
719: UPDATE OKL_REMARKTNG_COSTS_TL T SET (
720: COMMENTS) = (SELECT
721: B.COMMENTS
722: FROM OKL_REMARKTNG_COSTS_TL B
723: WHERE B.ID = T.ID

Line 722: FROM OKL_REMARKTNG_COSTS_TL B

718:
719: UPDATE OKL_REMARKTNG_COSTS_TL T SET (
720: COMMENTS) = (SELECT
721: B.COMMENTS
722: FROM OKL_REMARKTNG_COSTS_TL B
723: WHERE B.ID = T.ID
724: AND B.LANGUAGE = T.SOURCE_LANG)
725: WHERE (
726: T.ID,

Line 731: FROM OKL_REMARKTNG_COSTS_TL SUBB, OKL_REMARKTNG_COSTS_TL SUBT

727: T.LANGUAGE)
728: IN (SELECT
729: SUBT.ID,
730: SUBT.LANGUAGE
731: FROM OKL_REMARKTNG_COSTS_TL SUBB, OKL_REMARKTNG_COSTS_TL SUBT
732: WHERE SUBB.ID = SUBT.ID
733: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
734: AND (SUBB.COMMENTS <> SUBT.COMMENTS
735: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)

Line 739: INSERT INTO OKL_REMARKTNG_COSTS_TL (

735: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
736: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
737: ));
738:
739: INSERT INTO OKL_REMARKTNG_COSTS_TL (
740: ID,
741: LANGUAGE,
742: SOURCE_LANG,
743: SFWT_FLAG,

Line 761: FROM OKL_REMARKTNG_COSTS_TL B, FND_LANGUAGES L

757: B.CREATION_DATE,
758: B.LAST_UPDATED_BY,
759: B.LAST_UPDATE_DATE,
760: B.LAST_UPDATE_LOGIN
761: FROM OKL_REMARKTNG_COSTS_TL B, FND_LANGUAGES L
762: WHERE L.INSTALLED_FLAG IN ('I', 'B')
763: AND B.LANGUAGE = USERENV('LANG')
764: AND NOT EXISTS(
765: SELECT NULL

Line 766: FROM OKL_REMARKTNG_COSTS_TL T

762: WHERE L.INSTALLED_FLAG IN ('I', 'B')
763: AND B.LANGUAGE = USERENV('LANG')
764: AND NOT EXISTS(
765: SELECT NULL
766: FROM OKL_REMARKTNG_COSTS_TL T
767: WHERE T.ID = B.ID
768: AND T.LANGUAGE = L.LANGUAGE_CODE
769: );
770:

Line 890: -- FUNCTION get_rec for: OKL_REMARKTNG_COSTS_TL

886: BEGIN
887: RETURN(get_rec(p_rfc_rec, l_row_notfound));
888: END get_rec;
889: ---------------------------------------------------------------------------
890: -- FUNCTION get_rec for: OKL_REMARKTNG_COSTS_TL
891: ---------------------------------------------------------------------------
892: FUNCTION get_rec (
893: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
894: x_no_data_found OUT NOCOPY BOOLEAN

Line 893: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,

889: ---------------------------------------------------------------------------
890: -- FUNCTION get_rec for: OKL_REMARKTNG_COSTS_TL
891: ---------------------------------------------------------------------------
892: FUNCTION get_rec (
893: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
894: x_no_data_found OUT NOCOPY BOOLEAN
895: ) RETURN OklRemarktngCostsTlRecType IS
896: CURSOR okl_remarktng_costs_tl_pk_csr (p_id IN NUMBER,
897: p_language IN VARCHAR2) IS

Line 896: CURSOR okl_remarktng_costs_tl_pk_csr (p_id IN NUMBER,

892: FUNCTION get_rec (
893: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
894: x_no_data_found OUT NOCOPY BOOLEAN
895: ) RETURN OklRemarktngCostsTlRecType IS
896: CURSOR okl_remarktng_costs_tl_pk_csr (p_id IN NUMBER,
897: p_language IN VARCHAR2) IS
898: SELECT
899: ID,
900: LANGUAGE,

Line 909: FROM Okl_Remarktng_Costs_Tl

905: CREATION_DATE,
906: LAST_UPDATED_BY,
907: LAST_UPDATE_DATE,
908: LAST_UPDATE_LOGIN
909: FROM Okl_Remarktng_Costs_Tl
910: WHERE okl_remarktng_costs_tl.id = p_id
911: AND okl_remarktng_costs_tl.language = p_language;
912: l_okl_remarktng_costs_tl_pk okl_remarktng_costs_tl_pk_csr%ROWTYPE;
913: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

Line 910: WHERE okl_remarktng_costs_tl.id = p_id

906: LAST_UPDATED_BY,
907: LAST_UPDATE_DATE,
908: LAST_UPDATE_LOGIN
909: FROM Okl_Remarktng_Costs_Tl
910: WHERE okl_remarktng_costs_tl.id = p_id
911: AND okl_remarktng_costs_tl.language = p_language;
912: l_okl_remarktng_costs_tl_pk okl_remarktng_costs_tl_pk_csr%ROWTYPE;
913: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
914: BEGIN

Line 911: AND okl_remarktng_costs_tl.language = p_language;

907: LAST_UPDATE_DATE,
908: LAST_UPDATE_LOGIN
909: FROM Okl_Remarktng_Costs_Tl
910: WHERE okl_remarktng_costs_tl.id = p_id
911: AND okl_remarktng_costs_tl.language = p_language;
912: l_okl_remarktng_costs_tl_pk okl_remarktng_costs_tl_pk_csr%ROWTYPE;
913: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
914: BEGIN
915: x_no_data_found := TRUE;

Line 912: l_okl_remarktng_costs_tl_pk okl_remarktng_costs_tl_pk_csr%ROWTYPE;

908: LAST_UPDATE_LOGIN
909: FROM Okl_Remarktng_Costs_Tl
910: WHERE okl_remarktng_costs_tl.id = p_id
911: AND okl_remarktng_costs_tl.language = p_language;
912: l_okl_remarktng_costs_tl_pk okl_remarktng_costs_tl_pk_csr%ROWTYPE;
913: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
914: BEGIN
915: x_no_data_found := TRUE;
916: -- Get current database values

Line 913: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

909: FROM Okl_Remarktng_Costs_Tl
910: WHERE okl_remarktng_costs_tl.id = p_id
911: AND okl_remarktng_costs_tl.language = p_language;
912: l_okl_remarktng_costs_tl_pk okl_remarktng_costs_tl_pk_csr%ROWTYPE;
913: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
914: BEGIN
915: x_no_data_found := TRUE;
916: -- Get current database values
917: OPEN okl_remarktng_costs_tl_pk_csr (p_okl_remarktng_costs_tl_rec.id,

Line 917: OPEN okl_remarktng_costs_tl_pk_csr (p_okl_remarktng_costs_tl_rec.id,

913: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
914: BEGIN
915: x_no_data_found := TRUE;
916: -- Get current database values
917: OPEN okl_remarktng_costs_tl_pk_csr (p_okl_remarktng_costs_tl_rec.id,
918: p_okl_remarktng_costs_tl_rec.language);
919: FETCH okl_remarktng_costs_tl_pk_csr INTO
920: l_okl_remarktng_costs_tl_rec.ID,
921: l_okl_remarktng_costs_tl_rec.LANGUAGE,

Line 918: p_okl_remarktng_costs_tl_rec.language);

914: BEGIN
915: x_no_data_found := TRUE;
916: -- Get current database values
917: OPEN okl_remarktng_costs_tl_pk_csr (p_okl_remarktng_costs_tl_rec.id,
918: p_okl_remarktng_costs_tl_rec.language);
919: FETCH okl_remarktng_costs_tl_pk_csr INTO
920: l_okl_remarktng_costs_tl_rec.ID,
921: l_okl_remarktng_costs_tl_rec.LANGUAGE,
922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,

Line 919: FETCH okl_remarktng_costs_tl_pk_csr INTO

915: x_no_data_found := TRUE;
916: -- Get current database values
917: OPEN okl_remarktng_costs_tl_pk_csr (p_okl_remarktng_costs_tl_rec.id,
918: p_okl_remarktng_costs_tl_rec.language);
919: FETCH okl_remarktng_costs_tl_pk_csr INTO
920: l_okl_remarktng_costs_tl_rec.ID,
921: l_okl_remarktng_costs_tl_rec.LANGUAGE,
922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,
923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,

Line 920: l_okl_remarktng_costs_tl_rec.ID,

916: -- Get current database values
917: OPEN okl_remarktng_costs_tl_pk_csr (p_okl_remarktng_costs_tl_rec.id,
918: p_okl_remarktng_costs_tl_rec.language);
919: FETCH okl_remarktng_costs_tl_pk_csr INTO
920: l_okl_remarktng_costs_tl_rec.ID,
921: l_okl_remarktng_costs_tl_rec.LANGUAGE,
922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,
923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,
924: l_okl_remarktng_costs_tl_rec.COMMENTS,

Line 921: l_okl_remarktng_costs_tl_rec.LANGUAGE,

917: OPEN okl_remarktng_costs_tl_pk_csr (p_okl_remarktng_costs_tl_rec.id,
918: p_okl_remarktng_costs_tl_rec.language);
919: FETCH okl_remarktng_costs_tl_pk_csr INTO
920: l_okl_remarktng_costs_tl_rec.ID,
921: l_okl_remarktng_costs_tl_rec.LANGUAGE,
922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,
923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,
924: l_okl_remarktng_costs_tl_rec.COMMENTS,
925: l_okl_remarktng_costs_tl_rec.CREATED_BY,

Line 922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,

918: p_okl_remarktng_costs_tl_rec.language);
919: FETCH okl_remarktng_costs_tl_pk_csr INTO
920: l_okl_remarktng_costs_tl_rec.ID,
921: l_okl_remarktng_costs_tl_rec.LANGUAGE,
922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,
923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,
924: l_okl_remarktng_costs_tl_rec.COMMENTS,
925: l_okl_remarktng_costs_tl_rec.CREATED_BY,
926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,

Line 923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,

919: FETCH okl_remarktng_costs_tl_pk_csr INTO
920: l_okl_remarktng_costs_tl_rec.ID,
921: l_okl_remarktng_costs_tl_rec.LANGUAGE,
922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,
923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,
924: l_okl_remarktng_costs_tl_rec.COMMENTS,
925: l_okl_remarktng_costs_tl_rec.CREATED_BY,
926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,
927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,

Line 924: l_okl_remarktng_costs_tl_rec.COMMENTS,

920: l_okl_remarktng_costs_tl_rec.ID,
921: l_okl_remarktng_costs_tl_rec.LANGUAGE,
922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,
923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,
924: l_okl_remarktng_costs_tl_rec.COMMENTS,
925: l_okl_remarktng_costs_tl_rec.CREATED_BY,
926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,
927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,
928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,

Line 925: l_okl_remarktng_costs_tl_rec.CREATED_BY,

921: l_okl_remarktng_costs_tl_rec.LANGUAGE,
922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,
923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,
924: l_okl_remarktng_costs_tl_rec.COMMENTS,
925: l_okl_remarktng_costs_tl_rec.CREATED_BY,
926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,
927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,
928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,
929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;

Line 926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,

922: l_okl_remarktng_costs_tl_rec.SOURCE_LANG,
923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,
924: l_okl_remarktng_costs_tl_rec.COMMENTS,
925: l_okl_remarktng_costs_tl_rec.CREATED_BY,
926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,
927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,
928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,
929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;
930: x_no_data_found := okl_remarktng_costs_tl_pk_csr%NOTFOUND;

Line 927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,

923: l_okl_remarktng_costs_tl_rec.SFWT_FLAG,
924: l_okl_remarktng_costs_tl_rec.COMMENTS,
925: l_okl_remarktng_costs_tl_rec.CREATED_BY,
926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,
927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,
928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,
929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;
930: x_no_data_found := okl_remarktng_costs_tl_pk_csr%NOTFOUND;
931: CLOSE okl_remarktng_costs_tl_pk_csr;

Line 928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,

924: l_okl_remarktng_costs_tl_rec.COMMENTS,
925: l_okl_remarktng_costs_tl_rec.CREATED_BY,
926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,
927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,
928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,
929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;
930: x_no_data_found := okl_remarktng_costs_tl_pk_csr%NOTFOUND;
931: CLOSE okl_remarktng_costs_tl_pk_csr;
932: RETURN(l_okl_remarktng_costs_tl_rec);

Line 929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;

925: l_okl_remarktng_costs_tl_rec.CREATED_BY,
926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,
927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,
928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,
929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;
930: x_no_data_found := okl_remarktng_costs_tl_pk_csr%NOTFOUND;
931: CLOSE okl_remarktng_costs_tl_pk_csr;
932: RETURN(l_okl_remarktng_costs_tl_rec);
933: END get_rec;

Line 930: x_no_data_found := okl_remarktng_costs_tl_pk_csr%NOTFOUND;

926: l_okl_remarktng_costs_tl_rec.CREATION_DATE,
927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,
928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,
929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;
930: x_no_data_found := okl_remarktng_costs_tl_pk_csr%NOTFOUND;
931: CLOSE okl_remarktng_costs_tl_pk_csr;
932: RETURN(l_okl_remarktng_costs_tl_rec);
933: END get_rec;
934:

Line 931: CLOSE okl_remarktng_costs_tl_pk_csr;

927: l_okl_remarktng_costs_tl_rec.LAST_UPDATED_BY,
928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,
929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;
930: x_no_data_found := okl_remarktng_costs_tl_pk_csr%NOTFOUND;
931: CLOSE okl_remarktng_costs_tl_pk_csr;
932: RETURN(l_okl_remarktng_costs_tl_rec);
933: END get_rec;
934:
935: FUNCTION get_rec (

Line 932: RETURN(l_okl_remarktng_costs_tl_rec);

928: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_DATE,
929: l_okl_remarktng_costs_tl_rec.LAST_UPDATE_LOGIN;
930: x_no_data_found := okl_remarktng_costs_tl_pk_csr%NOTFOUND;
931: CLOSE okl_remarktng_costs_tl_pk_csr;
932: RETURN(l_okl_remarktng_costs_tl_rec);
933: END get_rec;
934:
935: FUNCTION get_rec (
936: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType

Line 936: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType

932: RETURN(l_okl_remarktng_costs_tl_rec);
933: END get_rec;
934:
935: FUNCTION get_rec (
936: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType
937: ) RETURN OklRemarktngCostsTlRecType IS
938: l_row_notfound BOOLEAN := TRUE;
939: BEGIN
940: RETURN(get_rec(p_okl_remarktng_costs_tl_rec, l_row_notfound));

Line 940: RETURN(get_rec(p_okl_remarktng_costs_tl_rec, l_row_notfound));

936: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType
937: ) RETURN OklRemarktngCostsTlRecType IS
938: l_row_notfound BOOLEAN := TRUE;
939: BEGIN
940: RETURN(get_rec(p_okl_remarktng_costs_tl_rec, l_row_notfound));
941: END get_rec;
942: ---------------------------------------------------------------------------
943: -- FUNCTION get_rec for: OKL_REMARKTNG_COSTS_V
944: ---------------------------------------------------------------------------

Line 1525: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

1521: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1522: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1523: l_rfcv_rec rfcv_rec_type := p_rfcv_rec;
1524: l_rfc_rec rfc_rec_type;
1525: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
1526: BEGIN
1527: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1528: G_PKG_NAME,
1529: p_init_msg_list,

Line 1848: -- insert_row for:OKL_REMARKTNG_COSTS_TL --

1844: '_PVT'
1845: );
1846: END insert_row;
1847: -------------------------------------------
1848: -- insert_row for:OKL_REMARKTNG_COSTS_TL --
1849: -------------------------------------------
1850: PROCEDURE insert_row(
1851: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1852: x_return_status OUT NOCOPY VARCHAR2,

Line 1855: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,

1851: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1852: x_return_status OUT NOCOPY VARCHAR2,
1853: x_msg_count OUT NOCOPY NUMBER,
1854: x_msg_data OUT NOCOPY VARCHAR2,
1855: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
1856: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType) IS
1857:
1858: l_api_version CONSTANT NUMBER := 1;
1859: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1856: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType) IS

1852: x_return_status OUT NOCOPY VARCHAR2,
1853: x_msg_count OUT NOCOPY NUMBER,
1854: x_msg_data OUT NOCOPY VARCHAR2,
1855: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
1856: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType) IS
1857:
1858: l_api_version CONSTANT NUMBER := 1;
1859: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1860: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1861: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType := p_okl_remarktng_costs_tl_rec;

1857:
1858: l_api_version CONSTANT NUMBER := 1;
1859: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1860: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1861: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType := p_okl_remarktng_costs_tl_rec;
1862: ldefoklremarktngcoststlrec OklRemarktngCostsTlRecType;
1863: CURSOR get_languages IS
1864: SELECT *
1865: FROM FND_LANGUAGES

Line 1868: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --

1864: SELECT *
1865: FROM FND_LANGUAGES
1866: WHERE INSTALLED_FLAG IN ('I', 'B');
1867: -----------------------------------------------
1868: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
1869: -----------------------------------------------
1870: FUNCTION Set_Attributes (
1871: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
1872: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType

Line 1871: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,

1867: -----------------------------------------------
1868: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
1869: -----------------------------------------------
1870: FUNCTION Set_Attributes (
1871: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
1872: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
1873: ) RETURN VARCHAR2 IS
1874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1875: BEGIN

Line 1872: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType

1868: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
1869: -----------------------------------------------
1870: FUNCTION Set_Attributes (
1871: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
1872: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
1873: ) RETURN VARCHAR2 IS
1874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1875: BEGIN
1876: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;

Line 1876: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;

1872: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
1873: ) RETURN VARCHAR2 IS
1874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1875: BEGIN
1876: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
1877: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');
1878: x_okl_remarktng_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
1879: RETURN(l_return_status);
1880: END Set_Attributes;

Line 1877: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');

1873: ) RETURN VARCHAR2 IS
1874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1875: BEGIN
1876: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
1877: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');
1878: x_okl_remarktng_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
1879: RETURN(l_return_status);
1880: END Set_Attributes;
1881: BEGIN

Line 1878: x_okl_remarktng_costs_tl_rec.SOURCE_LANG := USERENV('LANG');

1874: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1875: BEGIN
1876: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
1877: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');
1878: x_okl_remarktng_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
1879: RETURN(l_return_status);
1880: END Set_Attributes;
1881: BEGIN
1882: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1893: p_okl_remarktng_costs_tl_rec, -- IN

1889: RAISE OKC_API.G_EXCEPTION_ERROR;
1890: END IF;
1891: --- Setting item attributes
1892: l_return_status := Set_Attributes(
1893: p_okl_remarktng_costs_tl_rec, -- IN
1894: l_okl_remarktng_costs_tl_rec); -- OUT
1895: --- If any errors happen abort API
1896: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1894: l_okl_remarktng_costs_tl_rec); -- OUT

1890: END IF;
1891: --- Setting item attributes
1892: l_return_status := Set_Attributes(
1893: p_okl_remarktng_costs_tl_rec, -- IN
1894: l_okl_remarktng_costs_tl_rec); -- OUT
1895: --- If any errors happen abort API
1896: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1902: l_okl_remarktng_costs_tl_rec.language := l_lang_rec.language_code;

1898: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1899: RAISE OKC_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: FOR l_lang_rec IN get_languages LOOP
1902: l_okl_remarktng_costs_tl_rec.language := l_lang_rec.language_code;
1903: INSERT INTO OKL_REMARKTNG_COSTS_TL(
1904: id,
1905: language,
1906: source_lang,

Line 1903: INSERT INTO OKL_REMARKTNG_COSTS_TL(

1899: RAISE OKC_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: FOR l_lang_rec IN get_languages LOOP
1902: l_okl_remarktng_costs_tl_rec.language := l_lang_rec.language_code;
1903: INSERT INTO OKL_REMARKTNG_COSTS_TL(
1904: id,
1905: language,
1906: source_lang,
1907: sfwt_flag,

Line 1915: l_okl_remarktng_costs_tl_rec.id,

1911: last_updated_by,
1912: last_update_date,
1913: last_update_login)
1914: VALUES (
1915: l_okl_remarktng_costs_tl_rec.id,
1916: l_okl_remarktng_costs_tl_rec.language,
1917: l_okl_remarktng_costs_tl_rec.source_lang,
1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,
1919: l_okl_remarktng_costs_tl_rec.comments,

Line 1916: l_okl_remarktng_costs_tl_rec.language,

1912: last_update_date,
1913: last_update_login)
1914: VALUES (
1915: l_okl_remarktng_costs_tl_rec.id,
1916: l_okl_remarktng_costs_tl_rec.language,
1917: l_okl_remarktng_costs_tl_rec.source_lang,
1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,
1919: l_okl_remarktng_costs_tl_rec.comments,
1920: l_okl_remarktng_costs_tl_rec.created_by,

Line 1917: l_okl_remarktng_costs_tl_rec.source_lang,

1913: last_update_login)
1914: VALUES (
1915: l_okl_remarktng_costs_tl_rec.id,
1916: l_okl_remarktng_costs_tl_rec.language,
1917: l_okl_remarktng_costs_tl_rec.source_lang,
1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,
1919: l_okl_remarktng_costs_tl_rec.comments,
1920: l_okl_remarktng_costs_tl_rec.created_by,
1921: l_okl_remarktng_costs_tl_rec.creation_date,

Line 1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,

1914: VALUES (
1915: l_okl_remarktng_costs_tl_rec.id,
1916: l_okl_remarktng_costs_tl_rec.language,
1917: l_okl_remarktng_costs_tl_rec.source_lang,
1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,
1919: l_okl_remarktng_costs_tl_rec.comments,
1920: l_okl_remarktng_costs_tl_rec.created_by,
1921: l_okl_remarktng_costs_tl_rec.creation_date,
1922: l_okl_remarktng_costs_tl_rec.last_updated_by,

Line 1919: l_okl_remarktng_costs_tl_rec.comments,

1915: l_okl_remarktng_costs_tl_rec.id,
1916: l_okl_remarktng_costs_tl_rec.language,
1917: l_okl_remarktng_costs_tl_rec.source_lang,
1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,
1919: l_okl_remarktng_costs_tl_rec.comments,
1920: l_okl_remarktng_costs_tl_rec.created_by,
1921: l_okl_remarktng_costs_tl_rec.creation_date,
1922: l_okl_remarktng_costs_tl_rec.last_updated_by,
1923: l_okl_remarktng_costs_tl_rec.last_update_date,

Line 1920: l_okl_remarktng_costs_tl_rec.created_by,

1916: l_okl_remarktng_costs_tl_rec.language,
1917: l_okl_remarktng_costs_tl_rec.source_lang,
1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,
1919: l_okl_remarktng_costs_tl_rec.comments,
1920: l_okl_remarktng_costs_tl_rec.created_by,
1921: l_okl_remarktng_costs_tl_rec.creation_date,
1922: l_okl_remarktng_costs_tl_rec.last_updated_by,
1923: l_okl_remarktng_costs_tl_rec.last_update_date,
1924: l_okl_remarktng_costs_tl_rec.last_update_login);

Line 1921: l_okl_remarktng_costs_tl_rec.creation_date,

1917: l_okl_remarktng_costs_tl_rec.source_lang,
1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,
1919: l_okl_remarktng_costs_tl_rec.comments,
1920: l_okl_remarktng_costs_tl_rec.created_by,
1921: l_okl_remarktng_costs_tl_rec.creation_date,
1922: l_okl_remarktng_costs_tl_rec.last_updated_by,
1923: l_okl_remarktng_costs_tl_rec.last_update_date,
1924: l_okl_remarktng_costs_tl_rec.last_update_login);
1925: END LOOP;

Line 1922: l_okl_remarktng_costs_tl_rec.last_updated_by,

1918: l_okl_remarktng_costs_tl_rec.sfwt_flag,
1919: l_okl_remarktng_costs_tl_rec.comments,
1920: l_okl_remarktng_costs_tl_rec.created_by,
1921: l_okl_remarktng_costs_tl_rec.creation_date,
1922: l_okl_remarktng_costs_tl_rec.last_updated_by,
1923: l_okl_remarktng_costs_tl_rec.last_update_date,
1924: l_okl_remarktng_costs_tl_rec.last_update_login);
1925: END LOOP;
1926: -- Set OUT values

Line 1923: l_okl_remarktng_costs_tl_rec.last_update_date,

1919: l_okl_remarktng_costs_tl_rec.comments,
1920: l_okl_remarktng_costs_tl_rec.created_by,
1921: l_okl_remarktng_costs_tl_rec.creation_date,
1922: l_okl_remarktng_costs_tl_rec.last_updated_by,
1923: l_okl_remarktng_costs_tl_rec.last_update_date,
1924: l_okl_remarktng_costs_tl_rec.last_update_login);
1925: END LOOP;
1926: -- Set OUT values
1927: x_okl_remarktng_costs_tl_rec := l_okl_remarktng_costs_tl_rec;

Line 1924: l_okl_remarktng_costs_tl_rec.last_update_login);

1920: l_okl_remarktng_costs_tl_rec.created_by,
1921: l_okl_remarktng_costs_tl_rec.creation_date,
1922: l_okl_remarktng_costs_tl_rec.last_updated_by,
1923: l_okl_remarktng_costs_tl_rec.last_update_date,
1924: l_okl_remarktng_costs_tl_rec.last_update_login);
1925: END LOOP;
1926: -- Set OUT values
1927: x_okl_remarktng_costs_tl_rec := l_okl_remarktng_costs_tl_rec;
1928: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1927: x_okl_remarktng_costs_tl_rec := l_okl_remarktng_costs_tl_rec;

1923: l_okl_remarktng_costs_tl_rec.last_update_date,
1924: l_okl_remarktng_costs_tl_rec.last_update_login);
1925: END LOOP;
1926: -- Set OUT values
1927: x_okl_remarktng_costs_tl_rec := l_okl_remarktng_costs_tl_rec;
1928: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1929: EXCEPTION
1930: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1931: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1990: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

1986: l_rfcv_rec rfcv_rec_type;
1987: l_def_rfcv_rec rfcv_rec_type;
1988: l_rfc_rec rfc_rec_type;
1989: lx_rfc_rec rfc_rec_type;
1990: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
1991: lx_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
1992: -------------------------------
1993: -- FUNCTION fill_who_columns --
1994: -------------------------------

Line 1991: lx_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

1987: l_def_rfcv_rec rfcv_rec_type;
1988: l_rfc_rec rfc_rec_type;
1989: lx_rfc_rec rfc_rec_type;
1990: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
1991: lx_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
1992: -------------------------------
1993: -- FUNCTION fill_who_columns --
1994: -------------------------------
1995: FUNCTION fill_who_columns (

Line 2094: migrate(l_def_rfcv_rec, l_okl_remarktng_costs_tl_rec);

2090: --------------------------------------
2091: -- Move VIEW record to "Child" records
2092: --------------------------------------
2093: migrate(l_def_rfcv_rec, l_rfc_rec);
2094: migrate(l_def_rfcv_rec, l_okl_remarktng_costs_tl_rec);
2095:
2096: --------------------------------------------
2097: -- Call the INSERT_ROW for each child record
2098: --------------------------------------------

Line 2118: l_okl_remarktng_costs_tl_rec,

2114: p_init_msg_list,
2115: x_return_status,
2116: x_msg_count,
2117: x_msg_data,
2118: l_okl_remarktng_costs_tl_rec,
2119: lx_okl_remarktng_costs_tl_rec
2120: );
2121: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2119: lx_okl_remarktng_costs_tl_rec

2115: x_return_status,
2116: x_msg_count,
2117: x_msg_data,
2118: l_okl_remarktng_costs_tl_rec,
2119: lx_okl_remarktng_costs_tl_rec
2120: );
2121: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2126: migrate(lx_okl_remarktng_costs_tl_rec, l_def_rfcv_rec);

2122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2124: RAISE OKC_API.G_EXCEPTION_ERROR;
2125: END IF;
2126: migrate(lx_okl_remarktng_costs_tl_rec, l_def_rfcv_rec);
2127: -- Set OUT values
2128: x_rfcv_rec := l_def_rfcv_rec;
2129: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2130: EXCEPTION

Line 2372: -- lock_row for:OKL_REMARKTNG_COSTS_TL --

2368: '_PVT'
2369: );
2370: END lock_row;
2371: -----------------------------------------
2372: -- lock_row for:OKL_REMARKTNG_COSTS_TL --
2373: -----------------------------------------
2374: PROCEDURE lock_row(
2375: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2376: x_return_status OUT NOCOPY VARCHAR2,

Line 2379: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS

2375: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2376: x_return_status OUT NOCOPY VARCHAR2,
2377: x_msg_count OUT NOCOPY NUMBER,
2378: x_msg_data OUT NOCOPY VARCHAR2,
2379: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS
2380:
2381: E_Resource_Busy EXCEPTION;
2382: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2383: CURSOR lock_csr (p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS

Line 2383: CURSOR lock_csr (p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS

2379: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS
2380:
2381: E_Resource_Busy EXCEPTION;
2382: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2383: CURSOR lock_csr (p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS
2384: SELECT *
2385: FROM OKL_REMARKTNG_COSTS_TL
2386: WHERE ID = p_okl_remarktng_costs_tl_rec.id
2387: FOR UPDATE NOWAIT;

Line 2385: FROM OKL_REMARKTNG_COSTS_TL

2381: E_Resource_Busy EXCEPTION;
2382: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2383: CURSOR lock_csr (p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS
2384: SELECT *
2385: FROM OKL_REMARKTNG_COSTS_TL
2386: WHERE ID = p_okl_remarktng_costs_tl_rec.id
2387: FOR UPDATE NOWAIT;
2388:
2389: l_api_version CONSTANT NUMBER := 1;

Line 2386: WHERE ID = p_okl_remarktng_costs_tl_rec.id

2382: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2383: CURSOR lock_csr (p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS
2384: SELECT *
2385: FROM OKL_REMARKTNG_COSTS_TL
2386: WHERE ID = p_okl_remarktng_costs_tl_rec.id
2387: FOR UPDATE NOWAIT;
2388:
2389: l_api_version CONSTANT NUMBER := 1;
2390: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2406: OPEN lock_csr(p_okl_remarktng_costs_tl_rec);

2402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: END IF;
2405: BEGIN
2406: OPEN lock_csr(p_okl_remarktng_costs_tl_rec);
2407: FETCH lock_csr INTO l_lock_var;
2408: l_row_notfound := lock_csr%NOTFOUND;
2409: CLOSE lock_csr;
2410: EXCEPTION

Line 2471: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

2467: l_api_version CONSTANT NUMBER := 1;
2468: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2469: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2470: l_rfc_rec rfc_rec_type;
2471: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
2472: BEGIN
2473: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2474: G_PKG_NAME,
2475: p_init_msg_list,

Line 2489: migrate(p_rfcv_rec, l_okl_remarktng_costs_tl_rec);

2485: --------------------------------------
2486: -- Move VIEW record to "Child" records
2487: --------------------------------------
2488: migrate(p_rfcv_rec, l_rfc_rec);
2489: migrate(p_rfcv_rec, l_okl_remarktng_costs_tl_rec);
2490: --------------------------------------------
2491: -- Call the LOCK_ROW for each child record
2492: --------------------------------------------
2493: lock_row(

Line 2510: l_okl_remarktng_costs_tl_rec

2506: p_init_msg_list,
2507: x_return_status,
2508: x_msg_count,
2509: x_msg_data,
2510: l_okl_remarktng_costs_tl_rec
2511: );
2512: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2514: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2958: -- update_row for:OKL_REMARKTNG_COSTS_TL --

2954: '_PVT'
2955: );
2956: END update_row;
2957: -------------------------------------------
2958: -- update_row for:OKL_REMARKTNG_COSTS_TL --
2959: -------------------------------------------
2960: PROCEDURE update_row(
2961: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2962: x_return_status OUT NOCOPY VARCHAR2,

Line 2965: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,

2961: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2962: x_return_status OUT NOCOPY VARCHAR2,
2963: x_msg_count OUT NOCOPY NUMBER,
2964: x_msg_data OUT NOCOPY VARCHAR2,
2965: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
2966: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType) IS
2967:
2968: l_api_version CONSTANT NUMBER := 1;
2969: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2966: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType) IS

2962: x_return_status OUT NOCOPY VARCHAR2,
2963: x_msg_count OUT NOCOPY NUMBER,
2964: x_msg_data OUT NOCOPY VARCHAR2,
2965: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
2966: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType) IS
2967:
2968: l_api_version CONSTANT NUMBER := 1;
2969: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2970: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2971: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType := p_okl_remarktng_costs_tl_rec;

2967:
2968: l_api_version CONSTANT NUMBER := 1;
2969: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2970: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2971: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType := p_okl_remarktng_costs_tl_rec;
2972: ldefoklremarktngcoststlrec OklRemarktngCostsTlRecType;
2973: l_row_notfound BOOLEAN := TRUE;
2974: ----------------------------------
2975: -- FUNCTION populate_new_record --

Line 2978: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,

2974: ----------------------------------
2975: -- FUNCTION populate_new_record --
2976: ----------------------------------
2977: FUNCTION populate_new_record (
2978: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
2979: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
2980: ) RETURN VARCHAR2 IS
2981: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
2982: l_row_notfound BOOLEAN := TRUE;

Line 2979: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType

2975: -- FUNCTION populate_new_record --
2976: ----------------------------------
2977: FUNCTION populate_new_record (
2978: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
2979: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
2980: ) RETURN VARCHAR2 IS
2981: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
2982: l_row_notfound BOOLEAN := TRUE;
2983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2981: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

2977: FUNCTION populate_new_record (
2978: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
2979: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
2980: ) RETURN VARCHAR2 IS
2981: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
2982: l_row_notfound BOOLEAN := TRUE;
2983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2984: BEGIN
2985: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;

Line 2985: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;

2981: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
2982: l_row_notfound BOOLEAN := TRUE;
2983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2984: BEGIN
2985: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
2986: -- Get current database values
2987: l_okl_remarktng_costs_tl_rec := get_rec(p_okl_remarktng_costs_tl_rec, l_row_notfound);
2988: IF (l_row_notfound) THEN
2989: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2987: l_okl_remarktng_costs_tl_rec := get_rec(p_okl_remarktng_costs_tl_rec, l_row_notfound);

2983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2984: BEGIN
2985: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
2986: -- Get current database values
2987: l_okl_remarktng_costs_tl_rec := get_rec(p_okl_remarktng_costs_tl_rec, l_row_notfound);
2988: IF (l_row_notfound) THEN
2989: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2990: END IF;
2991: IF (x_okl_remarktng_costs_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2991: IF (x_okl_remarktng_costs_tl_rec.id = OKC_API.G_MISS_NUM)

2987: l_okl_remarktng_costs_tl_rec := get_rec(p_okl_remarktng_costs_tl_rec, l_row_notfound);
2988: IF (l_row_notfound) THEN
2989: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2990: END IF;
2991: IF (x_okl_remarktng_costs_tl_rec.id = OKC_API.G_MISS_NUM)
2992: THEN
2993: x_okl_remarktng_costs_tl_rec.id := l_okl_remarktng_costs_tl_rec.id;
2994: END IF;
2995: IF (x_okl_remarktng_costs_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2993: x_okl_remarktng_costs_tl_rec.id := l_okl_remarktng_costs_tl_rec.id;

2989: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2990: END IF;
2991: IF (x_okl_remarktng_costs_tl_rec.id = OKC_API.G_MISS_NUM)
2992: THEN
2993: x_okl_remarktng_costs_tl_rec.id := l_okl_remarktng_costs_tl_rec.id;
2994: END IF;
2995: IF (x_okl_remarktng_costs_tl_rec.language = OKC_API.G_MISS_CHAR)
2996: THEN
2997: x_okl_remarktng_costs_tl_rec.language := l_okl_remarktng_costs_tl_rec.language;

Line 2995: IF (x_okl_remarktng_costs_tl_rec.language = OKC_API.G_MISS_CHAR)

2991: IF (x_okl_remarktng_costs_tl_rec.id = OKC_API.G_MISS_NUM)
2992: THEN
2993: x_okl_remarktng_costs_tl_rec.id := l_okl_remarktng_costs_tl_rec.id;
2994: END IF;
2995: IF (x_okl_remarktng_costs_tl_rec.language = OKC_API.G_MISS_CHAR)
2996: THEN
2997: x_okl_remarktng_costs_tl_rec.language := l_okl_remarktng_costs_tl_rec.language;
2998: END IF;
2999: IF (x_okl_remarktng_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2997: x_okl_remarktng_costs_tl_rec.language := l_okl_remarktng_costs_tl_rec.language;

2993: x_okl_remarktng_costs_tl_rec.id := l_okl_remarktng_costs_tl_rec.id;
2994: END IF;
2995: IF (x_okl_remarktng_costs_tl_rec.language = OKC_API.G_MISS_CHAR)
2996: THEN
2997: x_okl_remarktng_costs_tl_rec.language := l_okl_remarktng_costs_tl_rec.language;
2998: END IF;
2999: IF (x_okl_remarktng_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3000: THEN
3001: x_okl_remarktng_costs_tl_rec.source_lang := l_okl_remarktng_costs_tl_rec.source_lang;

Line 2999: IF (x_okl_remarktng_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2995: IF (x_okl_remarktng_costs_tl_rec.language = OKC_API.G_MISS_CHAR)
2996: THEN
2997: x_okl_remarktng_costs_tl_rec.language := l_okl_remarktng_costs_tl_rec.language;
2998: END IF;
2999: IF (x_okl_remarktng_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3000: THEN
3001: x_okl_remarktng_costs_tl_rec.source_lang := l_okl_remarktng_costs_tl_rec.source_lang;
3002: END IF;
3003: IF (x_okl_remarktng_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 3001: x_okl_remarktng_costs_tl_rec.source_lang := l_okl_remarktng_costs_tl_rec.source_lang;

2997: x_okl_remarktng_costs_tl_rec.language := l_okl_remarktng_costs_tl_rec.language;
2998: END IF;
2999: IF (x_okl_remarktng_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3000: THEN
3001: x_okl_remarktng_costs_tl_rec.source_lang := l_okl_remarktng_costs_tl_rec.source_lang;
3002: END IF;
3003: IF (x_okl_remarktng_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3004: THEN
3005: x_okl_remarktng_costs_tl_rec.sfwt_flag := l_okl_remarktng_costs_tl_rec.sfwt_flag;

Line 3003: IF (x_okl_remarktng_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2999: IF (x_okl_remarktng_costs_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
3000: THEN
3001: x_okl_remarktng_costs_tl_rec.source_lang := l_okl_remarktng_costs_tl_rec.source_lang;
3002: END IF;
3003: IF (x_okl_remarktng_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3004: THEN
3005: x_okl_remarktng_costs_tl_rec.sfwt_flag := l_okl_remarktng_costs_tl_rec.sfwt_flag;
3006: END IF;
3007: IF (x_okl_remarktng_costs_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 3005: x_okl_remarktng_costs_tl_rec.sfwt_flag := l_okl_remarktng_costs_tl_rec.sfwt_flag;

3001: x_okl_remarktng_costs_tl_rec.source_lang := l_okl_remarktng_costs_tl_rec.source_lang;
3002: END IF;
3003: IF (x_okl_remarktng_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3004: THEN
3005: x_okl_remarktng_costs_tl_rec.sfwt_flag := l_okl_remarktng_costs_tl_rec.sfwt_flag;
3006: END IF;
3007: IF (x_okl_remarktng_costs_tl_rec.comments = OKC_API.G_MISS_CHAR)
3008: THEN
3009: x_okl_remarktng_costs_tl_rec.comments := l_okl_remarktng_costs_tl_rec.comments;

Line 3007: IF (x_okl_remarktng_costs_tl_rec.comments = OKC_API.G_MISS_CHAR)

3003: IF (x_okl_remarktng_costs_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
3004: THEN
3005: x_okl_remarktng_costs_tl_rec.sfwt_flag := l_okl_remarktng_costs_tl_rec.sfwt_flag;
3006: END IF;
3007: IF (x_okl_remarktng_costs_tl_rec.comments = OKC_API.G_MISS_CHAR)
3008: THEN
3009: x_okl_remarktng_costs_tl_rec.comments := l_okl_remarktng_costs_tl_rec.comments;
3010: END IF;
3011: IF (x_okl_remarktng_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 3009: x_okl_remarktng_costs_tl_rec.comments := l_okl_remarktng_costs_tl_rec.comments;

3005: x_okl_remarktng_costs_tl_rec.sfwt_flag := l_okl_remarktng_costs_tl_rec.sfwt_flag;
3006: END IF;
3007: IF (x_okl_remarktng_costs_tl_rec.comments = OKC_API.G_MISS_CHAR)
3008: THEN
3009: x_okl_remarktng_costs_tl_rec.comments := l_okl_remarktng_costs_tl_rec.comments;
3010: END IF;
3011: IF (x_okl_remarktng_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)
3012: THEN
3013: x_okl_remarktng_costs_tl_rec.created_by := l_okl_remarktng_costs_tl_rec.created_by;

Line 3011: IF (x_okl_remarktng_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)

3007: IF (x_okl_remarktng_costs_tl_rec.comments = OKC_API.G_MISS_CHAR)
3008: THEN
3009: x_okl_remarktng_costs_tl_rec.comments := l_okl_remarktng_costs_tl_rec.comments;
3010: END IF;
3011: IF (x_okl_remarktng_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)
3012: THEN
3013: x_okl_remarktng_costs_tl_rec.created_by := l_okl_remarktng_costs_tl_rec.created_by;
3014: END IF;
3015: IF (x_okl_remarktng_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 3013: x_okl_remarktng_costs_tl_rec.created_by := l_okl_remarktng_costs_tl_rec.created_by;

3009: x_okl_remarktng_costs_tl_rec.comments := l_okl_remarktng_costs_tl_rec.comments;
3010: END IF;
3011: IF (x_okl_remarktng_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)
3012: THEN
3013: x_okl_remarktng_costs_tl_rec.created_by := l_okl_remarktng_costs_tl_rec.created_by;
3014: END IF;
3015: IF (x_okl_remarktng_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3016: THEN
3017: x_okl_remarktng_costs_tl_rec.creation_date := l_okl_remarktng_costs_tl_rec.creation_date;

Line 3015: IF (x_okl_remarktng_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)

3011: IF (x_okl_remarktng_costs_tl_rec.created_by = OKC_API.G_MISS_NUM)
3012: THEN
3013: x_okl_remarktng_costs_tl_rec.created_by := l_okl_remarktng_costs_tl_rec.created_by;
3014: END IF;
3015: IF (x_okl_remarktng_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3016: THEN
3017: x_okl_remarktng_costs_tl_rec.creation_date := l_okl_remarktng_costs_tl_rec.creation_date;
3018: END IF;
3019: IF (x_okl_remarktng_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 3017: x_okl_remarktng_costs_tl_rec.creation_date := l_okl_remarktng_costs_tl_rec.creation_date;

3013: x_okl_remarktng_costs_tl_rec.created_by := l_okl_remarktng_costs_tl_rec.created_by;
3014: END IF;
3015: IF (x_okl_remarktng_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3016: THEN
3017: x_okl_remarktng_costs_tl_rec.creation_date := l_okl_remarktng_costs_tl_rec.creation_date;
3018: END IF;
3019: IF (x_okl_remarktng_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3020: THEN
3021: x_okl_remarktng_costs_tl_rec.last_updated_by := l_okl_remarktng_costs_tl_rec.last_updated_by;

Line 3019: IF (x_okl_remarktng_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

3015: IF (x_okl_remarktng_costs_tl_rec.creation_date = OKC_API.G_MISS_DATE)
3016: THEN
3017: x_okl_remarktng_costs_tl_rec.creation_date := l_okl_remarktng_costs_tl_rec.creation_date;
3018: END IF;
3019: IF (x_okl_remarktng_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3020: THEN
3021: x_okl_remarktng_costs_tl_rec.last_updated_by := l_okl_remarktng_costs_tl_rec.last_updated_by;
3022: END IF;
3023: IF (x_okl_remarktng_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 3021: x_okl_remarktng_costs_tl_rec.last_updated_by := l_okl_remarktng_costs_tl_rec.last_updated_by;

3017: x_okl_remarktng_costs_tl_rec.creation_date := l_okl_remarktng_costs_tl_rec.creation_date;
3018: END IF;
3019: IF (x_okl_remarktng_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3020: THEN
3021: x_okl_remarktng_costs_tl_rec.last_updated_by := l_okl_remarktng_costs_tl_rec.last_updated_by;
3022: END IF;
3023: IF (x_okl_remarktng_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3024: THEN
3025: x_okl_remarktng_costs_tl_rec.last_update_date := l_okl_remarktng_costs_tl_rec.last_update_date;

Line 3023: IF (x_okl_remarktng_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

3019: IF (x_okl_remarktng_costs_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
3020: THEN
3021: x_okl_remarktng_costs_tl_rec.last_updated_by := l_okl_remarktng_costs_tl_rec.last_updated_by;
3022: END IF;
3023: IF (x_okl_remarktng_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3024: THEN
3025: x_okl_remarktng_costs_tl_rec.last_update_date := l_okl_remarktng_costs_tl_rec.last_update_date;
3026: END IF;
3027: IF (x_okl_remarktng_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 3025: x_okl_remarktng_costs_tl_rec.last_update_date := l_okl_remarktng_costs_tl_rec.last_update_date;

3021: x_okl_remarktng_costs_tl_rec.last_updated_by := l_okl_remarktng_costs_tl_rec.last_updated_by;
3022: END IF;
3023: IF (x_okl_remarktng_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3024: THEN
3025: x_okl_remarktng_costs_tl_rec.last_update_date := l_okl_remarktng_costs_tl_rec.last_update_date;
3026: END IF;
3027: IF (x_okl_remarktng_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3028: THEN
3029: x_okl_remarktng_costs_tl_rec.last_update_login := l_okl_remarktng_costs_tl_rec.last_update_login;

Line 3027: IF (x_okl_remarktng_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

3023: IF (x_okl_remarktng_costs_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
3024: THEN
3025: x_okl_remarktng_costs_tl_rec.last_update_date := l_okl_remarktng_costs_tl_rec.last_update_date;
3026: END IF;
3027: IF (x_okl_remarktng_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3028: THEN
3029: x_okl_remarktng_costs_tl_rec.last_update_login := l_okl_remarktng_costs_tl_rec.last_update_login;
3030: END IF;
3031: RETURN(l_return_status);

Line 3029: x_okl_remarktng_costs_tl_rec.last_update_login := l_okl_remarktng_costs_tl_rec.last_update_login;

3025: x_okl_remarktng_costs_tl_rec.last_update_date := l_okl_remarktng_costs_tl_rec.last_update_date;
3026: END IF;
3027: IF (x_okl_remarktng_costs_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
3028: THEN
3029: x_okl_remarktng_costs_tl_rec.last_update_login := l_okl_remarktng_costs_tl_rec.last_update_login;
3030: END IF;
3031: RETURN(l_return_status);
3032: END populate_new_record;
3033: -----------------------------------------------

Line 3034: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --

3030: END IF;
3031: RETURN(l_return_status);
3032: END populate_new_record;
3033: -----------------------------------------------
3034: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
3035: -----------------------------------------------
3036: FUNCTION Set_Attributes (
3037: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
3038: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType

Line 3037: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,

3033: -----------------------------------------------
3034: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
3035: -----------------------------------------------
3036: FUNCTION Set_Attributes (
3037: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
3038: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
3039: ) RETURN VARCHAR2 IS
3040: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3041: BEGIN

Line 3038: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType

3034: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
3035: -----------------------------------------------
3036: FUNCTION Set_Attributes (
3037: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
3038: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
3039: ) RETURN VARCHAR2 IS
3040: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3041: BEGIN
3042: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;

Line 3042: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;

3038: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
3039: ) RETURN VARCHAR2 IS
3040: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3041: BEGIN
3042: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
3043: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');
3044: x_okl_remarktng_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
3045: RETURN(l_return_status);
3046: END Set_Attributes;

Line 3043: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');

3039: ) RETURN VARCHAR2 IS
3040: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3041: BEGIN
3042: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
3043: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');
3044: x_okl_remarktng_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
3045: RETURN(l_return_status);
3046: END Set_Attributes;
3047: BEGIN

Line 3044: x_okl_remarktng_costs_tl_rec.SOURCE_LANG := USERENV('LANG');

3040: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3041: BEGIN
3042: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
3043: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');
3044: x_okl_remarktng_costs_tl_rec.SOURCE_LANG := USERENV('LANG');
3045: RETURN(l_return_status);
3046: END Set_Attributes;
3047: BEGIN
3048: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3059: p_okl_remarktng_costs_tl_rec, -- IN

3055: RAISE OKC_API.G_EXCEPTION_ERROR;
3056: END IF;
3057: --- Setting item attributes
3058: l_return_status := Set_Attributes(
3059: p_okl_remarktng_costs_tl_rec, -- IN
3060: l_okl_remarktng_costs_tl_rec); -- OUT
3061: --- If any errors happen abort API
3062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3060: l_okl_remarktng_costs_tl_rec); -- OUT

3056: END IF;
3057: --- Setting item attributes
3058: l_return_status := Set_Attributes(
3059: p_okl_remarktng_costs_tl_rec, -- IN
3060: l_okl_remarktng_costs_tl_rec); -- OUT
3061: --- If any errors happen abort API
3062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3064: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3067: l_return_status := populate_new_record(l_okl_remarktng_costs_tl_rec, ldefoklremarktngcoststlrec);

3063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3064: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3065: RAISE OKC_API.G_EXCEPTION_ERROR;
3066: END IF;
3067: l_return_status := populate_new_record(l_okl_remarktng_costs_tl_rec, ldefoklremarktngcoststlrec);
3068: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3070: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3071: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3073: UPDATE OKL_REMARKTNG_COSTS_TL

3069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3070: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3071: RAISE OKC_API.G_EXCEPTION_ERROR;
3072: END IF;
3073: UPDATE OKL_REMARKTNG_COSTS_TL
3074: SET COMMENTS = ldefoklremarktngcoststlrec.comments,
3075: SOURCE_LANG = ldefoklremarktngcoststlrec.source_lang, --Fix fro bug 3637102
3076: CREATED_BY = ldefoklremarktngcoststlrec.created_by,
3077: CREATION_DATE = ldefoklremarktngcoststlrec.creation_date,

Line 3085: UPDATE OKL_REMARKTNG_COSTS_TL

3081: WHERE ID = ldefoklremarktngcoststlrec.id
3082: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
3083: --AND SOURCE_LANG = USERENV('LANG');
3084:
3085: UPDATE OKL_REMARKTNG_COSTS_TL
3086: SET SFWT_FLAG = 'Y'
3087: WHERE ID = ldefoklremarktngcoststlrec.id
3088: AND SOURCE_LANG <> USERENV('LANG');
3089:

Line 3090: x_okl_remarktng_costs_tl_rec := ldefoklremarktngcoststlrec;

3086: SET SFWT_FLAG = 'Y'
3087: WHERE ID = ldefoklremarktngcoststlrec.id
3088: AND SOURCE_LANG <> USERENV('LANG');
3089:
3090: x_okl_remarktng_costs_tl_rec := ldefoklremarktngcoststlrec;
3091: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3092: EXCEPTION
3093: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3094: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3151: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

3147: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
3148: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3149: l_rfcv_rec rfcv_rec_type := p_rfcv_rec;
3150: l_def_rfcv_rec rfcv_rec_type;
3151: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
3152: lx_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
3153: l_rfc_rec rfc_rec_type;
3154: lx_rfc_rec rfc_rec_type;
3155: -------------------------------

Line 3152: lx_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

3148: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3149: l_rfcv_rec rfcv_rec_type := p_rfcv_rec;
3150: l_def_rfcv_rec rfcv_rec_type;
3151: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
3152: lx_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
3153: l_rfc_rec rfc_rec_type;
3154: lx_rfc_rec rfc_rec_type;
3155: -------------------------------
3156: -- FUNCTION fill_who_columns --

Line 3416: migrate(l_def_rfcv_rec, l_okl_remarktng_costs_tl_rec);

3412:
3413: --------------------------------------
3414: -- Move VIEW record to "Child" records
3415: --------------------------------------
3416: migrate(l_def_rfcv_rec, l_okl_remarktng_costs_tl_rec);
3417: migrate(l_def_rfcv_rec, l_rfc_rec);
3418: --------------------------------------------
3419: -- Call the UPDATE_ROW for each child record
3420: --------------------------------------------

Line 3426: l_okl_remarktng_costs_tl_rec,

3422: p_init_msg_list,
3423: x_return_status,
3424: x_msg_count,
3425: x_msg_data,
3426: l_okl_remarktng_costs_tl_rec,
3427: lx_okl_remarktng_costs_tl_rec
3428: );
3429: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3430: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3427: lx_okl_remarktng_costs_tl_rec

3423: x_return_status,
3424: x_msg_count,
3425: x_msg_data,
3426: l_okl_remarktng_costs_tl_rec,
3427: lx_okl_remarktng_costs_tl_rec
3428: );
3429: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3430: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3431: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3434: migrate(lx_okl_remarktng_costs_tl_rec, l_def_rfcv_rec);

3430: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3431: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3432: RAISE OKC_API.G_EXCEPTION_ERROR;
3433: END IF;
3434: migrate(lx_okl_remarktng_costs_tl_rec, l_def_rfcv_rec);
3435: update_row(
3436: p_init_msg_list,
3437: x_return_status,
3438: x_msg_count,

Line 3631: -- delete_row for:OKL_REMARKTNG_COSTS_TL --

3627: '_PVT'
3628: );
3629: END delete_row;
3630: -------------------------------------------
3631: -- delete_row for:OKL_REMARKTNG_COSTS_TL --
3632: -------------------------------------------
3633: PROCEDURE delete_row(
3634: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3635: x_return_status OUT NOCOPY VARCHAR2,

Line 3638: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS

3634: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3635: x_return_status OUT NOCOPY VARCHAR2,
3636: x_msg_count OUT NOCOPY NUMBER,
3637: x_msg_data OUT NOCOPY VARCHAR2,
3638: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType) IS
3639:
3640: l_api_version CONSTANT NUMBER := 1;
3641: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3642: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3643: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType:= p_okl_remarktng_costs_tl_rec;

3639:
3640: l_api_version CONSTANT NUMBER := 1;
3641: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3642: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3643: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType:= p_okl_remarktng_costs_tl_rec;
3644: l_row_notfound BOOLEAN := TRUE;
3645: -----------------------------------------------
3646: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
3647: -----------------------------------------------

Line 3646: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --

3642: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3643: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType:= p_okl_remarktng_costs_tl_rec;
3644: l_row_notfound BOOLEAN := TRUE;
3645: -----------------------------------------------
3646: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
3647: -----------------------------------------------
3648: FUNCTION Set_Attributes (
3649: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
3650: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType

Line 3649: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,

3645: -----------------------------------------------
3646: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
3647: -----------------------------------------------
3648: FUNCTION Set_Attributes (
3649: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
3650: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
3651: ) RETURN VARCHAR2 IS
3652: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3653: BEGIN

Line 3650: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType

3646: -- Set_Attributes for:OKL_REMARKTNG_COSTS_TL --
3647: -----------------------------------------------
3648: FUNCTION Set_Attributes (
3649: p_okl_remarktng_costs_tl_rec IN OklRemarktngCostsTlRecType,
3650: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
3651: ) RETURN VARCHAR2 IS
3652: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3653: BEGIN
3654: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;

Line 3654: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;

3650: x_okl_remarktng_costs_tl_rec OUT NOCOPY OklRemarktngCostsTlRecType
3651: ) RETURN VARCHAR2 IS
3652: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3653: BEGIN
3654: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
3655: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');
3656: RETURN(l_return_status);
3657: END Set_Attributes;
3658: BEGIN

Line 3655: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');

3651: ) RETURN VARCHAR2 IS
3652: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3653: BEGIN
3654: x_okl_remarktng_costs_tl_rec := p_okl_remarktng_costs_tl_rec;
3655: x_okl_remarktng_costs_tl_rec.LANGUAGE := USERENV('LANG');
3656: RETURN(l_return_status);
3657: END Set_Attributes;
3658: BEGIN
3659: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3670: p_okl_remarktng_costs_tl_rec, -- IN

3666: RAISE OKC_API.G_EXCEPTION_ERROR;
3667: END IF;
3668: --- Setting item attributes
3669: l_return_status := Set_Attributes(
3670: p_okl_remarktng_costs_tl_rec, -- IN
3671: l_okl_remarktng_costs_tl_rec); -- OUT
3672: --- If any errors happen abort API
3673: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3671: l_okl_remarktng_costs_tl_rec); -- OUT

3667: END IF;
3668: --- Setting item attributes
3669: l_return_status := Set_Attributes(
3670: p_okl_remarktng_costs_tl_rec, -- IN
3671: l_okl_remarktng_costs_tl_rec); -- OUT
3672: --- If any errors happen abort API
3673: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3675: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3678: DELETE FROM OKL_REMARKTNG_COSTS_TL

3674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3675: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3676: RAISE OKC_API.G_EXCEPTION_ERROR;
3677: END IF;
3678: DELETE FROM OKL_REMARKTNG_COSTS_TL
3679: WHERE ID = l_okl_remarktng_costs_tl_rec.id;
3680:
3681: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3682: EXCEPTION

Line 3679: WHERE ID = l_okl_remarktng_costs_tl_rec.id;

3675: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3676: RAISE OKC_API.G_EXCEPTION_ERROR;
3677: END IF;
3678: DELETE FROM OKL_REMARKTNG_COSTS_TL
3679: WHERE ID = l_okl_remarktng_costs_tl_rec.id;
3680:
3681: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3682: EXCEPTION
3683: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3729: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;

3725: l_api_version CONSTANT NUMBER := 1;
3726: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3727: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3728: l_rfcv_rec rfcv_rec_type := p_rfcv_rec;
3729: l_okl_remarktng_costs_tl_rec OklRemarktngCostsTlRecType;
3730: l_rfc_rec rfc_rec_type;
3731: BEGIN
3732: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3733: G_PKG_NAME,

Line 3747: migrate(l_rfcv_rec, l_okl_remarktng_costs_tl_rec);

3743: END IF;
3744: --------------------------------------
3745: -- Move VIEW record to "Child" records
3746: --------------------------------------
3747: migrate(l_rfcv_rec, l_okl_remarktng_costs_tl_rec);
3748: migrate(l_rfcv_rec, l_rfc_rec);
3749: --------------------------------------------
3750: -- Call the DELETE_ROW for each child record
3751: --------------------------------------------

Line 3757: l_okl_remarktng_costs_tl_rec

3753: p_init_msg_list,
3754: x_return_status,
3755: x_msg_count,
3756: x_msg_data,
3757: l_okl_remarktng_costs_tl_rec
3758: );
3759: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3760: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3761: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN