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 3307: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

3303:
3304: l_undeleted_exist := FALSE;
3305: FOR i IN(SELECT a.deleted_flag, a.invalid_flag, a.disabled_flag ,
3306: a.INSTANTIATION_SCOPE, b.data_value, a.name
3307: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3308: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3309: a.component_id=l_model_node.ps_node_id AND
3310: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
3311: a.deleted_flag=G_NO_FLAG AND

Line 3332: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

3328: IF l_model_node.ps_node_type=G_REFERENCE_TYPE THEN
3329:
3330: FOR i IN(SELECT a.name, a.deleted_flag, a.invalid_flag, a.disabled_flag,
3331: a.INSTANTIATION_SCOPE, b.data_value
3332: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
3333: WHERE a.devl_project_id=l_model_node.devl_project_id AND
3334: a.component_id IN
3335: (SELECT ps_node_id FROM CZ_PS_NODES
3336: WHERE devl_project_id IN

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

5393: l_source_ui_def_id := 0;
5394: ELSE
5395: l_source_ui_def_id := p_source_ui_def_id;
5396: END IF;
5397: FOR k IN(SELECT rule_id,rule_type,seeded_flag,devl_project_id FROM CZ_RULES
5398: 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
5399: AND deleted_flag=G_NO_FLAG)
5400: LOOP
5401: l_run_id := 0; l_cp_rule_run_id := 0;

Line 5421: UPDATE CZ_RULES

5417: IF p_new_component_id IS NOT NULL THEN
5418:
5419: DEBUG('Associating copied rule to a different PS Node');
5420: -- This rule is being copied and associated to a different component_id
5421: UPDATE CZ_RULES
5422: SET component_id = p_new_component_id,
5423: model_ref_expl_id = p_new_expl_node_id
5424: WHERE rule_id = x_rule_id;
5425: l_copied_rule := TRUE;

Line 5836: FROM cz_rules

5832: l_expl_node_id,
5833: p_xml_node => p_xml_node);
5834:
5835: SELECT persistent_rule_id INTO l_persistent_rule_id
5836: FROM cz_rules
5837: WHERE rule_id = l_new_rule_id;
5838:
5839:
5840: IF p_source_template_id IS NOT NULL THEN

Line 6124: FROM cz_rules

6120: IF l_id IS NOT NULL THEN
6121: copy_UI_Rule(l_id, l_new_rule_id,0 , 0, p_new_element_id,p_source_ui_def_id, p_xml_node => p_xml_node);
6122:
6123: SELECT persistent_rule_id INTO l_persistent_rule_id
6124: FROM cz_rules
6125: WHERE rule_id = l_new_rule_id;
6126:
6127:
6128: IF p_source_template_id IS NOT NULL THEN

Line 6369: FROM cz_rules

6365: p_ui_element_id => p_ui_element_id,
6366: p_source_ui_def_id => p_ui_def_id);
6367:
6368: SELECT persistent_rule_id INTO l_persistent_rule_id
6369: FROM cz_rules
6370: WHERE rule_id = l_new_refenabledCondnId;
6371:
6372:
6373: l_user_attribute3_value := l_user_attribute3_value||'|enabledCondnId='||TO_CHAR(l_persistent_rule_id)||

Line 6399: FROM cz_rules

6395: p_source_ui_def_id => p_ui_def_id);
6396:
6397: l_persistent_rule_id := null;
6398: SELECT persistent_rule_id INTO l_persistent_rule_id
6399: FROM cz_rules
6400: WHERE rule_id = l_new_refdisplayCondnId;
6401:
6402: l_user_attribute3_value := l_user_attribute3_value||'|displayCondnId='||TO_CHAR(l_persistent_rule_id)||
6403: '|displayCondnComp=' || l_refdisplayCondnComp || '|displayCondnValue='||l_refdisplayCondnValue;

Line 6786: FROM CZ_RULES

