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:
68: model_found NUMBER := 0;
69:
70: x_error BOOLEAN:=FALSE;

Line 91: FROM cz_model_ref_expls

87: /* Get all published models, along with the child models that need to exist (undeleted models) */
88: SELECT distinct component_id
89: BULK COLLECT
90: INTO requiredModelTbl
91: FROM cz_model_ref_expls
92: WHERE deleted_flag = '0'
93: AND model_id IN (SELECT model_id FROM cz_model_publications
94: WHERE source_target_flag = 'T'
95: AND deleted_flag = '0')