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_TCL_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 10: SELECT OKL_TXL_CNTRCT_LNS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;

6: FUNCTION get_seq_id RETURN NUMBER IS
7: l_seq NUMBER;
8: BEGIN
9: -- Changed by nikshah for SLA project (Bug 5707866) 16-Apr-2007
10: SELECT OKL_TXL_CNTRCT_LNS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;
11: RETURN l_seq;
12: END get_seq_id;
13:
14: ---------------------------------------------------------------------------

Line 39: -- FUNCTION get_rec for: OKL_TXL_CNTRCT_LNS

35: null;
36: END api_copy;
37:
38: ---------------------------------------------------------------------------
39: -- FUNCTION get_rec for: OKL_TXL_CNTRCT_LNS
40: ---------------------------------------------------------------------------
41: FUNCTION get_rec (
42: p_tcl_rec IN tcl_rec_type,
43: x_no_data_found OUT NOCOPY BOOLEAN

Line 45: CURSOR okl_txl_cntrct_lns_pk_csr (p_id IN NUMBER) IS

41: FUNCTION get_rec (
42: p_tcl_rec IN tcl_rec_type,
43: x_no_data_found OUT NOCOPY BOOLEAN
44: ) RETURN tcl_rec_type IS
45: CURSOR okl_txl_cntrct_lns_pk_csr (p_id IN NUMBER) IS
46: SELECT
47: ID,
48: KHR_ID,
49: KLE_ID,

Line 109: FROM Okl_Txl_Cntrct_Lns

105: STREAM_TYPE_PURPOSE,
106: ASSET_BOOK_TYPE_NAME,
107: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
108: UPGRADE_STATUS_FLAG
109: FROM Okl_Txl_Cntrct_Lns
110: WHERE okl_txl_cntrct_lns.id = p_id;
111: l_okl_txl_cntrct_lns_pk okl_txl_cntrct_lns_pk_csr%ROWTYPE;
112: l_tcl_rec tcl_rec_type;
113: BEGIN

Line 110: WHERE okl_txl_cntrct_lns.id = p_id;

106: ASSET_BOOK_TYPE_NAME,
107: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
108: UPGRADE_STATUS_FLAG
109: FROM Okl_Txl_Cntrct_Lns
110: WHERE okl_txl_cntrct_lns.id = p_id;
111: l_okl_txl_cntrct_lns_pk okl_txl_cntrct_lns_pk_csr%ROWTYPE;
112: l_tcl_rec tcl_rec_type;
113: BEGIN
114: x_no_data_found := TRUE;

Line 111: l_okl_txl_cntrct_lns_pk okl_txl_cntrct_lns_pk_csr%ROWTYPE;

107: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
108: UPGRADE_STATUS_FLAG
109: FROM Okl_Txl_Cntrct_Lns
110: WHERE okl_txl_cntrct_lns.id = p_id;
111: l_okl_txl_cntrct_lns_pk okl_txl_cntrct_lns_pk_csr%ROWTYPE;
112: l_tcl_rec tcl_rec_type;
113: BEGIN
114: x_no_data_found := TRUE;
115: -- Get current database values

Line 116: OPEN okl_txl_cntrct_lns_pk_csr (p_tcl_rec.id);

112: l_tcl_rec tcl_rec_type;
113: BEGIN
114: x_no_data_found := TRUE;
115: -- Get current database values
116: OPEN okl_txl_cntrct_lns_pk_csr (p_tcl_rec.id);
117: FETCH okl_txl_cntrct_lns_pk_csr INTO
118: l_tcl_rec.ID,
119: l_tcl_rec.KHR_ID,
120: l_tcl_rec.KLE_ID,

Line 117: FETCH okl_txl_cntrct_lns_pk_csr INTO

113: BEGIN
114: x_no_data_found := TRUE;
115: -- Get current database values
116: OPEN okl_txl_cntrct_lns_pk_csr (p_tcl_rec.id);
117: FETCH okl_txl_cntrct_lns_pk_csr INTO
118: l_tcl_rec.ID,
119: l_tcl_rec.KHR_ID,
120: l_tcl_rec.KLE_ID,
121: l_tcl_rec.BEFORE_TRANSFER_YN,

Line 181: x_no_data_found := okl_txl_cntrct_lns_pk_csr%NOTFOUND;

177: l_tcl_rec.ASSET_BOOK_TYPE_NAME,
178: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
179: l_tcl_rec.UPGRADE_STATUS_FLAG;
180:
181: x_no_data_found := okl_txl_cntrct_lns_pk_csr%NOTFOUND;
182: CLOSE okl_txl_cntrct_lns_pk_csr;
183: RETURN(l_tcl_rec);
184: END get_rec;
185:

Line 182: CLOSE okl_txl_cntrct_lns_pk_csr;

178: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
179: l_tcl_rec.UPGRADE_STATUS_FLAG;
180:
181: x_no_data_found := okl_txl_cntrct_lns_pk_csr%NOTFOUND;
182: CLOSE okl_txl_cntrct_lns_pk_csr;
183: RETURN(l_tcl_rec);
184: END get_rec;
185:
186: FUNCTION get_rec (

Line 194: -- FUNCTION get_rec for: OKL_TXL_CNTRCT_LNS_V

190: BEGIN
191: RETURN(get_rec(p_tcl_rec, l_row_notfound));
192: END get_rec;
193: ---------------------------------------------------------------------------
194: -- FUNCTION get_rec for: OKL_TXL_CNTRCT_LNS_V
195: ---------------------------------------------------------------------------
196: FUNCTION get_rec (
197: p_tclv_rec IN tclv_rec_type,
198: x_no_data_found OUT NOCOPY BOOLEAN

Line 264: FROM OKL_TXL_CNTRCT_LNS

260: STREAM_TYPE_PURPOSE,
261: ASSET_BOOK_TYPE_NAME,
262: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
263: UPGRADE_STATUS_FLAG
264: FROM OKL_TXL_CNTRCT_LNS
265: WHERE OKL_TXL_CNTRCT_LNS.id = p_id;
266: l_okl_tclv_pk okl_tclv_pk_csr%ROWTYPE;
267: l_tclv_rec tclv_rec_type;
268: BEGIN

Line 265: WHERE OKL_TXL_CNTRCT_LNS.id = p_id;

261: ASSET_BOOK_TYPE_NAME,
262: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
263: UPGRADE_STATUS_FLAG
264: FROM OKL_TXL_CNTRCT_LNS
265: WHERE OKL_TXL_CNTRCT_LNS.id = p_id;
266: l_okl_tclv_pk okl_tclv_pk_csr%ROWTYPE;
267: l_tclv_rec tclv_rec_type;
268: BEGIN
269: x_no_data_found := TRUE;

Line 350: -- FUNCTION null_out_defaults for: OKL_TXL_CNTRCT_LNS_V --

346: RETURN(get_rec(p_tclv_rec, l_row_notfound));
347: END get_rec;
348:
349: ----------------------------------------------------------
350: -- FUNCTION null_out_defaults for: OKL_TXL_CNTRCT_LNS_V --
351: ----------------------------------------------------------
352: FUNCTION null_out_defaults (
353: p_tclv_rec IN tclv_rec_type
354: ) RETURN tclv_rec_type IS

Line 540: -- Validate_Attributes for:OKL_TXL_CNTRCT_LNS_V --

536: ---------------------------------------------------------------------------
537: -- PROCEDURE Validate_Attributes
538: ---------------------------------------------------------------------------
539: --------------------------------------------------
540: -- Validate_Attributes for:OKL_TXL_CNTRCT_LNS_V --
541: --------------------------------------------------
542: FUNCTION Validate_Attributes (
543: p_tclv_rec IN tclv_rec_type
544: ) RETURN VARCHAR2 IS

Line 585: -- Validate_Record for:OKL_TXL_CNTRCT_LNS_V --

581: ---------------------------------------------------------------------------
582: -- PROCEDURE Validate_Record
583: ---------------------------------------------------------------------------
584: ----------------------------------------------
585: -- Validate_Record for:OKL_TXL_CNTRCT_LNS_V --
586: ----------------------------------------------
587: FUNCTION Validate_Record (
588: p_tclv_rec IN tclv_rec_type
589: ) RETURN VARCHAR2 IS

Line 620: CURSOR unique_tcl_csr(p_tcn_id OKL_TXL_CNTRCT_LNS.tcn_id%TYPE

616:
617: l_dummy VARCHAR2(1);
618: l_row_found BOOLEAN := FALSE;
619:
620: CURSOR unique_tcl_csr(p_tcn_id OKL_TXL_CNTRCT_LNS.tcn_id%TYPE
621: ,p_line_number OKL_TXL_CNTRCT_LNS.line_number%TYPE
622: ,p_id OKL_TXL_CNTRCT_LNS.id%TYPE) IS
623: SELECT 1
624: FROM OKL_TXL_CNTRCT_LNS

Line 621: ,p_line_number OKL_TXL_CNTRCT_LNS.line_number%TYPE

617: l_dummy VARCHAR2(1);
618: l_row_found BOOLEAN := FALSE;
619:
620: CURSOR unique_tcl_csr(p_tcn_id OKL_TXL_CNTRCT_LNS.tcn_id%TYPE
621: ,p_line_number OKL_TXL_CNTRCT_LNS.line_number%TYPE
622: ,p_id OKL_TXL_CNTRCT_LNS.id%TYPE) IS
623: SELECT 1
624: FROM OKL_TXL_CNTRCT_LNS
625: WHERE tcn_id = p_tcn_id

Line 622: ,p_id OKL_TXL_CNTRCT_LNS.id%TYPE) IS

618: l_row_found BOOLEAN := FALSE;
619:
620: CURSOR unique_tcl_csr(p_tcn_id OKL_TXL_CNTRCT_LNS.tcn_id%TYPE
621: ,p_line_number OKL_TXL_CNTRCT_LNS.line_number%TYPE
622: ,p_id OKL_TXL_CNTRCT_LNS.id%TYPE) IS
623: SELECT 1
624: FROM OKL_TXL_CNTRCT_LNS
625: WHERE tcn_id = p_tcn_id
626: AND line_number = p_line_number

Line 624: FROM OKL_TXL_CNTRCT_LNS

620: CURSOR unique_tcl_csr(p_tcn_id OKL_TXL_CNTRCT_LNS.tcn_id%TYPE
621: ,p_line_number OKL_TXL_CNTRCT_LNS.line_number%TYPE
622: ,p_id OKL_TXL_CNTRCT_LNS.id%TYPE) IS
623: SELECT 1
624: FROM OKL_TXL_CNTRCT_LNS
625: WHERE tcn_id = p_tcn_id
626: AND line_number = p_line_number
627: AND id <> p_id;
628:

Line 2476: -- validate_row for:OKL_TXL_CNTRCT_LNS_V --

2472: ---------------------------------------------------------------------------
2473: -- PROCEDURE validate_row
2474: ---------------------------------------------------------------------------
2475: -------------------------------------------
2476: -- validate_row for:OKL_TXL_CNTRCT_LNS_V --
2477: -------------------------------------------
2478: PROCEDURE validate_row(
2479: p_api_version IN NUMBER,
2480: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2633: -- insert_row for:OKL_TXL_CNTRCT_LNS --

2629: ---------------------------------------------------------------------------
2630: -- PROCEDURE insert_row
2631: ---------------------------------------------------------------------------
2632: ---------------------------------------
2633: -- insert_row for:OKL_TXL_CNTRCT_LNS --
2634: ---------------------------------------
2635: PROCEDURE insert_row(
2636: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2637: x_return_status OUT NOCOPY VARCHAR2,

Line 2649: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS --

2645: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2646: l_tcl_rec tcl_rec_type := p_tcl_rec;
2647: l_def_tcl_rec tcl_rec_type;
2648: -------------------------------------------
2649: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS --
2650: -------------------------------------------
2651: FUNCTION Set_Attributes (
2652: p_tcl_rec IN tcl_rec_type,
2653: x_tcl_rec OUT NOCOPY tcl_rec_type

Line 2680: INSERT INTO OKL_TXL_CNTRCT_LNS(

2676: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2677: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2678: RAISE OKC_API.G_EXCEPTION_ERROR;
2679: END IF;
2680: INSERT INTO OKL_TXL_CNTRCT_LNS(
2681: id,
2682: khr_id,
2683: kle_id,
2684: before_transfer_yn,

Line 2840: -- insert_row for:OKL_TXL_CNTRCT_LNS_V --

2836: '_PVT'
2837: );
2838: END insert_row;
2839: -----------------------------------------
2840: -- insert_row for:OKL_TXL_CNTRCT_LNS_V --
2841: -----------------------------------------
2842: PROCEDURE insert_row(
2843: p_api_version IN NUMBER,
2844: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2874: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS_V --

2870: l_tclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2871: RETURN(l_tclv_rec);
2872: END fill_who_columns;
2873: ---------------------------------------------
2874: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS_V --
2875: ---------------------------------------------
2876: FUNCTION Set_Attributes (
2877: p_tclv_rec IN tclv_rec_type,
2878: x_tclv_rec OUT NOCOPY tclv_rec_type

Line 3114: -- lock_row for:OKL_TXL_CNTRCT_LNS --

3110: ---------------------------------------------------------------------------
3111: -- PROCEDURE lock_row
3112: ---------------------------------------------------------------------------
3113: -------------------------------------
3114: -- lock_row for:OKL_TXL_CNTRCT_LNS --
3115: -------------------------------------
3116: PROCEDURE lock_row(
3117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3118: x_return_status OUT NOCOPY VARCHAR2,

Line 3127: FROM OKL_TXL_CNTRCT_LNS

3123: E_Resource_Busy EXCEPTION;
3124: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3125: CURSOR lock_csr (p_tcl_rec IN tcl_rec_type) IS
3126: SELECT OBJECT_VERSION_NUMBER
3127: FROM OKL_TXL_CNTRCT_LNS
3128: WHERE ID = p_tcl_rec.id
3129: AND OBJECT_VERSION_NUMBER = p_tcl_rec.object_version_number
3130: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3131:

Line 3134: FROM OKL_TXL_CNTRCT_LNS

3130: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3131:
3132: CURSOR lchk_csr (p_tcl_rec IN tcl_rec_type) IS
3133: SELECT OBJECT_VERSION_NUMBER
3134: FROM OKL_TXL_CNTRCT_LNS
3135: WHERE ID = p_tcl_rec.id;
3136: l_api_version CONSTANT NUMBER := 1;
3137: l_api_name CONSTANT VARCHAR2(30) := 'LNS_lock_row';
3138: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3139: l_object_version_number OKL_TXL_CNTRCT_LNS.OBJECT_VERSION_NUMBER%TYPE;

3135: WHERE ID = p_tcl_rec.id;
3136: l_api_version CONSTANT NUMBER := 1;
3137: l_api_name CONSTANT VARCHAR2(30) := 'LNS_lock_row';
3138: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3139: l_object_version_number OKL_TXL_CNTRCT_LNS.OBJECT_VERSION_NUMBER%TYPE;
3140: lc_object_version_number OKL_TXL_CNTRCT_LNS.OBJECT_VERSION_NUMBER%TYPE;
3141: l_row_notfound BOOLEAN := FALSE;
3142: lc_row_notfound BOOLEAN := FALSE;
3143: BEGIN

Line 3140: lc_object_version_number OKL_TXL_CNTRCT_LNS.OBJECT_VERSION_NUMBER%TYPE;

3136: l_api_version CONSTANT NUMBER := 1;
3137: l_api_name CONSTANT VARCHAR2(30) := 'LNS_lock_row';
3138: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3139: l_object_version_number OKL_TXL_CNTRCT_LNS.OBJECT_VERSION_NUMBER%TYPE;
3140: lc_object_version_number OKL_TXL_CNTRCT_LNS.OBJECT_VERSION_NUMBER%TYPE;
3141: l_row_notfound BOOLEAN := FALSE;
3142: lc_row_notfound BOOLEAN := FALSE;
3143: BEGIN
3144: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3220: -- lock_row for:OKL_TXL_CNTRCT_LNS_V --

3216: '_PVT'
3217: );
3218: END lock_row;
3219: ---------------------------------------
3220: -- lock_row for:OKL_TXL_CNTRCT_LNS_V --
3221: ---------------------------------------
3222: PROCEDURE lock_row(
3223: p_api_version IN NUMBER,
3224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3381: -- update_row for:OKL_TXL_CNTRCT_LNS --

3377: ---------------------------------------------------------------------------
3378: -- PROCEDURE update_row
3379: ---------------------------------------------------------------------------
3380: ---------------------------------------
3381: -- update_row for:OKL_TXL_CNTRCT_LNS --
3382: ---------------------------------------
3383: PROCEDURE update_row(
3384: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3385: x_return_status OUT NOCOPY VARCHAR2,

Line 3653: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS --

3649:
3650: RETURN(l_return_status);
3651: END populate_new_record;
3652: -------------------------------------------
3653: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS --
3654: -------------------------------------------
3655: FUNCTION Set_Attributes (
3656: p_tcl_rec IN tcl_rec_type,
3657: x_tcl_rec OUT NOCOPY tcl_rec_type

Line 3690: UPDATE OKL_TXL_CNTRCT_LNS

3686: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3687: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3688: RAISE OKC_API.G_EXCEPTION_ERROR;
3689: END IF;
3690: UPDATE OKL_TXL_CNTRCT_LNS
3691: SET KHR_ID = l_def_tcl_rec.khr_id,
3692: KLE_ID = l_def_tcl_rec.kle_id,
3693: BEFORE_TRANSFER_YN = l_def_tcl_rec.before_transfer_yn,
3694: TCN_ID = l_def_tcl_rec.tcn_id,

Line 3788: -- update_row for:OKL_TXL_CNTRCT_LNS_V --

3784: '_PVT'
3785: );
3786: END update_row;
3787: -----------------------------------------
3788: -- update_row for:OKL_TXL_CNTRCT_LNS_V --
3789: -----------------------------------------
3790: PROCEDURE update_row(
3791: p_api_version IN NUMBER,
3792: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4075: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS_V --

4071:
4072: RETURN(l_return_status);
4073: END populate_new_record;
4074: ---------------------------------------------
4075: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS_V --
4076: ---------------------------------------------
4077: FUNCTION Set_Attributes (
4078: p_tclv_rec IN tclv_rec_type,
4079: x_tclv_rec OUT NOCOPY tclv_rec_type

Line 4284: -- delete_row for:OKL_TXL_CNTRCT_LNS --

4280: ---------------------------------------------------------------------------
4281: -- PROCEDURE delete_row
4282: ---------------------------------------------------------------------------
4283: ---------------------------------------
4284: -- delete_row for:OKL_TXL_CNTRCT_LNS --
4285: ---------------------------------------
4286: PROCEDURE delete_row(
4287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4288: x_return_status OUT NOCOPY VARCHAR2,

Line 4308: DELETE FROM OKL_TXL_CNTRCT_LNS

4304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4306: RAISE OKC_API.G_EXCEPTION_ERROR;
4307: END IF;
4308: DELETE FROM OKL_TXL_CNTRCT_LNS
4309: WHERE ID = l_tcl_rec.id;
4310:
4311: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4312: EXCEPTION

Line 4345: -- delete_row for:OKL_TXL_CNTRCT_LNS_V --

4341: '_PVT'
4342: );
4343: END delete_row;
4344: -----------------------------------------
4345: -- delete_row for:OKL_TXL_CNTRCT_LNS_V --
4346: -----------------------------------------
4347: PROCEDURE delete_row(
4348: p_api_version IN NUMBER,
4349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,