APPS.OKC_ACY_PVT dependencies on OKC_ANCESTRYS_V

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_ANCESTRYS_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_ANCESTRYS_V';
14: G_EXCEPTION_HALT_VALIDATION exception;
15:
16: -- Start of comments
17: --

Line 302: -- FUNCTION get_rec for: OKC_ANCESTRYS_V

298: BEGIN
299: RETURN(get_rec(p_acy_rec, l_row_notfound));
300: END get_rec;
301: ---------------------------------------------------------------------------
302: -- FUNCTION get_rec for: OKC_ANCESTRYS_V
303: ---------------------------------------------------------------------------
304: FUNCTION get_rec (
305: p_acyv_rec IN acyv_rec_type,
306: x_no_data_found OUT NOCOPY BOOLEAN

Line 320: FROM Okc_Ancestrys_V

316: CREATION_DATE,
317: LAST_UPDATED_BY,
318: LAST_UPDATE_DATE,
319: LAST_UPDATE_LOGIN
320: FROM Okc_Ancestrys_V
321: WHERE okc_ancestrys_v.cle_id = p_cle_id
322: AND okc_ancestrys_v.cle_id_ascendant = p_cle_id_ascendant;
323: l_okc_acyv_pk okc_acyv_pk_csr%ROWTYPE;
324: l_acyv_rec acyv_rec_type;

Line 321: WHERE okc_ancestrys_v.cle_id = p_cle_id

317: LAST_UPDATED_BY,
318: LAST_UPDATE_DATE,
319: LAST_UPDATE_LOGIN
320: FROM Okc_Ancestrys_V
321: WHERE okc_ancestrys_v.cle_id = p_cle_id
322: AND okc_ancestrys_v.cle_id_ascendant = p_cle_id_ascendant;
323: l_okc_acyv_pk okc_acyv_pk_csr%ROWTYPE;
324: l_acyv_rec acyv_rec_type;
325: BEGIN

Line 322: AND okc_ancestrys_v.cle_id_ascendant = p_cle_id_ascendant;

318: LAST_UPDATE_DATE,
319: LAST_UPDATE_LOGIN
320: FROM Okc_Ancestrys_V
321: WHERE okc_ancestrys_v.cle_id = p_cle_id
322: AND okc_ancestrys_v.cle_id_ascendant = p_cle_id_ascendant;
323: l_okc_acyv_pk okc_acyv_pk_csr%ROWTYPE;
324: l_acyv_rec acyv_rec_type;
325: BEGIN
326: x_no_data_found := TRUE;

Line 354: -- FUNCTION null_out_defaults for: OKC_ANCESTRYS_V --

350: RETURN(get_rec(p_acyv_rec, l_row_notfound));
351: END get_rec;
352:
353: -----------------------------------------------------
354: -- FUNCTION null_out_defaults for: OKC_ANCESTRYS_V --
355: -----------------------------------------------------
356: FUNCTION null_out_defaults (
357: p_acyv_rec IN acyv_rec_type
358: ) RETURN acyv_rec_type IS

Line 394: -- Validate_Attributes for:OKC_ANCESTRYS_V --

390: ---------------------------------------------------------------------------
391: -- PROCEDURE Validate_Attributes
392: ---------------------------------------------------------------------------
393: ---------------------------------------------
394: -- Validate_Attributes for:OKC_ANCESTRYS_V --
395: ---------------------------------------------
396: FUNCTION Validate_Attributes (
397: p_acyv_rec IN acyv_rec_type
398: ) RETURN VARCHAR2 IS

Line 459: -- Validate_Record for:OKC_ANCESTRYS_V --

455: ---------------------------------------------------------------------------
456: -- PROCEDURE Validate_Record
457: ---------------------------------------------------------------------------
458: -----------------------------------------
459: -- Validate_Record for:OKC_ANCESTRYS_V --
460: -----------------------------------------
461: FUNCTION Validate_Record (
462: p_acyv_rec IN acyv_rec_type
463: ) RETURN VARCHAR2 IS

Line 507: -- validate_row for:OKC_ANCESTRYS_V --

503: ---------------------------------------------------------------------------
504: -- PROCEDURE validate_row
505: ---------------------------------------------------------------------------
506: --------------------------------------
507: -- validate_row for:OKC_ANCESTRYS_V --
508: --------------------------------------
509: PROCEDURE validate_row(
510: p_api_version IN NUMBER,
511: p_init_msg_list IN VARCHAR2 ,

Line 765: -- insert_row for:OKC_ANCESTRYS_V --

761: '_PVT'
762: );
763: END insert_row;
764: ------------------------------------
765: -- insert_row for:OKC_ANCESTRYS_V --
766: ------------------------------------
767: PROCEDURE insert_row(
768: p_api_version IN NUMBER,
769: p_init_msg_list IN VARCHAR2 ,

Line 799: -- Set_Attributes for:OKC_ANCESTRYS_V --

795: l_acyv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
796: RETURN(l_acyv_rec);
797: END fill_who_columns;
798: ----------------------------------------
799: -- Set_Attributes for:OKC_ANCESTRYS_V --
800: ----------------------------------------
801: FUNCTION Set_Attributes (
802: p_acyv_rec IN acyv_rec_type,
803: x_acyv_rec OUT NOCOPY acyv_rec_type

Line 1096: -- lock_row for:OKC_ANCESTRYS_V --

1092: '_PVT'
1093: );
1094: END lock_row;
1095: ----------------------------------
1096: -- lock_row for:OKC_ANCESTRYS_V --
1097: ----------------------------------
1098: PROCEDURE lock_row(
1099: p_api_version IN NUMBER,
1100: p_init_msg_list IN VARCHAR2 ,

Line 1410: -- update_row for:OKC_ANCESTRYS_V --

1406: '_PVT'
1407: );
1408: END update_row;
1409: ------------------------------------
1410: -- update_row for:OKC_ANCESTRYS_V --
1411: ------------------------------------
1412: PROCEDURE update_row(
1413: p_api_version IN NUMBER,
1414: p_init_msg_list IN VARCHAR2 ,

Line 1497: -- Set_Attributes for:OKC_ANCESTRYS_V --

1493: END IF;
1494: RETURN(l_return_status);
1495: END populate_new_record;
1496: ----------------------------------------
1497: -- Set_Attributes for:OKC_ANCESTRYS_V --
1498: ----------------------------------------
1499: FUNCTION Set_Attributes (
1500: p_acyv_rec IN acyv_rec_type,
1501: x_acyv_rec OUT NOCOPY acyv_rec_type

Line 1753: -- delete_row for:OKC_ANCESTRYS_V --

1749: '_PVT'
1750: );
1751: END delete_row;
1752: ------------------------------------
1753: -- delete_row for:OKC_ANCESTRYS_V --
1754: ------------------------------------
1755: PROCEDURE delete_row(
1756: p_api_version IN NUMBER,
1757: p_init_msg_list IN VARCHAR2 ,