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_STA_PVT dependencies on OKL_STRM_TYP_ALLOCS

Line 36: -- FUNCTION get_rec for: OKL_STRM_TYP_ALLOCS

32: NULL;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_STRM_TYP_ALLOCS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_sta_rec IN sta_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 71: FROM Okl_Strm_Typ_Allocs

67: CREATION_DATE,
68: LAST_UPDATED_BY,
69: LAST_UPDATE_DATE,
70: LAST_UPDATE_LOGIN
71: FROM Okl_Strm_Typ_Allocs
72: WHERE okl_strm_typ_allocs.id = p_id;
73: l_sta_pk sta_pk_csr%ROWTYPE;
74: l_sta_rec sta_rec_type;
75: BEGIN

Line 72: WHERE okl_strm_typ_allocs.id = p_id;

68: LAST_UPDATED_BY,
69: LAST_UPDATE_DATE,
70: LAST_UPDATE_LOGIN
71: FROM Okl_Strm_Typ_Allocs
72: WHERE okl_strm_typ_allocs.id = p_id;
73: l_sta_pk sta_pk_csr%ROWTYPE;
74: l_sta_rec sta_rec_type;
75: BEGIN
76: x_no_data_found := TRUE;

Line 120: -- FUNCTION get_rec for: OKL_STRM_TYP_ALLOCS_V

