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.OKC_CLE_PVT dependencies on OKC_K_LINES_B

Line 184: from OKC_K_LINES_B

180:
181: l_dummy_var VARCHAR2(1) := '?';
182: Cursor l_clev_csr Is
183: select 'x'
184: from OKC_K_LINES_B
185: where ID = p_clev_rec.cle_id;
186: Begin
187:
188: IF (l_debug = 'Y') THEN

Line 270: FROM okc_k_lines_b

266: from OKC_LINE_STYLES_V
267: where ID = p_clev_rec.lse_id;
268: CURSOR c_lines61( p_chr_id NUMBER, p_cle_id NUMBER ) IS
269: SELECT 'x'
270: FROM okc_k_lines_b
271: WHERE chr_id = p_chr_id AND id<>Nvl(p_cle_id,-1) AND lse_id=61;
272: -- Rajendra
273: CURSOR c_access_level IS
274: SELECT access_level

Line 1169: FROM OKC_K_LINES_B

1165:
1166: -- Cursor to get parent line's start and end dates
1167: Cursor l_clev_csr Is
1168: SELECT START_DATE, END_DATE
1169: FROM OKC_K_LINES_B
1170: WHERE ID = p_clev_rec.cle_id;
1171: Begin
1172:
1173: IF (l_debug = 'Y') THEN

Line 1297: FROM OKC_K_LINES_B

1293:
1294: -- Cursor to get parent line's start and end dates
1295: Cursor l_clev_csr Is
1296: SELECT START_DATE, END_DATE
1297: FROM OKC_K_LINES_B
1298: WHERE ID = p_clev_rec.cle_id;
1299: Begin
1300:
1301: IF (l_debug = 'Y') THEN

Line 1473: from OKC_K_LINES_B

1469: x_line_number OUT NOCOPY NUMBER) Is
1470: -- cursor to get next line number if parent is header
1471: Cursor l_clev_csr1 Is
1472: select line_number
1473: from OKC_K_LINES_B
1474: where chr_id = p_chr_id;
1475:
1476: -- cursor to get next line number if parent is another line
1477: Cursor l_clev_csr2 Is

Line 1479: from OKC_K_LINES_B

1475:
1476: -- cursor to get next line number if parent is another line
1477: Cursor l_clev_csr2 Is
1478: select line_number
1479: from OKC_K_LINES_B
1480: where cle_id = p_cle_id;
1481: l_line_number_n NUMBER;
1482: BEGIN
1483:

Line 2315: FROM OKC_K_LINES_B

2311:
2312: l_dummy_var VARCHAR2(1) := '?';
2313: Cursor l_tml_id_csr Is
2314: SELECT 'x'
2315: FROM OKC_K_LINES_B
2316: WHERE id = p_clev_rec.config_top_model_line_id
2317: AND CONFIG_ITEM_TYPE = 'TOP_MODEL_LINE';
2318: Begin
2319:

Line 2802: FROM OKC_K_LINES_B B

2798:
2799: DELETE FROM OKC_K_LINES_TL T
2800: WHERE NOT EXISTS (
2801: SELECT NULL
2802: FROM OKC_K_LINES_B B
2803: WHERE B.ID = T.ID
2804: );
2805:
2806: UPDATE OKC_K_LINES_TL T SET (

Line 2898: FROM OKC_K_LINES_BH B

2894: /*
2895: DELETE FROM OKC_K_LINES_TLH T
2896: WHERE NOT EXISTS (
2897: SELECT NULL
2898: FROM OKC_K_LINES_BH B
2899: WHERE B.ID = T.ID
2900: AND T.MAJOR_VERSION = B.MAJOR_VERSION
2901: );
2902:

Line 3007: -- FUNCTION get_rec for: OKC_K_LINES_B

3003:
3004: END add_language;
3005:
3006: ---------------------------------------------------------------------------
3007: -- FUNCTION get_rec for: OKC_K_LINES_B
3008: ---------------------------------------------------------------------------
3009: FUNCTION get_rec (
3010: p_cle_rec IN cle_rec_type,
3011: x_no_data_found OUT NOCOPY BOOLEAN

Line 3111: FROM Okc_K_Lines_B

3107: --canc_reason_code,
3108: TERM_CANCEL_SOURCE,
3109: CANCELLED_AMOUNT,
3110: payment_instruction_type --added by mchoudha 22-JUL
3111: FROM Okc_K_Lines_B
3112: WHERE okc_k_lines_b.id = p_id;
3113: l_cle_pk cle_pk_csr%ROWTYPE;
3114: l_cle_rec cle_rec_type;
3115: BEGIN

Line 3112: WHERE okc_k_lines_b.id = p_id;

3108: TERM_CANCEL_SOURCE,
3109: CANCELLED_AMOUNT,
3110: payment_instruction_type --added by mchoudha 22-JUL
3111: FROM Okc_K_Lines_B
3112: WHERE okc_k_lines_b.id = p_id;
3113: l_cle_pk cle_pk_csr%ROWTYPE;
3114: l_cle_rec cle_rec_type;
3115: BEGIN
3116:

Line 4876: -- insert_row for:OKC_K_LINES_B --

4872: ---------------------------------------------------------------------------
4873: -- PROCEDURE insert_row
4874: ---------------------------------------------------------------------------
4875: ----------------------------------
4876: -- insert_row for:OKC_K_LINES_B --
4877: ----------------------------------
4878: PROCEDURE insert_row(
4879: p_init_msg_list IN VARCHAR2,
4880: x_return_status OUT NOCOPY VARCHAR2,

Line 4892: -- Set_Attributes for:OKC_K_LINES_B --

4888: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4889: l_cle_rec cle_rec_type := p_cle_rec;
4890: l_def_cle_rec cle_rec_type;
4891: --------------------------------------
4892: -- Set_Attributes for:OKC_K_LINES_B --
4893: --------------------------------------
4894: FUNCTION Set_Attributes (
4895: p_cle_rec IN cle_rec_type,
4896: x_cle_rec OUT NOCOPY cle_rec_type

Line 4931: INSERT INTO OKC_K_LINES_B(

4927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4929: RAISE OKC_API.G_EXCEPTION_ERROR;
4930: END IF;
4931: INSERT INTO OKC_K_LINES_B(
4932: id,
4933: line_number,
4934: chr_id,
4935: cle_id,

Line 5706: -- lock_row for:OKC_K_LINES_B --

5702: ---------------------------------------------------------------------------
5703: -- PROCEDURE lock_row
5704: ---------------------------------------------------------------------------
5705: --------------------------------
5706: -- lock_row for:OKC_K_LINES_B --
5707: --------------------------------
5708: PROCEDURE lock_row(
5709: p_init_msg_list IN VARCHAR2,
5710: x_return_status OUT NOCOPY VARCHAR2,

Line 5719: FROM OKC_K_LINES_B

5715: E_Resource_Busy EXCEPTION;
5716: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5717: CURSOR lock_csr (p_cle_rec IN cle_rec_type) IS
5718: SELECT OBJECT_VERSION_NUMBER
5719: FROM OKC_K_LINES_B
5720: WHERE ID = p_cle_rec.id
5721: AND OBJECT_VERSION_NUMBER = p_cle_rec.object_version_number
5722: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5723:

Line 5726: FROM OKC_K_LINES_B

5722: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5723:
5724: CURSOR lchk_csr (p_cle_rec IN cle_rec_type) IS
5725: SELECT OBJECT_VERSION_NUMBER
5726: FROM OKC_K_LINES_B
5727: WHERE ID = p_cle_rec.id;
5728: l_api_version CONSTANT NUMBER := 1;
5729: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5730: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 5731: l_object_version_number OKC_K_LINES_B.OBJECT_VERSION_NUMBER%TYPE;

5727: WHERE ID = p_cle_rec.id;
5728: l_api_version CONSTANT NUMBER := 1;
5729: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5730: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5731: l_object_version_number OKC_K_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
5732: lc_object_version_number OKC_K_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
5733: l_row_notfound BOOLEAN := FALSE;
5734: lc_row_notfound BOOLEAN := FALSE;
5735: BEGIN

Line 5732: lc_object_version_number OKC_K_LINES_B.OBJECT_VERSION_NUMBER%TYPE;

5728: l_api_version CONSTANT NUMBER := 1;
5729: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5730: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5731: l_object_version_number OKC_K_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
5732: lc_object_version_number OKC_K_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
5733: l_row_notfound BOOLEAN := FALSE;
5734: lc_row_notfound BOOLEAN := FALSE;
5735: BEGIN
5736:

Line 6230: -- update_row for:OKC_K_LINES_B --

6226: ---------------------------------------------------------------------------
6227: -- PROCEDURE update_row
6228: ---------------------------------------------------------------------------
6229: ----------------------------------
6230: -- update_row for:OKC_K_LINES_B --
6231: ----------------------------------
6232: PROCEDURE update_row(
6233: p_init_msg_list IN VARCHAR2,
6234: x_return_status OUT NOCOPY VARCHAR2,

Line 6660: -- Set_Attributes for:OKC_K_LINES_B --

6656: RETURN(l_return_status);
6657:
6658: END populate_new_record;
6659: --------------------------------------
6660: -- Set_Attributes for:OKC_K_LINES_B --
6661: --------------------------------------
6662: FUNCTION Set_Attributes (
6663: p_cle_rec IN cle_rec_type,
6664: x_cle_rec OUT NOCOPY cle_rec_type

Line 6706: UPDATE OKC_K_LINES_B

6702: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6703: RAISE OKC_API.G_EXCEPTION_ERROR;
6704: END IF;
6705:
6706: UPDATE OKC_K_LINES_B
6707: SET LINE_NUMBER = l_def_cle_rec.line_number,
6708: CHR_ID = l_def_cle_rec.chr_id,
6709: CLE_ID = l_def_cle_rec.cle_id,
6710: DNZ_CHR_ID = l_def_cle_rec.dnz_chr_id,

Line 7845: -- delete_row for:OKC_K_LINES_B --

7841: ---------------------------------------------------------------------------
7842: -- PROCEDURE delete_row
7843: ---------------------------------------------------------------------------
7844: ----------------------------------
7845: -- delete_row for:OKC_K_LINES_B --
7846: ----------------------------------
7847: PROCEDURE delete_row(
7848: p_init_msg_list IN VARCHAR2,
7849: x_return_status OUT NOCOPY VARCHAR2,

Line 7875: DELETE FROM OKC_K_LINES_B

7871: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7872: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7873: RAISE OKC_API.G_EXCEPTION_ERROR;
7874: END IF;
7875: DELETE FROM OKC_K_LINES_B
7876: WHERE ID = l_cle_rec.id;
7877:
7878: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
7879:

Line 8092: FROM okc_k_lines_b

8088: WHERE subject_cle_id = p_clev_rec.id;
8089:
8090: Cursor c_parent_line_id (p_line_id NUMBER) Is
8091: SELECT cle_id
8092: FROM okc_k_lines_b
8093: WHERE id = p_line_id
8094: AND lse_id in (7,8,9,10,11,13,18,25,35);
8095:
8096: Cursor cop_csr(p_oie_id NUMBER) Is

Line 8112: FROM okc_k_lines_b

8108: Cursor ste_csr Is
8109: SELECT ste_code
8110: FROM okc_statuses_b
8111: WHERE code = (SELECT sts_code
8112: FROM okc_k_lines_b
8113: WHERE id = p_clev_rec.id);
8114:
8115: BEGIN
8116:

Line 8234: UPDATE okc_k_lines_b

8230:
8231:
8232: l_parent_line_id := NULL;
8233:
8234: UPDATE okc_k_lines_b
8235: SET date_renewed = null
8236: WHERE id = ole_rec.object_cle_id
8237: AND date_renewed is not null;
8238:

Line 8245: UPDATE okc_k_lines_b

8241: Fetch c_parent_line_id into l_parent_line_id ;
8242: Close c_parent_line_id ;
8243:
8244: If l_parent_line_id IS NOT NULL then
8245: UPDATE okc_k_lines_b
8246: SET date_renewed = null
8247: WHERE id = l_parent_line_id
8248: AND date_renewed is not null;
8249: End If;

Line 8947: INTO OKC_K_LINES_B

8943: END LOOP;
8944:
8945: FORALL i in 1..l_tabsize
8946: INSERT
8947: INTO OKC_K_LINES_B
8948: (
8949: id,
8950: line_number,
8951: chr_id,

Line 9236: INSERT INTO okc_k_lines_bh

9232: okc_debug.Set_Indentation('OKC_CLE_PVT');
9233: okc_debug.log('23400: Entered create_version', 2);
9234: END IF;
9235:
9236: INSERT INTO okc_k_lines_bh
9237: (
9238: major_version,
9239: id,
9240: line_number,

Line 9436: FROM okc_k_lines_b

9432: term_cancel_source,
9433: cancelled_amount,
9434: payment_instruction_type, --Added by mchoudha 22-JUL
9435: annualized_factor --Added by npalepu 26-JUL
9436: FROM okc_k_lines_b
9437: WHERE dnz_chr_id = p_chr_id;
9438:
9439: ----------------------------------
9440: -- Version TL Table

Line 9481: from okc_k_lines_b

9477: last_update_date,
9478: last_update_login
9479: FROM okc_k_lines_tl
9480: WHERE id in (select id
9481: from okc_k_lines_b
9482: where dnz_chr_id = p_chr_id);
9483:
9484: IF (l_debug = 'Y') THEN
9485: okc_debug.log('23500: Exiting create_version', 2);

Line 9568: FROM okc_k_lines_bh

9564: last_update_date,
9565: last_update_login
9566: FROM okc_k_lines_tlh
9567: WHERE id in (SELECT id
9568: FROM okc_k_lines_bh
9569: WHERE dnz_chr_id = p_chr_id)
9570: AND major_version = p_major_version;
9571:
9572: ------------------------------------------

Line 9576: INSERT INTO okc_k_lines_b

9572: ------------------------------------------
9573: -- Restoring Base Table
9574: ------------------------------------------
9575:
9576: INSERT INTO okc_k_lines_b
9577: (
9578: id,
9579: line_number,
9580: chr_id,

Line 9775: FROM okc_k_lines_bh

9771: TERM_CANCEL_SOURCE,
9772: cancelled_amount,
9773: annualized_factor --added by npalepu 26-JUL
9774:
9775: FROM okc_k_lines_bh
9776: WHERE dnz_chr_id = p_chr_id
9777: AND major_version = p_major_version;
9778:
9779: IF (l_debug = 'Y') THEN