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_QCL_PVT dependencies on OKC_QA_CHECK_LISTS_B

Line 418: FROM OKC_QA_CHECK_LISTS_B B

414: BEGIN
415: DELETE FROM OKC_QA_CHECK_LISTS_TL T
416: WHERE NOT EXISTS (
417: SELECT NULL
418: FROM OKC_QA_CHECK_LISTS_B B
419: WHERE B.ID = T.ID
420: );
421:
422: UPDATE OKC_QA_CHECK_LISTS_TL T SET (

Line 482: -- FUNCTION get_rec for: OKC_QA_CHECK_LISTS_B

478:
479: END add_language;
480:
481: ---------------------------------------------------------------------------
482: -- FUNCTION get_rec for: OKC_QA_CHECK_LISTS_B
483: ---------------------------------------------------------------------------
484: FUNCTION get_rec (
485: p_qcl_rec IN qcl_rec_type,
486: x_no_data_found OUT NOCOPY BOOLEAN

Line 517: FROM Okc_Qa_Check_Lists_B

513: ATTRIBUTE14,
514: ATTRIBUTE15,
515: APPLICATION_ID,
516: DEFAULT_YN
517: FROM Okc_Qa_Check_Lists_B
518: WHERE okc_qa_check_lists_b.id = p_id;
519: l_qcl_pk qcl_pk_csr%ROWTYPE;
520: l_qcl_rec qcl_rec_type;
521: BEGIN

Line 518: WHERE okc_qa_check_lists_b.id = p_id;

514: ATTRIBUTE15,
515: APPLICATION_ID,
516: DEFAULT_YN
517: FROM Okc_Qa_Check_Lists_B
518: WHERE okc_qa_check_lists_b.id = p_id;
519: l_qcl_pk qcl_pk_csr%ROWTYPE;
520: l_qcl_rec qcl_rec_type;
521: BEGIN
522: x_no_data_found := TRUE;

Line 856: FROM okc_qa_check_lists_b

852: ) RETURN VARCHAR2 IS
853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
854: CURSOR cur_qcl IS
855: SELECT 'x'
856: FROM okc_qa_check_lists_b
857: WHERE application_id = p_qclv_rec.application_id
858: AND default_yn = 'Y'
859: AND id <> p_qclv_rec.id;
860:

Line 1179: -- insert_row for:OKC_QA_CHECK_LISTS_B --

1175: ---------------------------------------------------------------------------
1176: -- PROCEDURE insert_row
1177: ---------------------------------------------------------------------------
1178: -----------------------------------------
1179: -- insert_row for:OKC_QA_CHECK_LISTS_B --
1180: -----------------------------------------
1181: PROCEDURE insert_row(
1182: p_init_msg_list IN VARCHAR2 ,
1183: x_return_status OUT NOCOPY VARCHAR2,

Line 1195: -- Set_Attributes for:OKC_QA_CHECK_LISTS_B --

1191: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1192: l_qcl_rec qcl_rec_type := p_qcl_rec;
1193: l_def_qcl_rec qcl_rec_type;
1194: ---------------------------------------------
1195: -- Set_Attributes for:OKC_QA_CHECK_LISTS_B --
1196: ---------------------------------------------
1197: FUNCTION Set_Attributes (
1198: p_qcl_rec IN qcl_rec_type,
1199: x_qcl_rec OUT NOCOPY qcl_rec_type

Line 1226: INSERT INTO OKC_QA_CHECK_LISTS_B(

1222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1224: RAISE OKC_API.G_EXCEPTION_ERROR;
1225: END IF;
1226: INSERT INTO OKC_QA_CHECK_LISTS_B(
1227: id,
1228: begin_date,
1229: object_version_number,
1230: created_by,

Line 1667: -- lock_row for:OKC_QA_CHECK_LISTS_B --

1663: ---------------------------------------------------------------------------
1664: -- PROCEDURE lock_row
1665: ---------------------------------------------------------------------------
1666: ---------------------------------------
1667: -- lock_row for:OKC_QA_CHECK_LISTS_B --
1668: ---------------------------------------
1669: PROCEDURE lock_row(
1670: p_init_msg_list IN VARCHAR2 ,
1671: x_return_status OUT NOCOPY VARCHAR2,

Line 1680: FROM OKC_QA_CHECK_LISTS_B

1676: E_Resource_Busy EXCEPTION;
1677: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1678: CURSOR lock_csr (p_qcl_rec IN qcl_rec_type) IS
1679: SELECT OBJECT_VERSION_NUMBER
1680: FROM OKC_QA_CHECK_LISTS_B
1681: WHERE ID = p_qcl_rec.id
1682: AND OBJECT_VERSION_NUMBER = p_qcl_rec.object_version_number
1683: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1684:

Line 1687: FROM OKC_QA_CHECK_LISTS_B

1683: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1684:
1685: CURSOR lchk_csr (p_qcl_rec IN qcl_rec_type) IS
1686: SELECT OBJECT_VERSION_NUMBER
1687: FROM OKC_QA_CHECK_LISTS_B
1688: WHERE ID = p_qcl_rec.id;
1689: l_api_version CONSTANT NUMBER := 1;
1690: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1691: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1692: l_object_version_number OKC_QA_CHECK_LISTS_B.OBJECT_VERSION_NUMBER%TYPE;

1688: WHERE ID = p_qcl_rec.id;
1689: l_api_version CONSTANT NUMBER := 1;
1690: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1691: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1692: l_object_version_number OKC_QA_CHECK_LISTS_B.OBJECT_VERSION_NUMBER%TYPE;
1693: lc_object_version_number OKC_QA_CHECK_LISTS_B.OBJECT_VERSION_NUMBER%TYPE;
1694: l_row_notfound BOOLEAN := FALSE;
1695: lc_row_notfound BOOLEAN := FALSE;
1696: BEGIN

Line 1693: lc_object_version_number OKC_QA_CHECK_LISTS_B.OBJECT_VERSION_NUMBER%TYPE;

1689: l_api_version CONSTANT NUMBER := 1;
1690: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1691: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1692: l_object_version_number OKC_QA_CHECK_LISTS_B.OBJECT_VERSION_NUMBER%TYPE;
1693: lc_object_version_number OKC_QA_CHECK_LISTS_B.OBJECT_VERSION_NUMBER%TYPE;
1694: l_row_notfound BOOLEAN := FALSE;
1695: lc_row_notfound BOOLEAN := FALSE;
1696: BEGIN
1697: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2020: -- update_row for:OKC_QA_CHECK_LISTS_B --

2016: ---------------------------------------------------------------------------
2017: -- PROCEDURE update_row
2018: ---------------------------------------------------------------------------
2019: -----------------------------------------
2020: -- update_row for:OKC_QA_CHECK_LISTS_B --
2021: -----------------------------------------
2022: PROCEDURE update_row(
2023: p_init_msg_list IN VARCHAR2 ,
2024: x_return_status OUT NOCOPY VARCHAR2,

Line 2164: -- Set_Attributes for:OKC_QA_CHECK_LISTS_B --

2160: END IF;
2161: RETURN(l_return_status);
2162: END populate_new_record;
2163: ---------------------------------------------
2164: -- Set_Attributes for:OKC_QA_CHECK_LISTS_B --
2165: ---------------------------------------------
2166: FUNCTION Set_Attributes (
2167: p_qcl_rec IN qcl_rec_type,
2168: x_qcl_rec OUT NOCOPY qcl_rec_type

Line 2201: UPDATE OKC_QA_CHECK_LISTS_B

2197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2199: RAISE OKC_API.G_EXCEPTION_ERROR;
2200: END IF;
2201: UPDATE OKC_QA_CHECK_LISTS_B
2202: SET BEGIN_DATE = l_def_qcl_rec.begin_date,
2203: OBJECT_VERSION_NUMBER = l_def_qcl_rec.object_version_number,
2204: CREATED_BY = l_def_qcl_rec.created_by,
2205: CREATION_DATE = l_def_qcl_rec.creation_date,

Line 2806: -- delete_row for:OKC_QA_CHECK_LISTS_B --

2802: ---------------------------------------------------------------------------
2803: -- PROCEDURE delete_row
2804: ---------------------------------------------------------------------------
2805: -----------------------------------------
2806: -- delete_row for:OKC_QA_CHECK_LISTS_B --
2807: -----------------------------------------
2808: PROCEDURE delete_row(
2809: p_init_msg_list IN VARCHAR2 ,
2810: x_return_status OUT NOCOPY VARCHAR2,

Line 2830: DELETE FROM OKC_QA_CHECK_LISTS_B

2826: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2827: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2828: RAISE OKC_API.G_EXCEPTION_ERROR;
2829: END IF;
2830: DELETE FROM OKC_QA_CHECK_LISTS_B
2831: WHERE ID = l_qcl_rec.id;
2832:
2833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2834: EXCEPTION