APPS.OKC_CPL_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 12: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_PARTY_ROLES_V';

8: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
9: g_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
10: G_EXCEPTION_HALT_VALIDATION exception;
11: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
12: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_PARTY_ROLES_V';
13: /*+++++++++++++End of hand code +++++++++++++++++++*/
14: ---------------------------------------------------------------------------
15: -- FUNCTION get_seq_id
16: ---------------------------------------------------------------------------

Line 424: -- FUNCTION get_rec for: OKC_K_PARTY_ROLES_V

420: RETURN(get_rec(p_okc_k_party_roles_tl_rec, l_row_notfound));
421:
422: END get_rec;
423: ---------------------------------------------------------------------------
424: -- FUNCTION get_rec for: OKC_K_PARTY_ROLES_V
425: ---------------------------------------------------------------------------
426: FUNCTION get_rec (
427: p_cplv_rec IN cplv_rec_type,
428: x_no_data_found OUT NOCOPY BOOLEAN

Line 473: FROM Okc_K_Party_Roles_V

469: CREATION_DATE,
470: LAST_UPDATED_BY,
471: LAST_UPDATE_DATE,
472: LAST_UPDATE_LOGIN
473: FROM Okc_K_Party_Roles_V
474: WHERE okc_k_party_roles_v.id = p_id;
475: l_okc_cplv_pk okc_cplv_pk_csr%ROWTYPE;
476: l_cplv_rec cplv_rec_type;
477: BEGIN

Line 474: WHERE okc_k_party_roles_v.id = p_id;

470: LAST_UPDATED_BY,
471: LAST_UPDATE_DATE,
472: LAST_UPDATE_LOGIN
473: FROM Okc_K_Party_Roles_V
474: WHERE okc_k_party_roles_v.id = p_id;
475: l_okc_cplv_pk okc_cplv_pk_csr%ROWTYPE;
476: l_cplv_rec cplv_rec_type;
477: BEGIN
478:

Line 552: -- FUNCTION null_out_defaults for: OKC_K_PARTY_ROLES_V --

548:
549: END get_rec;
550:
551: ---------------------------------------------------------
552: -- FUNCTION null_out_defaults for: OKC_K_PARTY_ROLES_V --
553: ---------------------------------------------------------
554: FUNCTION null_out_defaults (
555: p_cplv_rec IN cplv_rec_type
556: ) RETURN cplv_rec_type IS

Line 1548: -- Validate_Attributes for:OKC_K_PARTY_ROLES_V --

1544: End validate_primary_yn;
1545:
1546: /*+++++++++++++End of hand code +++++++++++++++++++*/
1547: -------------------------------------------------
1548: -- Validate_Attributes for:OKC_K_PARTY_ROLES_V --
1549: -------------------------------------------------
1550: FUNCTION Validate_Attributes (
1551: p_cplv_rec IN cplv_rec_type
1552: ) RETURN VARCHAR2 IS

Line 1704: -- Validate_Record for:OKC_K_PARTY_ROLES_V --

1700: ---------------------------------------------------------------------------
1701: -- PROCEDURE Validate_Record
1702: ---------------------------------------------------------------------------
1703: ---------------------------------------------
1704: -- Validate_Record for:OKC_K_PARTY_ROLES_V --
1705: ---------------------------------------------
1706: FUNCTION Validate_Record (
1707: p_cplv_rec IN cplv_rec_type
1708: ) RETURN VARCHAR2 IS

Line 1876: p_view_name => 'OKC_K_PARTY_ROLES_V',

1872: l_unq_tbl(5).p_col_val := p_cplv_rec.OBJECT1_ID2;
1873: l_unq_tbl(6).p_col_name := 'CLE_ID';
1874: l_unq_tbl(6).p_col_val := p_cplv_rec.CLE_ID;
1875: OKC_UTIL.Check_Comp_Unique(
1876: p_view_name => 'OKC_K_PARTY_ROLES_V',
1877: p_col_tbl => l_unq_tbl,
1878: p_id => p_cplv_rec.ID,
1879: x_return_status => l_return_status);
1880: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

Line 2046: -- validate_row for:OKC_K_PARTY_ROLES_V --

2042: ---------------------------------------------------------------------------
2043: -- PROCEDURE validate_row
2044: ---------------------------------------------------------------------------
2045: ------------------------------------------
2046: -- validate_row for:OKC_K_PARTY_ROLES_V --
2047: ------------------------------------------
2048: PROCEDURE validate_row(
2049: p_api_version IN NUMBER,
2050: p_init_msg_list IN VARCHAR2 ,

Line 2632: -- insert_row for:OKC_K_PARTY_ROLES_V --

2628: );
2629:
2630: END insert_row;
2631: ----------------------------------------
2632: -- insert_row for:OKC_K_PARTY_ROLES_V --
2633: ----------------------------------------
2634: PROCEDURE insert_row(
2635: p_api_version IN NUMBER,
2636: p_init_msg_list IN VARCHAR2 ,

Line 2671: -- Set_Attributes for:OKC_K_PARTY_ROLES_V --

2667: RETURN(l_cplv_rec);
2668:
2669: END fill_who_columns;
2670: --------------------------------------------
2671: -- Set_Attributes for:OKC_K_PARTY_ROLES_V --
2672: --------------------------------------------
2673: FUNCTION Set_Attributes (
2674: p_cplv_rec IN cplv_rec_type,
2675: x_cplv_rec OUT NOCOPY cplv_rec_type

Line 3221: -- lock_row for:OKC_K_PARTY_ROLES_V --

3217: );
3218:
3219: END lock_row;
3220: --------------------------------------
3221: -- lock_row for:OKC_K_PARTY_ROLES_V --
3222: --------------------------------------
3223: PROCEDURE lock_row(
3224: p_api_version IN NUMBER,
3225: p_init_msg_list IN VARCHAR2 ,

Line 4038: -- update_row for:OKC_K_PARTY_ROLES_V --

4034: );
4035:
4036: END update_row;
4037: ----------------------------------------
4038: -- update_row for:OKC_K_PARTY_ROLES_V --
4039: ----------------------------------------
4040: PROCEDURE update_row(
4041: p_api_version IN NUMBER,
4042: p_init_msg_list IN VARCHAR2 ,

Line 4275: -- Set_Attributes for:OKC_K_PARTY_ROLES_V --

4271: RETURN(l_return_status);
4272:
4273: END populate_new_record;
4274: --------------------------------------------
4275: -- Set_Attributes for:OKC_K_PARTY_ROLES_V --
4276: --------------------------------------------
4277: FUNCTION Set_Attributes (
4278: p_cplv_rec IN cplv_rec_type,
4279: x_cplv_rec OUT NOCOPY cplv_rec_type

Line 4747: -- delete_row for:OKC_K_PARTY_ROLES_V --

4743: );
4744:
4745: END delete_row;
4746: ----------------------------------------
4747: -- delete_row for:OKC_K_PARTY_ROLES_V --
4748: ----------------------------------------
4749: PROCEDURE delete_row(
4750: p_api_version IN NUMBER,
4751: p_init_msg_list IN VARCHAR2 ,