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 346: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;

342: p_ib_trackable IN VARCHAR2,
343: p_devl_project_id IN NUMBER)
344: RETURN NUMBER IS
345:
346: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;
347: v_config_engine_type CZ_DEVL_PROJECTS.config_engine_type%TYPE;
348:
349: BEGIN
350:

Line 347: v_config_engine_type CZ_DEVL_PROJECTS.config_engine_type%TYPE;

343: p_devl_project_id IN NUMBER)
344: RETURN NUMBER IS
345:
346: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;
347: v_config_engine_type CZ_DEVL_PROJECTS.config_engine_type%TYPE;
348:
349: BEGIN
350:
351: SELECT NVL(config_engine_type,'L') INTO v_config_engine_type FROM CZ_DEVL_PROJECTS

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

347: v_config_engine_type CZ_DEVL_PROJECTS.config_engine_type%TYPE;
348:
349: BEGIN
350:
351: SELECT NVL(config_engine_type,'L') INTO v_config_engine_type FROM CZ_DEVL_PROJECTS
352: WHERE devl_project_id=p_devl_project_id AND deleted_flag='0';
353:
354: IF p_ps_node_type=PS_NODE_TYPE_PRODUCT AND p_instantiable_flag=MANDATORY_EXPL_TYPE THEN
355: RETURN MANDATORY_PRODUCT_TYPEID;

Line 428: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS

424: RETURN INT_RESOURCE_TYPEID;
425:
426: ELSIF p_ps_node_type=PS_NODE_TYPE_REFERENCE AND p_instantiable_flag=MANDATORY_EXPL_TYPE THEN
427:
428: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
429: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
430:
431: IF v_model_type IN (MODEL_TYPE_ATO, MODEL_TYPE_PTO) THEN
432: IF(p_ib_trackable = '1')THEN RETURN TRACKABLE_MBOM_REF_TYPEID;

Line 440: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS

436: END IF;
437:
438: ELSIF p_ps_node_type=PS_NODE_TYPE_REFERENCE AND p_instantiable_flag=OPTIONAL_EXPL_TYPE THEN
439:
440: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
441: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
442:
443:
444: IF v_model_type IN (MODEL_TYPE_ATO, MODEL_TYPE_PTO) THEN

Line 453: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS

449: END IF;
450:
451: ELSIF p_ps_node_type=PS_NODE_TYPE_REFERENCE AND p_instantiable_flag=MINMAX_EXPL_TYPE THEN
452:
453: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
454: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
455:
456: IF v_model_type IN (MODEL_TYPE_ATO, MODEL_TYPE_PTO) THEN
457: IF(p_ib_trackable = '1')THEN RETURN TRACKABLE_MMBOM_REF_TYPEID;