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 108: FROM Okl_Sif_Lines

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

Line 109: WHERE okl_sif_lines.id = p_id;

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

Line 194: -- FUNCTION get_rec for: OKL_SIF_LINES_V

190: BEGIN
191: RETURN(get_rec(p_sil_rec, l_row_notfound));
192: END get_rec;
193: ---------------------------------------------------------------------------
194: -- FUNCTION get_rec for: OKL_SIF_LINES_V
195: ---------------------------------------------------------------------------
196: FUNCTION get_rec (
197: p_silv_rec IN silv_rec_type,
198: x_no_data_found OUT NOCOPY BOOLEAN

Line 266: FROM Okl_Sif_Lines_V

262: RESIDUAL_DATE,
263: DOWN_PAYMENT_AMOUNT,
264: CAPITALIZE_DOWN_PAYMENT_YN,
265: orig_contract_line_id
266: FROM Okl_Sif_Lines_V
267: WHERE okl_sif_lines_v.id = p_id;
268: l_silv_pk silv_pk_csr%ROWTYPE;
269: l_silv_rec silv_rec_type;
270: BEGIN

Line 267: WHERE okl_sif_lines_v.id = p_id;

263: DOWN_PAYMENT_AMOUNT,
264: CAPITALIZE_DOWN_PAYMENT_YN,
265: orig_contract_line_id
266: FROM Okl_Sif_Lines_V
267: WHERE okl_sif_lines_v.id = p_id;
268: l_silv_pk silv_pk_csr%ROWTYPE;
269: l_silv_rec silv_rec_type;
270: BEGIN
271: x_no_data_found := TRUE;

Line 353: -- FUNCTION null_out_defaults for: OKL_SIF_LINES_V --

349: RETURN(get_rec(p_silv_rec, l_row_notfound));
350: END get_rec;
351:
352: -----------------------------------------------------
353: -- FUNCTION null_out_defaults for: OKL_SIF_LINES_V --
354: -----------------------------------------------------
355: FUNCTION null_out_defaults (
356: p_silv_rec IN silv_rec_type
357: ) RETURN silv_rec_type IS

Line 560: -- Validate_Attributes for:OKL_SIF_LINES_V --

556: ---------------------------------------------------------------------------
557: -- PROCEDURE Validate_Attributes
558: ---------------------------------------------------------------------------
559: ---------------------------------------------
560: -- Validate_Attributes for:OKL_SIF_LINES_V --
561: ---------------------------------------------
562: FUNCTION Validate_Attributes (
563: p_silv_rec IN silv_rec_type
564: ) RETURN VARCHAR2 IS

Line 913: CURSOR okl_klev_pk_csr (p_id IN OKL_SIF_LINES_V.kle_id%TYPE) IS

909: l_dummy VARCHAR2(1) := '?';
910: l_row_not_found BOOLEAN := FALSE;
911:
912: -- Cursor For OKL_SIL_KLE_FK;
913: CURSOR okl_klev_pk_csr (p_id IN OKL_SIF_LINES_V.kle_id%TYPE) IS
914: SELECT '1'
915: FROM OKL_K_LINES_V
916: WHERE OKL_K_LINES_V.id = p_id;
917:

Line 2824: -- Validate_Record for:OKL_SIF_LINES_V --

2820: ---------------------------------------------------------------------------
2821: -- PROCEDURE Validate_Record
2822: ---------------------------------------------------------------------------
2823: -----------------------------------------
2824: -- Validate_Record for:OKL_SIF_LINES_V --
2825: -----------------------------------------
2826: FUNCTION Validate_Record (
2827: p_silv_rec IN silv_rec_type
2828: ) RETURN VARCHAR2 IS

Line 2983: -- validate_row for:OKL_SIF_LINES_V --

2979: ---------------------------------------------------------------------------
2980: -- PROCEDURE validate_row
2981: ---------------------------------------------------------------------------
2982: --------------------------------------
2983: -- validate_row for:OKL_SIF_LINES_V --
2984: --------------------------------------
2985: PROCEDURE validate_row(
2986: p_api_version IN NUMBER,
2987: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3144: -- insert_row for:OKL_SIF_LINES --

3140: ---------------------------------------------------------------------------
3141: -- PROCEDURE insert_row
3142: ---------------------------------------------------------------------------
3143: ----------------------------------
3144: -- insert_row for:OKL_SIF_LINES --
3145: ----------------------------------
3146: PROCEDURE insert_row(
3147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3148: x_return_status OUT NOCOPY VARCHAR2,

Line 3160: -- Set_Attributes for:OKL_SIF_LINES --

3156: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3157: l_sil_rec sil_rec_type := p_sil_rec;
3158: l_def_sil_rec sil_rec_type;
3159: --------------------------------------
3160: -- Set_Attributes for:OKL_SIF_LINES --
3161: --------------------------------------
3162: FUNCTION Set_Attributes (
3163: p_sil_rec IN sil_rec_type,
3164: x_sil_rec OUT NOCOPY sil_rec_type

Line 3191: INSERT INTO OKL_SIF_LINES(

3187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3188: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3189: RAISE OKC_API.G_EXCEPTION_ERROR;
3190: END IF;
3191: INSERT INTO OKL_SIF_LINES(
3192: id,
3193: STATE_DEPRE_DMNSHING_VALUE_RT,
3194: BOOK_DEPRE_DMNSHING_VALUE_RT,
3195: residual_guarantee_method,

Line 3357: -- insert_row for:OKL_SIF_LINES_V --

3353: '_PVT'
3354: );
3355: END insert_row;
3356: ------------------------------------
3357: -- insert_row for:OKL_SIF_LINES_V --
3358: ------------------------------------
3359: PROCEDURE insert_row(
3360: p_api_version IN NUMBER,
3361: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3391: -- Set_Attributes for:OKL_SIF_LINES_V --

3387: l_silv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3388: RETURN(l_silv_rec);
3389: END fill_who_columns;
3390: ----------------------------------------
3391: -- Set_Attributes for:OKL_SIF_LINES_V --
3392: ----------------------------------------
3393: FUNCTION Set_Attributes (
3394: p_silv_rec IN silv_rec_type,
3395: x_silv_rec OUT NOCOPY silv_rec_type

Line 3588: -- lock_row for:OKL_SIF_LINES --

3584: ---------------------------------------------------------------------------
3585: -- PROCEDURE lock_row
3586: ---------------------------------------------------------------------------
3587: --------------------------------
3588: -- lock_row for:OKL_SIF_LINES --
3589: --------------------------------
3590: PROCEDURE lock_row(
3591: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3592: x_return_status OUT NOCOPY VARCHAR2,

Line 3601: FROM OKL_SIF_LINES

3597: E_Resource_Busy EXCEPTION;
3598: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3599: CURSOR lock_csr (p_sil_rec IN sil_rec_type) IS
3600: SELECT OBJECT_VERSION_NUMBER
3601: FROM OKL_SIF_LINES
3602: WHERE ID = p_sil_rec.id
3603: AND OBJECT_VERSION_NUMBER = p_sil_rec.object_version_number
3604: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3605:

Line 3608: FROM OKL_SIF_LINES

3604: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3605:
3606: CURSOR lchk_csr (p_sil_rec IN sil_rec_type) IS
3607: SELECT OBJECT_VERSION_NUMBER
3608: FROM OKL_SIF_LINES
3609: WHERE ID = p_sil_rec.id;
3610: l_api_version CONSTANT NUMBER := 1;
3611: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
3612: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3613: l_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;

3609: WHERE ID = p_sil_rec.id;
3610: l_api_version CONSTANT NUMBER := 1;
3611: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
3612: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3613: l_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;
3614: lc_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;
3615: l_row_notfound BOOLEAN := FALSE;
3616: lc_row_notfound BOOLEAN := FALSE;
3617: BEGIN

Line 3614: lc_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;

3610: l_api_version CONSTANT NUMBER := 1;
3611: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
3612: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3613: l_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;
3614: lc_object_version_number OKL_SIF_LINES.OBJECT_VERSION_NUMBER%TYPE;
3615: l_row_notfound BOOLEAN := FALSE;
3616: lc_row_notfound BOOLEAN := FALSE;
3617: BEGIN
3618: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3694: -- lock_row for:OKL_SIF_LINES_V --

3690: '_PVT'
3691: );
3692: END lock_row;
3693: ----------------------------------
3694: -- lock_row for:OKL_SIF_LINES_V --
3695: ----------------------------------
3696: PROCEDURE lock_row(
3697: p_api_version IN NUMBER,
3698: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3858: -- update_row for:OKL_SIF_LINES --

3854: ---------------------------------------------------------------------------
3855: -- PROCEDURE update_row
3856: ---------------------------------------------------------------------------
3857: ----------------------------------
3858: -- update_row for:OKL_SIF_LINES --
3859: ----------------------------------
3860: PROCEDURE update_row(
3861: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3862: x_return_status OUT NOCOPY VARCHAR2,

Line 4149: -- Set_Attributes for:OKL_SIF_LINES --

4145:
4146: RETURN(l_return_status);
4147: END populate_new_record;
4148: --------------------------------------
4149: -- Set_Attributes for:OKL_SIF_LINES --
4150: --------------------------------------
4151: FUNCTION Set_Attributes (
4152: p_sil_rec IN sil_rec_type,
4153: x_sil_rec OUT NOCOPY sil_rec_type

Line 4186: UPDATE OKL_SIF_LINES

4182: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4183: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4184: RAISE OKC_API.G_EXCEPTION_ERROR;
4185: END IF;
4186: UPDATE OKL_SIF_LINES
4187: SET STATE_DEPRE_DMNSHING_VALUE_RT = l_def_sil_rec.STATE_DEPRE_DMNSHING_VALUE_RT,
4188: BOOK_DEPRE_DMNSHING_VALUE_RT = l_def_sil_rec.BOOK_DEPRE_DMNSHING_VALUE_RT,
4189: RESIDUAL_GUARANTEE_METHOD = l_def_sil_rec.residual_guarantee_method,
4190: -- mvasudev , 05/13/2002

Line 4287: -- update_row for:OKL_SIF_LINES_V --

4283: '_PVT'
4284: );
4285: END update_row;
4286: ------------------------------------
4287: -- update_row for:OKL_SIF_LINES_V --
4288: ------------------------------------
4289: PROCEDURE update_row(
4290: p_api_version IN NUMBER,
4291: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4593: -- Set_Attributes for:OKL_SIF_LINES_V --

4589:
4590: RETURN(l_return_status);
4591: END populate_new_record;
4592: ----------------------------------------
4593: -- Set_Attributes for:OKL_SIF_LINES_V --
4594: ----------------------------------------
4595: FUNCTION Set_Attributes (
4596: p_silv_rec IN silv_rec_type,
4597: x_silv_rec OUT NOCOPY silv_rec_type

Line 4792: -- delete_row for:OKL_SIF_LINES --

4788: ---------------------------------------------------------------------------
4789: -- PROCEDURE delete_row
4790: ---------------------------------------------------------------------------
4791: ----------------------------------
4792: -- delete_row for:OKL_SIF_LINES --
4793: ----------------------------------
4794: PROCEDURE delete_row(
4795: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4796: x_return_status OUT NOCOPY VARCHAR2,

Line 4816: DELETE FROM OKL_SIF_LINES

4812: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4813: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4814: RAISE OKC_API.G_EXCEPTION_ERROR;
4815: END IF;
4816: DELETE FROM OKL_SIF_LINES
4817: WHERE ID = l_sil_rec.id;
4818:
4819: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4820: EXCEPTION

Line 4853: -- delete_row for:OKL_SIF_LINES_V --

4849: '_PVT'
4850: );
4851: END delete_row;
4852: ------------------------------------
4853: -- delete_row for:OKL_SIF_LINES_V --
4854: ------------------------------------
4855: PROCEDURE delete_row(
4856: p_api_version IN NUMBER,
4857: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,