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 879: FROM cz_rp_entries

875: -- verify p_devl_project_id
876: BEGIN
877: SELECT 1
878: INTO l_found
879: FROM cz_rp_entries
880: WHERE object_type = 'PRJ'
881: AND object_id = p_devl_project_id
882: AND deleted_flag = '0';
883: EXCEPTION

Line 1114: FROM cz_rp_entries

1110:
1111: BEGIN
1112: SELECT 1
1113: INTO l_found
1114: FROM cz_rp_entries
1115: WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';
1116: EXCEPTION
1117: WHEN NO_DATA_FOUND THEN
1118: RAISE NOT_VALID_PROJECT_ID;

Line 1287: FROM cz_rp_entries

1283:
1284: BEGIN
1285: SELECT 1
1286: INTO l_found
1287: FROM cz_rp_entries
1288: WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';
1289: EXCEPTION
1290: WHEN NO_DATA_FOUND THEN
1291: RAISE NOT_VALID_PROJECT_ID;

Line 1430: FROM cz_rp_entries

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

Line 1438: FROM cz_rp_entries

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

Line 1447: FROM cz_rp_entries

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

Line 1517: ,p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE

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

Line 1518: ,p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE

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

Line 1519: ,p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE

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

Line 1520: ,p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE

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

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

1517: ,p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE
1518: ,p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE
1519: ,p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE
1520: ,p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE
1521: ,x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE
1522: ,x_return_status OUT NOCOPY VARCHAR2
1523: ,x_msg_count OUT NOCOPY NUMBER
1524: ,x_msg_data OUT NOCOPY VARCHAR2
1525: )

Line 1531: l_new_object_id CZ_RP_ENTRIES.OBJECT_ID%TYPE;

1527:
1528: l_api_version CONSTANT NUMBER := 1.0;
1529: l_api_name CONSTANT VARCHAR2(30) := 'create_rp_folder';
1530:
1531: l_new_object_id CZ_RP_ENTRIES.OBJECT_ID%TYPE;
1532: l_dummy_nbr NUMBER;
1533: l_count NUMBER;
1534:
1535: BEGIN

Line 1547: FROM cz_rp_entries

1543: END IF;
1544:
1545: BEGIN -- validate the encl_folder_id
1546: SELECT 1 INTO l_dummy_nbr
1547: FROM cz_rp_entries
1548: WHERE object_id = p_encl_folder_id
1549: AND object_type = 'FLD'
1550: AND deleted_flag = '0';
1551: EXCEPTION

Line 1559: FROM cz_rp_entries

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

Line 1568: SELECT cz_rp_entries_s.NEXTVAL

1564:
1565: EXCEPTION -- it doesn't exists, so create it
1566: WHEN NO_DATA_FOUND THEN
1567:
1568: SELECT cz_rp_entries_s.NEXTVAL
1569: INTO l_new_object_id
1570: FROM DUAL;
1571:
1572: INSERT INTO cz_rp_entries

Line 1572: INSERT INTO cz_rp_entries

1568: SELECT cz_rp_entries_s.NEXTVAL
1569: INTO l_new_object_id
1570: FROM DUAL;
1571:
1572: INSERT INTO cz_rp_entries
1573: (object_id
1574: ,name
1575: ,object_type
1576: ,enclosing_folder

Line 1612: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,

1608: END create_rp_folder;
1609: ---------------------------------------------------------
1610: PROCEDURE create_rp_folder (
1611: p_api_version IN NUMBER,
1612: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1613: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,
1614: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,
1615: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1616: p_user_id IN NUMBER,

Line 1613: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,

1609: ---------------------------------------------------------
1610: PROCEDURE create_rp_folder (
1611: p_api_version IN NUMBER,
1612: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1613: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,
1614: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,
1615: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1616: p_user_id IN NUMBER,
1617: p_resp_id IN NUMBER,

Line 1614: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,

1610: PROCEDURE create_rp_folder (
1611: p_api_version IN NUMBER,
1612: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1613: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,
1614: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,
1615: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1616: p_user_id IN NUMBER,
1617: p_resp_id IN NUMBER,
1618: p_appl_id IN NUMBER,

Line 1615: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,

1611: p_api_version IN NUMBER,
1612: p_encl_folder_id IN CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1613: p_new_folder_name IN CZ_RP_ENTRIES.NAME%TYPE,
1614: p_folder_desc IN CZ_RP_ENTRIES.DESCRIPTION%TYPE,
1615: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1616: p_user_id IN NUMBER,
1617: p_resp_id IN NUMBER,
1618: p_appl_id IN NUMBER,
1619: x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE,

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

1615: p_folder_notes IN CZ_RP_ENTRIES.NOTES%TYPE,
1616: p_user_id IN NUMBER,
1617: p_resp_id IN NUMBER,
1618: p_appl_id IN NUMBER,
1619: x_new_folder_id OUT NOCOPY CZ_RP_ENTRIES.OBJECT_ID%TYPE,
1620: x_return_status OUT NOCOPY VARCHAR2,
1621: x_msg_count OUT NOCOPY NUMBER,
1622: x_msg_data OUT NOCOPY VARCHAR2
1623: ) IS

Line 1701: FROM cz_rp_entries

1697: END IF;
1698:
1699: BEGIN -- validate the encl_folder_id
1700: SELECT 1 INTO l_dummy_nbr
1701: FROM cz_rp_entries
1702: WHERE object_id = p_rp_folder_id
1703: AND object_type = 'FLD'
1704: AND deleted_flag = '0';
1705: EXCEPTION