APPS.CZ_UI_GENERATOR dependencies on CZ_UI_DEFS_S

Line 3446: SELECT CZ_UI_DEFS_S.NEXTVAL INTO MUID FROM DUAL;

3442:
3443: OPEN c1;
3444: FETCH c1 INTO var_c1;
3445: IF c1%NOTFOUND THEN
3446: SELECT CZ_UI_DEFS_S.NEXTVAL INTO MUID FROM DUAL;
3447:
3448: INSERT INTO CZ_UI_DEFS(ui_def_id,name,devl_project_id,component_id,
3449: ui_style,gen_version,gen_header,look_and_feel,deleted_flag)
3450: VALUES(MUID,'MUID',Project_Id,NULL,-1,GLOBAL_GEN_VERSION,GLOBAL_GEN_HEADER,NULL,NO_FLAG);

Line 3455: SELECT CZ_UI_DEFS_S.NEXTVAL INTO var_ui_def_id FROM DUAL;

3451:
3452: END IF;
3453: CLOSE c1;
3454:
3455: SELECT CZ_UI_DEFS_S.NEXTVAL INTO var_ui_def_id FROM DUAL;
3456:
3457: UI_Version:=generateUIVersion(Project_id);
3458: IF UI_Version>1 THEN
3459: InterfaceName:=SUBSTR(Model_Name||' User Interface '||TO_CHAR(UI_Version),1,255);

Line 7199: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_old_def_id;

7195:
7196: BEGIN
7197: IF in_replace_flag=YES_FLAG THEN
7198: SELECT name INTO var_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=in_old_def_id;
7199: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_old_def_id;
7200: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=in_new_def_id;
7201: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=in_new_def_id;
7202: UPDATE CZ_UI_NODES SET ui_def_ref_id=in_new_def_id WHERE ui_def_ref_id=in_old_def_id;
7203: END IF;

Line 7200: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=in_new_def_id;

7196: BEGIN
7197: IF in_replace_flag=YES_FLAG THEN
7198: SELECT name INTO var_ui_name FROM CZ_UI_DEFS WHERE ui_def_id=in_old_def_id;
7199: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_old_def_id;
7200: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=in_new_def_id;
7201: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=in_new_def_id;
7202: UPDATE CZ_UI_NODES SET ui_def_ref_id=in_new_def_id WHERE ui_def_ref_id=in_old_def_id;
7203: END IF;
7204:

Line 7867: UPDATE CZ_UI_DEFS SET last_update_date=SYSDATE WHERE

7863: WHEN NO_DATA_FOUND THEN
7864: mITEMS_ON_PAGE:=10;
7865: END;
7866:
7867: UPDATE CZ_UI_DEFS SET last_update_date=SYSDATE WHERE
7868: ui_def_id=in_ui_def_id RETURNING
7869: component_id,ui_style,gen_version,name
7870: INTO Project_Id,mUI_STYLE,var_gen_version,var_ui_name;
7871:

Line 7892: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id;

7888: in_max_bom_per_page=>mITEMS_ON_PAGE,
7889: in_wizard_style =>mWIZARD_STYLE);
7890:
7891:
7892: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id;
7893: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=new_ui_def_id;
7894: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
7895: UPDATE CZ_UI_NODES SET ui_def_ref_id=new_ui_def_id WHERE ui_def_ref_id=in_ui_def_id;
7896: in_ui_def_id:=new_ui_def_id;

Line 7893: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=new_ui_def_id;

7889: in_wizard_style =>mWIZARD_STYLE);
7890:
7891:
7892: UPDATE CZ_UI_DEFS SET deleted_flag=YES_FLAG WHERE ui_def_id=in_ui_def_id;
7893: UPDATE CZ_UI_DEFS SET name=var_ui_name WHERE ui_def_id=new_ui_def_id;
7894: UPDATE CZ_UI_NODES SET name=var_ui_name WHERE ui_node_id=parent_id AND ui_def_id=new_ui_def_id;
7895: UPDATE CZ_UI_NODES SET ui_def_ref_id=new_ui_def_id WHERE ui_def_ref_id=in_ui_def_id;
7896: in_ui_def_id:=new_ui_def_id;
7897: RAISE BREAK_IT;