116: BEGIN
117: RETURN(get_rec(p_sta_rec, l_row_notfound));
118: END get_rec;
119: ---------------------------------------------------------------------------
120: -- FUNCTION get_rec for: OKL_STRM_TYP_ALLOCS_V
121: ---------------------------------------------------------------------------
122: FUNCTION get_rec (
123: p_stav_rec IN stav_rec_type,
124: x_no_data_found OUT NOCOPY BOOLEAN

Line 155: FROM OKL_STRM_TYP_ALLOCS

151: CREATION_DATE,
152: LAST_UPDATED_BY,
153: LAST_UPDATE_DATE,
154: LAST_UPDATE_LOGIN
155: FROM OKL_STRM_TYP_ALLOCS
156: WHERE OKL_STRM_TYP_ALLOCS.id = p_id;
157: l_okl_stav_pk okl_stav_pk_csr%ROWTYPE;
158: l_stav_rec stav_rec_type;
159: BEGIN

Line 156: WHERE OKL_STRM_TYP_ALLOCS.id = p_id;

152: LAST_UPDATED_BY,
153: LAST_UPDATE_DATE,
154: LAST_UPDATE_LOGIN
155: FROM OKL_STRM_TYP_ALLOCS
156: WHERE OKL_STRM_TYP_ALLOCS.id = p_id;
157: l_okl_stav_pk okl_stav_pk_csr%ROWTYPE;
158: l_stav_rec stav_rec_type;
159: BEGIN
160: x_no_data_found := TRUE;

Line 205: -- FUNCTION null_out_defaults for: OKL_STRM_TYP_ALLOCS_V --

201: RETURN(get_rec(p_stav_rec, l_row_notfound));
202: END get_rec;
203:
204: -----------------------------------------------------------
205: -- FUNCTION null_out_defaults for: OKL_STRM_TYP_ALLOCS_V --
206: -----------------------------------------------------------
207: FUNCTION null_out_defaults (
208: p_stav_rec IN stav_rec_type
209: ) RETURN stav_rec_type IS

Line 485: FROM okl_strm_typ_allocs

481: FUNCTION IS_UNIQUE (p_stav_rec stav_rec_type) RETURN VARCHAR2
482: IS
483: CURSOR l_chr_csr IS
484: SELECT 'x'
485: FROM okl_strm_typ_allocs
486: WHERE sty_id = p_stav_rec.sty_id
487: AND cat_id = p_stav_rec.cat_id
488: AND id <> NVL(p_stav_rec.id,-99999);
489:

Line 603: -- Validate_Record for:OKL_STRM_TYP_ALLOCS_V --

599: ---------------------------------------------------------------------------
600: -- PROCEDURE Validate_Record
601: ---------------------------------------------------------------------------
602: -----------------------------------------------
603: -- Validate_Record for:OKL_STRM_TYP_ALLOCS_V --
604: -----------------------------------------------
605:
606: --Added 04/23/2001 Bruno Vaghela ---
607:

Line 703: p_to IN OUT NOCOPY okl_strm_typ_allocs_h_rec_type

699:
700: /* -- history stables not supported 04 Apr 2002
701: PROCEDURE migrate (
702: p_from IN sta_rec_type,
703: p_to IN OUT NOCOPY okl_strm_typ_allocs_h_rec_type
704: ) IS
705: BEGIN
706: p_to.id := p_from.id;
707: p_to.cat_id := p_from.cat_id;

Line 740: -- validate_row for:OKL_STRM_TYP_ALLOCS_V --

736: ---------------------------------------------------------------------------
737: -- PROCEDURE validate_row
738: ---------------------------------------------------------------------------
739: --------------------------------------------
740: -- validate_row for:OKL_STRM_TYP_ALLOCS_V --
741: --------------------------------------------
742: PROCEDURE validate_row(
743: p_api_version IN NUMBER,
744: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 905: -- insert_row for:OKL_STRM_TYP_ALLOCS_H --

901: ---------------------------------------------------------------------------
902: -- PROCEDURE insert_row
903: ---------------------------------------------------------------------------
904: ------------------------------------------
905: -- insert_row for:OKL_STRM_TYP_ALLOCS_H --
906: ------------------------------------------
907:
908: /* -- history tables not supported 04 Apr 2002
909:

Line 915: p_okl_strm_typ_allocs_h_rec IN okl_strm_typ_allocs_h_rec_type,

911: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
912: x_return_status OUT NOCOPY VARCHAR2,
913: x_msg_count OUT NOCOPY NUMBER,
914: x_msg_data OUT NOCOPY VARCHAR2,
915: p_okl_strm_typ_allocs_h_rec IN okl_strm_typ_allocs_h_rec_type,
916: x_okl_strm_typ_allocs_h_rec OUT NOCOPY okl_strm_typ_allocs_h_rec_type) IS
917:
918: l_api_version CONSTANT NUMBER := 1;
919: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';

Line 916: x_okl_strm_typ_allocs_h_rec OUT NOCOPY okl_strm_typ_allocs_h_rec_type) IS

912: x_return_status OUT NOCOPY VARCHAR2,
913: x_msg_count OUT NOCOPY NUMBER,
914: x_msg_data OUT NOCOPY VARCHAR2,
915: p_okl_strm_typ_allocs_h_rec IN okl_strm_typ_allocs_h_rec_type,
916: x_okl_strm_typ_allocs_h_rec OUT NOCOPY okl_strm_typ_allocs_h_rec_type) IS
917:
918: l_api_version CONSTANT NUMBER := 1;
919: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
920: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 921: l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type := p_okl_strm_typ_allocs_h_rec;

917:
918: l_api_version CONSTANT NUMBER := 1;
919: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
920: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
921: l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type := p_okl_strm_typ_allocs_h_rec;
922: ldefoklstrmtypallocshrec okl_strm_typ_allocs_h_rec_type;
923: ----------------------------------------------
924: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_H --
925: ----------------------------------------------

Line 922: ldefoklstrmtypallocshrec okl_strm_typ_allocs_h_rec_type;

918: l_api_version CONSTANT NUMBER := 1;
919: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
920: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
921: l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type := p_okl_strm_typ_allocs_h_rec;
922: ldefoklstrmtypallocshrec okl_strm_typ_allocs_h_rec_type;
923: ----------------------------------------------
924: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_H --
925: ----------------------------------------------
926: FUNCTION Set_Attributes (

Line 924: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_H --

920: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
921: l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type := p_okl_strm_typ_allocs_h_rec;
922: ldefoklstrmtypallocshrec okl_strm_typ_allocs_h_rec_type;
923: ----------------------------------------------
924: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_H --
925: ----------------------------------------------
926: FUNCTION Set_Attributes (
927: p_okl_strm_typ_allocs_h_rec IN okl_strm_typ_allocs_h_rec_type,
928: x_okl_strm_typ_allocs_h_rec OUT NOCOPY okl_strm_typ_allocs_h_rec_type

Line 927: p_okl_strm_typ_allocs_h_rec IN okl_strm_typ_allocs_h_rec_type,

923: ----------------------------------------------
924: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_H --
925: ----------------------------------------------
926: FUNCTION Set_Attributes (
927: p_okl_strm_typ_allocs_h_rec IN okl_strm_typ_allocs_h_rec_type,
928: x_okl_strm_typ_allocs_h_rec OUT NOCOPY okl_strm_typ_allocs_h_rec_type
929: ) RETURN VARCHAR2 IS
930: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
931: BEGIN

Line 928: x_okl_strm_typ_allocs_h_rec OUT NOCOPY okl_strm_typ_allocs_h_rec_type

924: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_H --
925: ----------------------------------------------
926: FUNCTION Set_Attributes (
927: p_okl_strm_typ_allocs_h_rec IN okl_strm_typ_allocs_h_rec_type,
928: x_okl_strm_typ_allocs_h_rec OUT NOCOPY okl_strm_typ_allocs_h_rec_type
929: ) RETURN VARCHAR2 IS
930: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
931: BEGIN
932: x_okl_strm_typ_allocs_h_rec := p_okl_strm_typ_allocs_h_rec;

Line 932: x_okl_strm_typ_allocs_h_rec := p_okl_strm_typ_allocs_h_rec;

928: x_okl_strm_typ_allocs_h_rec OUT NOCOPY okl_strm_typ_allocs_h_rec_type
929: ) RETURN VARCHAR2 IS
930: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
931: BEGIN
932: x_okl_strm_typ_allocs_h_rec := p_okl_strm_typ_allocs_h_rec;
933: RETURN(l_return_status);
934: END Set_Attributes;
935: BEGIN
936: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 947: p_okl_strm_typ_allocs_h_rec, -- IN

943: RAISE Okl_Api.G_EXCEPTION_ERROR;
944: END IF;
945: --- Setting item attributes
946: l_return_status := Set_Attributes(
947: p_okl_strm_typ_allocs_h_rec, -- IN
948: l_okl_strm_typ_allocs_h_rec); -- OUT
949: --- If any errors happen abort API
950: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 948: l_okl_strm_typ_allocs_h_rec); -- OUT

944: END IF;
945: --- Setting item attributes
946: l_return_status := Set_Attributes(
947: p_okl_strm_typ_allocs_h_rec, -- IN
948: l_okl_strm_typ_allocs_h_rec); -- OUT
949: --- If any errors happen abort API
950: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 955: INSERT INTO OKL_STRM_TYP_ALLOCS_H(

951: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
953: RAISE Okl_Api.G_EXCEPTION_ERROR;
954: END IF;
955: INSERT INTO OKL_STRM_TYP_ALLOCS_H(
956: id,
957: major_version,
958: cat_id,
959: sty_id,

Line 985: l_okl_strm_typ_allocs_h_rec.id,

981: last_updated_by,
982: last_update_date,
983: last_update_login)
984: VALUES (
985: l_okl_strm_typ_allocs_h_rec.id,
986: l_okl_strm_typ_allocs_h_rec.major_version,
987: l_okl_strm_typ_allocs_h_rec.cat_id,
988: l_okl_strm_typ_allocs_h_rec.sty_id,
989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,

Line 986: l_okl_strm_typ_allocs_h_rec.major_version,

982: last_update_date,
983: last_update_login)
984: VALUES (
985: l_okl_strm_typ_allocs_h_rec.id,
986: l_okl_strm_typ_allocs_h_rec.major_version,
987: l_okl_strm_typ_allocs_h_rec.cat_id,
988: l_okl_strm_typ_allocs_h_rec.sty_id,
989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,
990: l_okl_strm_typ_allocs_h_rec.object_version_number,

Line 987: l_okl_strm_typ_allocs_h_rec.cat_id,

983: last_update_login)
984: VALUES (
985: l_okl_strm_typ_allocs_h_rec.id,
986: l_okl_strm_typ_allocs_h_rec.major_version,
987: l_okl_strm_typ_allocs_h_rec.cat_id,
988: l_okl_strm_typ_allocs_h_rec.sty_id,
989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,
990: l_okl_strm_typ_allocs_h_rec.object_version_number,
991: l_okl_strm_typ_allocs_h_rec.sequence_number,

Line 988: l_okl_strm_typ_allocs_h_rec.sty_id,

984: VALUES (
985: l_okl_strm_typ_allocs_h_rec.id,
986: l_okl_strm_typ_allocs_h_rec.major_version,
987: l_okl_strm_typ_allocs_h_rec.cat_id,
988: l_okl_strm_typ_allocs_h_rec.sty_id,
989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,
990: l_okl_strm_typ_allocs_h_rec.object_version_number,
991: l_okl_strm_typ_allocs_h_rec.sequence_number,
992: l_okl_strm_typ_allocs_h_rec.attribute_category,

Line 989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,

985: l_okl_strm_typ_allocs_h_rec.id,
986: l_okl_strm_typ_allocs_h_rec.major_version,
987: l_okl_strm_typ_allocs_h_rec.cat_id,
988: l_okl_strm_typ_allocs_h_rec.sty_id,
989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,
990: l_okl_strm_typ_allocs_h_rec.object_version_number,
991: l_okl_strm_typ_allocs_h_rec.sequence_number,
992: l_okl_strm_typ_allocs_h_rec.attribute_category,
993: l_okl_strm_typ_allocs_h_rec.attribute1,

Line 990: l_okl_strm_typ_allocs_h_rec.object_version_number,

986: l_okl_strm_typ_allocs_h_rec.major_version,
987: l_okl_strm_typ_allocs_h_rec.cat_id,
988: l_okl_strm_typ_allocs_h_rec.sty_id,
989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,
990: l_okl_strm_typ_allocs_h_rec.object_version_number,
991: l_okl_strm_typ_allocs_h_rec.sequence_number,
992: l_okl_strm_typ_allocs_h_rec.attribute_category,
993: l_okl_strm_typ_allocs_h_rec.attribute1,
994: l_okl_strm_typ_allocs_h_rec.attribute2,

Line 991: l_okl_strm_typ_allocs_h_rec.sequence_number,

987: l_okl_strm_typ_allocs_h_rec.cat_id,
988: l_okl_strm_typ_allocs_h_rec.sty_id,
989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,
990: l_okl_strm_typ_allocs_h_rec.object_version_number,
991: l_okl_strm_typ_allocs_h_rec.sequence_number,
992: l_okl_strm_typ_allocs_h_rec.attribute_category,
993: l_okl_strm_typ_allocs_h_rec.attribute1,
994: l_okl_strm_typ_allocs_h_rec.attribute2,
995: l_okl_strm_typ_allocs_h_rec.attribute3,

Line 992: l_okl_strm_typ_allocs_h_rec.attribute_category,

988: l_okl_strm_typ_allocs_h_rec.sty_id,
989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,
990: l_okl_strm_typ_allocs_h_rec.object_version_number,
991: l_okl_strm_typ_allocs_h_rec.sequence_number,
992: l_okl_strm_typ_allocs_h_rec.attribute_category,
993: l_okl_strm_typ_allocs_h_rec.attribute1,
994: l_okl_strm_typ_allocs_h_rec.attribute2,
995: l_okl_strm_typ_allocs_h_rec.attribute3,
996: l_okl_strm_typ_allocs_h_rec.attribute4,

Line 993: l_okl_strm_typ_allocs_h_rec.attribute1,

989: l_okl_strm_typ_allocs_h_rec.stream_allc_type,
990: l_okl_strm_typ_allocs_h_rec.object_version_number,
991: l_okl_strm_typ_allocs_h_rec.sequence_number,
992: l_okl_strm_typ_allocs_h_rec.attribute_category,
993: l_okl_strm_typ_allocs_h_rec.attribute1,
994: l_okl_strm_typ_allocs_h_rec.attribute2,
995: l_okl_strm_typ_allocs_h_rec.attribute3,
996: l_okl_strm_typ_allocs_h_rec.attribute4,
997: l_okl_strm_typ_allocs_h_rec.attribute5,

Line 994: l_okl_strm_typ_allocs_h_rec.attribute2,

990: l_okl_strm_typ_allocs_h_rec.object_version_number,
991: l_okl_strm_typ_allocs_h_rec.sequence_number,
992: l_okl_strm_typ_allocs_h_rec.attribute_category,
993: l_okl_strm_typ_allocs_h_rec.attribute1,
994: l_okl_strm_typ_allocs_h_rec.attribute2,
995: l_okl_strm_typ_allocs_h_rec.attribute3,
996: l_okl_strm_typ_allocs_h_rec.attribute4,
997: l_okl_strm_typ_allocs_h_rec.attribute5,
998: l_okl_strm_typ_allocs_h_rec.attribute6,

Line 995: l_okl_strm_typ_allocs_h_rec.attribute3,

991: l_okl_strm_typ_allocs_h_rec.sequence_number,
992: l_okl_strm_typ_allocs_h_rec.attribute_category,
993: l_okl_strm_typ_allocs_h_rec.attribute1,
994: l_okl_strm_typ_allocs_h_rec.attribute2,
995: l_okl_strm_typ_allocs_h_rec.attribute3,
996: l_okl_strm_typ_allocs_h_rec.attribute4,
997: l_okl_strm_typ_allocs_h_rec.attribute5,
998: l_okl_strm_typ_allocs_h_rec.attribute6,
999: l_okl_strm_typ_allocs_h_rec.attribute7,

Line 996: l_okl_strm_typ_allocs_h_rec.attribute4,

992: l_okl_strm_typ_allocs_h_rec.attribute_category,
993: l_okl_strm_typ_allocs_h_rec.attribute1,
994: l_okl_strm_typ_allocs_h_rec.attribute2,
995: l_okl_strm_typ_allocs_h_rec.attribute3,
996: l_okl_strm_typ_allocs_h_rec.attribute4,
997: l_okl_strm_typ_allocs_h_rec.attribute5,
998: l_okl_strm_typ_allocs_h_rec.attribute6,
999: l_okl_strm_typ_allocs_h_rec.attribute7,
1000: l_okl_strm_typ_allocs_h_rec.attribute8,

Line 997: l_okl_strm_typ_allocs_h_rec.attribute5,

993: l_okl_strm_typ_allocs_h_rec.attribute1,
994: l_okl_strm_typ_allocs_h_rec.attribute2,
995: l_okl_strm_typ_allocs_h_rec.attribute3,
996: l_okl_strm_typ_allocs_h_rec.attribute4,
997: l_okl_strm_typ_allocs_h_rec.attribute5,
998: l_okl_strm_typ_allocs_h_rec.attribute6,
999: l_okl_strm_typ_allocs_h_rec.attribute7,
1000: l_okl_strm_typ_allocs_h_rec.attribute8,
1001: l_okl_strm_typ_allocs_h_rec.attribute9,

Line 998: l_okl_strm_typ_allocs_h_rec.attribute6,

994: l_okl_strm_typ_allocs_h_rec.attribute2,
995: l_okl_strm_typ_allocs_h_rec.attribute3,
996: l_okl_strm_typ_allocs_h_rec.attribute4,
997: l_okl_strm_typ_allocs_h_rec.attribute5,
998: l_okl_strm_typ_allocs_h_rec.attribute6,
999: l_okl_strm_typ_allocs_h_rec.attribute7,
1000: l_okl_strm_typ_allocs_h_rec.attribute8,
1001: l_okl_strm_typ_allocs_h_rec.attribute9,
1002: l_okl_strm_typ_allocs_h_rec.attribute10,

Line 999: l_okl_strm_typ_allocs_h_rec.attribute7,

995: l_okl_strm_typ_allocs_h_rec.attribute3,
996: l_okl_strm_typ_allocs_h_rec.attribute4,
997: l_okl_strm_typ_allocs_h_rec.attribute5,
998: l_okl_strm_typ_allocs_h_rec.attribute6,
999: l_okl_strm_typ_allocs_h_rec.attribute7,
1000: l_okl_strm_typ_allocs_h_rec.attribute8,
1001: l_okl_strm_typ_allocs_h_rec.attribute9,
1002: l_okl_strm_typ_allocs_h_rec.attribute10,
1003: l_okl_strm_typ_allocs_h_rec.attribute11,

Line 1000: l_okl_strm_typ_allocs_h_rec.attribute8,

996: l_okl_strm_typ_allocs_h_rec.attribute4,
997: l_okl_strm_typ_allocs_h_rec.attribute5,
998: l_okl_strm_typ_allocs_h_rec.attribute6,
999: l_okl_strm_typ_allocs_h_rec.attribute7,
1000: l_okl_strm_typ_allocs_h_rec.attribute8,
1001: l_okl_strm_typ_allocs_h_rec.attribute9,
1002: l_okl_strm_typ_allocs_h_rec.attribute10,
1003: l_okl_strm_typ_allocs_h_rec.attribute11,
1004: l_okl_strm_typ_allocs_h_rec.attribute12,

Line 1001: l_okl_strm_typ_allocs_h_rec.attribute9,

997: l_okl_strm_typ_allocs_h_rec.attribute5,
998: l_okl_strm_typ_allocs_h_rec.attribute6,
999: l_okl_strm_typ_allocs_h_rec.attribute7,
1000: l_okl_strm_typ_allocs_h_rec.attribute8,
1001: l_okl_strm_typ_allocs_h_rec.attribute9,
1002: l_okl_strm_typ_allocs_h_rec.attribute10,
1003: l_okl_strm_typ_allocs_h_rec.attribute11,
1004: l_okl_strm_typ_allocs_h_rec.attribute12,
1005: l_okl_strm_typ_allocs_h_rec.attribute13,

Line 1002: l_okl_strm_typ_allocs_h_rec.attribute10,

998: l_okl_strm_typ_allocs_h_rec.attribute6,
999: l_okl_strm_typ_allocs_h_rec.attribute7,
1000: l_okl_strm_typ_allocs_h_rec.attribute8,
1001: l_okl_strm_typ_allocs_h_rec.attribute9,
1002: l_okl_strm_typ_allocs_h_rec.attribute10,
1003: l_okl_strm_typ_allocs_h_rec.attribute11,
1004: l_okl_strm_typ_allocs_h_rec.attribute12,
1005: l_okl_strm_typ_allocs_h_rec.attribute13,
1006: l_okl_strm_typ_allocs_h_rec.attribute14,

Line 1003: l_okl_strm_typ_allocs_h_rec.attribute11,

999: l_okl_strm_typ_allocs_h_rec.attribute7,
1000: l_okl_strm_typ_allocs_h_rec.attribute8,
1001: l_okl_strm_typ_allocs_h_rec.attribute9,
1002: l_okl_strm_typ_allocs_h_rec.attribute10,
1003: l_okl_strm_typ_allocs_h_rec.attribute11,
1004: l_okl_strm_typ_allocs_h_rec.attribute12,
1005: l_okl_strm_typ_allocs_h_rec.attribute13,
1006: l_okl_strm_typ_allocs_h_rec.attribute14,
1007: l_okl_strm_typ_allocs_h_rec.attribute15,

Line 1004: l_okl_strm_typ_allocs_h_rec.attribute12,

1000: l_okl_strm_typ_allocs_h_rec.attribute8,
1001: l_okl_strm_typ_allocs_h_rec.attribute9,
1002: l_okl_strm_typ_allocs_h_rec.attribute10,
1003: l_okl_strm_typ_allocs_h_rec.attribute11,
1004: l_okl_strm_typ_allocs_h_rec.attribute12,
1005: l_okl_strm_typ_allocs_h_rec.attribute13,
1006: l_okl_strm_typ_allocs_h_rec.attribute14,
1007: l_okl_strm_typ_allocs_h_rec.attribute15,
1008: l_okl_strm_typ_allocs_h_rec.created_by,

Line 1005: l_okl_strm_typ_allocs_h_rec.attribute13,

1001: l_okl_strm_typ_allocs_h_rec.attribute9,
1002: l_okl_strm_typ_allocs_h_rec.attribute10,
1003: l_okl_strm_typ_allocs_h_rec.attribute11,
1004: l_okl_strm_typ_allocs_h_rec.attribute12,
1005: l_okl_strm_typ_allocs_h_rec.attribute13,
1006: l_okl_strm_typ_allocs_h_rec.attribute14,
1007: l_okl_strm_typ_allocs_h_rec.attribute15,
1008: l_okl_strm_typ_allocs_h_rec.created_by,
1009: l_okl_strm_typ_allocs_h_rec.creation_date,

Line 1006: l_okl_strm_typ_allocs_h_rec.attribute14,

1002: l_okl_strm_typ_allocs_h_rec.attribute10,
1003: l_okl_strm_typ_allocs_h_rec.attribute11,
1004: l_okl_strm_typ_allocs_h_rec.attribute12,
1005: l_okl_strm_typ_allocs_h_rec.attribute13,
1006: l_okl_strm_typ_allocs_h_rec.attribute14,
1007: l_okl_strm_typ_allocs_h_rec.attribute15,
1008: l_okl_strm_typ_allocs_h_rec.created_by,
1009: l_okl_strm_typ_allocs_h_rec.creation_date,
1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,

Line 1007: l_okl_strm_typ_allocs_h_rec.attribute15,

1003: l_okl_strm_typ_allocs_h_rec.attribute11,
1004: l_okl_strm_typ_allocs_h_rec.attribute12,
1005: l_okl_strm_typ_allocs_h_rec.attribute13,
1006: l_okl_strm_typ_allocs_h_rec.attribute14,
1007: l_okl_strm_typ_allocs_h_rec.attribute15,
1008: l_okl_strm_typ_allocs_h_rec.created_by,
1009: l_okl_strm_typ_allocs_h_rec.creation_date,
1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,
1011: l_okl_strm_typ_allocs_h_rec.last_update_date,

Line 1008: l_okl_strm_typ_allocs_h_rec.created_by,

1004: l_okl_strm_typ_allocs_h_rec.attribute12,
1005: l_okl_strm_typ_allocs_h_rec.attribute13,
1006: l_okl_strm_typ_allocs_h_rec.attribute14,
1007: l_okl_strm_typ_allocs_h_rec.attribute15,
1008: l_okl_strm_typ_allocs_h_rec.created_by,
1009: l_okl_strm_typ_allocs_h_rec.creation_date,
1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,
1011: l_okl_strm_typ_allocs_h_rec.last_update_date,
1012: l_okl_strm_typ_allocs_h_rec.last_update_login);

Line 1009: l_okl_strm_typ_allocs_h_rec.creation_date,

1005: l_okl_strm_typ_allocs_h_rec.attribute13,
1006: l_okl_strm_typ_allocs_h_rec.attribute14,
1007: l_okl_strm_typ_allocs_h_rec.attribute15,
1008: l_okl_strm_typ_allocs_h_rec.created_by,
1009: l_okl_strm_typ_allocs_h_rec.creation_date,
1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,
1011: l_okl_strm_typ_allocs_h_rec.last_update_date,
1012: l_okl_strm_typ_allocs_h_rec.last_update_login);
1013: -- Set OUT values

Line 1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,

1006: l_okl_strm_typ_allocs_h_rec.attribute14,
1007: l_okl_strm_typ_allocs_h_rec.attribute15,
1008: l_okl_strm_typ_allocs_h_rec.created_by,
1009: l_okl_strm_typ_allocs_h_rec.creation_date,
1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,
1011: l_okl_strm_typ_allocs_h_rec.last_update_date,
1012: l_okl_strm_typ_allocs_h_rec.last_update_login);
1013: -- Set OUT values
1014: x_okl_strm_typ_allocs_h_rec := l_okl_strm_typ_allocs_h_rec;

Line 1011: l_okl_strm_typ_allocs_h_rec.last_update_date,

1007: l_okl_strm_typ_allocs_h_rec.attribute15,
1008: l_okl_strm_typ_allocs_h_rec.created_by,
1009: l_okl_strm_typ_allocs_h_rec.creation_date,
1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,
1011: l_okl_strm_typ_allocs_h_rec.last_update_date,
1012: l_okl_strm_typ_allocs_h_rec.last_update_login);
1013: -- Set OUT values
1014: x_okl_strm_typ_allocs_h_rec := l_okl_strm_typ_allocs_h_rec;
1015: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1012: l_okl_strm_typ_allocs_h_rec.last_update_login);

1008: l_okl_strm_typ_allocs_h_rec.created_by,
1009: l_okl_strm_typ_allocs_h_rec.creation_date,
1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,
1011: l_okl_strm_typ_allocs_h_rec.last_update_date,
1012: l_okl_strm_typ_allocs_h_rec.last_update_login);
1013: -- Set OUT values
1014: x_okl_strm_typ_allocs_h_rec := l_okl_strm_typ_allocs_h_rec;
1015: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1016: EXCEPTION

Line 1014: x_okl_strm_typ_allocs_h_rec := l_okl_strm_typ_allocs_h_rec;

1010: l_okl_strm_typ_allocs_h_rec.last_updated_by,
1011: l_okl_strm_typ_allocs_h_rec.last_update_date,
1012: l_okl_strm_typ_allocs_h_rec.last_update_login);
1013: -- Set OUT values
1014: x_okl_strm_typ_allocs_h_rec := l_okl_strm_typ_allocs_h_rec;
1015: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1016: EXCEPTION
1017: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1018: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1051: -- insert_row for:OKL_STRM_TYP_ALLOCS --

1047: END insert_row;
1048: */
1049:
1050: ----------------------------------------
1051: -- insert_row for:OKL_STRM_TYP_ALLOCS --
1052: ----------------------------------------
1053: PROCEDURE insert_row(
1054: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1055: x_return_status OUT NOCOPY VARCHAR2,

Line 1067: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS --

1063: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1064: l_sta_rec sta_rec_type := p_sta_rec;
1065: l_def_sta_rec sta_rec_type;
1066: --------------------------------------------
1067: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS --
1068: --------------------------------------------
1069: FUNCTION Set_Attributes (
1070: p_sta_rec IN sta_rec_type,
1071: x_sta_rec OUT NOCOPY sta_rec_type

Line 1098: INSERT INTO OKL_STRM_TYP_ALLOCS(

1094: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1095: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1096: RAISE Okl_Api.G_EXCEPTION_ERROR;
1097: END IF;
1098: INSERT INTO OKL_STRM_TYP_ALLOCS(
1099: id,
1100: cat_id,
1101: sty_id,
1102: stream_allc_type,

Line 1190: -- insert_row for:OKL_STRM_TYP_ALLOCS_V --

1186: '_PVT'
1187: );
1188: END insert_row;
1189: ------------------------------------------
1190: -- insert_row for:OKL_STRM_TYP_ALLOCS_V --
1191: ------------------------------------------
1192: PROCEDURE insert_row(
1193: p_api_version IN NUMBER,
1194: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1224: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_V --

1220: l_stav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1221: RETURN(l_stav_rec);
1222: END fill_who_columns;
1223: ----------------------------------------------
1224: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_V --
1225: ----------------------------------------------
1226: FUNCTION Set_Attributes (
1227: p_stav_rec IN stav_rec_type,
1228: x_stav_rec OUT NOCOPY stav_rec_type

Line 1426: -- lock_row for:OKL_STRM_TYP_ALLOCS --

1422: ---------------------------------------------------------------------------
1423: -- PROCEDURE lock_row
1424: ---------------------------------------------------------------------------
1425: --------------------------------------
1426: -- lock_row for:OKL_STRM_TYP_ALLOCS --
1427: --------------------------------------
1428: PROCEDURE lock_row(
1429: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1430: x_return_status OUT NOCOPY VARCHAR2,

Line 1439: FROM OKL_STRM_TYP_ALLOCS

1435: E_Resource_Busy EXCEPTION;
1436: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1437: CURSOR lock_csr (p_sta_rec IN sta_rec_type) IS
1438: SELECT OBJECT_VERSION_NUMBER
1439: FROM OKL_STRM_TYP_ALLOCS
1440: WHERE ID = p_sta_rec.id
1441: AND OBJECT_VERSION_NUMBER = p_sta_rec.object_version_number
1442: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1443:

Line 1446: FROM OKL_STRM_TYP_ALLOCS

1442: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1443:
1444: CURSOR lchk_csr (p_sta_rec IN sta_rec_type) IS
1445: SELECT OBJECT_VERSION_NUMBER
1446: FROM OKL_STRM_TYP_ALLOCS
1447: WHERE ID = p_sta_rec.id;
1448: l_api_version CONSTANT NUMBER := 1;
1449: l_api_name CONSTANT VARCHAR2(30) := 'ALLOCS_lock_row';
1450: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1451: l_object_version_number OKL_STRM_TYP_ALLOCS.OBJECT_VERSION_NUMBER%TYPE;

1447: WHERE ID = p_sta_rec.id;
1448: l_api_version CONSTANT NUMBER := 1;
1449: l_api_name CONSTANT VARCHAR2(30) := 'ALLOCS_lock_row';
1450: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1451: l_object_version_number OKL_STRM_TYP_ALLOCS.OBJECT_VERSION_NUMBER%TYPE;
1452: lc_object_version_number OKL_STRM_TYP_ALLOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_row_notfound BOOLEAN := FALSE;
1454: lc_row_notfound BOOLEAN := FALSE;
1455: BEGIN

Line 1452: lc_object_version_number OKL_STRM_TYP_ALLOCS.OBJECT_VERSION_NUMBER%TYPE;

1448: l_api_version CONSTANT NUMBER := 1;
1449: l_api_name CONSTANT VARCHAR2(30) := 'ALLOCS_lock_row';
1450: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1451: l_object_version_number OKL_STRM_TYP_ALLOCS.OBJECT_VERSION_NUMBER%TYPE;
1452: lc_object_version_number OKL_STRM_TYP_ALLOCS.OBJECT_VERSION_NUMBER%TYPE;
1453: l_row_notfound BOOLEAN := FALSE;
1454: lc_row_notfound BOOLEAN := FALSE;
1455: BEGIN
1456: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1532: -- lock_row for:OKL_STRM_TYP_ALLOCS_V --

1528: '_PVT'
1529: );
1530: END lock_row;
1531: ----------------------------------------
1532: -- lock_row for:OKL_STRM_TYP_ALLOCS_V --
1533: ----------------------------------------
1534: PROCEDURE lock_row(
1535: p_api_version IN NUMBER,
1536: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1701: -- update_row for:OKL_STRM_TYP_ALLOCS --

1697: ---------------------------------------------------------------------------
1698: -- PROCEDURE update_row
1699: ---------------------------------------------------------------------------
1700: ----------------------------------------
1701: -- update_row for:OKL_STRM_TYP_ALLOCS --
1702: ----------------------------------------
1703: PROCEDURE update_row(
1704: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1705: x_return_status OUT NOCOPY VARCHAR2,

Line 1717: -- l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;

1713: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1714: l_sta_rec sta_rec_type := p_sta_rec;
1715: l_def_sta_rec sta_rec_type;
1716: l_row_notfound BOOLEAN := TRUE;
1717: -- l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;
1718: -- lx_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;
1719: ----------------------------------
1720: -- FUNCTION populate_new_record --
1721: ----------------------------------

Line 1718: -- lx_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;

1714: l_sta_rec sta_rec_type := p_sta_rec;
1715: l_def_sta_rec sta_rec_type;
1716: l_row_notfound BOOLEAN := TRUE;
1717: -- l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;
1718: -- lx_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;
1719: ----------------------------------
1720: -- FUNCTION populate_new_record --
1721: ----------------------------------
1722: FUNCTION populate_new_record (

Line 1739: -- migrate(l_sta_rec, l_okl_strm_typ_allocs_h_rec);

1735: END IF;
1736: -- Move the "old" record to the history record:
1737: -- (1) to get the "old" version
1738: -- (2) to avoid 2 hits to the database
1739: -- migrate(l_sta_rec, l_okl_strm_typ_allocs_h_rec);
1740: IF (x_sta_rec.id = Okl_Api.G_MISS_NUM)
1741: THEN
1742: x_sta_rec.id := l_sta_rec.id;
1743: END IF;

Line 1851: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS --

1847: END IF;
1848: RETURN(l_return_status);
1849: END populate_new_record;
1850: --------------------------------------------
1851: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS --
1852: --------------------------------------------
1853: FUNCTION Set_Attributes (
1854: p_sta_rec IN sta_rec_type,
1855: x_sta_rec OUT NOCOPY sta_rec_type

Line 1888: UPDATE OKL_STRM_TYP_ALLOCS

1884: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1886: RAISE Okl_Api.G_EXCEPTION_ERROR;
1887: END IF;
1888: UPDATE OKL_STRM_TYP_ALLOCS
1889: SET CAT_ID = l_def_sta_rec.cat_id,
1890: STY_ID = l_def_sta_rec.sty_id,
1891: STREAM_ALLC_TYPE = l_def_sta_rec.stream_allc_type,
1892: OBJECT_VERSION_NUMBER = l_def_sta_rec.object_version_number,

Line 1924: l_okl_strm_typ_allocs_h_rec,

1920: p_init_msg_list,
1921: x_return_status,
1922: x_msg_count,
1923: x_msg_data,
1924: l_okl_strm_typ_allocs_h_rec,
1925: lx_okl_strm_typ_allocs_h_rec
1926: );
1927: */
1928: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1925: lx_okl_strm_typ_allocs_h_rec

1921: x_return_status,
1922: x_msg_count,
1923: x_msg_data,
1924: l_okl_strm_typ_allocs_h_rec,
1925: lx_okl_strm_typ_allocs_h_rec
1926: );
1927: */
1928: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1968: -- update_row for:OKL_STRM_TYP_ALLOCS_V --

1964: '_PVT'
1965: );
1966: END update_row;
1967: ------------------------------------------
1968: -- update_row for:OKL_STRM_TYP_ALLOCS_V --
1969: ------------------------------------------
1970: PROCEDURE update_row(
1971: p_api_version IN NUMBER,
1972: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 2127: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_V --

2123: END IF;
2124: RETURN(l_return_status);
2125: END populate_new_record;
2126: ----------------------------------------------
2127: -- Set_Attributes for:OKL_STRM_TYP_ALLOCS_V --
2128: ----------------------------------------------
2129: FUNCTION Set_Attributes (
2130: p_stav_rec IN stav_rec_type,
2131: x_stav_rec OUT NOCOPY stav_rec_type

Line 2332: -- delete_row for:OKL_STRM_TYP_ALLOCS --

2328: ---------------------------------------------------------------------------
2329: -- PROCEDURE delete_row
2330: ---------------------------------------------------------------------------
2331: ----------------------------------------
2332: -- delete_row for:OKL_STRM_TYP_ALLOCS --
2333: ----------------------------------------
2334: PROCEDURE delete_row(
2335: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2336: x_return_status OUT NOCOPY VARCHAR2,

Line 2346: -- l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;

2342: l_api_name CONSTANT VARCHAR2(30) := 'ALLOCS_delete_row';
2343: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2344: l_sta_rec sta_rec_type:= p_sta_rec;
2345: l_row_notfound BOOLEAN := TRUE;
2346: -- l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;
2347: -- lx_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;
2348: BEGIN
2349: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2350: p_init_msg_list,

Line 2347: -- lx_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;

2343: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2344: l_sta_rec sta_rec_type:= p_sta_rec;
2345: l_row_notfound BOOLEAN := TRUE;
2346: -- l_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;
2347: -- lx_okl_strm_typ_allocs_h_rec okl_strm_typ_allocs_h_rec_type;
2348: BEGIN
2349: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2350: p_init_msg_list,
2351: '_PVT',

Line 2365: migrate(l_sta_rec, l_okl_strm_typ_allocs_h_rec);

2361: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2362: END IF;
2363:
2364: /*
2365: migrate(l_sta_rec, l_okl_strm_typ_allocs_h_rec);
2366: insert_row(
2367: p_init_msg_list,
2368: x_return_status,
2369: x_msg_count,

Line 2371: l_okl_strm_typ_allocs_h_rec,

2367: p_init_msg_list,
2368: x_return_status,
2369: x_msg_count,
2370: x_msg_data,
2371: l_okl_strm_typ_allocs_h_rec,
2372: lx_okl_strm_typ_allocs_h_rec
2373: );
2374: */
2375:

Line 2372: lx_okl_strm_typ_allocs_h_rec

2368: x_return_status,
2369: x_msg_count,
2370: x_msg_data,
2371: l_okl_strm_typ_allocs_h_rec,
2372: lx_okl_strm_typ_allocs_h_rec
2373: );
2374: */
2375:
2376: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2381: DELETE FROM OKL_STRM_TYP_ALLOCS

2377: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2378: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2379: RAISE Okl_Api.G_EXCEPTION_ERROR;
2380: END IF;
2381: DELETE FROM OKL_STRM_TYP_ALLOCS
2382: WHERE ID = l_sta_rec.id;
2383:
2384: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2385: EXCEPTION

Line 2418: -- delete_row for:OKL_STRM_TYP_ALLOCS_V --

2414: '_PVT'
2415: );
2416: END delete_row;
2417: ------------------------------------------
2418: -- delete_row for:OKL_STRM_TYP_ALLOCS_V --
2419: ------------------------------------------
2420: PROCEDURE delete_row(
2421: p_api_version IN NUMBER,
2422: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,