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_REFS dependencies on CZ_MODEL_REF_EXPLS_S

Line 192: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;

188:
189: FUNCTION allocate_Expl_Id RETURN NUMBER IS
190: v_next_id NUMBER;
191: BEGIN
192: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;
193: RETURN v_next_id;
194: END allocate_Expl_Id;
195:
196: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 1908: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG WHERE model_ref_expl_id IN

1904: -- DEBUG ERROR CODE --
1905: --
1906: ERROR_CODE:=500;
1907:
1908: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG WHERE model_ref_expl_id IN
1909: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1910: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1911: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1912:

Line 1951: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

1947: p_ps_node_type IN INTEGER DEFAULT NULL) IS
1948:
1949: BEGIN
1950: IF p_del_logically=YES_FLAG THEN
1951: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1952: WHERE model_ref_expl_id=p_expl_id;
1953: ELSE
1954: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_expl_id;
1955: END IF;

Line 1959: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

1955: END IF;
1956:
1957: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1958: IF p_del_logically=YES_FLAG THEN
1959: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1960: WHERE deleted_flag=NO_FLAG AND model_ref_expl_id IN
1961: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1962: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1963: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 3057: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-1

3053: START WITH model_ref_expl_id=x.model_ref_expl_id AND deleted_flag=NO_FLAG
3054: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
3055: PRIOR deleted_flag=NO_FLAG)
3056: LOOP
3057: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-1
3058: WHERE model_ref_expl_id=y.model_ref_expl_id;
3059: END LOOP;
3060:
3061: --

Line 3066: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=x.parent_expl_node_id

3062: -- DEBUG ERROR CODE --
3063: --
3064: ERROR_CODE:=906;
3065:
3066: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=x.parent_expl_node_id
3067: WHERE parent_expl_node_id=x.model_ref_expl_id
3068: AND model_id=x.model_id AND deleted_flag=NO_FLAG;
3069:
3070: EXCEPTION

Line 3426: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level

3422: BEGIN
3423: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id FROM CZ_MODEL_REF_EXPLS
3424: WHERE parent_expl_node_id=p_expl_id AND deleted_flag=NO_FLAG)
3425: LOOP
3426: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level
3427: WHERE model_ref_expl_id=i.model_ref_expl_id;
3428:
3429: --
3430: -- DEBUG ERROR CODE --

Line 3733: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_ref_up_level+1

3729: SET parent_expl_node_id=v_ref_up_expl_id
3730: WHERE model_ref_expl_id=v_from_up_expl_id
3731: AND deleted_flag=NO_FLAG;
3732:
3733: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_ref_up_level+1
3734: WHERE model_ref_expl_id IN
3735: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3736: START WITH model_ref_expl_id=v_from_up_expl_id AND deleted_flag=NO_FLAG
3737: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG

Line 3782: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-var_subroot_level+v_ref_up_level+1

3778: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3779: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3780: RETURNING model_ref_expl_id,node_depth INTO var_subroot_id,var_subroot_level ;
3781:
3782: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-var_subroot_level+v_ref_up_level+1
3783: WHERE model_ref_expl_id IN
3784: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3785: START WITH model_ref_expl_id=var_subroot_id AND deleted_flag=NO_FLAG
3786: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 3861: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=v_up_expl_id

3857: -- DEBUG ERROR CODE --
3858: --
3859: ERROR_CODE:=1307;
3860:
3861: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=v_up_expl_id
3862: WHERE model_ref_expl_id=t_model_ref_expl(i)
3863: AND model_id=p_project_id;
3864:
3865: --

Line 3870: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_up_level+1

3866: -- DEBUG ERROR CODE --
3867: --
3868: ERROR_CODE:=1308;
3869:
3870: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_up_level+1
3871: WHERE model_ref_expl_id IN
3872: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3873: START WITH model_ref_expl_id=t_model_ref_expl(i) AND deleted_flag=NO_FLAG
3874: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 4150: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

4146: -- DEBUG ERROR CODE --
4147: --
4148: ERROR_CODE:=1600;
4149:
4150: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
4151: WHERE model_ref_expl_id IN(
4152: SELECT model_ref_expl_id FROM cz_model_ref_expls
4153: START WITH model_ref_expl_id=j.model_ref_expl_id AND deleted_flag=NO_FLAG
4154: CONNECT by PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG

Line 4268: UPDATE CZ_MODEL_REF_EXPLS SET has_trackable_children=v_ib_trackable

4264: IF v_ib_trackable=NO_FLAG THEN
4265: t_nontrk_tbl(t_nontrk_tbl.COUNT+1):=t_m_chain_tbl(i);
4266: END IF;
4267:
4268: UPDATE CZ_MODEL_REF_EXPLS SET has_trackable_children=v_ib_trackable
4269: WHERE model_id=t_m_chain_tbl(i) AND component_id=t_m_chain_tbl(i) AND deleted_flag=NO_FLAG;
4270:
4271: END LOOP;
4272: