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_CNL_PVT dependencies on OKC_CONDITION_LINES_B

Line 53: FROM OKC_CONDITION_LINES_B B

49:
50: DELETE FROM OKC_CONDITION_LINES_TL T
51: WHERE NOT EXISTS (
52: SELECT NULL
53: FROM OKC_CONDITION_LINES_B B
54: WHERE B.ID = T.ID
55: );
56:
57: UPDATE OKC_CONDITION_LINES_TL T SET (

Line 112: FROM OKC_CONDITION_LINES_BH B

108: );
109: DELETE FROM OKC_CONDITION_LINES_TLH T
110: WHERE NOT EXISTS (
111: SELECT NULL
112: FROM OKC_CONDITION_LINES_BH B
113: WHERE B.ID = T.ID
114: AND B.MAJOR_VERSION = T.MAJOR_VERSION
115: );
116:

Line 183: -- FUNCTION get_rec for: OKC_CONDITION_LINES_B

179:
180: END add_language;
181:
182: ---------------------------------------------------------------------------
183: -- FUNCTION get_rec for: OKC_CONDITION_LINES_B
184: ---------------------------------------------------------------------------
185: FUNCTION get_rec (
186: p_cnl_rec IN cnl_rec_type,
187: x_no_data_found OUT NOCOPY BOOLEAN

Line 189: CURSOR okc_condition_lines_b_pk_csr (p_id IN NUMBER) IS

185: FUNCTION get_rec (
186: p_cnl_rec IN cnl_rec_type,
187: x_no_data_found OUT NOCOPY BOOLEAN
188: ) RETURN cnl_rec_type IS
189: CURSOR okc_condition_lines_b_pk_csr (p_id IN NUMBER) IS
190: SELECT
191: ID,
192: CNH_ID,
193: PDF_ID,

Line 233: FROM Okc_Condition_Lines_B

229: ATTRIBUTE14,
230: ATTRIBUTE15,
231: APPLICATION_ID,
232: SEEDED_FLAG
233: FROM Okc_Condition_Lines_B
234: WHERE okc_condition_lines_b.id = p_id;
235: l_okc_condition_lines_b_pk okc_condition_lines_b_pk_csr%ROWTYPE;
236: l_cnl_rec cnl_rec_type;
237: BEGIN

Line 234: WHERE okc_condition_lines_b.id = p_id;

230: ATTRIBUTE15,
231: APPLICATION_ID,
232: SEEDED_FLAG
233: FROM Okc_Condition_Lines_B
234: WHERE okc_condition_lines_b.id = p_id;
235: l_okc_condition_lines_b_pk okc_condition_lines_b_pk_csr%ROWTYPE;
236: l_cnl_rec cnl_rec_type;
237: BEGIN
238: x_no_data_found := TRUE;

Line 235: l_okc_condition_lines_b_pk okc_condition_lines_b_pk_csr%ROWTYPE;

231: APPLICATION_ID,
232: SEEDED_FLAG
233: FROM Okc_Condition_Lines_B
234: WHERE okc_condition_lines_b.id = p_id;
235: l_okc_condition_lines_b_pk okc_condition_lines_b_pk_csr%ROWTYPE;
236: l_cnl_rec cnl_rec_type;
237: BEGIN
238: x_no_data_found := TRUE;
239: -- Get current database values

Line 240: OPEN okc_condition_lines_b_pk_csr (p_cnl_rec.id);

236: l_cnl_rec cnl_rec_type;
237: BEGIN
238: x_no_data_found := TRUE;
239: -- Get current database values
240: OPEN okc_condition_lines_b_pk_csr (p_cnl_rec.id);
241: FETCH okc_condition_lines_b_pk_csr INTO
242: l_cnl_rec.ID,
243: l_cnl_rec.CNH_ID,
244: l_cnl_rec.PDF_ID,

Line 241: FETCH okc_condition_lines_b_pk_csr INTO

237: BEGIN
238: x_no_data_found := TRUE;
239: -- Get current database values
240: OPEN okc_condition_lines_b_pk_csr (p_cnl_rec.id);
241: FETCH okc_condition_lines_b_pk_csr INTO
242: l_cnl_rec.ID,
243: l_cnl_rec.CNH_ID,
244: l_cnl_rec.PDF_ID,
245: l_cnl_rec.AAE_ID,

Line 284: x_no_data_found := okc_condition_lines_b_pk_csr%NOTFOUND;

280: l_cnl_rec.ATTRIBUTE14,
281: l_cnl_rec.ATTRIBUTE15,
282: l_cnl_rec.APPLICATION_ID,
283: l_cnl_rec.SEEDED_FLAG;
284: x_no_data_found := okc_condition_lines_b_pk_csr%NOTFOUND;
285: CLOSE okc_condition_lines_b_pk_csr;
286: RETURN(l_cnl_rec);
287: END get_rec;
288:

Line 285: CLOSE okc_condition_lines_b_pk_csr;

281: l_cnl_rec.ATTRIBUTE15,
282: l_cnl_rec.APPLICATION_ID,
283: l_cnl_rec.SEEDED_FLAG;
284: x_no_data_found := okc_condition_lines_b_pk_csr%NOTFOUND;
285: CLOSE okc_condition_lines_b_pk_csr;
286: RETURN(l_cnl_rec);
287: END get_rec;
288:
289: FUNCTION get_rec (

Line 1149: okc_condition_lines_b cnl,

1145: l_temp NUMBER ;
1146: CURSOR ctr_cur IS
1147: SELECT 'X'
1148: FROM okc_condition_headers_b cnh,
1149: okc_condition_lines_b cnl,
1150: okx_counters_v ctr
1151: WHERE cnh.id = cnl.cnh_id
1152: AND cnh.counter_group_id = ctr.counter_group_id
1153: AND ctr.counter_id = p_cnlv_rec.left_ctr_master_id;

Line 1219: okc_condition_lines_b cnl,

1215: l_temp NUMBER ;
1216: CURSOR ctr_cur IS
1217: SELECT 'X'
1218: FROM okc_condition_headers_b cnh,
1219: okc_condition_lines_b cnl,
1220: okx_counters_v ctr
1221: WHERE cnh.id = cnl.cnh_id
1222: AND cnh.counter_group_id = ctr.counter_group_id
1223: AND ctr.counter_id = p_cnlv_rec.right_ctr_master_id;

Line 1289: okc_condition_lines_b cnl,

1285: l_temp NUMBER ;
1286: CURSOR ctr_cur IS
1287: SELECT 'X'
1288: FROM okc_condition_headers_b cnh,
1289: okc_condition_lines_b cnl,
1290: okx_counters_v ctr
1291: WHERE cnh.id = cnl.cnh_id
1292: AND cnh.counter_group_id = ctr.counter_group_id
1293: AND ctr.counter_id = p_cnlv_rec.right_counter_id;

Line 1361: okc_condition_lines_b cnl,

1357:
1358: CURSOR ctr_cur IS
1359: SELECT 'X'
1360: FROM okc_condition_headers_b cnh,
1361: okc_condition_lines_b cnl,
1362: okx_counters_v ctr
1363: WHERE cnh.id = cnl.cnh_id
1364: AND cnh.counter_group_id = ctr.counter_group_id
1365: AND ctr.counter_id = p_cnlv_rec.left_counter_id;

Line 2013: OKC_condition_lines_b cnl

2009: IS
2010: SELECT acn.counter_action_yn counter_action_yn
2011: FROM okc_actions_b acn,
2012: okc_condition_headers_b cnh,
2013: OKC_condition_lines_b cnl
2014: WHERE acn.id = cnh.acn_id
2015: AND cnh.id = cnl.cnh_id
2016: AND cnl.cnh_id = p_cnlv_rec.cnh_id;
2017: acn_rec acn_cur%ROWTYPE;

Line 3085: -- insert_row for:OKC_CONDITION_LINES_B --

3081: ---------------------------------------------------------------------------
3082: -- PROCEDURE insert_row
3083: ---------------------------------------------------------------------------
3084: ------------------------------------------
3085: -- insert_row for:OKC_CONDITION_LINES_B --
3086: ------------------------------------------
3087: PROCEDURE insert_row(
3088: p_init_msg_list IN VARCHAR2 ,
3089: x_return_status OUT NOCOPY VARCHAR2,

Line 3101: -- Set_Attributes for:OKC_CONDITION_LINES_B --

3097: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3098: l_cnl_rec cnl_rec_type := p_cnl_rec;
3099: l_def_cnl_rec cnl_rec_type;
3100: ----------------------------------------------
3101: -- Set_Attributes for:OKC_CONDITION_LINES_B --
3102: ----------------------------------------------
3103: FUNCTION Set_Attributes (
3104: p_cnl_rec IN cnl_rec_type,
3105: x_cnl_rec OUT NOCOPY cnl_rec_type

Line 3132: INSERT INTO OKC_CONDITION_LINES_B(

3128: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3129: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3130: RAISE OKC_API.G_EXCEPTION_ERROR;
3131: END IF;
3132: INSERT INTO OKC_CONDITION_LINES_B(
3133: id,
3134: cnh_id,
3135: pdf_id,
3136: aae_id,

Line 3611: -- lock_row for:OKC_CONDITION_LINES_B --

3607: ---------------------------------------------------------------------------
3608: -- PROCEDURE lock_row
3609: ---------------------------------------------------------------------------
3610: ----------------------------------------
3611: -- lock_row for:OKC_CONDITION_LINES_B --
3612: ----------------------------------------
3613: PROCEDURE lock_row(
3614: p_init_msg_list IN VARCHAR2 ,
3615: x_return_status OUT NOCOPY VARCHAR2,

Line 3624: FROM OKC_CONDITION_LINES_B

3620: E_Resource_Busy EXCEPTION;
3621: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3622: CURSOR lock_csr (p_cnl_rec IN cnl_rec_type) IS
3623: SELECT OBJECT_VERSION_NUMBER
3624: FROM OKC_CONDITION_LINES_B
3625: WHERE ID = p_cnl_rec.id
3626: AND OBJECT_VERSION_NUMBER = p_cnl_rec.object_version_number
3627: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3628:

Line 3631: FROM OKC_CONDITION_LINES_B

3627: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3628:
3629: CURSOR lchk_csr (p_cnl_rec IN cnl_rec_type) IS
3630: SELECT OBJECT_VERSION_NUMBER
3631: FROM OKC_CONDITION_LINES_B
3632: WHERE ID = p_cnl_rec.id;
3633: l_api_version CONSTANT NUMBER := 1;
3634: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3636: l_object_version_number OKC_CONDITION_LINES_B.OBJECT_VERSION_NUMBER%TYPE;

3632: WHERE ID = p_cnl_rec.id;
3633: l_api_version CONSTANT NUMBER := 1;
3634: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3636: l_object_version_number OKC_CONDITION_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3637: lc_object_version_number OKC_CONDITION_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3638: l_row_notfound BOOLEAN := FALSE;
3639: lc_row_notfound BOOLEAN := FALSE;
3640: BEGIN

Line 3637: lc_object_version_number OKC_CONDITION_LINES_B.OBJECT_VERSION_NUMBER%TYPE;

3633: l_api_version CONSTANT NUMBER := 1;
3634: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3636: l_object_version_number OKC_CONDITION_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3637: lc_object_version_number OKC_CONDITION_LINES_B.OBJECT_VERSION_NUMBER%TYPE;
3638: l_row_notfound BOOLEAN := FALSE;
3639: lc_row_notfound BOOLEAN := FALSE;
3640: BEGIN
3641: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3964: -- update_row for:OKC_CONDITION_LINES_B --

3960: ---------------------------------------------------------------------------
3961: -- PROCEDURE update_row
3962: ---------------------------------------------------------------------------
3963: ------------------------------------------
3964: -- update_row for:OKC_CONDITION_LINES_B --
3965: ------------------------------------------
3966: PROCEDURE update_row(
3967: p_init_msg_list IN VARCHAR2 ,
3968: x_return_status OUT NOCOPY VARCHAR2,

Line 4168: -- Set_Attributes for:OKC_CONDITION_LINES_B --

4164: END IF;
4165: RETURN(l_return_status);
4166: END populate_new_record;
4167: ----------------------------------------------
4168: -- Set_Attributes for:OKC_CONDITION_LINES_B --
4169: ----------------------------------------------
4170: FUNCTION Set_Attributes (
4171: p_cnl_rec IN cnl_rec_type,
4172: x_cnl_rec OUT NOCOPY cnl_rec_type

Line 4205: UPDATE OKC_CONDITION_LINES_B

4201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4202: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4203: RAISE OKC_API.G_EXCEPTION_ERROR;
4204: END IF;
4205: UPDATE OKC_CONDITION_LINES_B
4206: SET CNH_ID = l_def_cnl_rec.cnh_id,
4207: PDF_ID = l_def_cnl_rec.pdf_id,
4208: AAE_ID = l_def_cnl_rec.aae_id,
4209: LEFT_CTR_MASTER_ID = l_def_cnl_rec.left_ctr_master_id,

Line 4886: -- delete_row for:OKC_CONDITION_LINES_B --

4882: ---------------------------------------------------------------------------
4883: -- PROCEDURE delete_row
4884: ---------------------------------------------------------------------------
4885: ------------------------------------------
4886: -- delete_row for:OKC_CONDITION_LINES_B --
4887: ------------------------------------------
4888: PROCEDURE delete_row(
4889: p_init_msg_list IN VARCHAR2 ,
4890: x_return_status OUT NOCOPY VARCHAR2,

Line 4910: DELETE FROM OKC_CONDITION_LINES_B

4906: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4907: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4908: RAISE OKC_API.G_EXCEPTION_ERROR;
4909: END IF;
4910: DELETE FROM OKC_CONDITION_LINES_B
4911: WHERE ID = l_cnl_rec.id;
4912:
4913: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4914: EXCEPTION

Line 5307: INTO OKC_CONDITION_LINES_B

5303: END LOOP;
5304:
5305: FORALL i in 1..l_tabsize
5306: INSERT
5307: INTO OKC_CONDITION_LINES_B
5308: (
5309: id,
5310: cnh_id,
5311: pdf_id,

Line 5452: INSERT INTO okc_condition_lines_bh

5448:
5449: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
5450:
5451: BEGIN
5452: INSERT INTO okc_condition_lines_bh
5453: (
5454: major_version,
5455: id,
5456: cnh_id,

Line 5542: FROM okc_condition_lines_b

5538: attribute14,
5539: attribute15,
5540: application_id,
5541: seeded_flag
5542: FROM okc_condition_lines_b
5543: WHERE dnz_chr_id = p_chr_id;
5544:
5545: ---------------------------------------
5546: -- Versioning TL Table

Line 5576: WHERE id in (select id from okc_condition_lines_b

5572: last_updated_by,
5573: last_update_date,
5574: last_update_login
5575: FROM okc_condition_lines_tl
5576: WHERE id in (select id from okc_condition_lines_b
5577: where dnz_chr_id = p_chr_id);
5578:
5579: RETURN l_return_status;
5580: EXCEPTION

Line 5634: FROM okc_condition_lines_bh

5630: last_update_date,
5631: last_update_login
5632: FROM okc_condition_lines_tlh
5633: WHERE id in (SELECT id
5634: FROM okc_condition_lines_bh
5635: WHERE dnz_chr_id = p_chr_id)
5636: AND major_version = p_major_version;
5637:
5638: -------------------------------------

Line 5642: INSERT INTO okc_condition_lines_b

5638: -------------------------------------
5639: -- Restoring Base Table
5640: -------------------------------------
5641:
5642: INSERT INTO okc_condition_lines_b
5643: (
5644: id,
5645: cnh_id,
5646: pdf_id,

Line 5730: FROM okc_condition_lines_bh

5726: attribute14,
5727: attribute15,
5728: application_id,
5729: seeded_flag
5730: FROM okc_condition_lines_bh
5731: WHERE dnz_chr_id = p_chr_id
5732: AND major_version = p_major_version;
5733:
5734: RETURN l_return_status;