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.CZ_MODELOPERATIONS_PUB dependencies on CZ_RP_ENTRIES

Line 30: FROM cz_rp_entries

26:
27: BEGIN
28: SELECT 1
29: INTO l_found
30: FROM cz_rp_entries
31: WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';
32: EXCEPTION
33: WHEN NO_DATA_FOUND THEN
34: RAISE NOT_VALID_PROJECT_ID;

Line 131: FROM cz_rp_entries

127:
128: BEGIN
129: SELECT 1
130: INTO l_found
131: FROM cz_rp_entries
132: WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: RAISE NOT_VALID_PROJECT_ID;

Line 355: FROM cz_rp_entries

351:
352: BEGIN
353: SELECT 1
354: INTO l_found
355: FROM cz_rp_entries
356: WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';
357: EXCEPTION
358: WHEN NO_DATA_FOUND THEN
359: RAISE NOT_VALID_PROJECT_ID;

Line 481: FROM cz_rp_entries rp, cz_ui_defs uidef

477:
478: BEGIN
479: SELECT 1
480: INTO l_found
481: FROM cz_rp_entries rp, cz_ui_defs uidef
482: WHERE object_type = 'PRJ' AND object_id = devl_project_id AND ui_def_id = p_ui_def_id
483: AND rp.deleted_flag = '0' AND uidef.deleted_flag = '0';
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN

Line 875: FROM cz_rp_entries

871: -- verify p_devl_project_id
872: BEGIN
873: SELECT 1
874: INTO l_found
875: FROM cz_rp_entries
876: WHERE object_type = 'PRJ'
877: AND object_id = p_devl_project_id
878: AND deleted_flag = '0';
879: EXCEPTION

Line 1110: FROM cz_rp_entries

1106:
1107: BEGIN
1108: SELECT 1
1109: INTO l_found
1110: FROM cz_rp_entries
1111: WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';
1112: EXCEPTION
1113: WHEN NO_DATA_FOUND THEN
1114: RAISE NOT_VALID_PROJECT_ID;

Line 1283: FROM cz_rp_entries

1279:
1280: BEGIN
1281: SELECT 1
1282: INTO l_found
1283: FROM cz_rp_entries
1284: WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';
1285: EXCEPTION
1286: WHEN NO_DATA_FOUND THEN
1287: RAISE NOT_VALID_PROJECT_ID;

Line 1426: FROM cz_rp_entries

1422:
1423: -- cursor to check the enclosing folder when it is not null
1424: CURSOR encl_folder_exits_csr IS
1425: SELECT 'X'
1426: FROM cz_rp_entries
1427: WHERE object_id = p_encl_folder_id
1428: AND object_type = 'FLD'
1429: AND deleted_flag = '0';
1430:

Line 1434: FROM cz_rp_entries

1430:
1431: -- cursor to check the folder when encl folder is not null
1432: CURSOR folder_exists_in_encl_csr IS
1433: SELECT 'X'
1434: FROM cz_rp_entries
1435: WHERE object_id = p_rp_folder_id
1436: AND enclosing_folder = p_encl_folder_id
1437: AND object_type = 'FLD'
1438: AND deleted_flag = '0';

Line 1443: FROM cz_rp_entries

1439:
1440: -- cursor to check the folder when enclosing folder is null
1441: CURSOR folder_exists_csr IS
1442: SELECT 'X'
1443: FROM cz_rp_entries
1444: WHERE object_id = p_rp_folder_id
1445: AND object_type = 'FLD'
1446: AND deleted_flag = '0';
1447:

Line 1513: ,p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE

