APPS.OKC_CAC_PVT dependencies on OKC_K_ACCESSES_V

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_ACCESSES_V';

9: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_ACCESSES_V';
14: G_EXCEPTION_HALT_VALIDATION exception;
15: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16:
17: -- Start of comments

Line 452: -- FUNCTION get_rec for: OKC_K_ACCESSES_V

448: RETURN(get_rec(p_cac_rec, l_row_notfound));
449:
450: END get_rec;
451: ---------------------------------------------------------------------------
452: -- FUNCTION get_rec for: OKC_K_ACCESSES_V
453: ---------------------------------------------------------------------------
454: FUNCTION get_rec (
455: p_cacv_rec IN cacv_rec_type,
456: x_no_data_found OUT NOCOPY BOOLEAN

Line 471: FROM Okc_K_Accesses_V

467: CREATION_DATE,
468: LAST_UPDATED_BY,
469: LAST_UPDATE_DATE,
470: LAST_UPDATE_LOGIN
471: FROM Okc_K_Accesses_V
472: WHERE okc_k_accesses_v.id = p_id;
473: l_okc_cacv_pk okc_cacv_pk_csr%ROWTYPE;
474: l_cacv_rec cacv_rec_type;
475: BEGIN

Line 472: WHERE okc_k_accesses_v.id = p_id;

468: LAST_UPDATED_BY,
469: LAST_UPDATE_DATE,
470: LAST_UPDATE_LOGIN
471: FROM Okc_K_Accesses_V
472: WHERE okc_k_accesses_v.id = p_id;
473: l_okc_cacv_pk okc_cacv_pk_csr%ROWTYPE;
474: l_cacv_rec cacv_rec_type;
475: BEGIN
476:

Line 520: -- FUNCTION null_out_defaults for: OKC_K_ACCESSES_V --

516:
517: END get_rec;
518:
519: ------------------------------------------------------
520: -- FUNCTION null_out_defaults for: OKC_K_ACCESSES_V --
521: ------------------------------------------------------
522: FUNCTION null_out_defaults (
523: p_cacv_rec IN cacv_rec_type
524: ) RETURN cacv_rec_type IS

Line 576: -- Validate_Attributes for:OKC_K_ACCESSES_V --

572: ---------------------------------------------------------------------------
573: -- PROCEDURE Validate_Attributes
574: ---------------------------------------------------------------------------
575: ----------------------------------------------
576: -- Validate_Attributes for:OKC_K_ACCESSES_V --
577: ----------------------------------------------
578: FUNCTION Validate_Attributes (
579: p_cacv_rec IN cacv_rec_type
580: ) RETURN VARCHAR2 IS

Line 675: -- Validate_Record for:OKC_K_ACCESSES_V --

671: ---------------------------------------------------------------------------
672: -- PROCEDURE Validate_Record
673: ---------------------------------------------------------------------------
674: ------------------------------------------
675: -- Validate_Record for:OKC_K_ACCESSES_V --
676: ------------------------------------------
677: FUNCTION Validate_Record (
678: p_cacv_rec IN cacv_rec_type
679: ) RETURN VARCHAR2 IS

Line 864: -- validate_row for:OKC_K_ACCESSES_V --

860: ---------------------------------------------------------------------------
861: -- PROCEDURE validate_row
862: ---------------------------------------------------------------------------
863: ---------------------------------------
864: -- validate_row for:OKC_K_ACCESSES_V --
865: ---------------------------------------
866: PROCEDURE validate_row(
867: p_api_version IN NUMBER,
868: p_init_msg_list IN VARCHAR2 ,

Line 1221: -- insert_row for:OKC_K_ACCESSES_V --

1217: );
1218:
1219: END insert_row;
1220: -------------------------------------
1221: -- insert_row for:OKC_K_ACCESSES_V --
1222: -------------------------------------
1223: PROCEDURE insert_row(
1224: p_api_version IN NUMBER,
1225: p_init_msg_list IN VARCHAR2 ,

Line 1268: -- Set_Attributes for:OKC_K_ACCESSES_V --

1264: RETURN(l_cacv_rec);
1265:
1266: END fill_who_columns;
1267: -----------------------------------------
1268: -- Set_Attributes for:OKC_K_ACCESSES_V --
1269: -----------------------------------------
1270: FUNCTION Set_Attributes (
1271: p_cacv_rec IN cacv_rec_type,
1272: x_cacv_rec OUT NOCOPY cacv_rec_type

Line 1692: -- lock_row for:OKC_K_ACCESSES_V --

1688: );
1689:
1690: END lock_row;
1691: -----------------------------------
1692: -- lock_row for:OKC_K_ACCESSES_V --
1693: -----------------------------------
1694: PROCEDURE lock_row(
1695: p_api_version IN NUMBER,
1696: p_init_msg_list IN VARCHAR2 ,

Line 2123: -- update_row for:OKC_K_ACCESSES_V --

2119: );
2120:
2121: END update_row;
2122: -------------------------------------
2123: -- update_row for:OKC_K_ACCESSES_V --
2124: -------------------------------------
2125: PROCEDURE update_row(
2126: p_api_version IN NUMBER,
2127: p_init_msg_list IN VARCHAR2 ,

Line 2233: -- Set_Attributes for:OKC_K_ACCESSES_V --

2229: RETURN(l_return_status);
2230:
2231: END populate_new_record;
2232: -----------------------------------------
2233: -- Set_Attributes for:OKC_K_ACCESSES_V --
2234: -----------------------------------------
2235: FUNCTION Set_Attributes (
2236: p_cacv_rec IN cacv_rec_type,
2237: x_cacv_rec OUT NOCOPY cacv_rec_type

Line 2586: -- delete_row for:OKC_K_ACCESSES_V --

2582: );
2583:
2584: END delete_row;
2585: -------------------------------------
2586: -- delete_row for:OKC_K_ACCESSES_V --
2587: -------------------------------------
2588: PROCEDURE delete_row(
2589: p_api_version IN NUMBER,
2590: p_init_msg_list IN VARCHAR2 ,