DBA Data[Home] [Help]

APPS.OKL_SIF_PVT dependencies on OKL_STREAM_INTERFACES_V

Line 202: -- FUNCTION get_rec for: OKL_STREAM_INTERFACES_V

198: BEGIN
199: RETURN(get_rec(p_sif_rec, l_row_notfound));
200: END get_rec;
201: ---------------------------------------------------------------------------
202: -- FUNCTION get_rec for: OKL_STREAM_INTERFACES_V
203: ---------------------------------------------------------------------------
204: FUNCTION get_rec (
205: p_sifv_rec IN sifv_rec_type,
206: x_no_data_found OUT NOCOPY BOOLEAN

Line 273: FROM OKL_STREAM_INTERFACES_V

269: -- mvasudev, Bug#2650599
270: SIF_ID,
271: PURPOSE_CODE
272: -- end, mvasudev, Bug#2650599
273: FROM OKL_STREAM_INTERFACES_V
274: WHERE OKL_STREAM_INTERFACES_V.id = p_id;
275: l_sifv_pk sifv_pk_csr%ROWTYPE;
276: l_sifv_rec sifv_rec_type;
277: BEGIN

Line 274: WHERE OKL_STREAM_INTERFACES_V.id = p_id;

270: SIF_ID,
271: PURPOSE_CODE
272: -- end, mvasudev, Bug#2650599
273: FROM OKL_STREAM_INTERFACES_V
274: WHERE OKL_STREAM_INTERFACES_V.id = p_id;
275: l_sifv_pk sifv_pk_csr%ROWTYPE;
276: l_sifv_rec sifv_rec_type;
277: BEGIN
278: x_no_data_found := TRUE;

Line 360: -- FUNCTION null_out_defaults for: OKL_STREAM_INTERFACES_V --

356: RETURN(get_rec(p_sifv_rec, l_row_notfound));
357: END get_rec;
358:
359: -------------------------------------------------------------
360: -- FUNCTION null_out_defaults for: OKL_STREAM_INTERFACES_V --
361: -------------------------------------------------------------
362: FUNCTION null_out_defaults (
363: p_sifv_rec IN sifv_rec_type
364: ) RETURN sifv_rec_type IS

Line 559: -- Validate_Attributes for:OKL_STREAM_INTERFACES_V --

555: ---------------------------------------------------------------------------
556: -- PROCEDURE Validate_Attributes
557: ---------------------------------------------------------------------------
558: -----------------------------------------------------
559: -- Validate_Attributes for:OKL_STREAM_INTERFACES_V --
560: -----------------------------------------------------
561: FUNCTION Validate_Attributes (
562: p_sifv_rec IN sifv_rec_type
563: ) RETURN VARCHAR2 IS

Line 634: -- Validate_Record for:OKL_STREAM_INTERFACES_V --

630: ---------------------------------------------------------------------------
631: -- PROCEDURE Validate_Record
632: ---------------------------------------------------------------------------
633: -------------------------------------------------
634: -- Validate_Record for:OKL_STREAM_INTERFACES_V --
635: -------------------------------------------------
636: FUNCTION Validate_Record (
637: p_sifv_rec IN sifv_rec_type
638: ) RETURN VARCHAR2 IS

Line 1929: -- validate_row for:OKL_STREAM_INTERFACES_V --

1925: ---------------------------------------------------------------------------
1926: -- PROCEDURE validate_row
1927: ---------------------------------------------------------------------------
1928: ----------------------------------------------
1929: -- validate_row for:OKL_STREAM_INTERFACES_V --
1930: ----------------------------------------------
1931: PROCEDURE validate_row(
1932: p_api_version IN NUMBER,
1933: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2316: -- insert_row for:OKL_STREAM_INTERFACES_V --

2312: '_PVT'
2313: );
2314: END insert_row;
2315: --------------------------------------------
2316: -- insert_row for:OKL_STREAM_INTERFACES_V --
2317: --------------------------------------------
2318: PROCEDURE insert_row(
2319: p_api_version IN NUMBER,
2320: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2350: -- Set_Attributes for:OKL_STREAM_INTERFACES_V --

2346: l_sifv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2347: RETURN(l_sifv_rec);
2348: END fill_who_columns;
2349: ------------------------------------------------
2350: -- Set_Attributes for:OKL_STREAM_INTERFACES_V --
2351: ------------------------------------------------
2352: FUNCTION Set_Attributes (
2353: p_sifv_rec IN sifv_rec_type,
2354: x_sifv_rec OUT NOCOPY sifv_rec_type

Line 2670: -- lock_row for:OKL_STREAM_INTERFACES_V --

2666: '_PVT'
2667: );
2668: END lock_row;
2669: ------------------------------------------
2670: -- lock_row for:OKL_STREAM_INTERFACES_V --
2671: ------------------------------------------
2672: PROCEDURE lock_row(
2673: p_api_version IN NUMBER,
2674: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3250: -- update_row for:OKL_STREAM_INTERFACES_V --

3246: '_PVT'
3247: );
3248: END update_row;
3249: --------------------------------------------
3250: -- update_row for:OKL_STREAM_INTERFACES_V --
3251: --------------------------------------------
3252: PROCEDURE update_row(
3253: p_api_version IN NUMBER,
3254: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3531: -- Set_Attributes for:OKL_STREAM_INTERFACES_V --

3527: -- end, mvasudev, Bug#2650599
3528: RETURN(l_return_status);
3529: END populate_new_record;
3530: ------------------------------------------------
3531: -- Set_Attributes for:OKL_STREAM_INTERFACES_V --
3532: ------------------------------------------------
3533: FUNCTION Set_Attributes (
3534: p_sifv_rec IN sifv_rec_type,
3535: x_sifv_rec OUT NOCOPY sifv_rec_type

Line 3802: -- delete_row for:OKL_STREAM_INTERFACES_V --

3798: '_PVT'
3799: );
3800: END delete_row;
3801: --------------------------------------------
3802: -- delete_row for:OKL_STREAM_INTERFACES_V --
3803: --------------------------------------------
3804: PROCEDURE delete_row(
3805: p_api_version IN NUMBER,
3806: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,