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_SST_PVT dependencies on OKL_SRCH_STRM_TYPS

Line 36: -- FUNCTION get_rec for: OKL_SRCH_STRM_TYPS

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

Line 70: FROM Okl_Srch_Strm_Typs

66: CREATION_DATE,
67: LAST_UPDATED_BY,
68: LAST_UPDATE_DATE,
69: LAST_UPDATE_LOGIN
70: FROM Okl_Srch_Strm_Typs
71: WHERE okl_srch_strm_typs.id = p_id;
72: l_sst_pk sst_pk_csr%ROWTYPE;
73: l_sst_rec sst_rec_type;
74: BEGIN

Line 71: WHERE okl_srch_strm_typs.id = p_id;

67: LAST_UPDATED_BY,
68: LAST_UPDATE_DATE,
69: LAST_UPDATE_LOGIN
70: FROM Okl_Srch_Strm_Typs
71: WHERE okl_srch_strm_typs.id = p_id;
72: l_sst_pk sst_pk_csr%ROWTYPE;
73: l_sst_rec sst_rec_type;
74: BEGIN
75: x_no_data_found := TRUE;

Line 118: -- FUNCTION get_rec for: OKL_SRCH_STRM_TYPS_V

114: BEGIN
115: RETURN(get_rec(p_sst_rec, l_row_notfound));
116: END get_rec;
117: ---------------------------------------------------------------------------
118: -- FUNCTION get_rec for: OKL_SRCH_STRM_TYPS_V
119: ---------------------------------------------------------------------------
120: FUNCTION get_rec (
121: p_sstv_rec IN sstv_rec_type,
122: x_no_data_found OUT NOCOPY BOOLEAN

Line 152: FROM Okl_Srch_Strm_Typs_V

148: CREATION_DATE,
149: LAST_UPDATED_BY,
150: LAST_UPDATE_DATE,
151: LAST_UPDATE_LOGIN
152: FROM Okl_Srch_Strm_Typs_V
153: WHERE okl_srch_strm_typs_v.id = p_id;
154: l_okl_sstv_pk okl_sstv_pk_csr%ROWTYPE;
155: l_sstv_rec sstv_rec_type;
156: BEGIN

Line 153: WHERE okl_srch_strm_typs_v.id = p_id;

149: LAST_UPDATED_BY,
150: LAST_UPDATE_DATE,
151: LAST_UPDATE_LOGIN
152: FROM Okl_Srch_Strm_Typs_V
153: WHERE okl_srch_strm_typs_v.id = p_id;
154: l_okl_sstv_pk okl_sstv_pk_csr%ROWTYPE;
155: l_sstv_rec sstv_rec_type;
156: BEGIN
157: x_no_data_found := TRUE;

Line 201: -- FUNCTION null_out_defaults for: OKL_SRCH_STRM_TYPS_V --

197: RETURN(get_rec(p_sstv_rec, l_row_notfound));
198: END get_rec;
199:
200: ----------------------------------------------------------
201: -- FUNCTION null_out_defaults for: OKL_SRCH_STRM_TYPS_V --
202: ----------------------------------------------------------
203: FUNCTION null_out_defaults (
204: p_sstv_rec IN sstv_rec_type
205: ) RETURN sstv_rec_type IS

Line 399: FROM okl_srch_strm_typs

395: FUNCTION IS_UNIQUE (p_sstv_rec sstv_rec_type) RETURN VARCHAR2
396: IS
397: CURSOR l_chr_csr IS
398: SELECT 'x'
399: FROM okl_srch_strm_typs
400: WHERE sty_id = p_sstv_rec.sty_id
401: AND cah_id = p_sstv_rec.cah_id
402: AND id <> NVL(p_sstv_rec.id,-99999);
403:

Line 439: -- Validate_Attributes for:OKL_SRCH_STRM_TYPS_V --

435: ---------------------------------------------------------------------------
436: -- PROCEDURE Validate_Attributes
437: ---------------------------------------------------------------------------
438: --------------------------------------------------
439: -- Validate_Attributes for:OKL_SRCH_STRM_TYPS_V --
440: --------------------------------------------------
441: FUNCTION Validate_Attributes (
442: p_sstv_rec IN sstv_rec_type
443: ) RETURN VARCHAR2 IS

Line 501: -- Validate_Record for:OKL_SRCH_STRM_TYPS_V --

497: ---------------------------------------------------------------------------
498: -- PROCEDURE Validate_Record
499: ---------------------------------------------------------------------------
500: ----------------------------------------------
501: -- Validate_Record for:OKL_SRCH_STRM_TYPS_V --
502: ----------------------------------------------
503:
504: --Added 04/23/2001 Bruno Vaghela ---
505:

Line 590: p_to IN OUT NOCOPY okl_srch_strm_typs_h_rec_type

586: END migrate;
587: /* -- history tables not supported -- 04 APR 2002
588: PROCEDURE migrate (
589: p_from IN sst_rec_type,
590: p_to IN OUT NOCOPY okl_srch_strm_typs_h_rec_type
591: ) IS
592: BEGIN
593: p_to.id := p_from.id;
594: p_to.sty_id := p_from.sty_id;

Line 625: -- validate_row for:OKL_SRCH_STRM_TYPS_V --

621: ---------------------------------------------------------------------------
622: -- PROCEDURE validate_row
623: ---------------------------------------------------------------------------
624: -------------------------------------------
625: -- validate_row for:OKL_SRCH_STRM_TYPS_V --
626: -------------------------------------------
627: PROCEDURE validate_row(
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 789: -- insert_row for:OKL_SRCH_STRM_TYPS_H --

785: ---------------------------------------------------------------------------
786: -- PROCEDURE insert_row
787: ---------------------------------------------------------------------------
788: -----------------------------------------
789: -- insert_row for:OKL_SRCH_STRM_TYPS_H --
790: -----------------------------------------
791: /* -- history tables not supported -- 04 APR 2002
792: PROCEDURE insert_row(
793: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 797: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,

793: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,
797: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,
798: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type) IS
799:
800: l_api_version CONSTANT NUMBER := 1;
801: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';

Line 798: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type) IS

794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,
797: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,
798: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type) IS
799:
800: l_api_version CONSTANT NUMBER := 1;
801: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
802: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 803: l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type := p_okl_srch_strm_typs_h_rec;

799:
800: l_api_version CONSTANT NUMBER := 1;
801: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
802: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
803: l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type := p_okl_srch_strm_typs_h_rec;
804: ldefoklsrchstrmtypshrec okl_srch_strm_typs_h_rec_type;
805: ---------------------------------------------
806: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_H --
807: ---------------------------------------------

Line 804: ldefoklsrchstrmtypshrec okl_srch_strm_typs_h_rec_type;

800: l_api_version CONSTANT NUMBER := 1;
801: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
802: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
803: l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type := p_okl_srch_strm_typs_h_rec;
804: ldefoklsrchstrmtypshrec okl_srch_strm_typs_h_rec_type;
805: ---------------------------------------------
806: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_H --
807: ---------------------------------------------
808: FUNCTION Set_Attributes (

Line 806: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_H --

802: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
803: l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type := p_okl_srch_strm_typs_h_rec;
804: ldefoklsrchstrmtypshrec okl_srch_strm_typs_h_rec_type;
805: ---------------------------------------------
806: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_H --
807: ---------------------------------------------
808: FUNCTION Set_Attributes (
809: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,
810: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type

Line 809: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,

805: ---------------------------------------------
806: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_H --
807: ---------------------------------------------
808: FUNCTION Set_Attributes (
809: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,
810: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type
811: ) RETURN VARCHAR2 IS
812: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
813: BEGIN

Line 810: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type

806: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_H --
807: ---------------------------------------------
808: FUNCTION Set_Attributes (
809: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,
810: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type
811: ) RETURN VARCHAR2 IS
812: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
813: BEGIN
814: x_okl_srch_strm_typs_h_rec := p_okl_srch_strm_typs_h_rec;

Line 814: x_okl_srch_strm_typs_h_rec := p_okl_srch_strm_typs_h_rec;

810: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type
811: ) RETURN VARCHAR2 IS
812: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
813: BEGIN
814: x_okl_srch_strm_typs_h_rec := p_okl_srch_strm_typs_h_rec;
815: RETURN(l_return_status);
816: END Set_Attributes;
817: BEGIN
818: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 829: p_okl_srch_strm_typs_h_rec, -- IN

825: RAISE Okl_Api.G_EXCEPTION_ERROR;
826: END IF;
827: --- Setting item attributes
828: l_return_status := Set_Attributes(
829: p_okl_srch_strm_typs_h_rec, -- IN
830: l_okl_srch_strm_typs_h_rec); -- OUT
831: --- If any errors happen abort API
832: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 830: l_okl_srch_strm_typs_h_rec); -- OUT

826: END IF;
827: --- Setting item attributes
828: l_return_status := Set_Attributes(
829: p_okl_srch_strm_typs_h_rec, -- IN
830: l_okl_srch_strm_typs_h_rec); -- OUT
831: --- If any errors happen abort API
832: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
834: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 837: INSERT INTO OKL_SRCH_STRM_TYPS_H(

833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
834: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
835: RAISE Okl_Api.G_EXCEPTION_ERROR;
836: END IF;
837: INSERT INTO OKL_SRCH_STRM_TYPS_H(
838: id,
839: major_version,
840: sty_id,
841: cah_id,

Line 866: l_okl_srch_strm_typs_h_rec.id,

862: last_updated_by,
863: last_update_date,
864: last_update_login)
865: VALUES (
866: l_okl_srch_strm_typs_h_rec.id,
867: l_okl_srch_strm_typs_h_rec.major_version,
868: l_okl_srch_strm_typs_h_rec.sty_id,
869: l_okl_srch_strm_typs_h_rec.cah_id,
870: l_okl_srch_strm_typs_h_rec.object_version_number,

Line 867: l_okl_srch_strm_typs_h_rec.major_version,

863: last_update_date,
864: last_update_login)
865: VALUES (
866: l_okl_srch_strm_typs_h_rec.id,
867: l_okl_srch_strm_typs_h_rec.major_version,
868: l_okl_srch_strm_typs_h_rec.sty_id,
869: l_okl_srch_strm_typs_h_rec.cah_id,
870: l_okl_srch_strm_typs_h_rec.object_version_number,
871: l_okl_srch_strm_typs_h_rec.add_yn,

Line 868: l_okl_srch_strm_typs_h_rec.sty_id,

864: last_update_login)
865: VALUES (
866: l_okl_srch_strm_typs_h_rec.id,
867: l_okl_srch_strm_typs_h_rec.major_version,
868: l_okl_srch_strm_typs_h_rec.sty_id,
869: l_okl_srch_strm_typs_h_rec.cah_id,
870: l_okl_srch_strm_typs_h_rec.object_version_number,
871: l_okl_srch_strm_typs_h_rec.add_yn,
872: l_okl_srch_strm_typs_h_rec.attribute_category,

Line 869: l_okl_srch_strm_typs_h_rec.cah_id,

865: VALUES (
866: l_okl_srch_strm_typs_h_rec.id,
867: l_okl_srch_strm_typs_h_rec.major_version,
868: l_okl_srch_strm_typs_h_rec.sty_id,
869: l_okl_srch_strm_typs_h_rec.cah_id,
870: l_okl_srch_strm_typs_h_rec.object_version_number,
871: l_okl_srch_strm_typs_h_rec.add_yn,
872: l_okl_srch_strm_typs_h_rec.attribute_category,
873: l_okl_srch_strm_typs_h_rec.attribute1,

Line 870: l_okl_srch_strm_typs_h_rec.object_version_number,

866: l_okl_srch_strm_typs_h_rec.id,
867: l_okl_srch_strm_typs_h_rec.major_version,
868: l_okl_srch_strm_typs_h_rec.sty_id,
869: l_okl_srch_strm_typs_h_rec.cah_id,
870: l_okl_srch_strm_typs_h_rec.object_version_number,
871: l_okl_srch_strm_typs_h_rec.add_yn,
872: l_okl_srch_strm_typs_h_rec.attribute_category,
873: l_okl_srch_strm_typs_h_rec.attribute1,
874: l_okl_srch_strm_typs_h_rec.attribute2,

Line 871: l_okl_srch_strm_typs_h_rec.add_yn,

867: l_okl_srch_strm_typs_h_rec.major_version,
868: l_okl_srch_strm_typs_h_rec.sty_id,
869: l_okl_srch_strm_typs_h_rec.cah_id,
870: l_okl_srch_strm_typs_h_rec.object_version_number,
871: l_okl_srch_strm_typs_h_rec.add_yn,
872: l_okl_srch_strm_typs_h_rec.attribute_category,
873: l_okl_srch_strm_typs_h_rec.attribute1,
874: l_okl_srch_strm_typs_h_rec.attribute2,
875: l_okl_srch_strm_typs_h_rec.attribute3,

Line 872: l_okl_srch_strm_typs_h_rec.attribute_category,

868: l_okl_srch_strm_typs_h_rec.sty_id,
869: l_okl_srch_strm_typs_h_rec.cah_id,
870: l_okl_srch_strm_typs_h_rec.object_version_number,
871: l_okl_srch_strm_typs_h_rec.add_yn,
872: l_okl_srch_strm_typs_h_rec.attribute_category,
873: l_okl_srch_strm_typs_h_rec.attribute1,
874: l_okl_srch_strm_typs_h_rec.attribute2,
875: l_okl_srch_strm_typs_h_rec.attribute3,
876: l_okl_srch_strm_typs_h_rec.attribute4,

Line 873: l_okl_srch_strm_typs_h_rec.attribute1,

869: l_okl_srch_strm_typs_h_rec.cah_id,
870: l_okl_srch_strm_typs_h_rec.object_version_number,
871: l_okl_srch_strm_typs_h_rec.add_yn,
872: l_okl_srch_strm_typs_h_rec.attribute_category,
873: l_okl_srch_strm_typs_h_rec.attribute1,
874: l_okl_srch_strm_typs_h_rec.attribute2,
875: l_okl_srch_strm_typs_h_rec.attribute3,
876: l_okl_srch_strm_typs_h_rec.attribute4,
877: l_okl_srch_strm_typs_h_rec.attribute5,

Line 874: l_okl_srch_strm_typs_h_rec.attribute2,

870: l_okl_srch_strm_typs_h_rec.object_version_number,
871: l_okl_srch_strm_typs_h_rec.add_yn,
872: l_okl_srch_strm_typs_h_rec.attribute_category,
873: l_okl_srch_strm_typs_h_rec.attribute1,
874: l_okl_srch_strm_typs_h_rec.attribute2,
875: l_okl_srch_strm_typs_h_rec.attribute3,
876: l_okl_srch_strm_typs_h_rec.attribute4,
877: l_okl_srch_strm_typs_h_rec.attribute5,
878: l_okl_srch_strm_typs_h_rec.attribute6,

Line 875: l_okl_srch_strm_typs_h_rec.attribute3,

871: l_okl_srch_strm_typs_h_rec.add_yn,
872: l_okl_srch_strm_typs_h_rec.attribute_category,
873: l_okl_srch_strm_typs_h_rec.attribute1,
874: l_okl_srch_strm_typs_h_rec.attribute2,
875: l_okl_srch_strm_typs_h_rec.attribute3,
876: l_okl_srch_strm_typs_h_rec.attribute4,
877: l_okl_srch_strm_typs_h_rec.attribute5,
878: l_okl_srch_strm_typs_h_rec.attribute6,
879: l_okl_srch_strm_typs_h_rec.attribute7,

Line 876: l_okl_srch_strm_typs_h_rec.attribute4,

872: l_okl_srch_strm_typs_h_rec.attribute_category,
873: l_okl_srch_strm_typs_h_rec.attribute1,
874: l_okl_srch_strm_typs_h_rec.attribute2,
875: l_okl_srch_strm_typs_h_rec.attribute3,
876: l_okl_srch_strm_typs_h_rec.attribute4,
877: l_okl_srch_strm_typs_h_rec.attribute5,
878: l_okl_srch_strm_typs_h_rec.attribute6,
879: l_okl_srch_strm_typs_h_rec.attribute7,
880: l_okl_srch_strm_typs_h_rec.attribute8,

Line 877: l_okl_srch_strm_typs_h_rec.attribute5,

873: l_okl_srch_strm_typs_h_rec.attribute1,
874: l_okl_srch_strm_typs_h_rec.attribute2,
875: l_okl_srch_strm_typs_h_rec.attribute3,
876: l_okl_srch_strm_typs_h_rec.attribute4,
877: l_okl_srch_strm_typs_h_rec.attribute5,
878: l_okl_srch_strm_typs_h_rec.attribute6,
879: l_okl_srch_strm_typs_h_rec.attribute7,
880: l_okl_srch_strm_typs_h_rec.attribute8,
881: l_okl_srch_strm_typs_h_rec.attribute9,

Line 878: l_okl_srch_strm_typs_h_rec.attribute6,

874: l_okl_srch_strm_typs_h_rec.attribute2,
875: l_okl_srch_strm_typs_h_rec.attribute3,
876: l_okl_srch_strm_typs_h_rec.attribute4,
877: l_okl_srch_strm_typs_h_rec.attribute5,
878: l_okl_srch_strm_typs_h_rec.attribute6,
879: l_okl_srch_strm_typs_h_rec.attribute7,
880: l_okl_srch_strm_typs_h_rec.attribute8,
881: l_okl_srch_strm_typs_h_rec.attribute9,
882: l_okl_srch_strm_typs_h_rec.attribute10,

Line 879: l_okl_srch_strm_typs_h_rec.attribute7,

875: l_okl_srch_strm_typs_h_rec.attribute3,
876: l_okl_srch_strm_typs_h_rec.attribute4,
877: l_okl_srch_strm_typs_h_rec.attribute5,
878: l_okl_srch_strm_typs_h_rec.attribute6,
879: l_okl_srch_strm_typs_h_rec.attribute7,
880: l_okl_srch_strm_typs_h_rec.attribute8,
881: l_okl_srch_strm_typs_h_rec.attribute9,
882: l_okl_srch_strm_typs_h_rec.attribute10,
883: l_okl_srch_strm_typs_h_rec.attribute11,

Line 880: l_okl_srch_strm_typs_h_rec.attribute8,

876: l_okl_srch_strm_typs_h_rec.attribute4,
877: l_okl_srch_strm_typs_h_rec.attribute5,
878: l_okl_srch_strm_typs_h_rec.attribute6,
879: l_okl_srch_strm_typs_h_rec.attribute7,
880: l_okl_srch_strm_typs_h_rec.attribute8,
881: l_okl_srch_strm_typs_h_rec.attribute9,
882: l_okl_srch_strm_typs_h_rec.attribute10,
883: l_okl_srch_strm_typs_h_rec.attribute11,
884: l_okl_srch_strm_typs_h_rec.attribute12,

Line 881: l_okl_srch_strm_typs_h_rec.attribute9,

877: l_okl_srch_strm_typs_h_rec.attribute5,
878: l_okl_srch_strm_typs_h_rec.attribute6,
879: l_okl_srch_strm_typs_h_rec.attribute7,
880: l_okl_srch_strm_typs_h_rec.attribute8,
881: l_okl_srch_strm_typs_h_rec.attribute9,
882: l_okl_srch_strm_typs_h_rec.attribute10,
883: l_okl_srch_strm_typs_h_rec.attribute11,
884: l_okl_srch_strm_typs_h_rec.attribute12,
885: l_okl_srch_strm_typs_h_rec.attribute13,

Line 882: l_okl_srch_strm_typs_h_rec.attribute10,

878: l_okl_srch_strm_typs_h_rec.attribute6,
879: l_okl_srch_strm_typs_h_rec.attribute7,
880: l_okl_srch_strm_typs_h_rec.attribute8,
881: l_okl_srch_strm_typs_h_rec.attribute9,
882: l_okl_srch_strm_typs_h_rec.attribute10,
883: l_okl_srch_strm_typs_h_rec.attribute11,
884: l_okl_srch_strm_typs_h_rec.attribute12,
885: l_okl_srch_strm_typs_h_rec.attribute13,
886: l_okl_srch_strm_typs_h_rec.attribute14,

Line 883: l_okl_srch_strm_typs_h_rec.attribute11,

879: l_okl_srch_strm_typs_h_rec.attribute7,
880: l_okl_srch_strm_typs_h_rec.attribute8,
881: l_okl_srch_strm_typs_h_rec.attribute9,
882: l_okl_srch_strm_typs_h_rec.attribute10,
883: l_okl_srch_strm_typs_h_rec.attribute11,
884: l_okl_srch_strm_typs_h_rec.attribute12,
885: l_okl_srch_strm_typs_h_rec.attribute13,
886: l_okl_srch_strm_typs_h_rec.attribute14,
887: l_okl_srch_strm_typs_h_rec.attribute15,

Line 884: l_okl_srch_strm_typs_h_rec.attribute12,

880: l_okl_srch_strm_typs_h_rec.attribute8,
881: l_okl_srch_strm_typs_h_rec.attribute9,
882: l_okl_srch_strm_typs_h_rec.attribute10,
883: l_okl_srch_strm_typs_h_rec.attribute11,
884: l_okl_srch_strm_typs_h_rec.attribute12,
885: l_okl_srch_strm_typs_h_rec.attribute13,
886: l_okl_srch_strm_typs_h_rec.attribute14,
887: l_okl_srch_strm_typs_h_rec.attribute15,
888: l_okl_srch_strm_typs_h_rec.created_by,

Line 885: l_okl_srch_strm_typs_h_rec.attribute13,

881: l_okl_srch_strm_typs_h_rec.attribute9,
882: l_okl_srch_strm_typs_h_rec.attribute10,
883: l_okl_srch_strm_typs_h_rec.attribute11,
884: l_okl_srch_strm_typs_h_rec.attribute12,
885: l_okl_srch_strm_typs_h_rec.attribute13,
886: l_okl_srch_strm_typs_h_rec.attribute14,
887: l_okl_srch_strm_typs_h_rec.attribute15,
888: l_okl_srch_strm_typs_h_rec.created_by,
889: l_okl_srch_strm_typs_h_rec.creation_date,

Line 886: l_okl_srch_strm_typs_h_rec.attribute14,

882: l_okl_srch_strm_typs_h_rec.attribute10,
883: l_okl_srch_strm_typs_h_rec.attribute11,
884: l_okl_srch_strm_typs_h_rec.attribute12,
885: l_okl_srch_strm_typs_h_rec.attribute13,
886: l_okl_srch_strm_typs_h_rec.attribute14,
887: l_okl_srch_strm_typs_h_rec.attribute15,
888: l_okl_srch_strm_typs_h_rec.created_by,
889: l_okl_srch_strm_typs_h_rec.creation_date,
890: l_okl_srch_strm_typs_h_rec.last_updated_by,

Line 887: l_okl_srch_strm_typs_h_rec.attribute15,

883: l_okl_srch_strm_typs_h_rec.attribute11,
884: l_okl_srch_strm_typs_h_rec.attribute12,
885: l_okl_srch_strm_typs_h_rec.attribute13,
886: l_okl_srch_strm_typs_h_rec.attribute14,
887: l_okl_srch_strm_typs_h_rec.attribute15,
888: l_okl_srch_strm_typs_h_rec.created_by,
889: l_okl_srch_strm_typs_h_rec.creation_date,
890: l_okl_srch_strm_typs_h_rec.last_updated_by,
891: l_okl_srch_strm_typs_h_rec.last_update_date,

Line 888: l_okl_srch_strm_typs_h_rec.created_by,

884: l_okl_srch_strm_typs_h_rec.attribute12,
885: l_okl_srch_strm_typs_h_rec.attribute13,
886: l_okl_srch_strm_typs_h_rec.attribute14,
887: l_okl_srch_strm_typs_h_rec.attribute15,
888: l_okl_srch_strm_typs_h_rec.created_by,
889: l_okl_srch_strm_typs_h_rec.creation_date,
890: l_okl_srch_strm_typs_h_rec.last_updated_by,
891: l_okl_srch_strm_typs_h_rec.last_update_date,
892: l_okl_srch_strm_typs_h_rec.last_update_login);

Line 889: l_okl_srch_strm_typs_h_rec.creation_date,

885: l_okl_srch_strm_typs_h_rec.attribute13,
886: l_okl_srch_strm_typs_h_rec.attribute14,
887: l_okl_srch_strm_typs_h_rec.attribute15,
888: l_okl_srch_strm_typs_h_rec.created_by,
889: l_okl_srch_strm_typs_h_rec.creation_date,
890: l_okl_srch_strm_typs_h_rec.last_updated_by,
891: l_okl_srch_strm_typs_h_rec.last_update_date,
892: l_okl_srch_strm_typs_h_rec.last_update_login);
893: -- Set OUT values

Line 890: l_okl_srch_strm_typs_h_rec.last_updated_by,

886: l_okl_srch_strm_typs_h_rec.attribute14,
887: l_okl_srch_strm_typs_h_rec.attribute15,
888: l_okl_srch_strm_typs_h_rec.created_by,
889: l_okl_srch_strm_typs_h_rec.creation_date,
890: l_okl_srch_strm_typs_h_rec.last_updated_by,
891: l_okl_srch_strm_typs_h_rec.last_update_date,
892: l_okl_srch_strm_typs_h_rec.last_update_login);
893: -- Set OUT values
894: x_okl_srch_strm_typs_h_rec := l_okl_srch_strm_typs_h_rec;

Line 891: l_okl_srch_strm_typs_h_rec.last_update_date,

887: l_okl_srch_strm_typs_h_rec.attribute15,
888: l_okl_srch_strm_typs_h_rec.created_by,
889: l_okl_srch_strm_typs_h_rec.creation_date,
890: l_okl_srch_strm_typs_h_rec.last_updated_by,
891: l_okl_srch_strm_typs_h_rec.last_update_date,
892: l_okl_srch_strm_typs_h_rec.last_update_login);
893: -- Set OUT values
894: x_okl_srch_strm_typs_h_rec := l_okl_srch_strm_typs_h_rec;
895: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 892: l_okl_srch_strm_typs_h_rec.last_update_login);

888: l_okl_srch_strm_typs_h_rec.created_by,
889: l_okl_srch_strm_typs_h_rec.creation_date,
890: l_okl_srch_strm_typs_h_rec.last_updated_by,
891: l_okl_srch_strm_typs_h_rec.last_update_date,
892: l_okl_srch_strm_typs_h_rec.last_update_login);
893: -- Set OUT values
894: x_okl_srch_strm_typs_h_rec := l_okl_srch_strm_typs_h_rec;
895: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION

Line 894: x_okl_srch_strm_typs_h_rec := l_okl_srch_strm_typs_h_rec;

890: l_okl_srch_strm_typs_h_rec.last_updated_by,
891: l_okl_srch_strm_typs_h_rec.last_update_date,
892: l_okl_srch_strm_typs_h_rec.last_update_login);
893: -- Set OUT values
894: x_okl_srch_strm_typs_h_rec := l_okl_srch_strm_typs_h_rec;
895: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION
897: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
898: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 931: -- insert_row for:OKL_SRCH_STRM_TYPS --

927: END insert_row;
928: */ -- history tables not supported -- 04 APR 2002
929:
930: ---------------------------------------
931: -- insert_row for:OKL_SRCH_STRM_TYPS --
932: ---------------------------------------
933: PROCEDURE insert_row(
934: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
935: x_return_status OUT NOCOPY VARCHAR2,

Line 947: -- Set_Attributes for:OKL_SRCH_STRM_TYPS --

943: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
944: l_sst_rec sst_rec_type := p_sst_rec;
945: l_def_sst_rec sst_rec_type;
946: -------------------------------------------
947: -- Set_Attributes for:OKL_SRCH_STRM_TYPS --
948: -------------------------------------------
949: FUNCTION Set_Attributes (
950: p_sst_rec IN sst_rec_type,
951: x_sst_rec OUT NOCOPY sst_rec_type

Line 978: INSERT INTO OKL_SRCH_STRM_TYPS(

974: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
975: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
976: RAISE Okl_Api.G_EXCEPTION_ERROR;
977: END IF;
978: INSERT INTO OKL_SRCH_STRM_TYPS(
979: id,
980: sty_id,
981: cah_id,
982: object_version_number,

Line 1080: -- insert_row for:OKL_SRCH_STRM_TYPS_V --

1076: );
1077: */
1078: END insert_row;
1079: -----------------------------------------
1080: -- insert_row for:OKL_SRCH_STRM_TYPS_V --
1081: -----------------------------------------
1082: PROCEDURE insert_row(
1083: p_api_version IN NUMBER,
1084: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1114: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_V --

1110: l_sstv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1111: RETURN(l_sstv_rec);
1112: END fill_who_columns;
1113: ---------------------------------------------
1114: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_V --
1115: ---------------------------------------------
1116: FUNCTION Set_Attributes (
1117: p_sstv_rec IN sstv_rec_type,
1118: x_sstv_rec OUT NOCOPY sstv_rec_type

Line 1327: -- lock_row for:OKL_SRCH_STRM_TYPS --

1323: ---------------------------------------------------------------------------
1324: -- PROCEDURE lock_row
1325: ---------------------------------------------------------------------------
1326: -------------------------------------
1327: -- lock_row for:OKL_SRCH_STRM_TYPS --
1328: -------------------------------------
1329: PROCEDURE lock_row(
1330: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1331: x_return_status OUT NOCOPY VARCHAR2,

Line 1340: FROM OKL_SRCH_STRM_TYPS

1336: E_Resource_Busy EXCEPTION;
1337: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1338: CURSOR lock_csr (p_sst_rec IN sst_rec_type) IS
1339: SELECT OBJECT_VERSION_NUMBER
1340: FROM OKL_SRCH_STRM_TYPS
1341: WHERE ID = p_sst_rec.id
1342: AND OBJECT_VERSION_NUMBER = p_sst_rec.object_version_number
1343: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1344:

Line 1347: FROM OKL_SRCH_STRM_TYPS

1343: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1344:
1345: CURSOR lchk_csr (p_sst_rec IN sst_rec_type) IS
1346: SELECT OBJECT_VERSION_NUMBER
1347: FROM OKL_SRCH_STRM_TYPS
1348: WHERE ID = p_sst_rec.id;
1349: l_api_version CONSTANT NUMBER := 1;
1350: l_api_name CONSTANT VARCHAR2(30) := 'TYPS_lock_row';
1351: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1352: l_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;

1348: WHERE ID = p_sst_rec.id;
1349: l_api_version CONSTANT NUMBER := 1;
1350: l_api_name CONSTANT VARCHAR2(30) := 'TYPS_lock_row';
1351: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1352: l_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;
1353: lc_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;
1354: l_row_notfound BOOLEAN := FALSE;
1355: lc_row_notfound BOOLEAN := FALSE;
1356: BEGIN

Line 1353: lc_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;

1349: l_api_version CONSTANT NUMBER := 1;
1350: l_api_name CONSTANT VARCHAR2(30) := 'TYPS_lock_row';
1351: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1352: l_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;
1353: lc_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;
1354: l_row_notfound BOOLEAN := FALSE;
1355: lc_row_notfound BOOLEAN := FALSE;
1356: BEGIN
1357: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1433: -- lock_row for:OKL_SRCH_STRM_TYPS_V --

1429: '_PVT'
1430: );
1431: END lock_row;
1432: ---------------------------------------
1433: -- lock_row for:OKL_SRCH_STRM_TYPS_V --
1434: ---------------------------------------
1435: PROCEDURE lock_row(
1436: p_api_version IN NUMBER,
1437: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1602: -- update_row for:OKL_SRCH_STRM_TYPS --

1598: ---------------------------------------------------------------------------
1599: -- PROCEDURE update_row
1600: ---------------------------------------------------------------------------
1601: ---------------------------------------
1602: -- update_row for:OKL_SRCH_STRM_TYPS --
1603: ---------------------------------------
1604: PROCEDURE update_row(
1605: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1606: x_return_status OUT NOCOPY VARCHAR2,

Line 1619: -- l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;

1615: l_sst_rec sst_rec_type := p_sst_rec;
1616: l_def_sst_rec sst_rec_type;
1617: l_row_notfound BOOLEAN := TRUE;
1618: -- history tables not supported -- 04 APR 2002
1619: -- l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
1620: -- lx_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
1621: ----------------------------------
1622: -- FUNCTION populate_new_record --
1623: ----------------------------------

Line 1620: -- lx_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;

1616: l_def_sst_rec sst_rec_type;
1617: l_row_notfound BOOLEAN := TRUE;
1618: -- history tables not supported -- 04 APR 2002
1619: -- l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
1620: -- lx_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
1621: ----------------------------------
1622: -- FUNCTION populate_new_record --
1623: ----------------------------------
1624: FUNCTION populate_new_record (

Line 1641: -- migrate(l_sst_rec, l_okl_srch_strm_typs_h_rec);

1637: END IF;
1638: -- Move the "old" record to the history record:
1639: -- (1) to get the "old" version
1640: -- (2) to avoid 2 hits to the database
1641: -- migrate(l_sst_rec, l_okl_srch_strm_typs_h_rec);
1642: IF (x_sst_rec.id = Okl_Api.G_MISS_NUM)
1643: THEN
1644: x_sst_rec.id := l_sst_rec.id;
1645: END IF;

Line 1749: -- Set_Attributes for:OKL_SRCH_STRM_TYPS --

1745: END IF;
1746: RETURN(l_return_status);
1747: END populate_new_record;
1748: -------------------------------------------
1749: -- Set_Attributes for:OKL_SRCH_STRM_TYPS --
1750: -------------------------------------------
1751: FUNCTION Set_Attributes (
1752: p_sst_rec IN sst_rec_type,
1753: x_sst_rec OUT NOCOPY sst_rec_type

Line 1786: UPDATE OKL_SRCH_STRM_TYPS

1782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1784: RAISE Okl_Api.G_EXCEPTION_ERROR;
1785: END IF;
1786: UPDATE OKL_SRCH_STRM_TYPS
1787: SET STY_ID = l_def_sst_rec.sty_id,
1788: CAH_ID = l_def_sst_rec.cah_id,
1789: OBJECT_VERSION_NUMBER = l_def_sst_rec.object_version_number,
1790: ADD_YN = l_def_sst_rec.add_yn,

Line 1821: l_okl_srch_strm_typs_h_rec,

1817: p_init_msg_list,
1818: x_return_status,
1819: x_msg_count,
1820: x_msg_data,
1821: l_okl_srch_strm_typs_h_rec,
1822: lx_okl_srch_strm_typs_h_rec
1823: );
1824: */
1825: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1822: lx_okl_srch_strm_typs_h_rec

1818: x_return_status,
1819: x_msg_count,
1820: x_msg_data,
1821: l_okl_srch_strm_typs_h_rec,
1822: lx_okl_srch_strm_typs_h_rec
1823: );
1824: */
1825: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1865: -- update_row for:OKL_SRCH_STRM_TYPS_V --

1861: '_PVT'
1862: );
1863: END update_row;
1864: -----------------------------------------
1865: -- update_row for:OKL_SRCH_STRM_TYPS_V --
1866: -----------------------------------------
1867: PROCEDURE update_row(
1868: p_api_version IN NUMBER,
1869: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 2020: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_V --

2016: END IF;
2017: RETURN(l_return_status);
2018: END populate_new_record;
2019: ---------------------------------------------
2020: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_V --
2021: ---------------------------------------------
2022: FUNCTION Set_Attributes (
2023: p_sstv_rec IN sstv_rec_type,
2024: x_sstv_rec OUT NOCOPY sstv_rec_type

Line 2223: -- delete_row for:OKL_SRCH_STRM_TYPS --

2219: ---------------------------------------------------------------------------
2220: -- PROCEDURE delete_row
2221: ---------------------------------------------------------------------------
2222: ---------------------------------------
2223: -- delete_row for:OKL_SRCH_STRM_TYPS --
2224: ---------------------------------------
2225: PROCEDURE delete_row(
2226: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2227: x_return_status OUT NOCOPY VARCHAR2,

Line 2239: -- l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;

2235: l_sst_rec sst_rec_type:= p_sst_rec;
2236: l_row_notfound BOOLEAN := TRUE;
2237:
2238: -- history tables not supported -- 04 APR 2002
2239: -- l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
2240: -- lx_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
2241:
2242: BEGIN
2243: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2240: -- lx_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;

2236: l_row_notfound BOOLEAN := TRUE;
2237:
2238: -- history tables not supported -- 04 APR 2002
2239: -- l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
2240: -- lx_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
2241:
2242: BEGIN
2243: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2244: p_init_msg_list,

Line 2258: migrate(l_sst_rec, l_okl_srch_strm_typs_h_rec);

2254: l_sst_rec := get_rec(l_sst_rec, l_row_notfound);
2255: IF (l_row_notfound) THEN
2256: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2257: END IF;
2258: migrate(l_sst_rec, l_okl_srch_strm_typs_h_rec);
2259: insert_row(
2260: p_init_msg_list,
2261: x_return_status,
2262: x_msg_count,

Line 2264: l_okl_srch_strm_typs_h_rec,

2260: p_init_msg_list,
2261: x_return_status,
2262: x_msg_count,
2263: x_msg_data,
2264: l_okl_srch_strm_typs_h_rec,
2265: lx_okl_srch_strm_typs_h_rec
2266: );
2267: */
2268: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2265: lx_okl_srch_strm_typs_h_rec

2261: x_return_status,
2262: x_msg_count,
2263: x_msg_data,
2264: l_okl_srch_strm_typs_h_rec,
2265: lx_okl_srch_strm_typs_h_rec
2266: );
2267: */
2268: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2269: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2273: DELETE FROM OKL_SRCH_STRM_TYPS

2269: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2270: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2271: RAISE Okl_Api.G_EXCEPTION_ERROR;
2272: END IF;
2273: DELETE FROM OKL_SRCH_STRM_TYPS
2274: WHERE ID = l_sst_rec.id;
2275:
2276: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2277: EXCEPTION

Line 2310: -- delete_row for:OKL_SRCH_STRM_TYPS_V --

2306: '_PVT'
2307: );
2308: END delete_row;
2309: -----------------------------------------
2310: -- delete_row for:OKL_SRCH_STRM_TYPS_V --
2311: -----------------------------------------
2312: PROCEDURE delete_row(
2313: p_api_version IN NUMBER,
2314: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,