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_UIOA_PVT dependencies on CZ_RULES

Line 3245: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

3241:
3242: l_undeleted_exist := FALSE;
3243: FOR i IN(SELECT a.deleted_flag, a.invalid_flag, a.disabled_flag ,
3244: a.INSTANTIATION_SCOPE, b.data_value, a.name
3245: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3246: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3247: a.component_id=l_model_node.ps_node_id AND
3248: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
3249: a.deleted_flag=G_NO_FLAG AND

Line 3270: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

3266: IF l_model_node.ps_node_type=G_REFERENCE_TYPE THEN
3267:
3268: FOR i IN(SELECT a.name, a.deleted_flag, a.invalid_flag, a.disabled_flag,
3269: a.INSTANTIATION_SCOPE, b.data_value
3270: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3271: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3272: a.component_id IN
3273: (SELECT ps_node_id FROM CZ_PS_NODES
3274: WHERE devl_project_id IN

Line 5270: FOR k IN(SELECT rule_id,rule_type,seeded_flag,devl_project_id FROM CZ_RULES

5266: l_source_ui_def_id := 0;
5267: ELSE
5268: l_source_ui_def_id := p_source_ui_def_id;
5269: END IF;
5270: FOR k IN(SELECT rule_id,rule_type,seeded_flag,devl_project_id FROM CZ_RULES
5271: WHERE persistent_rule_id = p_rule_id AND DECODE(NVL(ui_def_id,0),0,l_source_ui_def_id,ui_def_id)=l_source_ui_def_id
5272: AND deleted_flag=G_NO_FLAG)
5273: LOOP
5274: l_run_id := 0; l_cp_rule_run_id := 0;

Line 6517: FROM CZ_RULES

6513:
6514:
6515:
6516: FOR i in (SELECT rule_id, ui_page_element_id
6517: FROM CZ_RULES
6518: WHERE devl_project_id = g_UI_Context.devl_project_id
6519: AND ui_def_id = g_UI_Context.ui_def_id
6520: AND ui_page_id = l_src_page_id
6521: AND component_id = l_old_component_id

Line 6527: UPDATE CZ_RULES

6523: LOOP
6524: DEBUG('asp: Found rule ' || i.rule_id || ', for element ' || i.ui_page_element_Id);
6525: IF l_element_ids_tbl.EXISTS(i.ui_page_element_id) THEN
6526: DEBUG('asp: Updating rule ' || i.rule_id || ' for element_id ' || i.ui_page_element_id);
6527: UPDATE CZ_RULES
6528: SET component_id = l_component_id,
6529: ui_page_id = p_ui_node.page_id
6530: WHERE devl_project_id = g_UI_Context.devl_project_id
6531: AND rule_id = i.rule_id;

Line 8607: SELECT TEMPLATE_TOKEN INTO G_CAPTION_RULE_TOKENNAME FROM CZ_RULES

8603: template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
8604: deleted_flag=G_NO_FLAG;
8605: END IF;
8606:
8607: SELECT TEMPLATE_TOKEN INTO G_CAPTION_RULE_TOKENNAME FROM CZ_RULES
8608: WHERE rule_id=G_DEFAULT_CAPTION_RULE_ID;
8609:
8610: END set_UI_Global_Entities;
8611:

Line 9008: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9004: RETURN;
9005: END IF;
9006:
9007: FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.name
9008: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9009: WHERE a.devl_project_id=p_node.devl_project_id AND
9010: a.component_id=p_node.ps_node_id AND
9011: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9012: a.deleted_flag=G_NO_FLAG AND

Line 9173: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9169:
9170: IF p_node.ps_node_type=G_REFERENCE_TYPE THEN
9171:
9172: FOR i IN(SELECT a.model_ref_expl_id, b.data_value, a.component_id, b.expr_node_id, a.name, a.INSTANTIATION_SCOPE
9173: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9174: WHERE a.devl_project_id=p_node.devl_project_id AND
9175: a.component_id IN
9176: (SELECT ps_node_id FROM CZ_PS_NODES
9177: WHERE devl_project_id IN

Line 9398: EXISTS(SELECT NULL FROM CZ_RULES

9394: WHERE devl_project_id=g_UI_Context.devl_project_id AND
9395: ui_def_id=g_UI_Context.from_master_template_id AND
9396: ps_node_type IN(G_OPTION_TYPE, G_BOM_STANDART_ITEM_TYPE) AND
9397: ui_omit=G_NO_FLAG AND deleted_flag=G_NO_FLAG AND
9398: EXISTS(SELECT NULL FROM CZ_RULES
9399: WHERE devl_project_id=g_UI_Context.devl_project_id AND
9400: component_id=a.ps_node_id AND
9401: disabled_flag=G_NO_FLAG AND
9402: deleted_flag=G_NO_FLAG))

Line 9412: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9408: deleted_flag NOT IN(G_YES_FLAG, G_MARK_TO_DELETE, G_LIMBO_FLAG))
9409: LOOP
9410:
9411: FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.NAME
9412: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9413: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
9414: a.component_id=option_node.ps_node_id AND
9415: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9416: a.deleted_flag=G_NO_FLAG AND

Line 9618: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9614: (SELECT persistent_node_id
9615: FROM CZ_PS_NODES
9616: WHERE devl_project_id = g_UI_Context.devl_project_id
9617: AND ps_node_id = a.component_id) persistent_node_Id
9618: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9619: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
9620: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9621: b.rule_id=a.rule_id AND
9622: b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND

Line 16925: UPDATE CZ_RULES

16921: FOR i IN g_condition_attr_tbl.First..g_condition_attr_tbl.Last
16922: LOOP
16923: l_persistent_id := TO_NUMBER(get_User_Attribute(l_user_attribute_value,g_condition_attr_tbl(i)));
16924: IF l_persistent_id IS NOT NULL THEN
16925: UPDATE CZ_RULES
16926: SET deleted_flag = G_YES_FLAG
16927: WHERE persistent_rule_id = l_persistent_id
16928: AND ui_def_id = p_ui_def_id
16929: AND seeded_flag = G_NO_FLAG;

Line 17811: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0'.

17807: --
17808: -- This procedure sets/propogates deleted_flag='1' from a given UI element to its subtree in CZ_UI_PAGE_ELEMENTS table.
17809: -- Also the procedure parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
17810: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
17811: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0'.
17812: -- If parameter p_delete_xml = '1' then it also deletes a corresponding XML elements.
17813: --
17814: PROCEDURE delete_UI_Subtree(p_ui_def_id IN NUMBER,
17815: p_ui_page_id IN NUMBER,

Line 17893: UPDATE CZ_RULES

17889: SET deleted_flag=G_YES_FLAG
17890: WHERE persistent_intl_text_id=i.caption_text_id AND
17891: ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
17892:
17893: UPDATE CZ_RULES
17894: SET deleted_flag=G_YES_FLAG
17895: WHERE persistent_rule_id IN(i.condition_id,i.caption_rule_id) AND
17896: ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
17897:

Line 17935: UPDATE CZ_RULES

17931: UPDATE CZ_LOCALIZED_TEXTS
17932: SET deleted_flag=G_YES_FLAG
17933: WHERE intl_text_id=l_caption_text_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
17934:
17935: UPDATE CZ_RULES
17936: SET deleted_flag=G_YES_FLAG
17937: WHERE rule_id IN(l_display_condition_id,l_caption_rule_id,l_enabled_condition_id)
17938: AND seeded_flag=G_NO_FLAG;
17939:

Line 17950: UPDATE CZ_RULES

17946: source_page_id=p_ui_page_id AND
17947: element_id=l_element_id_tbl(i) AND deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;
17948:
17949: FORALL i IN l_element_id_tbl.First..l_element_id_tbl.Last
17950: UPDATE CZ_RULES
17951: SET deleted_flag=G_YES_FLAG
17952: WHERE ui_def_id=p_ui_def_id AND
17953: ui_page_id=p_ui_page_id AND
17954: ui_page_element_id=l_element_id_tbl(i) AND

Line 18032: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0' and deletes the corresponding XML/JRAD document.

18028: --
18029: -- This procedure sets/propogates deleted_flag='1' from a given UI page to all related UI entities which belong to this page,
18030: -- parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
18031: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
18032: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0' and deletes the corresponding XML/JRAD document.
18033: --
18034: PROCEDURE delete_UI_Page(p_ui_def_id IN NUMBER, -- ui_def_id of UI
18035: p_ui_page_id IN NUMBER, -- page_id of
18036: -- UI page which needs

Line 18178: -- and CZ_RULES which have seeded_flag='0'

18174: -- For a given Local Template specified by parameters p_template_id and p_ui_def_id this procedure performs a soft deletion
18175: -- ( sets deleted_flag='1' ) of corresponding CZ_UI_TEMPLATES record and deletes the corresponding JRAD/XML document.
18176: -- It parses the corresponding XML to collect all caption intl_text_ids and UI Condition Ids and performs soft
18177: -- Delete of corresponding records in CZ_LOCALIZED_TEXTS
18178: -- and CZ_RULES which have seeded_flag='0'
18179: --
18180: PROCEDURE delete_Local_Template(p_template_ui_def_id IN NUMBER, -- ui_def_id of UI
18181: p_template_id IN NUMBER, -- template_id of
18182: -- Local UI Template which needs

Line 20517: FOR i IN(SELECT rule_id,ui_page_id,ui_page_element_id,rule_type FROM CZ_RULES a

20513: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
20514: l_page_id CZ_UI_PAGES.page_id%TYPE;
20515:
20516: BEGIN
20517: FOR i IN(SELECT rule_id,ui_page_id,ui_page_element_id,rule_type FROM CZ_RULES a
20518: WHERE ui_def_id=p_ui_def_id AND
20519: deleted_flag=G_NO_FLAG AND disabled_flag=G_NO_FLAG)
20520: LOOP
20521: