eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_TYPES dependencies on CZ_DEVL_PROJECTS

Line 168: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;

164: p_reference_id IN NUMBER,
165: p_max_selected IN NUMBER)
166: RETURN NUMBER IS
167:
168: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;
169: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
170:
171: BEGIN
172:

Line 228: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS

224: RETURN UMANDATORY_REF_TYPEID;
225:
226: ELSIF p_ps_node_type=PS_NODE_TYPE_REFERENCE AND p_instantiable_flag=OPTIONAL_EXPL_TYPE THEN
227:
228: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
229: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
230:
231: SELECT ps_node_type INTO v_ps_node_type FROM CZ_PS_NODES
232: WHERE ps_node_id=p_reference_id AND deleted_flag='0';

Line 242: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS

238: END IF;
239:
240: ELSIF p_ps_node_type=PS_NODE_TYPE_REFERENCE AND p_instantiable_flag=MINMAX_EXPL_TYPE THEN
241:
242: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
243: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
244:
245: SELECT ps_node_type INTO v_ps_node_type FROM CZ_PS_NODES
246: WHERE ps_node_id=p_reference_id AND deleted_flag='0';

Line 341: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;

337: p_ib_trackable IN VARCHAR2,
338: p_devl_project_id IN NUMBER)
339: RETURN NUMBER IS
340:
341: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;
342: v_config_engine_type CZ_DEVL_PROJECTS.config_engine_type%TYPE;
343:
344: BEGIN
345:

Line 342: v_config_engine_type CZ_DEVL_PROJECTS.config_engine_type%TYPE;

338: p_devl_project_id IN NUMBER)
339: RETURN NUMBER IS
340:
341: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;
342: v_config_engine_type CZ_DEVL_PROJECTS.config_engine_type%TYPE;
343:
344: BEGIN
345:
346: SELECT NVL(config_engine_type,'L') INTO v_config_engine_type FROM CZ_DEVL_PROJECTS

Line 346: SELECT NVL(config_engine_type,'L') INTO v_config_engine_type FROM CZ_DEVL_PROJECTS

342: v_config_engine_type CZ_DEVL_PROJECTS.config_engine_type%TYPE;
343:
344: BEGIN
345:
346: SELECT NVL(config_engine_type,'L') INTO v_config_engine_type FROM CZ_DEVL_PROJECTS
347: WHERE devl_project_id=p_devl_project_id AND deleted_flag='0';
348:
349: IF p_ps_node_type=PS_NODE_TYPE_PRODUCT AND p_instantiable_flag=MANDATORY_EXPL_TYPE THEN
350: RETURN MANDATORY_PRODUCT_TYPEID;

Line 423: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS

419: RETURN INT_RESOURCE_TYPEID;
420:
421: ELSIF p_ps_node_type=PS_NODE_TYPE_REFERENCE AND p_instantiable_flag=MANDATORY_EXPL_TYPE THEN
422:
423: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
424: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
425:
426: IF v_model_type IN (MODEL_TYPE_ATO, MODEL_TYPE_PTO) THEN
427: IF(p_ib_trackable = '1')THEN RETURN TRACKABLE_MBOM_REF_TYPEID;

Line 435: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS

431: END IF;
432:
433: ELSIF p_ps_node_type=PS_NODE_TYPE_REFERENCE AND p_instantiable_flag=OPTIONAL_EXPL_TYPE THEN
434:
435: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
436: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
437:
438:
439: IF v_model_type IN (MODEL_TYPE_ATO, MODEL_TYPE_PTO) THEN

Line 448: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS

444: END IF;
445:
446: ELSIF p_ps_node_type=PS_NODE_TYPE_REFERENCE AND p_instantiable_flag=MINMAX_EXPL_TYPE THEN
447:
448: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
449: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
450:
451: IF v_model_type IN (MODEL_TYPE_ATO, MODEL_TYPE_PTO) THEN
452: IF(p_ib_trackable = '1')THEN RETURN TRACKABLE_MMBOM_REF_TYPEID;