APPS.CZ_PUB_MGR dependencies on CZ_MODEL_REF_EXPLS

Line 55: TYPE tModelTable is table of cz_model_ref_expls.component_id%type index by binary_integer;

51:
52: procedure Propogate_DeletedFlag is
53:
54: TYPE tPublTable IS TABLE OF CZ_MODEL_PUBLICATIONS.PUBLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
55: TYPE tModelTable is table of cz_model_ref_expls.component_id%type index by binary_integer;
56: TYPE tModelTableIndexVC2 is table of cz_model_ref_expls.component_id%type index by VARCHAR2(15);
57:
58: /* requiredModelTbl tPublTable; */
59: requiredModelTbl tModelTable;

Line 56: TYPE tModelTableIndexVC2 is table of cz_model_ref_expls.component_id%type index by VARCHAR2(15);

52: procedure Propogate_DeletedFlag is
53:
54: TYPE tPublTable IS TABLE OF CZ_MODEL_PUBLICATIONS.PUBLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
55: TYPE tModelTable is table of cz_model_ref_expls.component_id%type index by binary_integer;
56: TYPE tModelTableIndexVC2 is table of cz_model_ref_expls.component_id%type index by VARCHAR2(15);
57:
58: /* requiredModelTbl tPublTable; */
59: requiredModelTbl tModelTable;
60:

Line 66: deletedPubl CZ_MODEL_REF_EXPLS.COMPONENT_ID%TYPE;

62: hashRequiredModels tModelTableIndexVC2;
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;

Line 78: --records in cz_devl_projects and at much latter stage to cz_model_ref_expls.

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.

Line 89: AND EXISTS (SELECT null FROM cz_model_ref_expls

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
91: AND deleted_flag='0')
92: AND devl_project_id NOT IN (SELECT object_id FROM cz_rp_entries
93: WHERE object_type = 'PRJ'

Line 105: FROM cz_model_ref_expls

101:
102: SELECT distinct component_id
103: BULK COLLECT
104: INTO requiredModelTbl
105: FROM cz_model_ref_expls
106: WHERE deleted_flag = '0'
107: AND model_id IN (SELECT model_id FROM cz_model_publications
108: WHERE source_target_flag = 'T'
109: AND deleted_flag = '0')