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 188: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;

184:
185: FUNCTION allocate_Expl_Id RETURN NUMBER IS
186: v_next_id NUMBER;
187: BEGIN
188: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;
189: RETURN v_next_id;
190: END allocate_Expl_Id;
191:
192: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

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

1838: -- DEBUG ERROR CODE --
1839: --
1840: ERROR_CODE:=500;
1841:
1842: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG WHERE model_ref_expl_id IN
1843: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1844: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1845: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1846:

Line 1885: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

1881: p_ps_node_type IN INTEGER DEFAULT NULL) IS
1882:
1883: BEGIN
1884: IF p_del_logically=YES_FLAG THEN
1885: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1886: WHERE model_ref_expl_id=p_expl_id;
1887: ELSE
1888: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_expl_id;
1889: END IF;

Line 1893: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

1889: END IF;
1890:
1891: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1892: IF p_del_logically=YES_FLAG THEN
1893: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1894: WHERE deleted_flag=NO_FLAG AND model_ref_expl_id IN
1895: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1896: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1897: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 2990: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-1

2986: START WITH model_ref_expl_id=x.model_ref_expl_id AND deleted_flag=NO_FLAG
2987: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
2988: PRIOR deleted_flag=NO_FLAG)
2989: LOOP
2990: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-1
2991: WHERE model_ref_expl_id=y.model_ref_expl_id;
2992: END LOOP;
2993:
2994: --

Line 2999: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=x.parent_expl_node_id

2995: -- DEBUG ERROR CODE --
2996: --
2997: ERROR_CODE:=906;
2998:
2999: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=x.parent_expl_node_id
3000: WHERE parent_expl_node_id=x.model_ref_expl_id
3001: AND model_id=x.model_id AND deleted_flag=NO_FLAG;
3002:
3003: EXCEPTION

Line 3348: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level

3344: BEGIN
3345: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id FROM CZ_MODEL_REF_EXPLS
3346: WHERE parent_expl_node_id=p_expl_id AND deleted_flag=NO_FLAG)
3347: LOOP
3348: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level
3349: WHERE model_ref_expl_id=i.model_ref_expl_id;
3350:
3351: --
3352: -- DEBUG ERROR CODE --

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

3651: SET parent_expl_node_id=v_ref_up_expl_id
3652: WHERE model_ref_expl_id=v_from_up_expl_id
3653: AND deleted_flag=NO_FLAG;
3654:
3655: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_ref_up_level+1
3656: WHERE model_ref_expl_id IN
3657: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3658: START WITH model_ref_expl_id=v_from_up_expl_id AND deleted_flag=NO_FLAG
3659: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG

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

3700: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3701: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3702: RETURNING model_ref_expl_id,node_depth INTO var_subroot_id,var_subroot_level ;
3703:
3704: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-var_subroot_level+v_ref_up_level+1
3705: WHERE model_ref_expl_id IN
3706: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3707: START WITH model_ref_expl_id=var_subroot_id AND deleted_flag=NO_FLAG
3708: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 3783: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=v_up_expl_id

3779: -- DEBUG ERROR CODE --
3780: --
3781: ERROR_CODE:=1307;
3782:
3783: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=v_up_expl_id
3784: WHERE model_ref_expl_id=t_model_ref_expl(i)
3785: AND model_id=p_project_id;
3786:
3787: --

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

3788: -- DEBUG ERROR CODE --
3789: --
3790: ERROR_CODE:=1308;
3791:
3792: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_up_level+1
3793: WHERE model_ref_expl_id IN
3794: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3795: START WITH model_ref_expl_id=t_model_ref_expl(i) AND deleted_flag=NO_FLAG
3796: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 4072: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

4068: -- DEBUG ERROR CODE --
4069: --
4070: ERROR_CODE:=1600;
4071:
4072: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
4073: WHERE model_ref_expl_id IN(
4074: SELECT model_ref_expl_id FROM cz_model_ref_expls
4075: START WITH model_ref_expl_id=j.model_ref_expl_id AND deleted_flag=NO_FLAG
4076: CONNECT by PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG

Line 4190: UPDATE CZ_MODEL_REF_EXPLS SET has_trackable_children=v_ib_trackable

4186: IF v_ib_trackable=NO_FLAG THEN
4187: t_nontrk_tbl(t_nontrk_tbl.COUNT+1):=t_m_chain_tbl(i);
4188: END IF;
4189:
4190: UPDATE CZ_MODEL_REF_EXPLS SET has_trackable_children=v_ib_trackable
4191: WHERE model_id=t_m_chain_tbl(i) AND component_id=t_m_chain_tbl(i) AND deleted_flag=NO_FLAG;
4192:
4193: END LOOP;
4194: