[Home] [Help]
63:
64: deletedPublsTbl tPublTable;
65: delPublsTbl tPublTable;
66: deletedPubl CZ_MODEL_REF_EXPLS.COMPONENT_ID%TYPE;
67: deletedPKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;
68: vModelKeyStr CZ_DB_LOGS.MESSAGE%TYPE:=NULL;
69:
70: model_found NUMBER := 0;
71:
74:
75: /* All deleted publications*/
76: --Bug12653412: SKM - Adding an additional condition in order to run
77: --publication and purge at the same time. During publication we first create the
78: --records in cz_devl_projects and at much latter stage to cz_model_ref_expls.
79: --So, excluding such records not to be purge candidates.
80:
81: --Bug#12653412: Additional condition added for the models with on-going
82: --publications are marked as published date not null. DO NOT select such models.
82: --publications are marked as published date not null. DO NOT select such models.
83:
84: CURSOR cDeletedPublication IS
85: SELECT devl_project_id, NVL(product_key,name)
86: FROM cz_devl_projects
87: WHERE deleted_flag = '0'
88: AND published IS NULL
89: AND EXISTS (SELECT null FROM cz_model_ref_expls
90: WHERE model_id=cz_devl_projects.devl_project_id
86: FROM cz_devl_projects
87: WHERE deleted_flag = '0'
88: AND published IS NULL
89: AND EXISTS (SELECT null FROM cz_model_ref_expls
90: WHERE model_id=cz_devl_projects.devl_project_id
91: AND deleted_flag='0')
92: AND devl_project_id NOT IN (SELECT object_id FROM cz_rp_entries
93: WHERE object_type = 'PRJ'
94: AND deleted_flag = '0');
128:
129: IF (NOT (hashRequiredModels.EXISTS(deletedPubl))) THEN
130: BEGIN
131: /* Logically delete model */
132: UPDATE cz_devl_projects
133: SET deleted_flag = '1'
134: WHERE devl_project_id = deletedPubl
135: AND published IS NULL; /* Extra condition for over precaution*/
136: