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 529: devl_project_id IN(SELECT object_id FROM CZ_RP_ENTRIES

525: v_ind NUMBER:=0;
526: BEGIN
527: FOR i IN(SELECT DISTINCT devl_project_id FROM CZ_PS_NODES a
528: WHERE reference_id=p_id AND deleted_flag=NO_FLAG AND
529: devl_project_id IN(SELECT object_id FROM CZ_RP_ENTRIES
530: WHERE object_id=a.devl_project_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
531: LOOP
532: v_ind:=t_chain.COUNT+1;
533: t_chain(v_ind).model_id:=i.devl_project_id;

Line 2530: devl_project_id IN(SELECT object_id FROM CZ_RP_ENTRIES

2526:
2527: FOR n IN (SELECT * FROM CZ_PS_NODES a
2528: WHERE reference_id=p_current_model_id AND
2529: ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG AND
2530: devl_project_id IN(SELECT object_id FROM CZ_RP_ENTRIES
2531: WHERE object_id=a.devl_project_id AND object_type='PRJ' AND deleted_flag=NO_FLAG)
2532: )
2533: LOOP
2534:

Line 2972: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

2968: (v_ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE)) AND v_node_Exist THEN
2969:
2970: FOR x IN (SELECT model_ref_expl_id,parent_expl_node_id,model_id FROM CZ_MODEL_REF_EXPLS a
2971: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
2972: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
2973: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
2974: LOOP
2975: BEGIN
2976: IF x.model_id=p_model_id THEN

Line 3254: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3250: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
3251:
3252: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3253: WHERE referring_node_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3254: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3255: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3256: LOOP
3257: --
3258: -- DEBUG ERROR CODE --

Line 3277: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3273:
3274: IF v_virtual_flag='0' THEN
3275: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3276: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3277: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3278: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3279: LOOP
3280: --
3281: -- DEBUG ERROR CODE --

Line 3409: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3405: BULK COLLECT INTO t_refs,t_models
3406: FROM CZ_MODEL_REF_EXPLS a
3407: WHERE child_model_expl_id=p_expl_root_id
3408: AND ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG AND
3409: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3410: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
3411:
3412: --
3413: -- DEBUG ERROR CODE --

Line 3441: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3437: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3438: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
3439: deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
3440: AND
3441: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3442: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
3443:
3444: --
3445: -- DEBUG ERROR CODE --

Line 3456: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3452: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3453: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3454: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
3455: AND
3456: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3457: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
3458:
3459: --
3460: -- DEBUG ERROR CODE --

Line 3700: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

3696: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3697: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG
3698: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3699: AND PRIOR deleted_flag=NO_FLAG) AND
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

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

3971: -- check models that reference the current model ( p_refroot_model_id )
3972: FOR n IN(SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
3973: WHERE component_id=p_refroot_model_id AND ps_node_type=REFERENCE_TYPE AND
3974: deleted_flag='0' AND
3975: EXISTS(SELECT NULL FROM CZ_RP_ENTRIES WHERE object_id=a.model_id AND
3976: object_type='PRJ' AND deleted_flag='0'))
3977: LOOP
3978: IF containsBOM(n.model_id, v_instanciable) > 0 THEN
3979: p_out_status_code:=1;

Line 4029: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

4025: ERROR_CODE:=1500;
4026:
4027: UPDATE CZ_MODEL_REF_EXPLS a SET deleted_flag=YES_FLAG
4028: WHERE child_model_expl_id=t_arr(i) AND
4029: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4030: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG)
4031: RETURNING model_ref_expl_id BULK COLLECT INTO temp_arr;
4032:
4033: --

Line 4148: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

4144: AND deleted_flag=NO_FLAG
4145: UNION
4146: SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
4147: WHERE component_id=p_model_id AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4148: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4149: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG));
4150:
4151: t_m_chain_tbl(t_m_chain_tbl.COUNT+1):=p_model_id;
4152:

Line 4199: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

4195: IF t_trk_tbl.COUNT>0 THEN
4196: FORALL i IN t_trk_tbl.First..t_trk_tbl.Last
4197: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children='1'
4198: WHERE component_id=t_trk_tbl(i) AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4199: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4200: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
4201: END IF;
4202:
4203: IF t_nontrk_tbl.COUNT>0 THEN

Line 4207: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

4203: IF t_nontrk_tbl.COUNT>0 THEN
4204: FORALL i IN t_nontrk_tbl.First..t_nontrk_tbl.Last
4205: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children=NO_FLAG
4206: WHERE component_id=t_nontrk_tbl(i) AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4207: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4208: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
4209: END IF;
4210:
4211: