DBA Data[Home] [Help]

APPS.OKC_GVE_PVT dependencies on OKC_GOVERNANCES_V

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_GOVERNANCES_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_GOVERNANCES_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 292: p_token2_value => 'OKC_GOVERNANCES_V',

288: p_msg_name => g_no_parent_record,
289: p_token1 => g_col_name_token,
290: p_token1_value => 'isa_agreement_id',
291: p_token2 => g_child_table_token,
292: p_token2_value => 'OKC_GOVERNANCES_V',
293: p_token3 => g_parent_table_token,
294: p_token3_value => 'OKX_AGREEMENTS_V');
295: -- notify caller of an error
296: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 455: -- FUNCTION get_rec for: OKC_GOVERNANCES_V

451: BEGIN
452: RETURN(get_rec(p_gve_rec, l_row_notfound));
453: END get_rec;
454: ---------------------------------------------------------------------------
455: -- FUNCTION get_rec for: OKC_GOVERNANCES_V
456: ---------------------------------------------------------------------------
457: FUNCTION get_rec (
458: p_gvev_rec IN gvev_rec_type,
459: x_no_data_found OUT NOCOPY BOOLEAN

Line 477: FROM Okc_Governances_V

473: CREATION_DATE,
474: LAST_UPDATED_BY,
475: LAST_UPDATE_DATE,
476: LAST_UPDATE_LOGIN
477: FROM Okc_Governances_V
478: WHERE okc_governances_v.id = p_id;
479: l_okc_gvev_pk okc_gvev_pk_csr%ROWTYPE;
480: l_gvev_rec gvev_rec_type;
481: BEGIN

Line 478: WHERE okc_governances_v.id = p_id;

474: LAST_UPDATED_BY,
475: LAST_UPDATE_DATE,
476: LAST_UPDATE_LOGIN
477: FROM Okc_Governances_V
478: WHERE okc_governances_v.id = p_id;
479: l_okc_gvev_pk okc_gvev_pk_csr%ROWTYPE;
480: l_gvev_rec gvev_rec_type;
481: BEGIN
482: x_no_data_found := TRUE;

Line 514: -- FUNCTION null_out_defaults for: OKC_GOVERNANCES_V --

510: RETURN(get_rec(p_gvev_rec, l_row_notfound));
511: END get_rec;
512:
513: -------------------------------------------------------
514: -- FUNCTION null_out_defaults for: OKC_GOVERNANCES_V --
515: -------------------------------------------------------
516: FUNCTION null_out_defaults (
517: p_gvev_rec IN gvev_rec_type
518: ) RETURN gvev_rec_type IS

Line 566: -- Validate_Attributes for:OKC_GOVERNANCES_V --

562: ---------------------------------------------------------------------------
563: -- PROCEDURE Validate_Attributes
564: ---------------------------------------------------------------------------
565: -----------------------------------------------
566: -- Validate_Attributes for:OKC_GOVERNANCES_V --
567: -----------------------------------------------
568: FUNCTION Validate_Attributes (
569: p_gvev_rec IN gvev_rec_type
570: ) RETURN VARCHAR2 IS

Line 664: -- Validate_Record for:OKC_GOVERNANCES_V --

660: ---------------------------------------------------------------------------
661: -- PROCEDURE Validate_Record
662: ---------------------------------------------------------------------------
663: -------------------------------------------
664: -- Validate_Record for:OKC_GOVERNANCES_V --
665: -------------------------------------------
666: FUNCTION Validate_Record (
667: p_gvev_rec IN gvev_rec_type
668: ) RETURN VARCHAR2 IS

Line 765: -- validate_row for:OKC_GOVERNANCES_V --

761: ---------------------------------------------------------------------------
762: -- PROCEDURE validate_row
763: ---------------------------------------------------------------------------
764: ----------------------------------------
765: -- validate_row for:OKC_GOVERNANCES_V --
766: ----------------------------------------
767: PROCEDURE validate_row(
768: p_api_version IN NUMBER,
769: p_init_msg_list IN VARCHAR2 ,

Line 1033: -- insert_row for:OKC_GOVERNANCES_V --

1029: '_PVT'
1030: );
1031: END insert_row;
1032: --------------------------------------
1033: -- insert_row for:OKC_GOVERNANCES_V --
1034: --------------------------------------
1035: PROCEDURE insert_row(
1036: p_api_version IN NUMBER,
1037: p_init_msg_list IN VARCHAR2 ,

Line 1067: -- Set_Attributes for:OKC_GOVERNANCES_V --

1063: l_gvev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1064: RETURN(l_gvev_rec);
1065: END fill_who_columns;
1066: ------------------------------------------
1067: -- Set_Attributes for:OKC_GOVERNANCES_V --
1068: ------------------------------------------
1069: FUNCTION Set_Attributes (
1070: p_gvev_rec IN gvev_rec_type,
1071: x_gvev_rec OUT NOCOPY gvev_rec_type

Line 1367: -- lock_row for:OKC_GOVERNANCES_V --

1363: '_PVT'
1364: );
1365: END lock_row;
1366: ------------------------------------
1367: -- lock_row for:OKC_GOVERNANCES_V --
1368: ------------------------------------
1369: PROCEDURE lock_row(
1370: p_api_version IN NUMBER,
1371: p_init_msg_list IN VARCHAR2 ,

Line 1706: -- update_row for:OKC_GOVERNANCES_V --

1702: '_PVT'
1703: );
1704: END update_row;
1705: --------------------------------------
1706: -- update_row for:OKC_GOVERNANCES_V --
1707: --------------------------------------
1708: PROCEDURE update_row(
1709: p_api_version IN NUMBER,
1710: p_init_msg_list IN VARCHAR2 ,

Line 1813: -- Set_Attributes for:OKC_GOVERNANCES_V --

1809: END IF;
1810: RETURN(l_return_status);
1811: END populate_new_record;
1812: ------------------------------------------
1813: -- Set_Attributes for:OKC_GOVERNANCES_V --
1814: ------------------------------------------
1815: FUNCTION Set_Attributes (
1816: p_gvev_rec IN gvev_rec_type,
1817: x_gvev_rec OUT NOCOPY gvev_rec_type

Line 2071: -- delete_row for:OKC_GOVERNANCES_V --

2067: '_PVT'
2068: );
2069: END delete_row;
2070: --------------------------------------
2071: -- delete_row for:OKC_GOVERNANCES_V --
2072: --------------------------------------
2073: PROCEDURE delete_row(
2074: p_api_version IN NUMBER,
2075: p_init_msg_list IN VARCHAR2 ,