APPS.CZ_UI_MGR dependencies on CZ_UI_DEFS

Line 57: Type UI_type is table of CZ_UI_DEFS.ui_def_id%TYPE;

53: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
54:
55: procedure Propogate_DeletedFlag is
56:
57: Type UI_type is table of CZ_UI_DEFS.ui_def_id%TYPE;
58: UIs UI_type;
59: v_ui integer;
60:
61: begin

Line 80: from CZ_UI_DEFS where (devl_project_id in(select devl_project_id from cz_devl_projects where

76: end loop;
77: end loop;
78:
79: select ui_def_id bulk collect into UIs
80: from CZ_UI_DEFS where (devl_project_id in(select devl_project_id from cz_devl_projects where
81: deleted_flag='1' and devl_project_id<>0) or deleted_flag='1') and NVL(seeded_flag,'0')='0' and ui_def_id<>0;
82:
83: if UIs.Count>0 then
84: for i in UIs.First..UIs.Last

Line 88: update cz_ui_defs

84: for i in UIs.First..UIs.Last
85: loop
86: v_ui:=UIs(i);
87:
88: update cz_ui_defs
89: set deleted_flag='1' where ui_def_id=v_ui;
90: commit;
91:
92: update cz_ui_properties