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_SECURITY_PVT dependencies on CZ_UI_DEFS

Line 736: l_ui_style cz_ui_defs.ui_style%TYPE;

732: x_locked_entities OUT NOCOPY number_type_tbl)
733: IS
734:
735: rec_count NUMBER := 0;
736: l_ui_style cz_ui_defs.ui_style%TYPE;
737: l_devl_project_id cz_ui_defs.devl_project_id%TYPE;
738: l_cz_ui_defs_id_tbl number_type_tbl;
739: l_cz_ui_defs_style_tbl varchar_type_tbl;
740:

Line 737: l_devl_project_id cz_ui_defs.devl_project_id%TYPE;

733: IS
734:
735: rec_count NUMBER := 0;
736: l_ui_style cz_ui_defs.ui_style%TYPE;
737: l_devl_project_id cz_ui_defs.devl_project_id%TYPE;
738: l_cz_ui_defs_id_tbl number_type_tbl;
739: l_cz_ui_defs_style_tbl varchar_type_tbl;
740:
741: BEGIN

Line 738: l_cz_ui_defs_id_tbl number_type_tbl;

734:
735: rec_count NUMBER := 0;
736: l_ui_style cz_ui_defs.ui_style%TYPE;
737: l_devl_project_id cz_ui_defs.devl_project_id%TYPE;
738: l_cz_ui_defs_id_tbl number_type_tbl;
739: l_cz_ui_defs_style_tbl varchar_type_tbl;
740:
741: BEGIN
742: IF (p_entity_type = cz_security_pvt.MODEL) THEN

Line 739: l_cz_ui_defs_style_tbl varchar_type_tbl;

735: rec_count NUMBER := 0;
736: l_ui_style cz_ui_defs.ui_style%TYPE;
737: l_devl_project_id cz_ui_defs.devl_project_id%TYPE;
738: l_cz_ui_defs_id_tbl number_type_tbl;
739: l_cz_ui_defs_style_tbl varchar_type_tbl;
740:
741: BEGIN
742: IF (p_entity_type = cz_security_pvt.MODEL) THEN
743: -----get all model entities to lock

Line 767: FROM cz_ui_defs

763: -----get UI style
764: BEGIN
765: SELECT ui_style
766: INTO l_ui_style
767: FROM cz_ui_defs
768: WHERE cz_ui_defs.devl_project_id = p_entity_id
769: AND cz_ui_defs.deleted_flag = '0';
770: EXCEPTION
771: WHEN NO_DATA_FOUND THEN

Line 768: WHERE cz_ui_defs.devl_project_id = p_entity_id

764: BEGIN
765: SELECT ui_style
766: INTO l_ui_style
767: FROM cz_ui_defs
768: WHERE cz_ui_defs.devl_project_id = p_entity_id
769: AND cz_ui_defs.deleted_flag = '0';
770: EXCEPTION
771: WHEN NO_DATA_FOUND THEN
772: NULL;

Line 769: AND cz_ui_defs.deleted_flag = '0';

765: SELECT ui_style
766: INTO l_ui_style
767: FROM cz_ui_defs
768: WHERE cz_ui_defs.devl_project_id = p_entity_id
769: AND cz_ui_defs.deleted_flag = '0';
770: EXCEPTION
771: WHEN NO_DATA_FOUND THEN
772: NULL;
773: END;

Line 805: FROM cz_ui_defs

801: FROM cz_ui_refs
802: WHERE cz_ui_refs.ui_def_id = p_entity_id
803: AND cz_ui_refs.deleted_flag = '0'
804: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
805: FROM cz_ui_defs
806: WHERE cz_ui_defs.deleted_flag = '0'
807: AND cz_ui_defs.ui_style = '7');
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN

Line 806: WHERE cz_ui_defs.deleted_flag = '0'

802: WHERE cz_ui_refs.ui_def_id = p_entity_id
803: AND cz_ui_refs.deleted_flag = '0'
804: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
805: FROM cz_ui_defs
806: WHERE cz_ui_defs.deleted_flag = '0'
807: AND cz_ui_defs.ui_style = '7');
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
810: NULL;

Line 807: AND cz_ui_defs.ui_style = '7');

803: AND cz_ui_refs.deleted_flag = '0'
804: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
805: FROM cz_ui_defs
806: WHERE cz_ui_defs.deleted_flag = '0'
807: AND cz_ui_defs.ui_style = '7');
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
810: NULL;
811: END;

Line 846: l_ui_style cz_ui_defs.ui_style%TYPE;

