DBA Data[Home] [Help]

APPS.OKL_SST_PVT dependencies on OKL_SRCH_STRM_TYPS_V

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 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 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 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 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 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 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,