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_V

Line 350: -- FUNCTION get_rec for: OKC_CONDITION_LINES_V

346: BEGIN
347: RETURN(get_rec(p_okc_condition_lines_tl_rec, l_row_notfound));
348: END get_rec;
349: ---------------------------------------------------------------------------
350: -- FUNCTION get_rec for: OKC_CONDITION_LINES_V
351: ---------------------------------------------------------------------------
352: FUNCTION get_rec (
353: p_cnlv_rec IN cnlv_rec_type,
354: x_no_data_found OUT NOCOPY BOOLEAN

Line 402: FROM Okc_Condition_Lines_V

398: CREATION_DATE,
399: LAST_UPDATED_BY,
400: LAST_UPDATE_DATE,
401: LAST_UPDATE_LOGIN
402: FROM Okc_Condition_Lines_V
403: WHERE okc_condition_lines_v.id = p_id;
404: l_okc_cnlv_pk okc_cnlv_pk_csr%ROWTYPE;
405: l_cnlv_rec cnlv_rec_type;
406: BEGIN

Line 403: WHERE okc_condition_lines_v.id = p_id;

399: LAST_UPDATED_BY,
400: LAST_UPDATE_DATE,
401: LAST_UPDATE_LOGIN
402: FROM Okc_Condition_Lines_V
403: WHERE okc_condition_lines_v.id = p_id;
404: l_okc_cnlv_pk okc_cnlv_pk_csr%ROWTYPE;
405: l_cnlv_rec cnlv_rec_type;
406: BEGIN
407: x_no_data_found := TRUE;

Line 469: -- FUNCTION null_out_defaults for: OKC_CONDITION_LINES_V --

465: RETURN(get_rec(p_cnlv_rec, l_row_notfound));
466: END get_rec;
467:
468: -----------------------------------------------------------
469: -- FUNCTION null_out_defaults for: OKC_CONDITION_LINES_V --
470: -----------------------------------------------------------
471: FUNCTION null_out_defaults (
472: p_cnlv_rec IN cnlv_rec_type
473: ) RETURN cnlv_rec_type IS

Line 613: -- Validate_Attributes for:OKC_CONDITION_LINES_V --

609:
610: -- PROCEDURE Validate_Attributes
611: ---------------------------------------------------------------------------
612: ---------------------------------------------------
613: -- Validate_Attributes for:OKC_CONDITION_LINES_V --
614: ---------------------------------------------------
615: FUNCTION Validate_Attributes (
616: p_cnlv_rec IN cnlv_rec_type
617: ) RETURN VARCHAR2 IS

Line 648: -- Validate_Record for:OKC_CONDITION_LINES_V --

644: ---------------------------------------------------------------------------
645: -- PROCEDURE Validate_Record
646: ---------------------------------------------------------------------------
647: -----------------------------------------------
648: -- Validate_Record for:OKC_CONDITION_LINES_V --
649: -----------------------------------------------
650: FUNCTION Validate_Record (
651: p_cnlv_rec IN cnlv_rec_type
652: ) RETURN VARCHAR2 IS

Line 900: -- Validate_Attributes for:OKC_CONDITION_LINES_V --

896: ---------------------------------------------------------------------------
897: -- PROCEDURE Validate_Attributes
898: ---------------------------------------------------------------------------
899: ---------------------------------------------------
900: -- Validate_Attributes for:OKC_CONDITION_LINES_V --
901: ---------------------------------------------------
902: ---------------------------------------------------------------------------
903: -- PROCEDURE Validate_cnh_id
904: ---------------------------------------------------------------------------

Line 1736: l_value OKC_CONDITION_LINES_V.left_parenthesis%TYPE;

1732: ,p_cnlv_rec IN cnlv_rec_type)
1733: IS
1734:
1735: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1736: l_value OKC_CONDITION_LINES_V.left_parenthesis%TYPE;
1737: BEGIN
1738: -- initialize return status
1739: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1740:

Line 1804: l_value OKC_CONDITION_LINES_V.right_parenthesis%TYPE;

1800: ,p_cnlv_rec IN cnlv_rec_type)
1801: IS
1802:
1803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1804: l_value OKC_CONDITION_LINES_V.right_parenthesis%TYPE;
1805: BEGIN
1806: -- initialize return status
1807: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1808:

Line 1872: l_value OKC_CONDITION_LINES_V.right_parenthesis%TYPE;

1868: ,p_cnlv_rec IN cnlv_rec_type)
1869: IS
1870:
1871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1872: l_value OKC_CONDITION_LINES_V.right_parenthesis%TYPE;
1873: l_format OKC_ACTION_ATTRIBUTES_V.format_mask%TYPE;
1874: l_csm_rec VARCHAR2(1);
1875: l_cs_rec VARCHAR2(1);
1876: /* CURSOR csm_cur IS

Line 2461: -- Validate_Attributes for:OKC_CONDITION_LINES_V --

2457: ---------------------------------------------------------------------------
2458: -- PROCEDURE Validate_Attributes
2459: ---------------------------------------------------------------------------
2460: -----------------------------------------------------
2461: -- Validate_Attributes for:OKC_CONDITION_LINES_V --
2462: -----------------------------------------------------
2463: FUNCTION Validate_Attributes (
2464: p_cnlv_rec IN cnlv_rec_type
2465: ) RETURN VARCHAR2 IS

Line 2777: -- Validate_Record for:OKC_CONDITION_LINES_V --

2773: ---------------------------------------------------------------------------
2774: -- PROCEDURE Validate_Record
2775: ---------------------------------------------------------------------------
2776: -----------------------------------------------
2777: -- Validate_Record for:OKC_CONDITION_LINES_V --
2778: -----------------------------------------------
2779: FUNCTION Validate_Record (
2780: p_cnlv_rec IN cnlv_rec_type
2781: ) RETURN VARCHAR2 IS

Line 2785: select 'X' from okc_condition_lines_v cnl

2781: ) RETURN VARCHAR2 IS
2782: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2783: l_cnl_rec VARCHAR2(1);
2784: CURSOR cnl_cur IS
2785: select 'X' from okc_condition_lines_v cnl
2786: where cnl.sortseq = p_cnlv_rec.sortseq
2787: and cnl.cnh_id = p_cnlv_rec.cnh_id
2788: and cnl.id <> p_cnlv_rec.id;
2789: BEGIN

Line 2940: -- validate_row for:OKC_CONDITION_LINES_V --

2936: ---------------------------------------------------------------------------
2937: -- PROCEDURE validate_row
2938: ---------------------------------------------------------------------------
2939: --------------------------------------------
2940: -- validate_row for:OKC_CONDITION_LINES_V --
2941: --------------------------------------------
2942: PROCEDURE validate_row(
2943: p_api_version IN NUMBER,
2944: p_init_msg_list IN VARCHAR2 ,

Line 3368: -- insert_row for:OKC_CONDITION_LINES_V --

3364: '_PVT'
3365: );
3366: END insert_row;
3367: ------------------------------------------
3368: -- insert_row for:OKC_CONDITION_LINES_V --
3369: ------------------------------------------
3370: PROCEDURE insert_row(
3371: p_api_version IN NUMBER,
3372: p_init_msg_list IN VARCHAR2 ,

Line 3405: -- Set_Attributes for:OKC_CONDITION_LINES_V --

3401: l_cnlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3402: RETURN(l_cnlv_rec);
3403: END fill_who_columns;
3404: ----------------------------------------------
3405: -- Set_Attributes for:OKC_CONDITION_LINES_V --
3406: ----------------------------------------------
3407: FUNCTION Set_Attributes (
3408: p_cnlv_rec IN cnlv_rec_type,
3409: x_cnlv_rec OUT NOCOPY cnlv_rec_type

Line 3802: -- lock_row for:OKC_CONDITION_LINES_V --

3798: '_PVT'
3799: );
3800: END lock_row;
3801: ----------------------------------------
3802: -- lock_row for:OKC_CONDITION_LINES_V --
3803: ----------------------------------------
3804: PROCEDURE lock_row(
3805: p_api_version IN NUMBER,
3806: p_init_msg_list IN VARCHAR2 ,

Line 4451: -- update_row for:OKC_CONDITION_LINES_V --

4447: '_PVT'
4448: );
4449: END update_row;
4450: ------------------------------------------
4451: -- update_row for:OKC_CONDITION_LINES_V --
4452: ------------------------------------------
4453: PROCEDURE update_row(
4454: p_api_version IN NUMBER,
4455: p_init_msg_list IN VARCHAR2 ,

Line 4680: -- Set_Attributes for:OKC_CONDITION_LINES_V --

4676: END IF;
4677: RETURN(l_return_status);
4678: END populate_new_record;
4679: ----------------------------------------------
4680: -- Set_Attributes for:OKC_CONDITION_LINES_V --
4681: ----------------------------------------------
4682: FUNCTION Set_Attributes (
4683: p_cnlv_rec IN cnlv_rec_type,
4684: x_cnlv_rec OUT NOCOPY cnlv_rec_type

Line 5031: -- delete_row for:OKC_CONDITION_LINES_V --

5027: '_PVT'
5028: );
5029: END delete_row;
5030: ------------------------------------------
5031: -- delete_row for:OKC_CONDITION_LINES_V --
5032: ------------------------------------------
5033: PROCEDURE delete_row(
5034: p_api_version IN NUMBER,
5035: p_init_msg_list IN VARCHAR2 ,