842: x_checkout_user_tbl OUT NOCOPY varchar_type_tbl)
843: IS
844:
845: rec_count NUMBER := 0;
846: l_ui_style cz_ui_defs.ui_style%TYPE;
847: l_locked_entities number_type_tbl;
848: l_checkout_user_tbl varchar_type_tbl;
849:
850: BEGIN

Line 890: FROM cz_ui_defs

886:
887: -----get UI style
888: SELECT ui_style
889: INTO l_ui_style
890: FROM cz_ui_defs
891: WHERE cz_ui_defs.ui_def_id = p_entity_id
892: AND cz_ui_defs.deleted_flag = '0';
893:
894: -----get all UI entities to lock

Line 891: WHERE cz_ui_defs.ui_def_id = p_entity_id

887: -----get UI style
888: SELECT ui_style
889: INTO l_ui_style
890: FROM cz_ui_defs
891: WHERE cz_ui_defs.ui_def_id = p_entity_id
892: AND cz_ui_defs.deleted_flag = '0';
893:
894: -----get all UI entities to lock
895: IF (l_ui_style IN ('0','3') ) THEN

Line 892: AND cz_ui_defs.deleted_flag = '0';

888: SELECT ui_style
889: INTO l_ui_style
890: FROM cz_ui_defs
891: WHERE cz_ui_defs.ui_def_id = p_entity_id
892: AND cz_ui_defs.deleted_flag = '0';
893:
894: -----get all UI entities to lock
895: IF (l_ui_style IN ('0','3') ) THEN
896:

Line 913: FROM cz_ui_defs

909: SELECT checkout_user
910: BULK
911: COLLECT
912: INTO l_checkout_user_tbl
913: FROM cz_ui_defs
914: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)
915: AND cz_ui_defs.deleted_flag = '0'
916: AND cz_ui_defs.checkout_user IS NOT NULL;
917:

Line 914: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)

910: BULK
911: COLLECT
912: INTO l_checkout_user_tbl
913: FROM cz_ui_defs
914: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)
915: AND cz_ui_defs.deleted_flag = '0'
916: AND cz_ui_defs.checkout_user IS NOT NULL;
917:
918: IF (l_checkout_user_tbl.COUNT > 0) THEN

Line 915: AND cz_ui_defs.deleted_flag = '0'

911: COLLECT
912: INTO l_checkout_user_tbl
913: FROM cz_ui_defs
914: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)
915: AND cz_ui_defs.deleted_flag = '0'
916: AND cz_ui_defs.checkout_user IS NOT NULL;
917:
918: IF (l_checkout_user_tbl.COUNT > 0) THEN
919: rec_count := x_locked_entities.COUNT + 1;

Line 916: AND cz_ui_defs.checkout_user IS NOT NULL;

912: INTO l_checkout_user_tbl
913: FROM cz_ui_defs
914: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)
915: AND cz_ui_defs.deleted_flag = '0'
916: AND cz_ui_defs.checkout_user IS NOT NULL;
917:
918: IF (l_checkout_user_tbl.COUNT > 0) THEN
919: rec_count := x_locked_entities.COUNT + 1;
920: x_locked_entities(rec_count) := l_locked_entities(j);

Line 936: FROM cz_ui_defs x

932: FROM cz_ui_refs
933: WHERE cz_ui_refs.ui_def_id = p_entity_id
934: AND cz_ui_refs.deleted_flag = '0'
935: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
936: FROM cz_ui_defs x
937: WHERE x.deleted_flag = '0'
938: AND x.checkout_user IS NOT NULL
939: AND x.ui_style = '7');
940:

Line 948: FROM cz_ui_defs

944: SELECT checkout_user
945: BULK
946: COLLECT
947: INTO l_checkout_user_tbl
948: FROM cz_ui_defs
949: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)
950: AND cz_ui_defs.deleted_flag = '0'
951: AND cz_ui_defs.checkout_user IS NOT NULL;
952:

Line 949: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)

945: BULK
946: COLLECT
947: INTO l_checkout_user_tbl
948: FROM cz_ui_defs
949: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)
950: AND cz_ui_defs.deleted_flag = '0'
951: AND cz_ui_defs.checkout_user IS NOT NULL;
952:
953: IF (l_checkout_user_tbl.COUNT > 0) THEN

Line 950: AND cz_ui_defs.deleted_flag = '0'

946: COLLECT
947: INTO l_checkout_user_tbl
948: FROM cz_ui_defs
949: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)
950: AND cz_ui_defs.deleted_flag = '0'
951: AND cz_ui_defs.checkout_user IS NOT NULL;
952:
953: IF (l_checkout_user_tbl.COUNT > 0) THEN
954: rec_count := x_locked_entities.COUNT + 1;

Line 951: AND cz_ui_defs.checkout_user IS NOT NULL;

947: INTO l_checkout_user_tbl
948: FROM cz_ui_defs
949: WHERE cz_ui_defs.ui_def_id = l_locked_entities(j)
950: AND cz_ui_defs.deleted_flag = '0'
951: AND cz_ui_defs.checkout_user IS NOT NULL;
952:
953: IF (l_checkout_user_tbl.COUNT > 0) THEN
954: rec_count := x_locked_entities.COUNT + 1;
955: x_locked_entities(rec_count) := l_locked_entities(j);

Line 1000: l_table_name := 'cz_ui_defs';

996: l_table_name := 'cz_devl_projects';
997: l_primary_key_name := 'devl_project_id';
998: l_entity := 2;
999: ELSIF (p_entity_type = cz_security_pvt.UI) THEN
1000: l_table_name := 'cz_ui_defs';
1001: l_primary_key_name := 'ui_def_id';
1002: l_entity := 3;
1003: ELSIF (p_entity_type = cz_security_pvt.RULEFOLDER) THEN
1004: l_table_name := 'cz_rule_folders';

Line 1520: FROM cz_ui_defs

1516: IF (p_entity = cz_security_pvt.MODEL) THEN
1517: l_proj_id := p_entity_id;
1518: ELSIF (p_entity = cz_security_pvt.UI) THEN
1519: SELECT devl_project_id INTO l_proj_id
1520: FROM cz_ui_defs
1521: WHERE ui_def_id = p_entity_id
1522: AND deleted_flag = '0';
1523: ELSIF (p_entity = cz_security_pvt.RULEFOLDER) THEN
1524: begin

Line 1768: FROM cz_ui_defs

1764: END IF;
1765:
1766: SELECT checkout_user
1767: INTO l_checkout_user
1768: FROM cz_ui_defs
1769: WHERE cz_ui_defs.ui_def_id = p_ui_def_id
1770: AND cz_ui_defs.deleted_flag = '0';
1771:
1772: IF (l_checkout_user IS NULL) THEN

Line 1769: WHERE cz_ui_defs.ui_def_id = p_ui_def_id

1765:
1766: SELECT checkout_user
1767: INTO l_checkout_user
1768: FROM cz_ui_defs
1769: WHERE cz_ui_defs.ui_def_id = p_ui_def_id
1770: AND cz_ui_defs.deleted_flag = '0';
1771:
1772: IF (l_checkout_user IS NULL) THEN
1773: l_status := '0';

Line 1770: AND cz_ui_defs.deleted_flag = '0';

1766: SELECT checkout_user
1767: INTO l_checkout_user
1768: FROM cz_ui_defs
1769: WHERE cz_ui_defs.ui_def_id = p_ui_def_id
1770: AND cz_ui_defs.deleted_flag = '0';
1771:
1772: IF (l_checkout_user IS NULL) THEN
1773: l_status := '0';
1774: ELSIF (l_checkout_user = FND_GLOBAL.user_name) THEN

Line 1829: FROM cz_ui_defs

1825: l_ret_status := 'T';
1826: BEGIN
1827: SELECT checkout_user
1828: INTO l_checkout_user
1829: FROM cz_ui_defs
1830: WHERE ui_def_id = p_ui_def_id ;
1831: EXCEPTION
1832: WHEN NO_DATA_FOUND THEN
1833: l_checkout_user := NULL;

Line 1837: UPDATE cz_ui_defs

1833: l_checkout_user := NULL;
1834: END;
1835:
1836: IF (l_checkout_user IS NULL) THEN
1837: UPDATE cz_ui_defs
1838: SET checkout_user = FND_GLOBAL.user_name
1839: WHERE ui_def_id = p_ui_def_id ;
1840: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_UI_EVENT',
1841: 'LOCKEDBY',FND_GLOBAL.user_name,'LOCKDATE',to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'));

Line 1870: FROM cz_ui_defs

1866:
1867: BEGIN
1868: SELECT checkout_user
1869: INTO l_checkout_user
1870: FROM cz_ui_defs
1871: WHERE ui_def_id = p_ui_def_id ;
1872: EXCEPTION
1873: WHEN NO_DATA_FOUND THEN
1874: l_checkout_user := NULL;

Line 1878: UPDATE cz_ui_defs

