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_V

Line 15: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_QA_CHECK_LISTS_V';

11: G_UPPER_CASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
12: G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'INVALID_END_DATE';
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_QA_CHECK_LISTS_V';
16: G_EXCEPTION_HALT_VALIDATION exception;
17: g_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
18:
19: -- Start of comments

Line 35: SELECT id from OKC_QA_CHECK_LISTS_V where name=p_name;

31: ) IS
32: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
33:
34: CURSOR l_unq_cur(p_name varchar2) is
35: SELECT id from OKC_QA_CHECK_LISTS_V where name=p_name;
36: l_id number:=OKC_API.G_MISS_NUM;
37: BEGIN
38: -- initialize return status
39: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 372: OKC_QA_CHECK_LISTS_V

368: cursor seed_c is
369: select
370: nvl(max(id), 11000) + 1
371: from
372: OKC_QA_CHECK_LISTS_V
373: where
374: id >= 11000 AND id < 50000;
375: BEGIN
376: if fnd_global.user_id = 1 then

Line 621: -- FUNCTION get_rec for: OKC_QA_CHECK_LISTS_V

617: BEGIN
618: RETURN(get_rec(p_okc_qa_check_lists_tl_rec, l_row_notfound));
619: END get_rec;
620: ---------------------------------------------------------------------------
621: -- FUNCTION get_rec for: OKC_QA_CHECK_LISTS_V
622: ---------------------------------------------------------------------------
623: FUNCTION get_rec (
624: p_qclv_rec IN qclv_rec_type,
625: x_no_data_found OUT NOCOPY BOOLEAN

Line 659: FROM Okc_Qa_Check_Lists_V

655: LAST_UPDATE_DATE,
656: LAST_UPDATE_LOGIN,
657: APPLICATION_ID,
658: DEFAULT_YN
659: FROM Okc_Qa_Check_Lists_V
660: WHERE okc_qa_check_lists_v.id = p_id;
661: l_okc_qclv_pk okc_qclv_pk_csr%ROWTYPE;
662: l_qclv_rec qclv_rec_type;
663: BEGIN

Line 660: WHERE okc_qa_check_lists_v.id = p_id;

656: LAST_UPDATE_LOGIN,
657: APPLICATION_ID,
658: DEFAULT_YN
659: FROM Okc_Qa_Check_Lists_V
660: WHERE okc_qa_check_lists_v.id = p_id;
661: l_okc_qclv_pk okc_qclv_pk_csr%ROWTYPE;
662: l_qclv_rec qclv_rec_type;
663: BEGIN
664: x_no_data_found := TRUE;

Line 712: -- FUNCTION null_out_defaults for: OKC_QA_CHECK_LISTS_V --

708: RETURN(get_rec(p_qclv_rec, l_row_notfound));
709: END get_rec;
710:
711: ----------------------------------------------------------
712: -- FUNCTION null_out_defaults for: OKC_QA_CHECK_LISTS_V --
713: ----------------------------------------------------------
714: FUNCTION null_out_defaults (
715: p_qclv_rec IN qclv_rec_type
716: ) RETURN qclv_rec_type IS

Line 812: -- Validate_Attributes for:OKC_QA_CHECK_LISTS_V --

808: ---------------------------------------------------------------------------
809: -- PROCEDURE Validate_Attributes
810: ---------------------------------------------------------------------------
811: --------------------------------------------------
812: -- Validate_Attributes for:OKC_QA_CHECK_LISTS_V --
813: --------------------------------------------------
814: /* commenting out nocopy generated code in favor of hand-coded procedure
815: FUNCTION Validate_Attributes (
816: p_qclv_rec IN qclv_rec_type

Line 848: -- Validate_Record for:OKC_QA_CHECK_LISTS_V --

844: ---------------------------------------------------------------------------
845: -- PROCEDURE Validate_Record
846: ---------------------------------------------------------------------------
847: ----------------------------------------------
848: -- Validate_Record for:OKC_QA_CHECK_LISTS_V --
849: ----------------------------------------------
850: FUNCTION Validate_Record (
851: p_qclv_rec IN qclv_rec_type
852: ) RETURN VARCHAR2 IS

Line 1034: -- validate_row for:OKC_QA_CHECK_LISTS_V --

1030: ---------------------------------------------------------------------------
1031: -- PROCEDURE validate_row
1032: ---------------------------------------------------------------------------
1033: -------------------------------------------
1034: -- validate_row for:OKC_QA_CHECK_LISTS_V --
1035: -------------------------------------------
1036: PROCEDURE validate_row(
1037: p_api_version IN NUMBER,
1038: p_init_msg_list IN VARCHAR2 ,

Line 1434: -- insert_row for:OKC_QA_CHECK_LISTS_V --

1430: '_PVT'
1431: );
1432: END insert_row;
1433: -----------------------------------------
1434: -- insert_row for:OKC_QA_CHECK_LISTS_V --
1435: -----------------------------------------
1436: PROCEDURE insert_row(
1437: p_api_version IN NUMBER,
1438: p_init_msg_list IN VARCHAR2 ,

Line 1471: -- Set_Attributes for:OKC_QA_CHECK_LISTS_V --

1467: l_qclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1468: RETURN(l_qclv_rec);
1469: END fill_who_columns;
1470: ---------------------------------------------
1471: -- Set_Attributes for:OKC_QA_CHECK_LISTS_V --
1472: ---------------------------------------------
1473: FUNCTION Set_Attributes (
1474: p_qclv_rec IN qclv_rec_type,
1475: x_qclv_rec OUT NOCOPY qclv_rec_type

Line 1858: -- lock_row for:OKC_QA_CHECK_LISTS_V --

1854: '_PVT'
1855: );
1856: END lock_row;
1857: ---------------------------------------
1858: -- lock_row for:OKC_QA_CHECK_LISTS_V --
1859: ---------------------------------------
1860: PROCEDURE lock_row(
1861: p_api_version IN NUMBER,
1862: p_init_msg_list IN VARCHAR2 ,

Line 2435: -- update_row for:OKC_QA_CHECK_LISTS_V --

2431: '_PVT'
2432: );
2433: END update_row;
2434: -----------------------------------------
2435: -- update_row for:OKC_QA_CHECK_LISTS_V --
2436: -----------------------------------------
2437: PROCEDURE update_row(
2438: p_api_version IN NUMBER,
2439: p_init_msg_list IN VARCHAR2 ,

Line 2608: -- Set_Attributes for:OKC_QA_CHECK_LISTS_V --

2604: END IF;
2605: RETURN(l_return_status);
2606: END populate_new_record;
2607: ---------------------------------------------
2608: -- Set_Attributes for:OKC_QA_CHECK_LISTS_V --
2609: ---------------------------------------------
2610: FUNCTION Set_Attributes (
2611: p_qclv_rec IN qclv_rec_type,
2612: x_qclv_rec OUT NOCOPY qclv_rec_type

Line 2951: -- delete_row for:OKC_QA_CHECK_LISTS_V --

2947: '_PVT'
2948: );
2949: END delete_row;
2950: -----------------------------------------
2951: -- delete_row for:OKC_QA_CHECK_LISTS_V --
2952: -----------------------------------------
2953: PROCEDURE delete_row(
2954: p_api_version IN NUMBER,
2955: p_init_msg_list IN VARCHAR2 ,