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_UI_GENERATOR dependencies on CZ_MODEL_REF_EXPLS

Line 2226: var_ref_model_id CZ_MODEL_REF_EXPLS.component_id%TYPE;

2222: -- populate CZ_UI_NODES.model_ref_expl_id associated with References
2223: --
2224: PROCEDURE populate_RefSI(in_ui_def_id IN INTEGER) IS
2225: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
2226: var_ref_model_id CZ_MODEL_REF_EXPLS.component_id%TYPE;
2227: var_ref_root_screen CZ_UI_NODES.ui_node_id%TYPE;
2228: BEGIN
2229: FOR i IN(SELECT ps_node_id,model_ref_expl_id,ui_def_ref_id FROM CZ_UI_NODES
2230: WHERE ui_def_id=in_ui_def_id AND deleted_flag=NO_FLAG

Line 2251: FROM CZ_MODEL_REF_EXPLS a

2247: --
2248: IF var_ui_node_ref_id IS NULL THEN
2249: BEGIN
2250: SELECT component_id INTO var_ref_model_id
2251: FROM CZ_MODEL_REF_EXPLS a
2252: WHERE model_id=Project_Id AND deleted_flag=NO_FLAG
2253: AND referring_node_id=i.ps_node_id AND ps_node_type=REFERENCE_NODE_TYPE AND rownum<2;
2254:
2255: SELECT ui_node_id INTO var_ref_root_screen FROM CZ_UI_NODES

Line 2557: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2553: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
2554: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;
2555: var_align CZ_UI_NODE_PROPS.value_str%TYPE;
2556: var_ref_root_screen CZ_UI_NODES.ui_node_id%TYPE;
2557: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2558: var_use_labels VARCHAR2(1);
2559: Top_Labeled BOOLEAN:=FALSE;
2560:
2561: BEGIN

Line 2584: FROM CZ_MODEL_REF_EXPLS a WHERE model_id=Project_Id AND component_id=in_ref_model_id

2580: END IF;
2581:
2582: BEGIN
2583: SELECT MIN(model_ref_expl_id) INTO var_model_ref_expl_id
2584: FROM CZ_MODEL_REF_EXPLS a WHERE model_id=Project_Id AND component_id=in_ref_model_id
2585: AND referring_node_id=in_ref_ps_id AND ps_node_type=REFERENCE_NODE_TYPE
2586: AND deleted_flag=NO_FLAG;
2587: EXCEPTION
2588: WHEN OTHERS THEN

Line 2781: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2777: var_button_name CZ_PS_NODES.name%TYPE;
2778: var_ui_name CZ_PS_NODES.name%TYPE;
2779: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
2780: var_model_id CZ_PS_NODES.devl_project_id%TYPE;
2781: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2782: var_ref_root_screen INTEGER;
2783: counter INTEGER;
2784: ind INTEGER;
2785: existsDeleteMe VARCHAR2(1);

Line 2791: SELECT MIN(model_ref_expl_id) INTO var_expl_id FROM CZ_MODEL_REF_EXPLS a

2787:
2788: BEGIN
2789: BEGIN
2790: ERROR_CODE:='00191';
2791: SELECT MIN(model_ref_expl_id) INTO var_expl_id FROM CZ_MODEL_REF_EXPLS a
2792: WHERE referring_node_id=in_arr.ps_node_id AND model_id=Project_Id AND
2793: deleted_flag=NO_FLAG;
2794: ERROR_CODE:='00192';
2795: EXCEPTION

Line 4184: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

4180: var_button_name CZ_UI_NODES.name%TYPE;
4181: var_button_caption CZ_INTL_TEXTS.text_str%TYPE;
4182: var_ref_name CZ_UI_NODES.name%TYPE;
4183: var_ref_label_id CZ_PS_NODES.intl_text_id%TYPE;
4184: var_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4185: var_ref_label CZ_INTL_TEXTS.text_str%TYPE;
4186: var_text_width CZ_UI_NODES.width%TYPE;
4187: var_borders CZ_UI_NODES.borders%TYPE:=YES_FLAG;
4188: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;

Line 4197: SELECT MIN(model_ref_expl_id) INTO var_expl_id FROM CZ_MODEL_REF_EXPLS a

4193:
4194: BEGIN
4195:
4196: BEGIN
4197: SELECT MIN(model_ref_expl_id) INTO var_expl_id FROM CZ_MODEL_REF_EXPLS a
4198: WHERE referring_node_id=in_arr.ps_node_id AND model_id=Project_Id
4199: AND deleted_flag=NO_FLAG;
4200: EXCEPTION
4201: WHEN NO_DATA_FOUND THEN

Line 4463: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

4459: var_prev_parent_id CZ_UI_NODES.parent_id%TYPE;
4460: var_curr_parent_id CZ_UI_NODES.parent_id%TYPE;
4461: var_ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE;
4462: var_screen_oc_id CZ_UI_NODES.ui_node_id%TYPE;
4463: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
4464: var_use_default_color CZ_UI_NODES.default_bkgrnd_color_flag%TYPE:=YES_FLAG;
4465:
4466: var_type INTEGER;
4467: var_temp INTEGER;

Line 4639: FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id

4635: END;
4636:
4637: BEGIN
4638: SELECT model_ref_expl_id INTO var_model_ref_expl_id
4639: FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id
4640: AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
4641: EXCEPTION
4642: WHEN OTHERS THEN
4643: var_model_ref_expl_id:=NULL;

Line 7750: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

7746: var_ui_parent_screen_id CZ_UI_NODES.ui_node_id%TYPE;
7747: var_modified_flags CZ_UI_NODES.MODIFIED_FLAGS%TYPE;
7748: var_gen_version CZ_UI_DEFS.GEN_VERSION%TYPE;
7749: var_ui_name CZ_UI_DEFS.NAME%TYPE;
7750: var_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
7751: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
7752:
7753: NEXT_ITTERATION EXCEPTION;
7754: NO_COMPONENT_TREE_NODE EXCEPTION;

Line 8235: SELECT MIN(model_ref_expl_id) INTO var_model_ref_id FROM CZ_MODEL_REF_EXPLS a WHERE

8231:
8232: IF i.ps_node_type IN(PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,REFERENCE_NODE_TYPE,CONNECTOR_NODE_TYPE) THEN
8233: BEGIN
8234: IF i.ps_node_type IN(REFERENCE_NODE_TYPE,CONNECTOR_NODE_TYPE) THEN
8235: SELECT MIN(model_ref_expl_id) INTO var_model_ref_id FROM CZ_MODEL_REF_EXPLS a WHERE
8236: model_id=Project_Id AND referring_node_id=i.ps_node_id AND deleted_flag=NO_FLAG;
8237: ELSE
8238: SELECT MIN(model_ref_expl_id) INTO var_model_ref_id FROM CZ_MODEL_REF_EXPLS a WHERE
8239: model_id=Project_Id AND component_id=i.ps_node_id AND deleted_flag=NO_FLAG;

Line 8238: SELECT MIN(model_ref_expl_id) INTO var_model_ref_id FROM CZ_MODEL_REF_EXPLS a WHERE

8234: IF i.ps_node_type IN(REFERENCE_NODE_TYPE,CONNECTOR_NODE_TYPE) THEN
8235: SELECT MIN(model_ref_expl_id) INTO var_model_ref_id FROM CZ_MODEL_REF_EXPLS a WHERE
8236: model_id=Project_Id AND referring_node_id=i.ps_node_id AND deleted_flag=NO_FLAG;
8237: ELSE
8238: SELECT MIN(model_ref_expl_id) INTO var_model_ref_id FROM CZ_MODEL_REF_EXPLS a WHERE
8239: model_id=Project_Id AND component_id=i.ps_node_id AND deleted_flag=NO_FLAG;
8240: END IF;
8241:
8242: /* *** refresh model_ref_expl_id-s for all Components,Products,References and UI controls *** */

Line 8457: FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id

8453: END;
8454:
8455: BEGIN
8456: SELECT model_ref_expl_id INTO var_model_ref_expl_id
8457: FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id
8458: AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
8459: EXCEPTION
8460: WHEN OTHERS THEN
8461: var_model_ref_expl_id:=NULL;

Line 8466: FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id

8462: END;
8463:
8464: BEGIN
8465: SELECT model_ref_expl_id INTO var_model_ref_expl_id
8466: FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id
8467: AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
8468: EXCEPTION
8469: WHEN OTHERS THEN
8470: var_model_ref_expl_id:=NULL;

Line 9607: FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id

9603: END IF;
9604:
9605: BEGIN
9606: SELECT model_ref_expl_id INTO var_model_ref_expl_id
9607: FROM CZ_MODEL_REF_EXPLS WHERE model_id=Project_Id
9608: AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
9609: EXCEPTION
9610: WHEN OTHERS THEN
9611: var_model_ref_expl_id:=NULL;

Line 9886: AND ps_node_id NOT IN(SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS

9882: SELECT '1' INTO v_just_OC FROM DUAL WHERE EXISTS
9883: (SELECT NULL FROM CZ_UI_NODES WHERE parent_id=var_temp
9884: AND ui_node_ref_id IS NOT NULL
9885: AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG
9886: AND ps_node_id NOT IN(SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS
9887: WHERE model_id=Project_Id AND referring_node_id IS NOT NULL AND deleted_flag=NO_FLAG))
9888: AND NOT EXISTS
9889: (SELECT NULL FROM CZ_UI_NODES WHERE parent_id=var_temp
9890: AND ui_node_ref_id IS NULL