APPS.CZ_LOGIC_GEN dependencies on CZ_DEVL_PROJECTS

Line 103: rootProjectName cz_devl_projects.name%TYPE;

99: StopOnFatalRuleError PLS_INTEGER;
100: GenerateUpdatedOnly PLS_INTEGER;
101: StoreNlsCharacters VARCHAR2(16) := NlsNumericCharacters;
102:
103: rootProjectName cz_devl_projects.name%TYPE;
104: rootProjectType cz_devl_projects.model_type%TYPE;
105:
106: NewHeaders tIntegerArray;
107: OldHeaders tIntegerArray;

Line 104: rootProjectType cz_devl_projects.model_type%TYPE;

100: GenerateUpdatedOnly PLS_INTEGER;
101: StoreNlsCharacters VARCHAR2(16) := NlsNumericCharacters;
102:
103: rootProjectName cz_devl_projects.name%TYPE;
104: rootProjectType cz_devl_projects.model_type%TYPE;
105:
106: NewHeaders tIntegerArray;
107: OldHeaders tIntegerArray;
108: NewHeadersComponents tIntegerArray;

Line 208: ' FROM cz_devl_projects proj, cz_model_ref_expls expl, cz_lce_headers head' ||

204: FAILED_TO_LOCK_MODEL EXCEPTION;
205:
206: --bug fix 8689041 Modified the criteria to retrieve last_logic_update and logic creation_date
207: logicSQL VARCHAR2(4000) := 'SELECT proj.devl_project_id, max(proj.last_logic_update),max(head.creation_date)' ||
208: ' FROM cz_devl_projects proj, cz_model_ref_expls expl, cz_lce_headers head' ||
209: ' WHERE proj.deleted_flag = ''' || FLAG_NOT_DELETED ||
210: ''' AND expl.deleted_flag = ''' || FLAG_NOT_DELETED ||
211: ''' AND head.deleted_flag = ''' || FLAG_NOT_DELETED ||
212: ''' AND expl.node_depth = 1' ||

Line 229: ' AND (SELECT model_type FROM cz_devl_projects' ||

225: ' (SELECT model_id FROM cz_model_ref_expls' ||
226: ' WHERE deleted_flag = ''' || FLAG_NOT_DELETED || '''' ||
227: ' AND ps_node_type IN (' || PS_NODE_TYPE_REFERENCE || ', ' || PS_NODE_TYPE_CONNECTOR || ')' ||
228: ' AND component_id = :1' ||
229: ' AND (SELECT model_type FROM cz_devl_projects' ||
230: ' WHERE devl_project_id = model_id) = ''' || MODEL_TYPE_CONTAINER_MODEL || ''')';
231:
232: GENERATION_REQUIRED CONSTANT PLS_INTEGER := 1;
233: GENERATION_NOT_REQUIRED CONSTANT PLS_INTEGER := 2;

Line 350: thisProjectId cz_devl_projects.devl_project_id%TYPE;

346: v_IndexByNodeId tIntegerArray_idx_vc2;
347: v_TypeByExplId tExplNodeType;
348:
349: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
350: thisProjectId cz_devl_projects.devl_project_id%TYPE;
351: thisProjectName cz_devl_projects.name%TYPE;
352: thisProjectType cz_devl_projects.model_type%TYPE;
353: thisRootExplIndex PLS_INTEGER;
354:

Line 351: thisProjectName cz_devl_projects.name%TYPE;

347: v_TypeByExplId tExplNodeType;
348:
349: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
350: thisProjectId cz_devl_projects.devl_project_id%TYPE;
351: thisProjectName cz_devl_projects.name%TYPE;
352: thisProjectType cz_devl_projects.model_type%TYPE;
353: thisRootExplIndex PLS_INTEGER;
354:
355: nStructureHeaderId cz_lce_headers.lce_header_id%TYPE;

Line 352: thisProjectType cz_devl_projects.model_type%TYPE;

348:
349: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
350: thisProjectId cz_devl_projects.devl_project_id%TYPE;
351: thisProjectName cz_devl_projects.name%TYPE;
352: thisProjectType cz_devl_projects.model_type%TYPE;
353: thisRootExplIndex PLS_INTEGER;
354:
355: nStructureHeaderId cz_lce_headers.lce_header_id%TYPE;
356: PrevEffFrom DATE := EpochBeginDate;

Line 9846: FROM cz_devl_projects

9842:
9843: BEGIN
9844:
9845: SELECT name, model_type INTO thisProjectName, thisProjectType
9846: FROM cz_devl_projects
9847: WHERE devl_project_id = inComponentId;
9848: EXCEPTION
9849: WHEN OTHERS THEN
9850: nParam := inComponentId;

Line 11240: childModelId cz_devl_projects.devl_project_id%TYPE;

11236:
11237: c_model refCursor;
11238: childFlag PLS_INTEGER;
11239: thisFlag PLS_INTEGER := GENERATION_NOT_REQUIRED;
11240: childModelId cz_devl_projects.devl_project_id%TYPE;
11241: childLogicUpdate cz_devl_projects.last_logic_update%TYPE;
11242: childHeaderCreated cz_lce_headers.creation_date%TYPE;
11243:
11244: BEGIN

Line 11241: childLogicUpdate cz_devl_projects.last_logic_update%TYPE;

11237: c_model refCursor;
11238: childFlag PLS_INTEGER;
11239: thisFlag PLS_INTEGER := GENERATION_NOT_REQUIRED;
11240: childModelId cz_devl_projects.devl_project_id%TYPE;
11241: childLogicUpdate cz_devl_projects.last_logic_update%TYPE;
11242: childHeaderCreated cz_lce_headers.creation_date%TYPE;
11243:
11244: BEGIN
11245:

Line 11667: l_config_engine_type cz_devl_projects.config_engine_type%TYPE;

11663: PROCEDURE GENERATE_LOGIC(inDevlProjectId IN NUMBER,
11664: thisRunId IN OUT NOCOPY NUMBER)
11665: IS
11666:
11667: l_config_engine_type cz_devl_projects.config_engine_type%TYPE;
11668: l_fusion_debug VARCHAR2(240);
11669:
11670: BEGIN
11671:

Line 11675: FROM cz_devl_projects

11671:
11672: BEGIN
11673:
11674: SELECT config_engine_type INTO l_config_engine_type
11675: FROM cz_devl_projects
11676: WHERE deleted_flag = FLAG_NOT_DELETED
11677: AND devl_project_id = inDevlProjectId;
11678:
11679: EXCEPTION