1874: l_checkout_user := NULL;
1875: END;
1876:
1877: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user = FND_GLOBAL.user_name) ) THEN
1878: UPDATE cz_ui_defs
1879: SET checkout_user = NULL
1880: WHERE ui_def_id = p_ui_def_id ;
1881: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_UNLOCK_UI_EVENT',
1882: 'UNLOCKEDBY',FND_GLOBAL.user_name,'UNLOCKDATE',to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'));

Line 2318: FROM cz_ui_defs

2314: SELECT ui_def_id
2315: BULK
2316: COLLECT
2317: INTO l_ui_tbl
2318: FROM cz_ui_defs
2319: WHERE cz_ui_defs.devl_project_id = p_model_id
2320: AND cz_ui_defs.deleted_flag = '0'
2321: AND cz_ui_defs.checkout_user IS NOT NULL;
2322: EXCEPTION

Line 2319: WHERE cz_ui_defs.devl_project_id = p_model_id

2315: BULK
2316: COLLECT
2317: INTO l_ui_tbl
2318: FROM cz_ui_defs
2319: WHERE cz_ui_defs.devl_project_id = p_model_id
2320: AND cz_ui_defs.deleted_flag = '0'
2321: AND cz_ui_defs.checkout_user IS NOT NULL;
2322: EXCEPTION
2323: WHEN NO_DATA_FOUND THEN

Line 2320: AND cz_ui_defs.deleted_flag = '0'

2316: COLLECT
2317: INTO l_ui_tbl
2318: FROM cz_ui_defs
2319: WHERE cz_ui_defs.devl_project_id = p_model_id
2320: AND cz_ui_defs.deleted_flag = '0'
2321: AND cz_ui_defs.checkout_user IS NOT NULL;
2322: EXCEPTION
2323: WHEN NO_DATA_FOUND THEN
2324: NULL;

Line 2321: AND cz_ui_defs.checkout_user IS NOT NULL;

2317: INTO l_ui_tbl
2318: FROM cz_ui_defs
2319: WHERE cz_ui_defs.devl_project_id = p_model_id
2320: AND cz_ui_defs.deleted_flag = '0'
2321: AND cz_ui_defs.checkout_user IS NOT NULL;
2322: EXCEPTION
2323: WHEN NO_DATA_FOUND THEN
2324: NULL;
2325: END;

Line 2378: FROM cz_ui_defs

2374: SELECT ui_def_id,checkout_user
2375: BULK
2376: COLLECT
2377: INTO l_ui_tbl,l_ui_checkout_tbl
2378: FROM cz_ui_defs
2379: WHERE cz_ui_defs.devl_project_id = p_model_id
2380: AND cz_ui_defs.deleted_flag = '0'
2381: AND cz_ui_defs.checkout_user IS NOT NULL;
2382: EXCEPTION

Line 2379: WHERE cz_ui_defs.devl_project_id = p_model_id

2375: BULK
2376: COLLECT
2377: INTO l_ui_tbl,l_ui_checkout_tbl
2378: FROM cz_ui_defs
2379: WHERE cz_ui_defs.devl_project_id = p_model_id
2380: AND cz_ui_defs.deleted_flag = '0'
2381: AND cz_ui_defs.checkout_user IS NOT NULL;
2382: EXCEPTION
2383: WHEN NO_DATA_FOUND THEN

Line 2380: AND cz_ui_defs.deleted_flag = '0'

2376: COLLECT
2377: INTO l_ui_tbl,l_ui_checkout_tbl
2378: FROM cz_ui_defs
2379: WHERE cz_ui_defs.devl_project_id = p_model_id
2380: AND cz_ui_defs.deleted_flag = '0'
2381: AND cz_ui_defs.checkout_user IS NOT NULL;
2382: EXCEPTION
2383: WHEN NO_DATA_FOUND THEN
2384: NULL;

Line 2381: AND cz_ui_defs.checkout_user IS NOT NULL;

2377: INTO l_ui_tbl,l_ui_checkout_tbl
2378: FROM cz_ui_defs
2379: WHERE cz_ui_defs.devl_project_id = p_model_id
2380: AND cz_ui_defs.deleted_flag = '0'
2381: AND cz_ui_defs.checkout_user IS NOT NULL;
2382: EXCEPTION
2383: WHEN NO_DATA_FOUND THEN
2384: NULL;
2385: END;

Line 2485: FROM cz_ui_defs

