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.OKS_CVP_PVT dependencies on OKS_COV_TYPES_B

Line 101: FROM OKS_COV_TYPES_B B

97: BEGIN
98: DELETE FROM OKS_COV_TYPES_TL T
99: WHERE NOT EXISTS (
100: SELECT NULL
101: FROM OKS_COV_TYPES_B B
102: WHERE B.CODE =T.CODE
103: );
104:
105: UPDATE OKS_COV_TYPES_TL T SET(

Line 349: -- FUNCTION get_rec for: OKS_COV_TYPES_B

345: BEGIN
346: RETURN(get_rec(p_oks_cov_types_tl_rec, l_row_not_found));
347: END get_rec;
348: ---------------------------------------------------------------------------
349: -- FUNCTION get_rec for: OKS_COV_TYPES_B
350: ---------------------------------------------------------------------------
351: FUNCTION get_rec (
352: p_cvp_rec IN cvp_rec_type,
353: x_no_data_found OUT NOCOPY BOOLEAN

Line 355: CURSOR oks_cov_types_b_pk_csr (p_code IN VARCHAR2) IS

351: FUNCTION get_rec (
352: p_cvp_rec IN cvp_rec_type,
353: x_no_data_found OUT NOCOPY BOOLEAN
354: ) RETURN cvp_rec_type IS
355: CURSOR oks_cov_types_b_pk_csr (p_code IN VARCHAR2) IS
356: SELECT
357: CODE,
358: IMPORTANCE_LEVEL,
359: ENABLED_FLAG,

Line 383: FROM Oks_Cov_Types_B

379: ATTRIBUTE12,
380: ATTRIBUTE13,
381: ATTRIBUTE14,
382: ATTRIBUTE15
383: FROM Oks_Cov_Types_B
384: WHERE oks_cov_types_b.code = p_code;
385: l_oks_cov_types_b_pk oks_cov_types_b_pk_csr%ROWTYPE;
386: l_cvp_rec cvp_rec_type;
387: BEGIN

Line 384: WHERE oks_cov_types_b.code = p_code;

380: ATTRIBUTE13,
381: ATTRIBUTE14,
382: ATTRIBUTE15
383: FROM Oks_Cov_Types_B
384: WHERE oks_cov_types_b.code = p_code;
385: l_oks_cov_types_b_pk oks_cov_types_b_pk_csr%ROWTYPE;
386: l_cvp_rec cvp_rec_type;
387: BEGIN
388: x_no_data_found := TRUE;

Line 385: l_oks_cov_types_b_pk oks_cov_types_b_pk_csr%ROWTYPE;

381: ATTRIBUTE14,
382: ATTRIBUTE15
383: FROM Oks_Cov_Types_B
384: WHERE oks_cov_types_b.code = p_code;
385: l_oks_cov_types_b_pk oks_cov_types_b_pk_csr%ROWTYPE;
386: l_cvp_rec cvp_rec_type;
387: BEGIN
388: x_no_data_found := TRUE;
389: -- Get current database values

Line 390: OPEN oks_cov_types_b_pk_csr (p_cvp_rec.code);

386: l_cvp_rec cvp_rec_type;
387: BEGIN
388: x_no_data_found := TRUE;
389: -- Get current database values
390: OPEN oks_cov_types_b_pk_csr (p_cvp_rec.code);
391: FETCH oks_cov_types_b_pk_csr INTO
392: l_cvp_rec.code,
393: l_cvp_rec.importance_level,
394: l_cvp_rec.enabled_flag,

Line 391: FETCH oks_cov_types_b_pk_csr INTO

387: BEGIN
388: x_no_data_found := TRUE;
389: -- Get current database values
390: OPEN oks_cov_types_b_pk_csr (p_cvp_rec.code);
391: FETCH oks_cov_types_b_pk_csr INTO
392: l_cvp_rec.code,
393: l_cvp_rec.importance_level,
394: l_cvp_rec.enabled_flag,
395: l_cvp_rec.start_date_active,

Line 418: x_no_data_found := oks_cov_types_b_pk_csr%NOTFOUND;

414: l_cvp_rec.attribute12,
415: l_cvp_rec.attribute13,
416: l_cvp_rec.attribute14,
417: l_cvp_rec.attribute15;
418: x_no_data_found := oks_cov_types_b_pk_csr%NOTFOUND;
419: CLOSE oks_cov_types_b_pk_csr;
420: RETURN(l_cvp_rec);
421: END get_rec;
422:

Line 419: CLOSE oks_cov_types_b_pk_csr;

415: l_cvp_rec.attribute13,
416: l_cvp_rec.attribute14,
417: l_cvp_rec.attribute15;
418: x_no_data_found := oks_cov_types_b_pk_csr%NOTFOUND;
419: CLOSE oks_cov_types_b_pk_csr;
420: RETURN(l_cvp_rec);
421: END get_rec;
422:
423: ------------------------------------------------------------------

Line 1049: -- insert_row for:OKS_COV_TYPES_B --

1045: ---------------------------------------------------------------------------
1046: -- PROCEDURE insert_row
1047: ---------------------------------------------------------------------------
1048: ------------------------------------
1049: -- insert_row for:OKS_COV_TYPES_B --
1050: ------------------------------------
1051: PROCEDURE insert_row(
1052: p_init_msg_list IN VARCHAR2,
1053: x_return_status OUT NOCOPY VARCHAR2,

Line 1065: -- Set_Attributes for:OKS_COV_TYPES_B --

1061: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1062: l_cvp_rec cvp_rec_type := p_cvp_rec;
1063: l_def_cvp_rec cvp_rec_type;
1064: ----------------------------------------
1065: -- Set_Attributes for:OKS_COV_TYPES_B --
1066: ----------------------------------------
1067: FUNCTION Set_Attributes (
1068: p_cvp_rec IN cvp_rec_type,
1069: x_cvp_rec OUT NOCOPY cvp_rec_type

Line 1096: INSERT INTO OKS_COV_TYPES_B(

1092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1093: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1094: RAISE OKC_API.G_EXCEPTION_ERROR;
1095: END IF;
1096: INSERT INTO OKS_COV_TYPES_B(
1097: code,
1098: importance_level,
1099: enabled_flag,
1100: start_date_active,

Line 1634: -- lock_row for:OKS_COV_TYPES_B --

1630: ---------------------------------------------------------------------------
1631: -- PROCEDURE lock_row
1632: ---------------------------------------------------------------------------
1633: ----------------------------------
1634: -- lock_row for:OKS_COV_TYPES_B --
1635: ----------------------------------
1636: PROCEDURE lock_row(
1637: p_init_msg_list IN VARCHAR2,
1638: x_return_status OUT NOCOPY VARCHAR2,

Line 1647: FROM OKS_COV_TYPES_B

1643: E_Resource_Busy EXCEPTION;
1644: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1645: CURSOR lock_csr (p_cvp_rec IN cvp_rec_type) IS
1646: SELECT *
1647: FROM OKS_COV_TYPES_B
1648: WHERE CODE = p_cvp_rec.code
1649: FOR UPDATE NOWAIT;
1650:
1651: l_api_version CONSTANT NUMBER := 1;

Line 2165: -- update_row for:OKS_COV_TYPES_B --

2161: ---------------------------------------------------------------------------
2162: -- PROCEDURE update_row
2163: ---------------------------------------------------------------------------
2164: ------------------------------------
2165: -- update_row for:OKS_COV_TYPES_B --
2166: ------------------------------------
2167: PROCEDURE update_row(
2168: p_init_msg_list IN VARCHAR2,
2169: x_return_status OUT NOCOPY VARCHAR2,

Line 2304: -- Set_Attributes for:OKS_COV_TYPES_B --

2300: END IF;
2301: RETURN(l_return_status);
2302: END populate_new_record;
2303: ----------------------------------------
2304: -- Set_Attributes for:OKS_COV_TYPES_B --
2305: ----------------------------------------
2306: FUNCTION Set_Attributes (
2307: p_cvp_rec IN cvp_rec_type,
2308: x_cvp_rec OUT NOCOPY cvp_rec_type

Line 2341: UPDATE OKS_COV_TYPES_B

2337: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2338: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2339: RAISE OKC_API.G_EXCEPTION_ERROR;
2340: END IF;
2341: UPDATE OKS_COV_TYPES_B
2342: SET IMPORTANCE_LEVEL = l_def_cvp_rec.importance_level,
2343: ENABLED_FLAG = l_def_cvp_rec.enabled_flag,
2344: START_DATE_ACTIVE = l_def_cvp_rec.start_date_active,
2345: END_DATE_ACTIVE = l_def_cvp_rec.end_date_active,

Line 3054: -- delete_row for:OKS_COV_TYPES_B --

3050: ---------------------------------------------------------------------------
3051: -- PROCEDURE delete_row
3052: ---------------------------------------------------------------------------
3053: ------------------------------------
3054: -- delete_row for:OKS_COV_TYPES_B --
3055: ------------------------------------
3056: PROCEDURE delete_row(
3057: p_init_msg_list IN VARCHAR2,
3058: x_return_status OUT NOCOPY VARCHAR2,

Line 3079: DELETE FROM OKS_COV_TYPES_B

3075: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3076: RAISE OKC_API.G_EXCEPTION_ERROR;
3077: END IF;
3078:
3079: DELETE FROM OKS_COV_TYPES_B
3080: WHERE CODE = p_cvp_rec.code;
3081:
3082: x_return_status := l_return_status;
3083: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3465: SELECT 'X' FROM OKS_COV_TYPES_B

3461: WHERE F.LOOKUP_TYPE = 'OKSCVETYPE';
3462:
3463:
3464: CURSOR CUR_CHECK_EXISTS_B(v_code VARCHAR2) IS
3465: SELECT 'X' FROM OKS_COV_TYPES_B
3466: WHERE CODE = v_code ;
3467:
3468: CURSOR CUR_CHECK_EXISTS_TL(v_code VARCHAR2, v_lang VARCHAR2) IS
3469: SELECT 'X' FROM OKS_COV_TYPES_TL

Line 3506: INSERT INTO OKS_COV_TYPES_B(CODE,

3502: v_exist:= TRUE;
3503: END LOOP ;
3504:
3505: IF (v_exist = FALSE) THEN
3506: INSERT INTO OKS_COV_TYPES_B(CODE,
3507: IMPORTANCE_LEVEL,
3508: ENABLED_FLAG,
3509: START_DATE_ACTIVE,
3510: END_DATE_ACTIVE,