6782:
6783:
6784:
6785: FOR i in (SELECT rule_id, ui_page_element_id
6786: FROM CZ_RULES
6787: WHERE devl_project_id = g_UI_Context.devl_project_id
6788: AND ui_def_id = g_UI_Context.ui_def_id
6789: AND ui_page_id = l_src_page_id
6790: AND component_id = l_old_component_id

Line 6796: UPDATE CZ_RULES

6792: LOOP
6793: DEBUG('asp: Found rule ' || i.rule_id || ', for element ' || i.ui_page_element_Id);
6794: IF l_element_ids_tbl.EXISTS(i.ui_page_element_id) THEN
6795: DEBUG('asp: Updating rule ' || i.rule_id || ' for element_id ' || i.ui_page_element_id);
6796: UPDATE CZ_RULES
6797: SET component_id = l_component_id,
6798: ui_page_id = p_ui_node.page_id
6799: WHERE devl_project_id = g_UI_Context.devl_project_id
6800: AND rule_id = i.rule_id;

Line 9067: SELECT TEMPLATE_TOKEN INTO G_CAPTION_RULE_TOKENNAME FROM CZ_RULES

9063: template_id=G_DRILLDOWN_BUTTON_TEMPLATE_ID AND
9064: deleted_flag=G_NO_FLAG;
9065: END IF;
9066:
9067: SELECT TEMPLATE_TOKEN INTO G_CAPTION_RULE_TOKENNAME FROM CZ_RULES
9068: WHERE rule_id=G_DEFAULT_CAPTION_RULE_ID;
9069:
9070: END set_UI_Global_Entities;
9071:

Line 9468: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9464: RETURN;
9465: END IF;
9466:
9467: FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.name
9468: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9469: WHERE a.devl_project_id=p_node.devl_project_id AND
9470: a.component_id=p_node.ps_node_id AND
9471: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9472: a.deleted_flag=G_NO_FLAG AND

Line 9638: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9634:
9635: IF p_node.ps_node_type=G_REFERENCE_TYPE THEN
9636:
9637: FOR i IN(SELECT a.model_ref_expl_id, b.data_value, a.component_id, b.expr_node_id, a.name, a.INSTANTIATION_SCOPE
9638: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9639: WHERE a.devl_project_id=p_node.devl_project_id AND
9640: a.component_id IN
9641: (SELECT ps_node_id FROM CZ_PS_NODES
9642: WHERE devl_project_id IN

Line 9868: EXISTS(SELECT NULL FROM CZ_RULES

9864: WHERE devl_project_id=g_UI_Context.devl_project_id AND
9865: ui_def_id=g_UI_Context.from_master_template_id AND
9866: ps_node_type IN(G_OPTION_TYPE, G_BOM_STANDART_ITEM_TYPE) AND
9867: ui_omit=G_NO_FLAG AND deleted_flag=G_NO_FLAG AND
9868: EXISTS(SELECT NULL FROM CZ_RULES
9869: WHERE devl_project_id=g_UI_Context.devl_project_id AND
9870: component_id=a.ps_node_id AND
9871: disabled_flag=G_NO_FLAG AND
9872: deleted_flag=G_NO_FLAG))

Line 9882: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

9878: deleted_flag NOT IN(G_YES_FLAG, G_MARK_TO_DELETE, G_LIMBO_FLAG))
9879: LOOP
9880:
9881: FOR i IN(SELECT DISTINCT b.data_value, b.expr_node_id, a.INSTANTIATION_SCOPE, a.NAME
9882: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
9883: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
9884: a.component_id=option_node.ps_node_id AND
9885: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
9886: a.deleted_flag=G_NO_FLAG AND

Line 10092: FROM CZ_RULES a, CZ_EXPRESSION_NODES b

10088: (SELECT persistent_node_id
10089: FROM CZ_PS_NODES
10090: WHERE devl_project_id = g_UI_Context.devl_project_id
10091: AND ps_node_id = a.component_id) persistent_node_Id
10092: FROM CZ_RULES a, CZ_EXPRESSION_NODES b
10093: WHERE a.devl_project_id=g_UI_Context.devl_project_id AND
10094: a.rule_type=G_CZ_EXTENTSIONS_RULE_TYPE AND
10095: b.rule_id=a.rule_id AND
10096: b.argument_signature_id=G_EVENT_ON_COMMAND_SIGID AND

Line 17775: UPDATE CZ_RULES

17771: FOR i IN g_condition_attr_tbl.First..g_condition_attr_tbl.Last
17772: LOOP
17773: l_persistent_id := TO_NUMBER(get_User_Attribute(l_user_attribute_value,g_condition_attr_tbl(i)));
17774: IF l_persistent_id IS NOT NULL THEN
17775: UPDATE CZ_RULES
17776: SET deleted_flag = G_YES_FLAG
17777: WHERE persistent_rule_id = l_persistent_id
17778: AND ui_def_id = p_ui_def_id
17779: AND seeded_flag = G_NO_FLAG;

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

18713: --
18714: -- This procedure sets/propogates deleted_flag='1' from a given UI element to its subtree in CZ_UI_PAGE_ELEMENTS table.
18715: -- Also the procedure parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
18716: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
18717: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0'.
18718: -- If parameter p_delete_xml = '1' then it also deletes a corresponding XML elements.
18719: --
18720: PROCEDURE delete_UI_Subtree(p_ui_def_id IN NUMBER,
18721: p_ui_page_id IN NUMBER,

Line 18799: UPDATE CZ_RULES

18795: SET deleted_flag=G_YES_FLAG
18796: WHERE persistent_intl_text_id=i.caption_text_id AND
18797: ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
18798:
18799: UPDATE CZ_RULES
18800: SET deleted_flag=G_YES_FLAG
18801: WHERE persistent_rule_id IN(i.condition_id,i.caption_rule_id) AND
18802: ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
18803:

Line 18841: UPDATE CZ_RULES

18837: UPDATE CZ_LOCALIZED_TEXTS
18838: SET deleted_flag=G_YES_FLAG
18839: WHERE intl_text_id=l_caption_text_id AND ui_def_id=p_ui_def_id AND seeded_flag=G_NO_FLAG;
18840:
18841: UPDATE CZ_RULES
18842: SET deleted_flag=G_YES_FLAG
18843: WHERE rule_id IN(l_display_condition_id,l_caption_rule_id,l_enabled_condition_id)
18844: AND seeded_flag=G_NO_FLAG;
18845:

Line 18856: UPDATE CZ_RULES

18852: source_page_id=p_ui_page_id AND
18853: element_id=l_element_id_tbl(i) AND deleted_flag=G_NO_FLAG AND seeded_flag=G_NO_FLAG;
18854:
18855: FORALL i IN l_element_id_tbl.First..l_element_id_tbl.Last
18856: UPDATE CZ_RULES
18857: SET deleted_flag=G_YES_FLAG
18858: WHERE ui_def_id=p_ui_def_id AND
18859: ui_page_id=p_ui_page_id AND
18860: ui_page_element_id=l_element_id_tbl(i) AND

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

18934: --
18935: -- This procedure sets/propogates deleted_flag='1' from a given UI page to all related UI entities which belong to this page,
18936: -- parses the corresponding XML to collect all caption intl_text_ids, UI condtion rules ids of
18937: -- deleted UI elements and then performs a soft delete ( set deleted_flag='1' ) of corresponding records
18938: -- in tables CZ_LOCALIZED_TEXTS and CZ_RULES which have seeded_flag='0' and deletes the corresponding XML/JRAD document.
18939: --
18940: PROCEDURE delete_UI_Page(p_ui_def_id IN NUMBER, -- ui_def_id of UI
18941: p_ui_page_id IN NUMBER, -- page_id of
18942: -- UI page which needs

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

19080: -- For a given Local Template specified by parameters p_template_id and p_ui_def_id this procedure performs a soft deletion
19081: -- ( sets deleted_flag='1' ) of corresponding CZ_UI_TEMPLATES record and deletes the corresponding JRAD/XML document.
19082: -- It parses the corresponding XML to collect all caption intl_text_ids and UI Condition Ids and performs soft
19083: -- Delete of corresponding records in CZ_LOCALIZED_TEXTS
19084: -- and CZ_RULES which have seeded_flag='0'
19085: --
19086: PROCEDURE delete_Local_Template(p_template_ui_def_id IN NUMBER, -- ui_def_id of UI
19087: p_template_id IN NUMBER, -- template_id of
19088: -- Local UI Template which needs

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

21629: l_element_id CZ_UI_PAGE_ELEMENTS.element_id%TYPE;
21630: l_page_id CZ_UI_PAGES.page_id%TYPE;
21631:
21632: BEGIN
21633: FOR i IN(SELECT rule_id,ui_page_id,ui_page_element_id,rule_type FROM CZ_RULES a
21634: WHERE ui_def_id=p_ui_def_id AND
21635: deleted_flag=G_NO_FLAG AND disabled_flag=G_NO_FLAG)
21636: LOOP
21637: