DBA Data[Home] [Help]

APPS.OKC_CPS_PVT dependencies on OKC_K_PROCESSES_V

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_PROCESSES_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) := 'ERROR_MESSAGE';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_PROCESSES_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 499: -- FUNCTION get_rec for: OKC_K_PROCESSES_V

495: BEGIN
496: RETURN(get_rec(p_cps_rec, l_row_notfound));
497: END get_rec;
498: ---------------------------------------------------------------------------
499: -- FUNCTION get_rec for: OKC_K_PROCESSES_V
500: ---------------------------------------------------------------------------
501: FUNCTION get_rec (
502: p_cpsv_rec IN cpsv_rec_type,
503: x_no_data_found OUT NOCOPY BOOLEAN

Line 536: FROM Okc_K_Processes_V

532: CREATION_DATE,
533: LAST_UPDATED_BY,
534: LAST_UPDATE_DATE,
535: LAST_UPDATE_LOGIN
536: FROM Okc_K_Processes_V
537: WHERE okc_k_processes_v.id = p_id;
538: l_okc_cpsv_pk okc_cpsv_pk_csr%ROWTYPE;
539: l_cpsv_rec cpsv_rec_type;
540: BEGIN

Line 537: WHERE okc_k_processes_v.id = p_id;

533: LAST_UPDATED_BY,
534: LAST_UPDATE_DATE,
535: LAST_UPDATE_LOGIN
536: FROM Okc_K_Processes_V
537: WHERE okc_k_processes_v.id = p_id;
538: l_okc_cpsv_pk okc_cpsv_pk_csr%ROWTYPE;
539: l_cpsv_rec cpsv_rec_type;
540: BEGIN
541: x_no_data_found := TRUE;

Line 588: -- FUNCTION null_out_defaults for: OKC_K_PROCESSES_V --

584: RETURN(get_rec(p_cpsv_rec, l_row_notfound));
585: END get_rec;
586:
587: -------------------------------------------------------
588: -- FUNCTION null_out_defaults for: OKC_K_PROCESSES_V --
589: -------------------------------------------------------
590: FUNCTION null_out_defaults (
591: p_cpsv_rec IN cpsv_rec_type
592: ) RETURN cpsv_rec_type IS

Line 685: -- Validate_Attributes for:OKC_K_PROCESSES_V --

681: ---------------------------------------------------------------------------
682: -- PROCEDURE Validate_Attributes
683: ---------------------------------------------------------------------------
684: -----------------------------------------------
685: -- Validate_Attributes for:OKC_K_PROCESSES_V --
686: -----------------------------------------------
687: FUNCTION Validate_Attributes (
688: p_cpsv_rec IN cpsv_rec_type
689: ) RETURN VARCHAR2 IS

Line 788: -- Validate_Record for:OKC_K_PROCESSES_V --

784: ---------------------------------------------------------------------------
785: -- PROCEDURE Validate_Record
786: ---------------------------------------------------------------------------
787: -------------------------------------------
788: -- Validate_Record for:OKC_K_PROCESSES_V --
789: -------------------------------------------
790: FUNCTION Validate_Record (
791: p_cpsv_rec IN cpsv_rec_type
792: ) RETURN VARCHAR2 IS

Line 972: -- validate_row for:OKC_K_PROCESSES_V --

968: ---------------------------------------------------------------------------
969: -- PROCEDURE validate_row
970: ---------------------------------------------------------------------------
971: ----------------------------------------
972: -- validate_row for:OKC_K_PROCESSES_V --
973: ----------------------------------------
974: PROCEDURE validate_row(
975: p_api_version IN NUMBER,
976: p_init_msg_list IN VARCHAR2 ,

Line 1270: -- insert_row for:OKC_K_PROCESSES_V --

1266: '_PVT'
1267: );
1268: END insert_row;
1269: --------------------------------------
1270: -- insert_row for:OKC_K_PROCESSES_V --
1271: --------------------------------------
1272: PROCEDURE insert_row(
1273: p_api_version IN NUMBER,
1274: p_init_msg_list IN VARCHAR2 ,

Line 1305: -- Set_Attributes for:OKC_K_PROCESSES_V --

1301: l_cpsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1302: RETURN(l_cpsv_rec);
1303: END fill_who_columns;
1304: ------------------------------------------
1305: -- Set_Attributes for:OKC_K_PROCESSES_V --
1306: ------------------------------------------
1307: FUNCTION Set_Attributes (
1308: p_cpsv_rec IN cpsv_rec_type,
1309: x_cpsv_rec OUT NOCOPY cpsv_rec_type

Line 1607: -- lock_row for:OKC_K_PROCESSES_V --

1603: '_PVT'
1604: );
1605: END lock_row;
1606: ------------------------------------
1607: -- lock_row for:OKC_K_PROCESSES_V --
1608: ------------------------------------
1609: PROCEDURE lock_row(
1610: p_api_version IN NUMBER,
1611: p_init_msg_list IN VARCHAR2 ,

Line 2021: -- update_row for:OKC_K_PROCESSES_V --

2017: '_PVT'
2018: );
2019: END update_row;
2020: --------------------------------------
2021: -- update_row for:OKC_K_PROCESSES_V --
2022: --------------------------------------
2023: PROCEDURE update_row(
2024: p_api_version IN NUMBER,
2025: p_init_msg_list IN VARCHAR2 ,

Line 2188: -- Set_Attributes for:OKC_K_PROCESSES_V --

2184: END IF;
2185: RETURN(l_return_status);
2186: END populate_new_record;
2187: ------------------------------------------
2188: -- Set_Attributes for:OKC_K_PROCESSES_V --
2189: ------------------------------------------
2190: FUNCTION Set_Attributes (
2191: p_cpsv_rec IN cpsv_rec_type,
2192: x_cpsv_rec OUT NOCOPY cpsv_rec_type

Line 2446: -- delete_row for:OKC_K_PROCESSES_V --

2442: '_PVT'
2443: );
2444: END delete_row;
2445: --------------------------------------
2446: -- delete_row for:OKC_K_PROCESSES_V --
2447: --------------------------------------
2448: PROCEDURE delete_row(
2449: p_api_version IN NUMBER,
2450: p_init_msg_list IN VARCHAR2 ,