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 207: ' FROM cz_devl_projects proj, cz_model_ref_expls expl, cz_lce_headers head' ||

203: l_locked_models cz_security_pvt.number_type_tbl;
204: FAILED_TO_LOCK_MODEL EXCEPTION;
205:
206: logicSQL VARCHAR2(4000) := 'SELECT proj.devl_project_id, proj.last_logic_update, head.creation_date' ||
207: ' FROM cz_devl_projects proj, cz_model_ref_expls expl, cz_lce_headers head' ||
208: ' WHERE proj.deleted_flag = ''' || FLAG_NOT_DELETED ||
209: ''' AND expl.deleted_flag = ''' || FLAG_NOT_DELETED ||
210: ''' AND head.deleted_flag = ''' || FLAG_NOT_DELETED ||
211: ''' AND expl.node_depth = 1' ||

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

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

Line 346: thisProjectId cz_devl_projects.devl_project_id%TYPE;

342: v_IndexByNodeId tIntegerArray_idx_vc2;
343: v_TypeByExplId tExplNodeType;
344:
345: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
346: thisProjectId cz_devl_projects.devl_project_id%TYPE;
347: thisProjectName cz_devl_projects.name%TYPE;
348: thisProjectType cz_devl_projects.model_type%TYPE;
349: thisRootExplIndex PLS_INTEGER;
350:

Line 347: thisProjectName cz_devl_projects.name%TYPE;

343: v_TypeByExplId tExplNodeType;
344:
345: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
346: thisProjectId cz_devl_projects.devl_project_id%TYPE;
347: thisProjectName cz_devl_projects.name%TYPE;
348: thisProjectType cz_devl_projects.model_type%TYPE;
349: thisRootExplIndex PLS_INTEGER;
350:
351: nStructureHeaderId cz_lce_headers.lce_header_id%TYPE;

Line 348: thisProjectType cz_devl_projects.model_type%TYPE;

344:
345: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
346: thisProjectId cz_devl_projects.devl_project_id%TYPE;
347: thisProjectName cz_devl_projects.name%TYPE;
348: thisProjectType cz_devl_projects.model_type%TYPE;
349: thisRootExplIndex PLS_INTEGER;
350:
351: nStructureHeaderId cz_lce_headers.lce_header_id%TYPE;
352: PrevEffFrom DATE := EpochBeginDate;

Line 9814: FROM cz_devl_projects

9810:
9811: BEGIN
9812:
9813: SELECT name, model_type INTO thisProjectName, thisProjectType
9814: FROM cz_devl_projects
9815: WHERE devl_project_id = inComponentId;
9816: EXCEPTION
9817: WHEN OTHERS THEN
9818: nParam := inComponentId;

Line 11165: childModelId cz_devl_projects.devl_project_id%TYPE;

11161:
11162: c_model refCursor;
11163: childFlag PLS_INTEGER;
11164: thisFlag PLS_INTEGER := GENERATION_NOT_REQUIRED;
11165: childModelId cz_devl_projects.devl_project_id%TYPE;
11166: childLogicUpdate cz_devl_projects.last_logic_update%TYPE;
11167: childHeaderCreated cz_lce_headers.creation_date%TYPE;
11168:
11169: BEGIN

Line 11166: childLogicUpdate cz_devl_projects.last_logic_update%TYPE;

11162: c_model refCursor;
11163: childFlag PLS_INTEGER;
11164: thisFlag PLS_INTEGER := GENERATION_NOT_REQUIRED;
11165: childModelId cz_devl_projects.devl_project_id%TYPE;
11166: childLogicUpdate cz_devl_projects.last_logic_update%TYPE;
11167: childHeaderCreated cz_lce_headers.creation_date%TYPE;
11168:
11169: BEGIN
11170:

Line 11586: l_config_engine_type cz_devl_projects.config_engine_type%TYPE;

11582: PROCEDURE GENERATE_LOGIC(inDevlProjectId IN NUMBER,
11583: thisRunId IN OUT NOCOPY NUMBER)
11584: IS
11585:
11586: l_config_engine_type cz_devl_projects.config_engine_type%TYPE;
11587: l_fusion_debug VARCHAR2(240);
11588:
11589: BEGIN
11590:

Line 11594: FROM cz_devl_projects

11590:
11591: BEGIN
11592:
11593: SELECT config_engine_type INTO l_config_engine_type
11594: FROM cz_devl_projects
11595: WHERE deleted_flag = FLAG_NOT_DELETED
11596: AND devl_project_id = inDevlProjectId;
11597:
11598: EXCEPTION