188: BEGIN
189: RETURN(get_rec(p_sil_rec, l_row_notfound));
190: END get_rec;
191: ---------------------------------------------------------------------------
192: -- FUNCTION get_rec for: OKL_SIF_LINES_V
193: ---------------------------------------------------------------------------
194: FUNCTION get_rec (
195: p_silv_rec IN silv_rec_type,
196: x_no_data_found OUT NOCOPY BOOLEAN
259: RESIDUAL_GUARANTEE_TYPE,
260: RESIDUAL_DATE,
261: DOWN_PAYMENT_AMOUNT,
262: CAPITALIZE_DOWN_PAYMENT_YN
263: FROM Okl_Sif_Lines_V
264: WHERE okl_sif_lines_v.id = p_id;
265: l_silv_pk silv_pk_csr%ROWTYPE;
266: l_silv_rec silv_rec_type;
267: BEGIN
260: RESIDUAL_DATE,
261: DOWN_PAYMENT_AMOUNT,
262: CAPITALIZE_DOWN_PAYMENT_YN
263: FROM Okl_Sif_Lines_V
264: WHERE okl_sif_lines_v.id = p_id;
265: l_silv_pk silv_pk_csr%ROWTYPE;
266: l_silv_rec silv_rec_type;
267: BEGIN
268: x_no_data_found := TRUE;
345: RETURN(get_rec(p_silv_rec, l_row_notfound));
346: END get_rec;
347:
348: -----------------------------------------------------
349: -- FUNCTION null_out_defaults for: OKL_SIF_LINES_V --
350: -----------------------------------------------------
351: FUNCTION null_out_defaults (
352: p_silv_rec IN silv_rec_type
353: ) RETURN silv_rec_type IS
547: ---------------------------------------------------------------------------
548: -- PROCEDURE Validate_Attributes
549: ---------------------------------------------------------------------------
550: ---------------------------------------------
551: -- Validate_Attributes for:OKL_SIF_LINES_V --
552: ---------------------------------------------
553: FUNCTION Validate_Attributes (
554: p_silv_rec IN silv_rec_type
555: ) RETURN VARCHAR2 IS
900: l_dummy VARCHAR2(1) := '?';
901: l_row_not_found BOOLEAN := FALSE;
902:
903: -- Cursor For OKL_SIL_KLE_FK;
904: CURSOR okl_klev_pk_csr (p_id IN OKL_SIF_LINES_V.kle_id%TYPE) IS
905: SELECT '1'
906: FROM OKL_K_LINES_V
907: WHERE OKL_K_LINES_V.id = p_id;
908:
2811: ---------------------------------------------------------------------------
2812: -- PROCEDURE Validate_Record
2813: ---------------------------------------------------------------------------
2814: -----------------------------------------
2815: -- Validate_Record for:OKL_SIF_LINES_V --
2816: -----------------------------------------
2817: FUNCTION Validate_Record (
2818: p_silv_rec IN silv_rec_type
2819: ) RETURN VARCHAR2 IS
2968: ---------------------------------------------------------------------------
2969: -- PROCEDURE validate_row
2970: ---------------------------------------------------------------------------
2971: --------------------------------------
2972: -- validate_row for:OKL_SIF_LINES_V --
2973: --------------------------------------
2974: PROCEDURE validate_row(
2975: p_api_version IN NUMBER,
2976: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3340: '_PVT'
3341: );
3342: END insert_row;
3343: ------------------------------------
3344: -- insert_row for:OKL_SIF_LINES_V --
3345: ------------------------------------
3346: PROCEDURE insert_row(
3347: p_api_version IN NUMBER,
3348: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3374: l_silv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3375: RETURN(l_silv_rec);
3376: END fill_who_columns;
3377: ----------------------------------------
3378: -- Set_Attributes for:OKL_SIF_LINES_V --
3379: ----------------------------------------
3380: FUNCTION Set_Attributes (
3381: p_silv_rec IN silv_rec_type,
3382: x_silv_rec OUT NOCOPY silv_rec_type
3677: '_PVT'
3678: );
3679: END lock_row;
3680: ----------------------------------
3681: -- lock_row for:OKL_SIF_LINES_V --
3682: ----------------------------------
3683: PROCEDURE lock_row(
3684: p_api_version IN NUMBER,
3685: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4263: '_PVT'
4264: );
4265: END update_row;
4266: ------------------------------------
4267: -- update_row for:OKL_SIF_LINES_V --
4268: ------------------------------------
4269: PROCEDURE update_row(
4270: p_api_version IN NUMBER,
4271: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4563: END IF;
4564: RETURN(l_return_status);
4565: END populate_new_record;
4566: ----------------------------------------
4567: -- Set_Attributes for:OKL_SIF_LINES_V --
4568: ----------------------------------------
4569: FUNCTION Set_Attributes (
4570: p_silv_rec IN silv_rec_type,
4571: x_silv_rec OUT NOCOPY silv_rec_type
4823: '_PVT'
4824: );
4825: END delete_row;
4826: ------------------------------------
4827: -- delete_row for:OKL_SIF_LINES_V --
4828: ------------------------------------
4829: PROCEDURE delete_row(
4830: p_api_version IN NUMBER,
4831: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,