2481: SELECT ui_def_id
2482: BULK
2483: COLLECT
2484: INTO l_ui_tbl
2485: FROM cz_ui_defs
2486: WHERE cz_ui_defs.devl_project_id = p_model_id
2487: AND cz_ui_defs.deleted_flag = '0';
2488: EXCEPTION
2489: WHEN NO_DATA_FOUND THEN

Line 2486: WHERE cz_ui_defs.devl_project_id = p_model_id

2482: BULK
2483: COLLECT
2484: INTO l_ui_tbl
2485: FROM cz_ui_defs
2486: WHERE cz_ui_defs.devl_project_id = p_model_id
2487: AND cz_ui_defs.deleted_flag = '0';
2488: EXCEPTION
2489: WHEN NO_DATA_FOUND THEN
2490: NULL;

Line 2487: AND cz_ui_defs.deleted_flag = '0';

2483: COLLECT
2484: INTO l_ui_tbl
2485: FROM cz_ui_defs
2486: WHERE cz_ui_defs.devl_project_id = p_model_id
2487: AND cz_ui_defs.deleted_flag = '0';
2488: EXCEPTION
2489: WHEN NO_DATA_FOUND THEN
2490: NULL;
2491: END;

Line 2610: SELECT devl_project_id INTO l_proj_id FROM cz_ui_defs WHERE ui_def_id = p_ui_def_id ;

2606: l_status VARCHAR2(1) := 'N';
2607: l_proj_id NUMBER;
2608: l_profile_value VARCHAR2(100);
2609: BEGIN
2610: SELECT devl_project_id INTO l_proj_id FROM cz_ui_defs WHERE ui_def_id = p_ui_def_id ;
2611: l_has_priv_status := has_privileges(1.0,FND_GLOBAL.user_name,LOCK_UI_FUNC,cz_security_pvt.UI,l_proj_id);
2612: l_is_lockable := is_ui_def_locked(p_ui_def_id);
2613: l_profile_value := FND_PROFILE.value(LOCK_MODELS_FOR_EDIT);
2614: IF (l_profile_value = 'N') THEN

Line 2689: FROM cz_ui_defs

2685: SELECT ui_def_id
2686: BULK
2687: COLLECT
2688: INTO l_ui_tbl
2689: FROM cz_ui_defs
2690: WHERE cz_ui_defs.devl_project_id = p_model_id
2691: AND cz_ui_defs.deleted_flag = '0';
2692: EXCEPTION
2693: WHEN NO_DATA_FOUND THEN

Line 2690: WHERE cz_ui_defs.devl_project_id = p_model_id

2686: BULK
2687: COLLECT
2688: INTO l_ui_tbl
2689: FROM cz_ui_defs
2690: WHERE cz_ui_defs.devl_project_id = p_model_id
2691: AND cz_ui_defs.deleted_flag = '0';
2692: EXCEPTION
2693: WHEN NO_DATA_FOUND THEN
2694: NULL;

Line 2691: AND cz_ui_defs.deleted_flag = '0';

2687: COLLECT
2688: INTO l_ui_tbl
2689: FROM cz_ui_defs
2690: WHERE cz_ui_defs.devl_project_id = p_model_id
2691: AND cz_ui_defs.deleted_flag = '0';
2692: EXCEPTION
2693: WHEN NO_DATA_FOUND THEN
2694: NULL;
2695: END;

Line 2777: FROM cz_ui_defs

2773: END IF;
2774:
2775: SELECT checkout_user
2776: INTO l_checkout_user
2777: FROM cz_ui_defs
2778: WHERE cz_ui_defs.ui_def_id = p_ui_def_id
2779: AND cz_ui_defs.deleted_flag = '0';
2780:
2781: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user <> FND_GLOBAL.user_name)) THEN

Line 2778: WHERE cz_ui_defs.ui_def_id = p_ui_def_id

2774:
2775: SELECT checkout_user
2776: INTO l_checkout_user
2777: FROM cz_ui_defs
2778: WHERE cz_ui_defs.ui_def_id = p_ui_def_id
2779: AND cz_ui_defs.deleted_flag = '0';
2780:
2781: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user <> FND_GLOBAL.user_name)) THEN
2782: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.UI,

Line 2779: AND cz_ui_defs.deleted_flag = '0';

2775: SELECT checkout_user
2776: INTO l_checkout_user
2777: FROM cz_ui_defs
2778: WHERE cz_ui_defs.ui_def_id = p_ui_def_id
2779: AND cz_ui_defs.deleted_flag = '0';
2780:
2781: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user <> FND_GLOBAL.user_name)) THEN
2782: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.UI,
2783: 'Id',p_ui_def_id,'User', l_checkout_user);