1509: );
1510: END rp_folder_exists;
1511: ---------------------------------------------------------
1512: PROCEDURE create_rp_folder(p_api_version IN NUMBER
1513: ,p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE
1514: ,p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE
1515: ,p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE
1516: ,p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE
1517: ,x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE

Line 1514: ,p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE

1510: END rp_folder_exists;
1511: ---------------------------------------------------------
1512: PROCEDURE create_rp_folder(p_api_version IN NUMBER
1513: ,p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE
1514: ,p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE
1515: ,p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE
1516: ,p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE
1517: ,x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE
1518: ,x_return_status OUT NOCOPY VARCHAR2

Line 1515: ,p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE

1511: ---------------------------------------------------------
1512: PROCEDURE create_rp_folder(p_api_version IN NUMBER
1513: ,p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE
1514: ,p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE
1515: ,p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE
1516: ,p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE
1517: ,x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE
1518: ,x_return_status OUT NOCOPY VARCHAR2
1519: ,x_msg_count OUT NOCOPY NUMBER

Line 1516: ,p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE

1512: PROCEDURE create_rp_folder(p_api_version IN NUMBER
1513: ,p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE
1514: ,p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE
1515: ,p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE
1516: ,p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE
1517: ,x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE
1518: ,x_return_status OUT NOCOPY VARCHAR2
1519: ,x_msg_count OUT NOCOPY NUMBER
1520: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1517: ,x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE

1513: ,p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE
1514: ,p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE
1515: ,p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE
1516: ,p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE
1517: ,x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE
1518: ,x_return_status OUT NOCOPY VARCHAR2
1519: ,x_msg_count OUT NOCOPY NUMBER
1520: ,x_msg_data OUT NOCOPY VARCHAR2
1521: )

Line 1527: l_new_object_id CZ_RP_ENTRIES.OBJECT_ID%TYPE;

1523:
1524: l_api_version CONSTANT NUMBER := 1.0;
1525: l_api_name CONSTANT VARCHAR2(30) := 'create_rp_folder';
1526:
1527: l_new_object_id CZ_RP_ENTRIES.OBJECT_ID%TYPE;
1528: l_dummy_nbr NUMBER;
1529: l_count NUMBER;
1530:
1531: BEGIN

Line 1543: FROM cz_rp_entries

1539: END IF;
1540:
1541: BEGIN -- validate the encl_folder_id
1542: SELECT 1 INTO l_dummy_nbr
1543: FROM cz_rp_entries
1544: WHERE object_id = p_encl_folder_id
1545: AND object_type = 'FLD'
1546: AND deleted_flag = '0';
1547: EXCEPTION

Line 1555: FROM cz_rp_entries

1551: END;
1552:
1553: BEGIN -- check if folder already exists, if so return its id
1554: SELECT object_id INTO x_new_folder_id
1555: FROM cz_rp_entries
1556: WHERE name = p_new_folder_name
1557: AND enclosing_folder = p_encl_folder_id
1558: AND object_type = 'FLD'
1559: AND deleted_flag = '0';

Line 1564: SELECT cz_rp_entries_s.NEXTVAL

1560:
1561: EXCEPTION -- it doesn't exists, so create it
1562: WHEN NO_DATA_FOUND THEN
1563:
1564: SELECT cz_rp_entries_s.NEXTVAL
1565: INTO l_new_object_id
1566: FROM DUAL;
1567:
1568: INSERT INTO cz_rp_entries

Line 1568: INSERT INTO cz_rp_entries

1564: SELECT cz_rp_entries_s.NEXTVAL
1565: INTO l_new_object_id
1566: FROM DUAL;
1567:
1568: INSERT INTO cz_rp_entries
1569: (object_id
1570: ,name
1571: ,object_type
1572: ,enclosing_folder

Line 1608: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,

1604: END create_rp_folder;
1605: ---------------------------------------------------------
1606: PROCEDURE create_rp_folder (
1607: p_api_version IN NUMBER,
1608: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1609: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,
1610: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,
1611: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1612: p_user_id IN NUMBER,

Line 1609: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,

1605: ---------------------------------------------------------
1606: PROCEDURE create_rp_folder (
1607: p_api_version IN NUMBER,
1608: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1609: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,
1610: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,
1611: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1612: p_user_id IN NUMBER,
1613: p_resp_id IN NUMBER,

Line 1610: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,

1606: PROCEDURE create_rp_folder (
1607: p_api_version IN NUMBER,
1608: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1609: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,
1610: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,
1611: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1612: p_user_id IN NUMBER,
1613: p_resp_id IN NUMBER,
1614: p_appl_id IN NUMBER,

Line 1611: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,

1607: p_api_version IN NUMBER,
1608: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1609: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,
1610: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,
1611: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1612: p_user_id IN NUMBER,
1613: p_resp_id IN NUMBER,
1614: p_appl_id IN NUMBER,
1615: x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE,

Line 1615: x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE,

1611: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1612: p_user_id IN NUMBER,
1613: p_resp_id IN NUMBER,
1614: p_appl_id IN NUMBER,
1615: x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1616: x_return_status OUT NOCOPY VARCHAR2,
1617: x_msg_count OUT NOCOPY NUMBER,
1618: x_msg_data OUT NOCOPY VARCHAR2
1619: ) IS

Line 1697: FROM cz_rp_entries

1693: END IF;
1694:
1695: BEGIN -- validate the encl_folder_id
1696: SELECT 1 INTO l_dummy_nbr
1697: FROM cz_rp_entries
1698: WHERE object_id = p_rp_folder_id
1699: AND object_type = 'FLD'
1700: AND deleted_flag = '0';
1701: EXCEPTION