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_RP_ENTRIES

Line 595: devl_project_id IN(SELECT object_id FROM CZ_RP_ENTRIES

591: v_ind NUMBER:=0;
592: BEGIN
593: FOR i IN(SELECT DISTINCT devl_project_id FROM CZ_PS_NODES a
594: WHERE reference_id=p_id AND deleted_flag=NO_FLAG AND
595: devl_project_id IN(SELECT object_id FROM CZ_RP_ENTRIES
596: WHERE object_id=a.devl_project_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
597: LOOP
598: v_ind:=t_chain.COUNT+1;
599: t_chain(v_ind).model_id:=i.devl_project_id;

Line 2596: devl_project_id IN(SELECT object_id FROM CZ_RP_ENTRIES

2592:
2593: FOR n IN (SELECT * FROM CZ_PS_NODES a
2594: WHERE reference_id=p_current_model_id AND
2595: ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG AND
2596: devl_project_id IN(SELECT object_id FROM CZ_RP_ENTRIES
2597: WHERE object_id=a.devl_project_id AND object_type='PRJ' AND deleted_flag=NO_FLAG)
2598: )
2599: LOOP
2600:

Line 3039: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3035: (v_ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE)) AND v_node_Exist THEN
3036:
3037: FOR x IN (SELECT model_ref_expl_id,parent_expl_node_id,model_id FROM CZ_MODEL_REF_EXPLS a
3038: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3039: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3040: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3041: LOOP
3042: BEGIN
3043: IF x.model_id=p_model_id THEN

Line 3332: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3328: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
3329:
3330: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3331: WHERE referring_node_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3332: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3333: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3334: LOOP
3335: --
3336: -- DEBUG ERROR CODE --

Line 3355: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3351:
3352: IF v_virtual_flag='0' THEN
3353: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3354: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3355: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3356: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3357: LOOP
3358: --
3359: -- DEBUG ERROR CODE --

Line 3487: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3483: BULK COLLECT INTO t_refs,t_models
3484: FROM CZ_MODEL_REF_EXPLS a
3485: WHERE child_model_expl_id=p_expl_root_id
3486: AND ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG AND
3487: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3488: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
3489:
3490: --
3491: -- DEBUG ERROR CODE --

Line 3519: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3515: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3516: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
3517: deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
3518: AND
3519: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3520: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
3521:
3522: --
3523: -- DEBUG ERROR CODE --

Line 3534: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3530: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3531: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3532: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
3533: AND
3534: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3535: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
3536:
3537: --
3538: -- DEBUG ERROR CODE --

Line 3778: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3774: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3775: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG
3776: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3777: AND PRIOR deleted_flag=NO_FLAG) AND
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

Line 4053: EXISTS(SELECT NULL FROM CZ_RP_ENTRIES WHERE object_id=a.model_id AND

4049: -- check models that reference the current model ( p_refroot_model_id )
4050: FOR n IN(SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
4051: WHERE component_id=p_refroot_model_id AND ps_node_type=REFERENCE_TYPE AND
4052: deleted_flag='0' AND
4053: EXISTS(SELECT NULL FROM CZ_RP_ENTRIES WHERE object_id=a.model_id AND
4054: object_type='PRJ' AND deleted_flag='0'))
4055: LOOP
4056: IF containsBOM(n.model_id, v_instanciable) > 0 THEN
4057: p_out_status_code:=1;

Line 4107: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

4103: ERROR_CODE:=1500;
4104:
4105: UPDATE CZ_MODEL_REF_EXPLS a SET deleted_flag=YES_FLAG
4106: WHERE child_model_expl_id=t_arr(i) AND
4107: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4108: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG)
4109: RETURNING model_ref_expl_id BULK COLLECT INTO temp_arr;
4110:
4111: --

Line 4226: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

4222: AND deleted_flag=NO_FLAG
4223: UNION
4224: SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
4225: WHERE component_id=p_model_id AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4226: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4227: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG));
4228:
4229: t_m_chain_tbl(t_m_chain_tbl.COUNT+1):=p_model_id;
4230:

Line 4277: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

4273: IF t_trk_tbl.COUNT>0 THEN
4274: FORALL i IN t_trk_tbl.First..t_trk_tbl.Last
4275: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children='1'
4276: WHERE component_id=t_trk_tbl(i) AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4277: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4278: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
4279: END IF;
4280:
4281: IF t_nontrk_tbl.COUNT>0 THEN

Line 4285: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

4281: IF t_nontrk_tbl.COUNT>0 THEN
4282: FORALL i IN t_nontrk_tbl.First..t_nontrk_tbl.Last
4283: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children=NO_FLAG
4284: WHERE component_id=t_nontrk_tbl(i) AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4285: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4286: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
4287: END IF;
4288:
4289: