eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ACY_PVT dependencies on OKC_ANCESTRYS

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 251: -- FUNCTION get_rec for: OKC_ANCESTRYS

247: null;
248: END api_copy;
249:
250: ---------------------------------------------------------------------------
251: -- FUNCTION get_rec for: OKC_ANCESTRYS
252: ---------------------------------------------------------------------------
253: FUNCTION get_rec (
254: p_acy_rec IN acy_rec_type,
255: x_no_data_found OUT NOCOPY BOOLEAN

Line 269: FROM Okc_Ancestrys

265: CREATION_DATE,
266: LAST_UPDATED_BY,
267: LAST_UPDATE_DATE,
268: LAST_UPDATE_LOGIN
269: FROM Okc_Ancestrys
270: WHERE okc_ancestrys.cle_id = p_cle_id
271: AND okc_ancestrys.cle_id_ascendant = p_cle_id_ascendant;
272: l_acy_pk acy_pk_csr%ROWTYPE;
273: l_acy_rec acy_rec_type;

Line 270: WHERE okc_ancestrys.cle_id = p_cle_id

266: LAST_UPDATED_BY,
267: LAST_UPDATE_DATE,
268: LAST_UPDATE_LOGIN
269: FROM Okc_Ancestrys
270: WHERE okc_ancestrys.cle_id = p_cle_id
271: AND okc_ancestrys.cle_id_ascendant = p_cle_id_ascendant;
272: l_acy_pk acy_pk_csr%ROWTYPE;
273: l_acy_rec acy_rec_type;
274: BEGIN

Line 271: AND okc_ancestrys.cle_id_ascendant = p_cle_id_ascendant;

267: LAST_UPDATE_DATE,
268: LAST_UPDATE_LOGIN
269: FROM Okc_Ancestrys
270: WHERE okc_ancestrys.cle_id = p_cle_id
271: AND okc_ancestrys.cle_id_ascendant = p_cle_id_ascendant;
272: l_acy_pk acy_pk_csr%ROWTYPE;
273: l_acy_rec acy_rec_type;
274: BEGIN
275: x_no_data_found := TRUE;

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 662: -- insert_row for:OKC_ANCESTRYS --

658: ---------------------------------------------------------------------------
659: -- PROCEDURE insert_row
660: ---------------------------------------------------------------------------
661: ----------------------------------
662: -- insert_row for:OKC_ANCESTRYS --
663: ----------------------------------
664: PROCEDURE insert_row(
665: p_init_msg_list IN VARCHAR2 ,
666: x_return_status OUT NOCOPY VARCHAR2,

Line 678: -- Set_Attributes for:OKC_ANCESTRYS --

674: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
675: l_acy_rec acy_rec_type := p_acy_rec;
676: l_def_acy_rec acy_rec_type;
677: --------------------------------------
678: -- Set_Attributes for:OKC_ANCESTRYS --
679: --------------------------------------
680: FUNCTION Set_Attributes (
681: p_acy_rec IN acy_rec_type,
682: x_acy_rec OUT NOCOPY acy_rec_type

Line 709: INSERT INTO OKC_ANCESTRYS(

705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
707: RAISE OKC_API.G_EXCEPTION_ERROR;
708: END IF;
709: INSERT INTO OKC_ANCESTRYS(
710: cle_id,
711: cle_id_ascendant,
712: object_version_number,
713: level_sequence,

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 988: -- lock_row for:OKC_ANCESTRYS --

984: ---------------------------------------------------------------------------
985: -- PROCEDURE lock_row
986: ---------------------------------------------------------------------------
987: --------------------------------
988: -- lock_row for:OKC_ANCESTRYS --
989: --------------------------------
990: PROCEDURE lock_row(
991: p_init_msg_list IN VARCHAR2 ,
992: x_return_status OUT NOCOPY VARCHAR2,

Line 1001: FROM OKC_ANCESTRYS

997: E_Resource_Busy EXCEPTION;
998: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
999: CURSOR lock_csr (p_acy_rec IN acy_rec_type) IS
1000: SELECT OBJECT_VERSION_NUMBER
1001: FROM OKC_ANCESTRYS
1002: WHERE CLE_ID = p_acy_rec.cle_id
1003: AND CLE_ID_ASCENDANT = p_acy_rec.cle_id_ascendant
1004: AND OBJECT_VERSION_NUMBER = p_acy_rec.object_version_number
1005: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 1009: FROM OKC_ANCESTRYS

1005: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1006:
1007: CURSOR lchk_csr (p_acy_rec IN acy_rec_type) IS
1008: SELECT OBJECT_VERSION_NUMBER
1009: FROM OKC_ANCESTRYS
1010: WHERE CLE_ID = p_acy_rec.cle_id
1011: AND CLE_ID_ASCENDANT = p_acy_rec.cle_id_ascendant;
1012: l_api_version CONSTANT NUMBER := 1;
1013: l_api_name CONSTANT VARCHAR2(30) := 'ANCESTRYS_lock_row';

Line 1015: l_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;

1011: AND CLE_ID_ASCENDANT = p_acy_rec.cle_id_ascendant;
1012: l_api_version CONSTANT NUMBER := 1;
1013: l_api_name CONSTANT VARCHAR2(30) := 'ANCESTRYS_lock_row';
1014: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1015: l_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;
1016: lc_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;
1017: l_row_notfound BOOLEAN := FALSE;
1018: lc_row_notfound BOOLEAN := FALSE;
1019: BEGIN

Line 1016: lc_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;

1012: l_api_version CONSTANT NUMBER := 1;
1013: l_api_name CONSTANT VARCHAR2(30) := 'ANCESTRYS_lock_row';
1014: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1015: l_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;
1016: lc_object_version_number OKC_ANCESTRYS.OBJECT_VERSION_NUMBER%TYPE;
1017: l_row_notfound BOOLEAN := FALSE;
1018: lc_row_notfound BOOLEAN := FALSE;
1019: BEGIN
1020: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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 1255: -- update_row for:OKC_ANCESTRYS --

1251: ---------------------------------------------------------------------------
1252: -- PROCEDURE update_row
1253: ---------------------------------------------------------------------------
1254: ----------------------------------
1255: -- update_row for:OKC_ANCESTRYS --
1256: ----------------------------------
1257: PROCEDURE update_row(
1258: p_init_msg_list IN VARCHAR2 ,
1259: x_return_status OUT NOCOPY VARCHAR2,

Line 1327: -- Set_Attributes for:OKC_ANCESTRYS --

1323: END IF;
1324: RETURN(l_return_status);
1325: END populate_new_record;
1326: --------------------------------------
1327: -- Set_Attributes for:OKC_ANCESTRYS --
1328: --------------------------------------
1329: FUNCTION Set_Attributes (
1330: p_acy_rec IN acy_rec_type,
1331: x_acy_rec OUT NOCOPY acy_rec_type

Line 1364: UPDATE OKC_ANCESTRYS

1360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1362: RAISE OKC_API.G_EXCEPTION_ERROR;
1363: END IF;
1364: UPDATE OKC_ANCESTRYS
1365: SET OBJECT_VERSION_NUMBER = l_def_acy_rec.object_version_number,
1366: LEVEL_SEQUENCE = l_def_acy_rec.level_sequence,
1367: CREATED_BY = l_def_acy_rec.created_by,
1368: CREATION_DATE = l_def_acy_rec.creation_date,

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 1691: -- delete_row for:OKC_ANCESTRYS --

1687: ---------------------------------------------------------------------------
1688: -- PROCEDURE delete_row
1689: ---------------------------------------------------------------------------
1690: ----------------------------------
1691: -- delete_row for:OKC_ANCESTRYS --
1692: ----------------------------------
1693: PROCEDURE delete_row(
1694: p_init_msg_list IN VARCHAR2 ,
1695: x_return_status OUT NOCOPY VARCHAR2,

Line 1715: DELETE FROM OKC_ANCESTRYS

1711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1713: RAISE OKC_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: DELETE FROM OKC_ANCESTRYS
1716: WHERE CLE_ID = l_acy_rec.cle_id AND
1717: CLE_ID_ASCENDANT = l_acy_rec.cle_id_ascendant;
1718:
1719: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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 ,