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_CAH_PVT dependencies on OKL_CSH_ALLCT_SRCHS

Line 36: -- FUNCTION get_rec for: OKL_CSH_ALLCT_SRCHS

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

Line 72: FROM Okl_Csh_Allct_Srchs

68: CREATION_DATE,
69: LAST_UPDATED_BY,
70: LAST_UPDATE_DATE,
71: LAST_UPDATE_LOGIN
72: FROM Okl_Csh_Allct_Srchs
73: WHERE okl_csh_allct_srchs.id = p_id;
74: l_cah_pk cah_pk_csr%ROWTYPE;
75: l_cah_rec cah_rec_type;
76: BEGIN

Line 73: WHERE okl_csh_allct_srchs.id = p_id;

69: LAST_UPDATED_BY,
70: LAST_UPDATE_DATE,
71: LAST_UPDATE_LOGIN
72: FROM Okl_Csh_Allct_Srchs
73: WHERE okl_csh_allct_srchs.id = p_id;
74: l_cah_pk cah_pk_csr%ROWTYPE;
75: l_cah_rec cah_rec_type;
76: BEGIN
77: x_no_data_found := TRUE;

Line 122: -- FUNCTION get_rec for: OKL_CSH_ALLCT_SRCHS_V

118: BEGIN
119: RETURN(get_rec(p_cah_rec, l_row_notfound));
120: END get_rec;
121: ---------------------------------------------------------------------------
122: -- FUNCTION get_rec for: OKL_CSH_ALLCT_SRCHS_V
123: ---------------------------------------------------------------------------
124: FUNCTION get_rec (
125: p_cahv_rec IN cahv_rec_type,
126: x_no_data_found OUT NOCOPY BOOLEAN

Line 158: FROM OKL_CSH_ALLCT_SRCHS

154: CREATION_DATE,
155: LAST_UPDATED_BY,
156: LAST_UPDATE_DATE,
157: LAST_UPDATE_LOGIN
158: FROM OKL_CSH_ALLCT_SRCHS
159: WHERE OKL_CSH_ALLCT_SRCHS.id = p_id;
160: l_okl_cahv_pk okl_cahv_pk_csr%ROWTYPE;
161: l_cahv_rec cahv_rec_type;
162: BEGIN

Line 159: WHERE OKL_CSH_ALLCT_SRCHS.id = p_id;

155: LAST_UPDATED_BY,
156: LAST_UPDATE_DATE,
157: LAST_UPDATE_LOGIN
158: FROM OKL_CSH_ALLCT_SRCHS
159: WHERE OKL_CSH_ALLCT_SRCHS.id = p_id;
160: l_okl_cahv_pk okl_cahv_pk_csr%ROWTYPE;
161: l_cahv_rec cahv_rec_type;
162: BEGIN
163: x_no_data_found := TRUE;

Line 209: -- FUNCTION null_out_defaults for: OKL_CSH_ALLCT_SRCHS_V --

205: RETURN(get_rec(p_cahv_rec, l_row_notfound));
206: END get_rec;
207:
208: -----------------------------------------------------------
209: -- FUNCTION null_out_defaults for: OKL_CSH_ALLCT_SRCHS_V --
210: -----------------------------------------------------------
211: FUNCTION null_out_defaults (
212: p_cahv_rec IN cahv_rec_type
213: ) RETURN cahv_rec_type IS

Line 336: FROM okl_csh_allct_srchs

332: FUNCTION IS_UNIQUE (p_cahv_rec cahv_rec_type) RETURN VARCHAR2
333: IS
334: CURSOR l_chr_csr IS
335: SELECT 'x'
336: FROM okl_csh_allct_srchs
337: WHERE name = p_cahv_rec.name
338: AND id <> NVL(p_cahv_rec.id,-99999);
339:
340: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 364: -- Validate_Attributes for:OKL_CSH_ALLCT_SRCHS_V --

360: ---------------------------------------------------------------------------
361: -- PROCEDURE Validate_Attributes
362: ---------------------------------------------------------------------------
363: ---------------------------------------------------
364: -- Validate_Attributes for:OKL_CSH_ALLCT_SRCHS_V --
365: ---------------------------------------------------
366: FUNCTION Validate_Attributes (
367: p_cahv_rec IN cahv_rec_type
368: ) RETURN VARCHAR2 IS

Line 422: -- Validate_Record for:OKL_CSH_ALLCT_SRCHS_V --

418: ---------------------------------------------------------------------------
419: -- PROCEDURE Validate_Record
420: ---------------------------------------------------------------------------
421: -----------------------------------------------
422: -- Validate_Record for:OKL_CSH_ALLCT_SRCHS_V --
423: -----------------------------------------------
424:
425: --Added 04/23/2001 Bruno Vaghela ---
426:

Line 515: p_to IN OUT NOCOPY okl_csh_allct_srchs_h_rec_type

511: END migrate;
512: /* -- history tables not supported -- 04 APR 2002
513: PROCEDURE migrate (
514: p_from IN cah_rec_type,
515: p_to IN OUT NOCOPY okl_csh_allct_srchs_h_rec_type
516: ) IS
517: BEGIN
518: p_to.id := p_from.id;
519: p_to.name := p_from.name;

Line 551: -- validate_row for:OKL_CSH_ALLCT_SRCHS_V --

547: ---------------------------------------------------------------------------
548: -- PROCEDURE validate_row
549: ---------------------------------------------------------------------------
550: --------------------------------------------
551: -- validate_row for:OKL_CSH_ALLCT_SRCHS_V --
552: --------------------------------------------
553: PROCEDURE validate_row(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 715: -- insert_row for:OKL_CSH_ALLCT_SRCHS_H --

711: ---------------------------------------------------------------------------
712: -- PROCEDURE insert_row
713: ---------------------------------------------------------------------------
714: ------------------------------------------
715: -- insert_row for:OKL_CSH_ALLCT_SRCHS_H --
716: ------------------------------------------
717: /* -- history tables not supported -- 04 APR 2002
718: PROCEDURE insert_row(
719: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 723: p_okl_csh_allct_srchs_h_rec IN okl_csh_allct_srchs_h_rec_type,

719: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
720: x_return_status OUT NOCOPY VARCHAR2,
721: x_msg_count OUT NOCOPY NUMBER,
722: x_msg_data OUT NOCOPY VARCHAR2,
723: p_okl_csh_allct_srchs_h_rec IN okl_csh_allct_srchs_h_rec_type,
724: x_okl_csh_allct_srchs_h_rec OUT NOCOPY okl_csh_allct_srchs_h_rec_type) IS
725:
726: l_api_version CONSTANT NUMBER := 1;
727: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';

Line 724: x_okl_csh_allct_srchs_h_rec OUT NOCOPY okl_csh_allct_srchs_h_rec_type) IS

720: x_return_status OUT NOCOPY VARCHAR2,
721: x_msg_count OUT NOCOPY NUMBER,
722: x_msg_data OUT NOCOPY VARCHAR2,
723: p_okl_csh_allct_srchs_h_rec IN okl_csh_allct_srchs_h_rec_type,
724: x_okl_csh_allct_srchs_h_rec OUT NOCOPY okl_csh_allct_srchs_h_rec_type) IS
725:
726: l_api_version CONSTANT NUMBER := 1;
727: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
728: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 729: l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type := p_okl_csh_allct_srchs_h_rec;

725:
726: l_api_version CONSTANT NUMBER := 1;
727: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
728: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
729: l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type := p_okl_csh_allct_srchs_h_rec;
730: ldefoklcshallctsrchshrec okl_csh_allct_srchs_h_rec_type;
731: ----------------------------------------------
732: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_H --
733: ----------------------------------------------

Line 730: ldefoklcshallctsrchshrec okl_csh_allct_srchs_h_rec_type;

726: l_api_version CONSTANT NUMBER := 1;
727: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
728: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
729: l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type := p_okl_csh_allct_srchs_h_rec;
730: ldefoklcshallctsrchshrec okl_csh_allct_srchs_h_rec_type;
731: ----------------------------------------------
732: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_H --
733: ----------------------------------------------
734: FUNCTION Set_Attributes (

Line 732: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_H --

728: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
729: l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type := p_okl_csh_allct_srchs_h_rec;
730: ldefoklcshallctsrchshrec okl_csh_allct_srchs_h_rec_type;
731: ----------------------------------------------
732: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_H --
733: ----------------------------------------------
734: FUNCTION Set_Attributes (
735: p_okl_csh_allct_srchs_h_rec IN okl_csh_allct_srchs_h_rec_type,
736: x_okl_csh_allct_srchs_h_rec OUT NOCOPY okl_csh_allct_srchs_h_rec_type

Line 735: p_okl_csh_allct_srchs_h_rec IN okl_csh_allct_srchs_h_rec_type,

731: ----------------------------------------------
732: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_H --
733: ----------------------------------------------
734: FUNCTION Set_Attributes (
735: p_okl_csh_allct_srchs_h_rec IN okl_csh_allct_srchs_h_rec_type,
736: x_okl_csh_allct_srchs_h_rec OUT NOCOPY okl_csh_allct_srchs_h_rec_type
737: ) RETURN VARCHAR2 IS
738: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
739: BEGIN

Line 736: x_okl_csh_allct_srchs_h_rec OUT NOCOPY okl_csh_allct_srchs_h_rec_type

732: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_H --
733: ----------------------------------------------
734: FUNCTION Set_Attributes (
735: p_okl_csh_allct_srchs_h_rec IN okl_csh_allct_srchs_h_rec_type,
736: x_okl_csh_allct_srchs_h_rec OUT NOCOPY okl_csh_allct_srchs_h_rec_type
737: ) RETURN VARCHAR2 IS
738: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
739: BEGIN
740: x_okl_csh_allct_srchs_h_rec := p_okl_csh_allct_srchs_h_rec;

Line 740: x_okl_csh_allct_srchs_h_rec := p_okl_csh_allct_srchs_h_rec;

736: x_okl_csh_allct_srchs_h_rec OUT NOCOPY okl_csh_allct_srchs_h_rec_type
737: ) RETURN VARCHAR2 IS
738: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
739: BEGIN
740: x_okl_csh_allct_srchs_h_rec := p_okl_csh_allct_srchs_h_rec;
741: RETURN(l_return_status);
742: END Set_Attributes;
743: BEGIN
744: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 755: p_okl_csh_allct_srchs_h_rec, -- IN

751: RAISE Okl_Api.G_EXCEPTION_ERROR;
752: END IF;
753: --- Setting item attributes
754: l_return_status := Set_Attributes(
755: p_okl_csh_allct_srchs_h_rec, -- IN
756: l_okl_csh_allct_srchs_h_rec); -- OUT
757: --- If any errors happen abort API
758: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 756: l_okl_csh_allct_srchs_h_rec); -- OUT

752: END IF;
753: --- Setting item attributes
754: l_return_status := Set_Attributes(
755: p_okl_csh_allct_srchs_h_rec, -- IN
756: l_okl_csh_allct_srchs_h_rec); -- OUT
757: --- If any errors happen abort API
758: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 773: INSERT INTO OKL_CSH_ALLCT_SRCHS_H(

769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
770: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
771: RAISE Okl_Api.G_EXCEPTION_ERROR;
772: END IF;
773: INSERT INTO OKL_CSH_ALLCT_SRCHS_H(
774: id,
775: major_version,
776: name,
777: sequence_number,

Line 803: l_okl_csh_allct_srchs_h_rec.id,

799: last_updated_by,
800: last_update_date,
801: last_update_login)
802: VALUES (
803: l_okl_csh_allct_srchs_h_rec.id,
804: l_okl_csh_allct_srchs_h_rec.major_version,
805: l_okl_csh_allct_srchs_h_rec.name,
806: l_okl_csh_allct_srchs_h_rec.sequence_number,
807: l_okl_csh_allct_srchs_h_rec.cash_search_type,

Line 804: l_okl_csh_allct_srchs_h_rec.major_version,

800: last_update_date,
801: last_update_login)
802: VALUES (
803: l_okl_csh_allct_srchs_h_rec.id,
804: l_okl_csh_allct_srchs_h_rec.major_version,
805: l_okl_csh_allct_srchs_h_rec.name,
806: l_okl_csh_allct_srchs_h_rec.sequence_number,
807: l_okl_csh_allct_srchs_h_rec.cash_search_type,
808: l_okl_csh_allct_srchs_h_rec.object_version_number,

Line 805: l_okl_csh_allct_srchs_h_rec.name,

801: last_update_login)
802: VALUES (
803: l_okl_csh_allct_srchs_h_rec.id,
804: l_okl_csh_allct_srchs_h_rec.major_version,
805: l_okl_csh_allct_srchs_h_rec.name,
806: l_okl_csh_allct_srchs_h_rec.sequence_number,
807: l_okl_csh_allct_srchs_h_rec.cash_search_type,
808: l_okl_csh_allct_srchs_h_rec.object_version_number,
809: l_okl_csh_allct_srchs_h_rec.description,

Line 806: l_okl_csh_allct_srchs_h_rec.sequence_number,

802: VALUES (
803: l_okl_csh_allct_srchs_h_rec.id,
804: l_okl_csh_allct_srchs_h_rec.major_version,
805: l_okl_csh_allct_srchs_h_rec.name,
806: l_okl_csh_allct_srchs_h_rec.sequence_number,
807: l_okl_csh_allct_srchs_h_rec.cash_search_type,
808: l_okl_csh_allct_srchs_h_rec.object_version_number,
809: l_okl_csh_allct_srchs_h_rec.description,
810: l_okl_csh_allct_srchs_h_rec.attribute_category,

Line 807: l_okl_csh_allct_srchs_h_rec.cash_search_type,

803: l_okl_csh_allct_srchs_h_rec.id,
804: l_okl_csh_allct_srchs_h_rec.major_version,
805: l_okl_csh_allct_srchs_h_rec.name,
806: l_okl_csh_allct_srchs_h_rec.sequence_number,
807: l_okl_csh_allct_srchs_h_rec.cash_search_type,
808: l_okl_csh_allct_srchs_h_rec.object_version_number,
809: l_okl_csh_allct_srchs_h_rec.description,
810: l_okl_csh_allct_srchs_h_rec.attribute_category,
811: l_okl_csh_allct_srchs_h_rec.attribute1,

Line 808: l_okl_csh_allct_srchs_h_rec.object_version_number,

804: l_okl_csh_allct_srchs_h_rec.major_version,
805: l_okl_csh_allct_srchs_h_rec.name,
806: l_okl_csh_allct_srchs_h_rec.sequence_number,
807: l_okl_csh_allct_srchs_h_rec.cash_search_type,
808: l_okl_csh_allct_srchs_h_rec.object_version_number,
809: l_okl_csh_allct_srchs_h_rec.description,
810: l_okl_csh_allct_srchs_h_rec.attribute_category,
811: l_okl_csh_allct_srchs_h_rec.attribute1,
812: l_okl_csh_allct_srchs_h_rec.attribute2,

Line 809: l_okl_csh_allct_srchs_h_rec.description,

805: l_okl_csh_allct_srchs_h_rec.name,
806: l_okl_csh_allct_srchs_h_rec.sequence_number,
807: l_okl_csh_allct_srchs_h_rec.cash_search_type,
808: l_okl_csh_allct_srchs_h_rec.object_version_number,
809: l_okl_csh_allct_srchs_h_rec.description,
810: l_okl_csh_allct_srchs_h_rec.attribute_category,
811: l_okl_csh_allct_srchs_h_rec.attribute1,
812: l_okl_csh_allct_srchs_h_rec.attribute2,
813: l_okl_csh_allct_srchs_h_rec.attribute3,

Line 810: l_okl_csh_allct_srchs_h_rec.attribute_category,

806: l_okl_csh_allct_srchs_h_rec.sequence_number,
807: l_okl_csh_allct_srchs_h_rec.cash_search_type,
808: l_okl_csh_allct_srchs_h_rec.object_version_number,
809: l_okl_csh_allct_srchs_h_rec.description,
810: l_okl_csh_allct_srchs_h_rec.attribute_category,
811: l_okl_csh_allct_srchs_h_rec.attribute1,
812: l_okl_csh_allct_srchs_h_rec.attribute2,
813: l_okl_csh_allct_srchs_h_rec.attribute3,
814: l_okl_csh_allct_srchs_h_rec.attribute4,

Line 811: l_okl_csh_allct_srchs_h_rec.attribute1,

807: l_okl_csh_allct_srchs_h_rec.cash_search_type,
808: l_okl_csh_allct_srchs_h_rec.object_version_number,
809: l_okl_csh_allct_srchs_h_rec.description,
810: l_okl_csh_allct_srchs_h_rec.attribute_category,
811: l_okl_csh_allct_srchs_h_rec.attribute1,
812: l_okl_csh_allct_srchs_h_rec.attribute2,
813: l_okl_csh_allct_srchs_h_rec.attribute3,
814: l_okl_csh_allct_srchs_h_rec.attribute4,
815: l_okl_csh_allct_srchs_h_rec.attribute5,

Line 812: l_okl_csh_allct_srchs_h_rec.attribute2,

808: l_okl_csh_allct_srchs_h_rec.object_version_number,
809: l_okl_csh_allct_srchs_h_rec.description,
810: l_okl_csh_allct_srchs_h_rec.attribute_category,
811: l_okl_csh_allct_srchs_h_rec.attribute1,
812: l_okl_csh_allct_srchs_h_rec.attribute2,
813: l_okl_csh_allct_srchs_h_rec.attribute3,
814: l_okl_csh_allct_srchs_h_rec.attribute4,
815: l_okl_csh_allct_srchs_h_rec.attribute5,
816: l_okl_csh_allct_srchs_h_rec.attribute6,

Line 813: l_okl_csh_allct_srchs_h_rec.attribute3,

809: l_okl_csh_allct_srchs_h_rec.description,
810: l_okl_csh_allct_srchs_h_rec.attribute_category,
811: l_okl_csh_allct_srchs_h_rec.attribute1,
812: l_okl_csh_allct_srchs_h_rec.attribute2,
813: l_okl_csh_allct_srchs_h_rec.attribute3,
814: l_okl_csh_allct_srchs_h_rec.attribute4,
815: l_okl_csh_allct_srchs_h_rec.attribute5,
816: l_okl_csh_allct_srchs_h_rec.attribute6,
817: l_okl_csh_allct_srchs_h_rec.attribute7,

Line 814: l_okl_csh_allct_srchs_h_rec.attribute4,

810: l_okl_csh_allct_srchs_h_rec.attribute_category,
811: l_okl_csh_allct_srchs_h_rec.attribute1,
812: l_okl_csh_allct_srchs_h_rec.attribute2,
813: l_okl_csh_allct_srchs_h_rec.attribute3,
814: l_okl_csh_allct_srchs_h_rec.attribute4,
815: l_okl_csh_allct_srchs_h_rec.attribute5,
816: l_okl_csh_allct_srchs_h_rec.attribute6,
817: l_okl_csh_allct_srchs_h_rec.attribute7,
818: l_okl_csh_allct_srchs_h_rec.attribute8,

Line 815: l_okl_csh_allct_srchs_h_rec.attribute5,

811: l_okl_csh_allct_srchs_h_rec.attribute1,
812: l_okl_csh_allct_srchs_h_rec.attribute2,
813: l_okl_csh_allct_srchs_h_rec.attribute3,
814: l_okl_csh_allct_srchs_h_rec.attribute4,
815: l_okl_csh_allct_srchs_h_rec.attribute5,
816: l_okl_csh_allct_srchs_h_rec.attribute6,
817: l_okl_csh_allct_srchs_h_rec.attribute7,
818: l_okl_csh_allct_srchs_h_rec.attribute8,
819: l_okl_csh_allct_srchs_h_rec.attribute9,

Line 816: l_okl_csh_allct_srchs_h_rec.attribute6,

812: l_okl_csh_allct_srchs_h_rec.attribute2,
813: l_okl_csh_allct_srchs_h_rec.attribute3,
814: l_okl_csh_allct_srchs_h_rec.attribute4,
815: l_okl_csh_allct_srchs_h_rec.attribute5,
816: l_okl_csh_allct_srchs_h_rec.attribute6,
817: l_okl_csh_allct_srchs_h_rec.attribute7,
818: l_okl_csh_allct_srchs_h_rec.attribute8,
819: l_okl_csh_allct_srchs_h_rec.attribute9,
820: l_okl_csh_allct_srchs_h_rec.attribute10,

Line 817: l_okl_csh_allct_srchs_h_rec.attribute7,

813: l_okl_csh_allct_srchs_h_rec.attribute3,
814: l_okl_csh_allct_srchs_h_rec.attribute4,
815: l_okl_csh_allct_srchs_h_rec.attribute5,
816: l_okl_csh_allct_srchs_h_rec.attribute6,
817: l_okl_csh_allct_srchs_h_rec.attribute7,
818: l_okl_csh_allct_srchs_h_rec.attribute8,
819: l_okl_csh_allct_srchs_h_rec.attribute9,
820: l_okl_csh_allct_srchs_h_rec.attribute10,
821: l_okl_csh_allct_srchs_h_rec.attribute11,

Line 818: l_okl_csh_allct_srchs_h_rec.attribute8,

814: l_okl_csh_allct_srchs_h_rec.attribute4,
815: l_okl_csh_allct_srchs_h_rec.attribute5,
816: l_okl_csh_allct_srchs_h_rec.attribute6,
817: l_okl_csh_allct_srchs_h_rec.attribute7,
818: l_okl_csh_allct_srchs_h_rec.attribute8,
819: l_okl_csh_allct_srchs_h_rec.attribute9,
820: l_okl_csh_allct_srchs_h_rec.attribute10,
821: l_okl_csh_allct_srchs_h_rec.attribute11,
822: l_okl_csh_allct_srchs_h_rec.attribute12,

Line 819: l_okl_csh_allct_srchs_h_rec.attribute9,

815: l_okl_csh_allct_srchs_h_rec.attribute5,
816: l_okl_csh_allct_srchs_h_rec.attribute6,
817: l_okl_csh_allct_srchs_h_rec.attribute7,
818: l_okl_csh_allct_srchs_h_rec.attribute8,
819: l_okl_csh_allct_srchs_h_rec.attribute9,
820: l_okl_csh_allct_srchs_h_rec.attribute10,
821: l_okl_csh_allct_srchs_h_rec.attribute11,
822: l_okl_csh_allct_srchs_h_rec.attribute12,
823: l_okl_csh_allct_srchs_h_rec.attribute13,

Line 820: l_okl_csh_allct_srchs_h_rec.attribute10,

816: l_okl_csh_allct_srchs_h_rec.attribute6,
817: l_okl_csh_allct_srchs_h_rec.attribute7,
818: l_okl_csh_allct_srchs_h_rec.attribute8,
819: l_okl_csh_allct_srchs_h_rec.attribute9,
820: l_okl_csh_allct_srchs_h_rec.attribute10,
821: l_okl_csh_allct_srchs_h_rec.attribute11,
822: l_okl_csh_allct_srchs_h_rec.attribute12,
823: l_okl_csh_allct_srchs_h_rec.attribute13,
824: l_okl_csh_allct_srchs_h_rec.attribute14,

Line 821: l_okl_csh_allct_srchs_h_rec.attribute11,

817: l_okl_csh_allct_srchs_h_rec.attribute7,
818: l_okl_csh_allct_srchs_h_rec.attribute8,
819: l_okl_csh_allct_srchs_h_rec.attribute9,
820: l_okl_csh_allct_srchs_h_rec.attribute10,
821: l_okl_csh_allct_srchs_h_rec.attribute11,
822: l_okl_csh_allct_srchs_h_rec.attribute12,
823: l_okl_csh_allct_srchs_h_rec.attribute13,
824: l_okl_csh_allct_srchs_h_rec.attribute14,
825: l_okl_csh_allct_srchs_h_rec.attribute15,

Line 822: l_okl_csh_allct_srchs_h_rec.attribute12,

818: l_okl_csh_allct_srchs_h_rec.attribute8,
819: l_okl_csh_allct_srchs_h_rec.attribute9,
820: l_okl_csh_allct_srchs_h_rec.attribute10,
821: l_okl_csh_allct_srchs_h_rec.attribute11,
822: l_okl_csh_allct_srchs_h_rec.attribute12,
823: l_okl_csh_allct_srchs_h_rec.attribute13,
824: l_okl_csh_allct_srchs_h_rec.attribute14,
825: l_okl_csh_allct_srchs_h_rec.attribute15,
826: l_okl_csh_allct_srchs_h_rec.created_by,

Line 823: l_okl_csh_allct_srchs_h_rec.attribute13,

819: l_okl_csh_allct_srchs_h_rec.attribute9,
820: l_okl_csh_allct_srchs_h_rec.attribute10,
821: l_okl_csh_allct_srchs_h_rec.attribute11,
822: l_okl_csh_allct_srchs_h_rec.attribute12,
823: l_okl_csh_allct_srchs_h_rec.attribute13,
824: l_okl_csh_allct_srchs_h_rec.attribute14,
825: l_okl_csh_allct_srchs_h_rec.attribute15,
826: l_okl_csh_allct_srchs_h_rec.created_by,
827: l_okl_csh_allct_srchs_h_rec.creation_date,

Line 824: l_okl_csh_allct_srchs_h_rec.attribute14,

820: l_okl_csh_allct_srchs_h_rec.attribute10,
821: l_okl_csh_allct_srchs_h_rec.attribute11,
822: l_okl_csh_allct_srchs_h_rec.attribute12,
823: l_okl_csh_allct_srchs_h_rec.attribute13,
824: l_okl_csh_allct_srchs_h_rec.attribute14,
825: l_okl_csh_allct_srchs_h_rec.attribute15,
826: l_okl_csh_allct_srchs_h_rec.created_by,
827: l_okl_csh_allct_srchs_h_rec.creation_date,
828: l_okl_csh_allct_srchs_h_rec.last_updated_by,

Line 825: l_okl_csh_allct_srchs_h_rec.attribute15,

821: l_okl_csh_allct_srchs_h_rec.attribute11,
822: l_okl_csh_allct_srchs_h_rec.attribute12,
823: l_okl_csh_allct_srchs_h_rec.attribute13,
824: l_okl_csh_allct_srchs_h_rec.attribute14,
825: l_okl_csh_allct_srchs_h_rec.attribute15,
826: l_okl_csh_allct_srchs_h_rec.created_by,
827: l_okl_csh_allct_srchs_h_rec.creation_date,
828: l_okl_csh_allct_srchs_h_rec.last_updated_by,
829: l_okl_csh_allct_srchs_h_rec.last_update_date,

Line 826: l_okl_csh_allct_srchs_h_rec.created_by,

822: l_okl_csh_allct_srchs_h_rec.attribute12,
823: l_okl_csh_allct_srchs_h_rec.attribute13,
824: l_okl_csh_allct_srchs_h_rec.attribute14,
825: l_okl_csh_allct_srchs_h_rec.attribute15,
826: l_okl_csh_allct_srchs_h_rec.created_by,
827: l_okl_csh_allct_srchs_h_rec.creation_date,
828: l_okl_csh_allct_srchs_h_rec.last_updated_by,
829: l_okl_csh_allct_srchs_h_rec.last_update_date,
830: l_okl_csh_allct_srchs_h_rec.last_update_login);

Line 827: l_okl_csh_allct_srchs_h_rec.creation_date,

823: l_okl_csh_allct_srchs_h_rec.attribute13,
824: l_okl_csh_allct_srchs_h_rec.attribute14,
825: l_okl_csh_allct_srchs_h_rec.attribute15,
826: l_okl_csh_allct_srchs_h_rec.created_by,
827: l_okl_csh_allct_srchs_h_rec.creation_date,
828: l_okl_csh_allct_srchs_h_rec.last_updated_by,
829: l_okl_csh_allct_srchs_h_rec.last_update_date,
830: l_okl_csh_allct_srchs_h_rec.last_update_login);
831: -- Set OUT values

Line 828: l_okl_csh_allct_srchs_h_rec.last_updated_by,

824: l_okl_csh_allct_srchs_h_rec.attribute14,
825: l_okl_csh_allct_srchs_h_rec.attribute15,
826: l_okl_csh_allct_srchs_h_rec.created_by,
827: l_okl_csh_allct_srchs_h_rec.creation_date,
828: l_okl_csh_allct_srchs_h_rec.last_updated_by,
829: l_okl_csh_allct_srchs_h_rec.last_update_date,
830: l_okl_csh_allct_srchs_h_rec.last_update_login);
831: -- Set OUT values
832: x_okl_csh_allct_srchs_h_rec := l_okl_csh_allct_srchs_h_rec;

Line 829: l_okl_csh_allct_srchs_h_rec.last_update_date,

825: l_okl_csh_allct_srchs_h_rec.attribute15,
826: l_okl_csh_allct_srchs_h_rec.created_by,
827: l_okl_csh_allct_srchs_h_rec.creation_date,
828: l_okl_csh_allct_srchs_h_rec.last_updated_by,
829: l_okl_csh_allct_srchs_h_rec.last_update_date,
830: l_okl_csh_allct_srchs_h_rec.last_update_login);
831: -- Set OUT values
832: x_okl_csh_allct_srchs_h_rec := l_okl_csh_allct_srchs_h_rec;
833: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 830: l_okl_csh_allct_srchs_h_rec.last_update_login);

826: l_okl_csh_allct_srchs_h_rec.created_by,
827: l_okl_csh_allct_srchs_h_rec.creation_date,
828: l_okl_csh_allct_srchs_h_rec.last_updated_by,
829: l_okl_csh_allct_srchs_h_rec.last_update_date,
830: l_okl_csh_allct_srchs_h_rec.last_update_login);
831: -- Set OUT values
832: x_okl_csh_allct_srchs_h_rec := l_okl_csh_allct_srchs_h_rec;
833: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
834: EXCEPTION

Line 832: x_okl_csh_allct_srchs_h_rec := l_okl_csh_allct_srchs_h_rec;

828: l_okl_csh_allct_srchs_h_rec.last_updated_by,
829: l_okl_csh_allct_srchs_h_rec.last_update_date,
830: l_okl_csh_allct_srchs_h_rec.last_update_login);
831: -- Set OUT values
832: x_okl_csh_allct_srchs_h_rec := l_okl_csh_allct_srchs_h_rec;
833: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
834: EXCEPTION
835: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
836: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 868: -- insert_row for:OKL_CSH_ALLCT_SRCHS --

864: );
865: END insert_row;
866: */ -- history tables not supported -- 04 APR 2002
867: ----------------------------------------
868: -- insert_row for:OKL_CSH_ALLCT_SRCHS --
869: ----------------------------------------
870: PROCEDURE insert_row(
871: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
872: x_return_status OUT NOCOPY VARCHAR2,

Line 884: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS --

880: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
881: l_cah_rec cah_rec_type := p_cah_rec;
882: l_def_cah_rec cah_rec_type;
883: --------------------------------------------
884: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS --
885: --------------------------------------------
886: FUNCTION Set_Attributes (
887: p_cah_rec IN cah_rec_type,
888: x_cah_rec OUT NOCOPY cah_rec_type

Line 915: INSERT INTO OKL_CSH_ALLCT_SRCHS(

911: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
912: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
913: RAISE Okl_Api.G_EXCEPTION_ERROR;
914: END IF;
915: INSERT INTO OKL_CSH_ALLCT_SRCHS(
916: id,
917: name,
918: sequence_number,
919: cash_search_type,

Line 1021: -- insert_row for:OKL_CSH_ALLCT_SRCHS_V --

1017: );
1018: */
1019: END insert_row;
1020: ------------------------------------------
1021: -- insert_row for:OKL_CSH_ALLCT_SRCHS_V --
1022: ------------------------------------------
1023: PROCEDURE insert_row(
1024: p_api_version IN NUMBER,
1025: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1055: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_V --

1051: l_cahv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1052: RETURN(l_cahv_rec);
1053: END fill_who_columns;
1054: ----------------------------------------------
1055: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_V --
1056: ----------------------------------------------
1057: FUNCTION Set_Attributes (
1058: p_cahv_rec IN cahv_rec_type,
1059: x_cahv_rec OUT NOCOPY cahv_rec_type

Line 1228: FROM OKL_CSH_ALLCT_SRCHS

1224: -------------------
1225: -- Get all the rows for update
1226: CURSOR c_csh_allct_srchs_all IS
1227: SELECT SEQUENCE_NUMBER, ID , NAME
1228: FROM OKL_CSH_ALLCT_SRCHS
1229: order by SEQUENCE_NUMBER;
1230:
1231: c_csh_allct_srchs_all_rec c_csh_allct_srchs_all%ROWTYPE;
1232:

Line 1347: -- lock_row for:OKL_CSH_ALLCT_SRCHS --

1343: ---------------------------------------------------------------------------
1344: -- PROCEDURE lock_row
1345: ---------------------------------------------------------------------------
1346: --------------------------------------
1347: -- lock_row for:OKL_CSH_ALLCT_SRCHS --
1348: --------------------------------------
1349: PROCEDURE lock_row(
1350: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1351: x_return_status OUT NOCOPY VARCHAR2,

Line 1360: FROM OKL_CSH_ALLCT_SRCHS

1356: E_Resource_Busy EXCEPTION;
1357: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1358: CURSOR lock_csr (p_cah_rec IN cah_rec_type) IS
1359: SELECT OBJECT_VERSION_NUMBER
1360: FROM OKL_CSH_ALLCT_SRCHS
1361: WHERE ID = p_cah_rec.id
1362: AND OBJECT_VERSION_NUMBER = p_cah_rec.object_version_number
1363: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1364:

Line 1367: FROM OKL_CSH_ALLCT_SRCHS

1363: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1364:
1365: CURSOR lchk_csr (p_cah_rec IN cah_rec_type) IS
1366: SELECT OBJECT_VERSION_NUMBER
1367: FROM OKL_CSH_ALLCT_SRCHS
1368: WHERE ID = p_cah_rec.id;
1369: l_api_version CONSTANT NUMBER := 1;
1370: l_api_name CONSTANT VARCHAR2(30) := 'SRCHS_lock_row';
1371: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1372: l_object_version_number OKL_CSH_ALLCT_SRCHS.OBJECT_VERSION_NUMBER%TYPE;

1368: WHERE ID = p_cah_rec.id;
1369: l_api_version CONSTANT NUMBER := 1;
1370: l_api_name CONSTANT VARCHAR2(30) := 'SRCHS_lock_row';
1371: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1372: l_object_version_number OKL_CSH_ALLCT_SRCHS.OBJECT_VERSION_NUMBER%TYPE;
1373: lc_object_version_number OKL_CSH_ALLCT_SRCHS.OBJECT_VERSION_NUMBER%TYPE;
1374: l_row_notfound BOOLEAN := FALSE;
1375: lc_row_notfound BOOLEAN := FALSE;
1376: BEGIN

Line 1373: lc_object_version_number OKL_CSH_ALLCT_SRCHS.OBJECT_VERSION_NUMBER%TYPE;

1369: l_api_version CONSTANT NUMBER := 1;
1370: l_api_name CONSTANT VARCHAR2(30) := 'SRCHS_lock_row';
1371: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1372: l_object_version_number OKL_CSH_ALLCT_SRCHS.OBJECT_VERSION_NUMBER%TYPE;
1373: lc_object_version_number OKL_CSH_ALLCT_SRCHS.OBJECT_VERSION_NUMBER%TYPE;
1374: l_row_notfound BOOLEAN := FALSE;
1375: lc_row_notfound BOOLEAN := FALSE;
1376: BEGIN
1377: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1453: -- lock_row for:OKL_CSH_ALLCT_SRCHS_V --

1449: '_PVT'
1450: );
1451: END lock_row;
1452: ----------------------------------------
1453: -- lock_row for:OKL_CSH_ALLCT_SRCHS_V --
1454: ----------------------------------------
1455: PROCEDURE lock_row(
1456: p_api_version IN NUMBER,
1457: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 1622: -- update_row for:OKL_CSH_ALLCT_SRCHS --

1618: ---------------------------------------------------------------------------
1619: -- PROCEDURE update_row
1620: ---------------------------------------------------------------------------
1621: ----------------------------------------
1622: -- update_row for:OKL_CSH_ALLCT_SRCHS --
1623: ----------------------------------------
1624: PROCEDURE update_row(
1625: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1626: x_return_status OUT NOCOPY VARCHAR2,

Line 1638: -- l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;

1634: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1635: l_cah_rec cah_rec_type := p_cah_rec;
1636: l_def_cah_rec cah_rec_type;
1637: l_row_notfound BOOLEAN := TRUE;
1638: -- l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;
1639: -- lx_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;
1640: ----------------------------------
1641: -- FUNCTION populate_new_record --
1642: ----------------------------------

Line 1639: -- lx_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;

1635: l_cah_rec cah_rec_type := p_cah_rec;
1636: l_def_cah_rec cah_rec_type;
1637: l_row_notfound BOOLEAN := TRUE;
1638: -- l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;
1639: -- lx_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;
1640: ----------------------------------
1641: -- FUNCTION populate_new_record --
1642: ----------------------------------
1643: FUNCTION populate_new_record (

Line 1660: -- migrate(l_cah_rec, l_okl_csh_allct_srchs_h_rec);

1656: END IF;
1657: -- Move the "old" record to the history record:
1658: -- (1) to get the "old" version
1659: -- (2) to avoid 2 hits to the database
1660: -- migrate(l_cah_rec, l_okl_csh_allct_srchs_h_rec);
1661: IF (x_cah_rec.id = Okl_Api.G_MISS_NUM)
1662: THEN
1663: x_cah_rec.id := l_cah_rec.id;
1664: END IF;

Line 1776: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS --

1772: END IF;
1773: RETURN(l_return_status);
1774: END populate_new_record;
1775: --------------------------------------------
1776: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS --
1777: --------------------------------------------
1778: FUNCTION Set_Attributes (
1779: p_cah_rec IN cah_rec_type,
1780: x_cah_rec OUT NOCOPY cah_rec_type

Line 1813: UPDATE OKL_CSH_ALLCT_SRCHS

1809: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1810: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1811: RAISE Okl_Api.G_EXCEPTION_ERROR;
1812: END IF;
1813: UPDATE OKL_CSH_ALLCT_SRCHS
1814: SET NAME = l_def_cah_rec.name,
1815: SEQUENCE_NUMBER = l_def_cah_rec.sequence_number,
1816: CASH_SEARCH_TYPE = l_def_cah_rec.cash_search_type,
1817: OBJECT_VERSION_NUMBER = l_def_cah_rec.object_version_number,

Line 1850: l_okl_csh_allct_srchs_h_rec,

1846: p_init_msg_list,
1847: x_return_status,
1848: x_msg_count,
1849: x_msg_data,
1850: l_okl_csh_allct_srchs_h_rec,
1851: lx_okl_csh_allct_srchs_h_rec
1852: );
1853: */
1854: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1851: lx_okl_csh_allct_srchs_h_rec

1847: x_return_status,
1848: x_msg_count,
1849: x_msg_data,
1850: l_okl_csh_allct_srchs_h_rec,
1851: lx_okl_csh_allct_srchs_h_rec
1852: );
1853: */
1854: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1894: -- update_row for:OKL_CSH_ALLCT_SRCHS_V --

1890: '_PVT'
1891: );
1892: END update_row;
1893: ------------------------------------------
1894: -- update_row for:OKL_CSH_ALLCT_SRCHS_V --
1895: ------------------------------------------
1896: PROCEDURE update_row(
1897: p_api_version IN NUMBER,
1898: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 2057: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_V --

2053: END IF;
2054: RETURN(l_return_status);
2055: END populate_new_record;
2056: ----------------------------------------------
2057: -- Set_Attributes for:OKL_CSH_ALLCT_SRCHS_V --
2058: ----------------------------------------------
2059: FUNCTION Set_Attributes (
2060: p_cahv_rec IN cahv_rec_type,
2061: x_cahv_rec OUT NOCOPY cahv_rec_type

Line 2214: FROM OKL_CSH_ALLCT_SRCHS

2210: -------------------
2211: -- Get all the rows for update
2212: CURSOR c_csh_allct_srchs_all IS
2213: SELECT SEQUENCE_NUMBER, ID
2214: FROM OKL_CSH_ALLCT_SRCHS
2215: order by SEQUENCE_NUMBER;
2216:
2217: c_csh_allct_srchs_all_rec c_csh_allct_srchs_all%ROWTYPE;
2218:

Line 2333: -- delete_row for:OKL_CSH_ALLCT_SRCHS --

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

Line 2347: -- l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;

2343: l_api_name CONSTANT VARCHAR2(30) := 'SRCHS_delete_row';
2344: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2345: l_cah_rec cah_rec_type:= p_cah_rec;
2346: l_row_notfound BOOLEAN := TRUE;
2347: -- l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;
2348: -- lx_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;
2349: BEGIN
2350: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2351: p_init_msg_list,

Line 2348: -- lx_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;

2344: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2345: l_cah_rec cah_rec_type:= p_cah_rec;
2346: l_row_notfound BOOLEAN := TRUE;
2347: -- l_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;
2348: -- lx_okl_csh_allct_srchs_h_rec okl_csh_allct_srchs_h_rec_type;
2349: BEGIN
2350: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2351: p_init_msg_list,
2352: '_PVT',

Line 2365: migrate(l_cah_rec, l_okl_csh_allct_srchs_h_rec);

2361: l_cah_rec := get_rec(l_cah_rec, l_row_notfound);
2362: IF (l_row_notfound) THEN
2363: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2364: END IF;
2365: migrate(l_cah_rec, l_okl_csh_allct_srchs_h_rec);
2366: insert_row(
2367: p_init_msg_list,
2368: x_return_status,
2369: x_msg_count,

Line 2371: l_okl_csh_allct_srchs_h_rec,

2367: p_init_msg_list,
2368: x_return_status,
2369: x_msg_count,
2370: x_msg_data,
2371: l_okl_csh_allct_srchs_h_rec,
2372: lx_okl_csh_allct_srchs_h_rec
2373: );
2374: */
2375: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2372: lx_okl_csh_allct_srchs_h_rec

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

Line 2380: DELETE FROM OKL_CSH_ALLCT_SRCHS

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

Line 2417: -- delete_row for:OKL_CSH_ALLCT_SRCHS_V --

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

Line 2448: FROM OKL_CSH_ALLCT_SRCHS

2444: -------------------
2445: -- Get all the rows for update
2446: CURSOR c_csh_allct_srchs_all IS
2447: SELECT SEQUENCE_NUMBER, ID
2448: FROM OKL_CSH_ALLCT_SRCHS
2449: order by SEQUENCE_NUMBER;
2450:
2451: c_csh_allct_srchs_all_rec c_csh_allct_srchs_all%ROWTYPE;
2452: