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_SIL_PVT dependencies on OKL_SIF_LINES

Line 36: -- FUNCTION get_rec for: OKL_SIF_LINES

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

Line 107: FROM Okl_Sif_Lines

103: RESIDUAL_GUARANTEE_TYPE,
104: RESIDUAL_DATE,
105: DOWN_PAYMENT_AMOUNT,
106: CAPITALIZE_DOWN_PAYMENT_YN
107: FROM Okl_Sif_Lines
108: WHERE okl_sif_lines.id = p_id;
109: l_sil_pk sil_pk_csr%ROWTYPE;
110: l_sil_rec sil_rec_type;
111: BEGIN

Line 108: WHERE okl_sif_lines.id = p_id;

104: RESIDUAL_DATE,
105: DOWN_PAYMENT_AMOUNT,
106: CAPITALIZE_DOWN_PAYMENT_YN
107: FROM Okl_Sif_Lines
108: WHERE okl_sif_lines.id = p_id;
109: l_sil_pk sil_pk_csr%ROWTYPE;
110: l_sil_rec sil_rec_type;
111: BEGIN
112: x_no_data_found := TRUE;

Line 192: -- FUNCTION get_rec for: OKL_SIF_LINES_V

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

Line 263: FROM Okl_Sif_Lines_V

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

Line 264: WHERE okl_sif_lines_v.id = p_id;

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;

Line 349: -- FUNCTION null_out_defaults for: OKL_SIF_LINES_V --

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

Line 551: -- Validate_Attributes for:OKL_SIF_LINES_V --

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

Line 904: CURSOR okl_klev_pk_csr (p_id IN OKL_SIF_LINES_V.kle_id%TYPE) 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:

Line 2815: -- Validate_Record for:OKL_SIF_LINES_V --

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

Line 2972: -- validate_row for:OKL_SIF_LINES_V --

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,

Line 3133: -- insert_row for:OKL_SIF_LINES --

3129: ---------------------------------------------------------------------------
3130: -- PROCEDURE insert_row
3131: ---------------------------------------------------------------------------
3132: ----------------------------------
3133: -- insert_row for:OKL_SIF_LINES --
3134: ----------------------------------
3135: PROCEDURE insert_row(
3136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3137: x_return_status OUT NOCOPY VARCHAR2,

Line 3149: -- Set_Attributes for:OKL_SIF_LINES --

3145: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3146: l_sil_rec sil_rec_type := p_sil_rec;
3147: l_def_sil_rec sil_rec_type;
3148: --------------------------------------
3149: -- Set_Attributes for:OKL_SIF_LINES --
3150: --------------------------------------
3151: FUNCTION Set_Attributes (
3152: p_sil_rec IN sil_rec_type,
3153: x_sil_rec OUT NOCOPY sil_rec_type

Line 3180: INSERT INTO OKL_SIF_LINES(

3176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3177: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3178: RAISE OKC_API.G_EXCEPTION_ERROR;
3179: END IF;
3180: INSERT INTO OKL_SIF_LINES(
3181: id,
3182: STATE_DEPRE_DMNSHING_VALUE_RT,
3183: BOOK_DEPRE_DMNSHING_VALUE_RT,
3184: residual_guarantee_method,

Line 3344: -- insert_row for:OKL_SIF_LINES_V --

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,

Line 3378: -- Set_Attributes for:OKL_SIF_LINES_V --

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

Line 3575: -- lock_row for:OKL_SIF_LINES --

3571: ---------------------------------------------------------------------------
3572: -- PROCEDURE lock_row
3573: ---------------------------------------------------------------------------
3574: --------------------------------
3575: -- lock_row for:OKL_SIF_LINES --
3576: --------------------------------
3577: PROCEDURE lock_row(
3578: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3579: x_return_status OUT NOCOPY VARCHAR2,

Line 3588: FROM OKL_SIF_LINES

3584: E_Resource_Busy EXCEPTION;
3585: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3586: CURSOR lock_csr (p_sil_rec IN sil_rec_type) IS
3587: SELECT OBJECT_VERSION_NUMBER
3588: FROM OKL_SIF_LINES
3589: WHERE ID = p_sil_rec.id
3590: AND OBJECT_VERSION_NUMBER = p_sil_rec.object_version_number
3591: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3592:

Line 3595: FROM OKL_SIF_LINES

3591: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3592:
3593: CURSOR lchk_csr (p_sil_rec IN sil_rec_type) IS
3594: SELECT OBJECT_VERSION_NUMBER
3595: FROM OKL_SIF_LINES
3596: WHERE ID = p_sil_rec.id;
3597: l_api_version CONSTANT NUMBER := 1;
3598: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
3599: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3600: l_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;

3596: WHERE ID = p_sil_rec.id;
3597: l_api_version CONSTANT NUMBER := 1;
3598: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
3599: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3600: l_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;
3601: lc_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;
3602: l_row_notfound BOOLEAN := FALSE;
3603: lc_row_notfound BOOLEAN := FALSE;
3604: BEGIN

Line 3601: lc_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;

3597: l_api_version CONSTANT NUMBER := 1;
3598: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
3599: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3600: l_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;
3601: lc_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;
3602: l_row_notfound BOOLEAN := FALSE;
3603: lc_row_notfound BOOLEAN := FALSE;
3604: BEGIN
3605: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3681: -- lock_row for:OKL_SIF_LINES_V --

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,

Line 3845: -- update_row for:OKL_SIF_LINES --

3841: ---------------------------------------------------------------------------
3842: -- PROCEDURE update_row
3843: ---------------------------------------------------------------------------
3844: ----------------------------------
3845: -- update_row for:OKL_SIF_LINES --
3846: ----------------------------------
3847: PROCEDURE update_row(
3848: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3849: x_return_status OUT NOCOPY VARCHAR2,

Line 4130: -- Set_Attributes for:OKL_SIF_LINES --

4126: END IF;
4127: RETURN(l_return_status);
4128: END populate_new_record;
4129: --------------------------------------
4130: -- Set_Attributes for:OKL_SIF_LINES --
4131: --------------------------------------
4132: FUNCTION Set_Attributes (
4133: p_sil_rec IN sil_rec_type,
4134: x_sil_rec OUT NOCOPY sil_rec_type

Line 4167: UPDATE OKL_SIF_LINES

4163: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4164: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4165: RAISE OKC_API.G_EXCEPTION_ERROR;
4166: END IF;
4167: UPDATE OKL_SIF_LINES
4168: SET STATE_DEPRE_DMNSHING_VALUE_RT = l_def_sil_rec.STATE_DEPRE_DMNSHING_VALUE_RT,
4169: BOOK_DEPRE_DMNSHING_VALUE_RT = l_def_sil_rec.BOOK_DEPRE_DMNSHING_VALUE_RT,
4170: RESIDUAL_GUARANTEE_METHOD = l_def_sil_rec.residual_guarantee_method,
4171: -- mvasudev , 05/13/2002

Line 4267: -- update_row for:OKL_SIF_LINES_V --

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,

Line 4567: -- Set_Attributes for:OKL_SIF_LINES_V --

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

Line 4766: -- delete_row for:OKL_SIF_LINES --

4762: ---------------------------------------------------------------------------
4763: -- PROCEDURE delete_row
4764: ---------------------------------------------------------------------------
4765: ----------------------------------
4766: -- delete_row for:OKL_SIF_LINES --
4767: ----------------------------------
4768: PROCEDURE delete_row(
4769: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4770: x_return_status OUT NOCOPY VARCHAR2,

Line 4790: DELETE FROM OKL_SIF_LINES

4786: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4787: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4788: RAISE OKC_API.G_EXCEPTION_ERROR;
4789: END IF;
4790: DELETE FROM OKL_SIF_LINES
4791: WHERE ID = l_sil_rec.id;
4792:
4793: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4794: EXCEPTION

Line 4827: -- delete_row for:OKL_SIF_LINES_V --

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,