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_CNH_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 53: FROM OKC_CONDITION_HEADERS_B B

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

Line 131: FROM OKC_CONDITION_HEADERS_BH B

127: );
128: DELETE FROM OKC_CONDITION_HEADERS_TLH T
129: WHERE NOT EXISTS (
130: SELECT NULL
131: FROM OKC_CONDITION_HEADERS_BH B
132: WHERE B.ID = T.ID
133: AND B.MAJOR_VERSION = T.MAJOR_VERSION
134: );
135: UPDATE OKC_CONDITION_HEADERS_TLH T SET (

Line 217: -- FUNCTION get_rec for: OKC_CONDITION_HEADERS_B

213:
214: END add_language;
215:
216: ---------------------------------------------------------------------------
217: -- FUNCTION get_rec for: OKC_CONDITION_HEADERS_B
218: ---------------------------------------------------------------------------
219: FUNCTION get_rec (
220: p_cnh_rec IN cnh_rec_type,
221: x_no_data_found OUT NOCOPY BOOLEAN

Line 223: CURSOR okc_condition_headers_b_pk_csr (p_id IN NUMBER) IS

219: FUNCTION get_rec (
220: p_cnh_rec IN cnh_rec_type,
221: x_no_data_found OUT NOCOPY BOOLEAN
222: ) RETURN cnh_rec_type IS
223: CURSOR okc_condition_headers_b_pk_csr (p_id IN NUMBER) IS
224: SELECT
225: ID,
226: ACN_ID,
227: COUNTER_GROUP_ID,

Line 266: FROM Okc_Condition_Headers_B

262: ATTRIBUTE15,
263: APPLICATION_ID,
264: SEEDED_FLAG,
265: LAST_RUNDATE
266: FROM Okc_Condition_Headers_B
267: WHERE okc_condition_headers_b.id = p_id;
268: l_okc_condition_headers_b_pk okc_condition_headers_b_pk_csr%ROWTYPE;
269: l_cnh_rec cnh_rec_type;
270: BEGIN

Line 267: WHERE okc_condition_headers_b.id = p_id;

263: APPLICATION_ID,
264: SEEDED_FLAG,
265: LAST_RUNDATE
266: FROM Okc_Condition_Headers_B
267: WHERE okc_condition_headers_b.id = p_id;
268: l_okc_condition_headers_b_pk okc_condition_headers_b_pk_csr%ROWTYPE;
269: l_cnh_rec cnh_rec_type;
270: BEGIN
271: x_no_data_found := TRUE;

Line 268: l_okc_condition_headers_b_pk okc_condition_headers_b_pk_csr%ROWTYPE;

264: SEEDED_FLAG,
265: LAST_RUNDATE
266: FROM Okc_Condition_Headers_B
267: WHERE okc_condition_headers_b.id = p_id;
268: l_okc_condition_headers_b_pk okc_condition_headers_b_pk_csr%ROWTYPE;
269: l_cnh_rec cnh_rec_type;
270: BEGIN
271: x_no_data_found := TRUE;
272: -- Get current database values

Line 273: OPEN okc_condition_headers_b_pk_csr (p_cnh_rec.id);

269: l_cnh_rec cnh_rec_type;
270: BEGIN
271: x_no_data_found := TRUE;
272: -- Get current database values
273: OPEN okc_condition_headers_b_pk_csr (p_cnh_rec.id);
274: FETCH okc_condition_headers_b_pk_csr INTO
275: l_cnh_rec.ID,
276: l_cnh_rec.ACN_ID,
277: l_cnh_rec.COUNTER_GROUP_ID,

Line 274: FETCH okc_condition_headers_b_pk_csr INTO

270: BEGIN
271: x_no_data_found := TRUE;
272: -- Get current database values
273: OPEN okc_condition_headers_b_pk_csr (p_cnh_rec.id);
274: FETCH okc_condition_headers_b_pk_csr INTO
275: l_cnh_rec.ID,
276: l_cnh_rec.ACN_ID,
277: l_cnh_rec.COUNTER_GROUP_ID,
278: l_cnh_rec.ONE_TIME_YN,

Line 316: x_no_data_found := okc_condition_headers_b_pk_csr%NOTFOUND;

312: l_cnh_rec.ATTRIBUTE15,
313: l_cnh_rec.APPLICATION_ID,
314: l_cnh_rec.SEEDED_FLAG,
315: l_cnh_rec.LAST_RUNDATE;
316: x_no_data_found := okc_condition_headers_b_pk_csr%NOTFOUND;
317: CLOSE okc_condition_headers_b_pk_csr;
318: RETURN(l_cnh_rec);
319: END get_rec;
320:

Line 317: CLOSE okc_condition_headers_b_pk_csr;

313: l_cnh_rec.APPLICATION_ID,
314: l_cnh_rec.SEEDED_FLAG,
315: l_cnh_rec.LAST_RUNDATE;
316: x_no_data_found := okc_condition_headers_b_pk_csr%NOTFOUND;
317: CLOSE okc_condition_headers_b_pk_csr;
318: RETURN(l_cnh_rec);
319: END get_rec;
320:
321: FUNCTION get_rec (

Line 938: okc_condition_headers_b cnh

934: cgp_rec cgp_cur%ROWTYPE;
935: CURSOR acn_cur IS
936: SELECT acn.counter_action_yn counter_action_yn
937: FROM okc_actions_b acn,
938: okc_condition_headers_b cnh
939: WHERE acn.id = cnh.acn_id
940: AND cnh.id = p_cnhv_rec.id;
941: acn_rec acn_cur%ROWTYPE;
942: BEGIN

Line 2885: -- insert_row for:OKC_CONDITION_HEADERS_B --

2881: ---------------------------------------------------------------------------
2882: -- PROCEDURE insert_row
2883: ---------------------------------------------------------------------------
2884: --------------------------------------------
2885: -- insert_row for:OKC_CONDITION_HEADERS_B --
2886: --------------------------------------------
2887: PROCEDURE insert_row(
2888: p_init_msg_list IN VARCHAR2 ,
2889: x_return_status OUT NOCOPY VARCHAR2,

Line 2901: -- Set_Attributes for:OKC_CONDITION_HEADERS_B --

2897: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2898: l_cnh_rec cnh_rec_type := p_cnh_rec;
2899: l_def_cnh_rec cnh_rec_type;
2900: ------------------------------------------------
2901: -- Set_Attributes for:OKC_CONDITION_HEADERS_B --
2902: ------------------------------------------------
2903: FUNCTION Set_Attributes (
2904: p_cnh_rec IN cnh_rec_type,
2905: x_cnh_rec OUT NOCOPY cnh_rec_type

Line 2932: INSERT INTO OKC_CONDITION_HEADERS_B(

2928: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2929: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2930: RAISE OKC_API.G_EXCEPTION_ERROR;
2931: END IF;
2932: INSERT INTO OKC_CONDITION_HEADERS_B(
2933: id,
2934: acn_id,
2935: counter_group_id,
2936: one_time_yn,

Line 3431: -- lock_row for:OKC_CONDITION_HEADERS_B --

3427: ---------------------------------------------------------------------------
3428: -- PROCEDURE lock_row
3429: ---------------------------------------------------------------------------
3430: ------------------------------------------
3431: -- lock_row for:OKC_CONDITION_HEADERS_B --
3432: ------------------------------------------
3433: PROCEDURE lock_row(
3434: p_init_msg_list IN VARCHAR2 ,
3435: x_return_status OUT NOCOPY VARCHAR2,

Line 3444: FROM OKC_CONDITION_HEADERS_B

3440: E_Resource_Busy EXCEPTION;
3441: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3442: CURSOR lock_csr (p_cnh_rec IN cnh_rec_type) IS
3443: SELECT OBJECT_VERSION_NUMBER
3444: FROM OKC_CONDITION_HEADERS_B
3445: WHERE ID = p_cnh_rec.id
3446: AND OBJECT_VERSION_NUMBER = p_cnh_rec.object_version_number
3447: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3448:

Line 3451: FROM OKC_CONDITION_HEADERS_B

3447: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3448:
3449: CURSOR lchk_csr (p_cnh_rec IN cnh_rec_type) IS
3450: SELECT OBJECT_VERSION_NUMBER
3451: FROM OKC_CONDITION_HEADERS_B
3452: WHERE ID = p_cnh_rec.id;
3453: l_api_version CONSTANT NUMBER := 1;
3454: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3455: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3456: l_object_version_number OKC_CONDITION_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;

3452: WHERE ID = p_cnh_rec.id;
3453: l_api_version CONSTANT NUMBER := 1;
3454: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3455: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3456: l_object_version_number OKC_CONDITION_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;
3457: lc_object_version_number OKC_CONDITION_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;
3458: l_row_notfound BOOLEAN := FALSE;
3459: lc_row_notfound BOOLEAN := FALSE;
3460: BEGIN

Line 3457: lc_object_version_number OKC_CONDITION_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;

3453: l_api_version CONSTANT NUMBER := 1;
3454: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3455: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3456: l_object_version_number OKC_CONDITION_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;
3457: lc_object_version_number OKC_CONDITION_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE;
3458: l_row_notfound BOOLEAN := FALSE;
3459: lc_row_notfound BOOLEAN := FALSE;
3460: BEGIN
3461: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3784: -- update_row for:OKC_CONDITION_HEADERS_B --

3780: ---------------------------------------------------------------------------
3781: -- PROCEDURE update_row
3782: ---------------------------------------------------------------------------
3783: --------------------------------------------
3784: -- update_row for:OKC_CONDITION_HEADERS_B --
3785: --------------------------------------------
3786: PROCEDURE update_row(
3787: p_init_msg_list IN VARCHAR2 ,
3788: x_return_status OUT NOCOPY VARCHAR2,

Line 3984: -- Set_Attributes for:OKC_CONDITION_HEADERS_B --

3980: END IF;
3981: RETURN(l_return_status);
3982: END populate_new_record;
3983: ------------------------------------------------
3984: -- Set_Attributes for:OKC_CONDITION_HEADERS_B --
3985: ------------------------------------------------
3986: FUNCTION Set_Attributes (
3987: p_cnh_rec IN cnh_rec_type,
3988: x_cnh_rec OUT NOCOPY cnh_rec_type

Line 4021: UPDATE OKC_CONDITION_HEADERS_B

4017: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4018: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4019: RAISE OKC_API.G_EXCEPTION_ERROR;
4020: END IF;
4021: UPDATE OKC_CONDITION_HEADERS_B
4022: SET ACN_ID = l_def_cnh_rec.acn_id,
4023: COUNTER_GROUP_ID = l_def_cnh_rec.counter_group_id,
4024: ONE_TIME_YN = l_def_cnh_rec.one_time_yn,
4025: BEFORE_AFTER = l_def_cnh_rec.before_after,

Line 4740: -- delete_row for:OKC_CONDITION_HEADERS_B --

4736: ---------------------------------------------------------------------------
4737: -- PROCEDURE delete_row
4738: ---------------------------------------------------------------------------
4739: --------------------------------------------
4740: -- delete_row for:OKC_CONDITION_HEADERS_B --
4741: --------------------------------------------
4742: PROCEDURE delete_row(
4743: p_init_msg_list IN VARCHAR2 ,
4744: x_return_status OUT NOCOPY VARCHAR2,

Line 4764: DELETE FROM OKC_CONDITION_HEADERS_B

4760: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4761: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4762: RAISE OKC_API.G_EXCEPTION_ERROR;
4763: END IF;
4764: DELETE FROM OKC_CONDITION_HEADERS_B
4765: WHERE ID = l_cnh_rec.id;
4766:
4767: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4768: EXCEPTION

Line 5165: INTO OKC_CONDITION_HEADERS_B

5161: END LOOP;
5162:
5163: FORALL i in 1..l_tabsize
5164: INSERT
5165: INTO OKC_CONDITION_HEADERS_B
5166: (
5167: id,
5168: acn_id,
5169: counter_group_id,

Line 5315: INSERT INTO okc_condition_headers_bh

5311:
5312: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
5313:
5314: BEGIN
5315: INSERT INTO okc_condition_headers_bh
5316: (
5317: major_version,
5318: id,
5319: acn_id,

Line 5403: FROM okc_condition_headers_b

5399: task_owner_id,
5400: application_id,
5401: seeded_flag,
5402: last_rundate
5403: FROM okc_condition_headers_b
5404: WHERE dnz_chr_id = p_chr_id;
5405:
5406: ------------------------------
5407: -- Versioning TL Table

Line 5443: WHERE id in ( select id from okc_condition_headers_b

5439: last_update_date,
5440: last_update_login,
5441: name
5442: FROM okc_condition_headers_tl
5443: WHERE id in ( select id from okc_condition_headers_b
5444: where dnz_chr_id = p_chr_id );
5445:
5446: RETURN l_return_status;
5447: EXCEPTION

Line 5507: FROM okc_condition_headers_bh

5503: last_update_login,
5504: name
5505: FROM okc_condition_headers_tlh
5506: WHERE id in (SELECT id
5507: FROM okc_condition_headers_bh
5508: WHERE dnz_chr_id = p_chr_id)
5509: AND major_version = p_major_version;
5510:
5511: ------------------------------------------

Line 5515: INSERT INTO okc_condition_headers_b

5511: ------------------------------------------
5512: -- Restoring Base Table
5513: ------------------------------------------
5514:
5515: INSERT INTO okc_condition_headers_b
5516: (
5517: id,
5518: acn_id,
5519: counter_group_id,

Line 5601: FROM okc_condition_headers_bh

5597: task_owner_id,
5598: application_id,
5599: seeded_flag,
5600: last_rundate
5601: FROM okc_condition_headers_bh
5602: WHERE dnz_chr_id = p_chr_id
5603: AND major_version = p_major_version;
5604:
5605: RETURN l_return_status;