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_PS_NODES

Line 5: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,

1: PACKAGE BODY CZ_UI_GENERATOR AS
2: /* $Header: czuigenb.pls 120.5 2007/11/26 12:12:38 kdande ship $ */
3:
4: TYPE UIStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
5: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
6: parent_id CZ_PS_NODES.parent_id%TYPE,
7: name CZ_UI_NODES.name%TYPE,
8: caption_name CZ_INTL_TEXTS.text_str%TYPE,
9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,

Line 6: parent_id CZ_PS_NODES.parent_id%TYPE,

2: /* $Header: czuigenb.pls 120.5 2007/11/26 12:12:38 kdande ship $ */
3:
4: TYPE UIStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
5: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
6: parent_id CZ_PS_NODES.parent_id%TYPE,
7: name CZ_UI_NODES.name%TYPE,
8: caption_name CZ_INTL_TEXTS.text_str%TYPE,
9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
10: tree_seq CZ_PS_NODES.tree_seq%TYPE,

Line 9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,

5: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
6: parent_id CZ_PS_NODES.parent_id%TYPE,
7: name CZ_UI_NODES.name%TYPE,
8: caption_name CZ_INTL_TEXTS.text_str%TYPE,
9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
10: tree_seq CZ_PS_NODES.tree_seq%TYPE,
11: maximum CZ_PS_NODES.maximum%TYPE,
12: minimum CZ_PS_NODES.minimum%TYPE,
13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,

Line 10: tree_seq CZ_PS_NODES.tree_seq%TYPE,

6: parent_id CZ_PS_NODES.parent_id%TYPE,
7: name CZ_UI_NODES.name%TYPE,
8: caption_name CZ_INTL_TEXTS.text_str%TYPE,
9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
10: tree_seq CZ_PS_NODES.tree_seq%TYPE,
11: maximum CZ_PS_NODES.maximum%TYPE,
12: minimum CZ_PS_NODES.minimum%TYPE,
13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,
14: reference_id CZ_PS_NODES.reference_id%TYPE,

Line 11: maximum CZ_PS_NODES.maximum%TYPE,

7: name CZ_UI_NODES.name%TYPE,
8: caption_name CZ_INTL_TEXTS.text_str%TYPE,
9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
10: tree_seq CZ_PS_NODES.tree_seq%TYPE,
11: maximum CZ_PS_NODES.maximum%TYPE,
12: minimum CZ_PS_NODES.minimum%TYPE,
13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,
14: reference_id CZ_PS_NODES.reference_id%TYPE,
15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,

Line 12: minimum CZ_PS_NODES.minimum%TYPE,

8: caption_name CZ_INTL_TEXTS.text_str%TYPE,
9: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
10: tree_seq CZ_PS_NODES.tree_seq%TYPE,
11: maximum CZ_PS_NODES.maximum%TYPE,
12: minimum CZ_PS_NODES.minimum%TYPE,
13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,
14: reference_id CZ_PS_NODES.reference_id%TYPE,
15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
16: ui_omit CZ_PS_NODES.ui_omit%TYPE,

Line 14: reference_id CZ_PS_NODES.reference_id%TYPE,

10: tree_seq CZ_PS_NODES.tree_seq%TYPE,
11: maximum CZ_PS_NODES.maximum%TYPE,
12: minimum CZ_PS_NODES.minimum%TYPE,
13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,
14: reference_id CZ_PS_NODES.reference_id%TYPE,
15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
16: ui_omit CZ_PS_NODES.ui_omit%TYPE,
17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
18:

Line 15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,

11: maximum CZ_PS_NODES.maximum%TYPE,
12: minimum CZ_PS_NODES.minimum%TYPE,
13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,
14: reference_id CZ_PS_NODES.reference_id%TYPE,
15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
16: ui_omit CZ_PS_NODES.ui_omit%TYPE,
17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
18:
19: TYPE featureStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,

Line 16: ui_omit CZ_PS_NODES.ui_omit%TYPE,

12: minimum CZ_PS_NODES.minimum%TYPE,
13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,
14: reference_id CZ_PS_NODES.reference_id%TYPE,
15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
16: ui_omit CZ_PS_NODES.ui_omit%TYPE,
17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
18:
19: TYPE featureStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
20: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,

Line 17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);

13: ui_node_ref_id CZ_UI_NODES.ui_node_ref_id%TYPE,
14: reference_id CZ_PS_NODES.reference_id%TYPE,
15: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
16: ui_omit CZ_PS_NODES.ui_omit%TYPE,
17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
18:
19: TYPE featureStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
20: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
21: parent_id CZ_PS_NODES.parent_id%TYPE,

Line 20: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,

16: ui_omit CZ_PS_NODES.ui_omit%TYPE,
17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
18:
19: TYPE featureStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
20: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
21: parent_id CZ_PS_NODES.parent_id%TYPE,
22: name CZ_UI_NODES.name%TYPE,
23: caption_name CZ_INTL_TEXTS.text_str%TYPE,
24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,

Line 21: parent_id CZ_PS_NODES.parent_id%TYPE,

17: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
18:
19: TYPE featureStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
20: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
21: parent_id CZ_PS_NODES.parent_id%TYPE,
22: name CZ_UI_NODES.name%TYPE,
23: caption_name CZ_INTL_TEXTS.text_str%TYPE,
24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,
25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,

Line 24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,

20: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
21: parent_id CZ_PS_NODES.parent_id%TYPE,
22: name CZ_UI_NODES.name%TYPE,
23: caption_name CZ_INTL_TEXTS.text_str%TYPE,
24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,
25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
26: tree_seq CZ_PS_NODES.tree_seq%TYPE,
27: maximum CZ_PS_NODES.maximum%TYPE,
28: minimum CZ_PS_NODES.minimum%TYPE,

Line 25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,

21: parent_id CZ_PS_NODES.parent_id%TYPE,
22: name CZ_UI_NODES.name%TYPE,
23: caption_name CZ_INTL_TEXTS.text_str%TYPE,
24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,
25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
26: tree_seq CZ_PS_NODES.tree_seq%TYPE,
27: maximum CZ_PS_NODES.maximum%TYPE,
28: minimum CZ_PS_NODES.minimum%TYPE,
29: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,

Line 26: tree_seq CZ_PS_NODES.tree_seq%TYPE,

22: name CZ_UI_NODES.name%TYPE,
23: caption_name CZ_INTL_TEXTS.text_str%TYPE,
24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,
25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
26: tree_seq CZ_PS_NODES.tree_seq%TYPE,
27: maximum CZ_PS_NODES.maximum%TYPE,
28: minimum CZ_PS_NODES.minimum%TYPE,
29: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
30: feature_type CZ_PS_NODES.feature_type%TYPE,

Line 27: maximum CZ_PS_NODES.maximum%TYPE,

23: caption_name CZ_INTL_TEXTS.text_str%TYPE,
24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,
25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
26: tree_seq CZ_PS_NODES.tree_seq%TYPE,
27: maximum CZ_PS_NODES.maximum%TYPE,
28: minimum CZ_PS_NODES.minimum%TYPE,
29: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
30: feature_type CZ_PS_NODES.feature_type%TYPE,
31: reference_id CZ_PS_NODES.reference_id%TYPE,

Line 28: minimum CZ_PS_NODES.minimum%TYPE,

24: counted_options_flag CZ_PS_NODES.counted_options_flag%TYPE,
25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
26: tree_seq CZ_PS_NODES.tree_seq%TYPE,
27: maximum CZ_PS_NODES.maximum%TYPE,
28: minimum CZ_PS_NODES.minimum%TYPE,
29: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
30: feature_type CZ_PS_NODES.feature_type%TYPE,
31: reference_id CZ_PS_NODES.reference_id%TYPE,
32: atp_flag BOOLEAN);

Line 29: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,

25: ps_node_type CZ_PS_NODES.ps_node_type%TYPE,
26: tree_seq CZ_PS_NODES.tree_seq%TYPE,
27: maximum CZ_PS_NODES.maximum%TYPE,
28: minimum CZ_PS_NODES.minimum%TYPE,
29: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
30: feature_type CZ_PS_NODES.feature_type%TYPE,
31: reference_id CZ_PS_NODES.reference_id%TYPE,
32: atp_flag BOOLEAN);
33:

Line 30: feature_type CZ_PS_NODES.feature_type%TYPE,

26: tree_seq CZ_PS_NODES.tree_seq%TYPE,
27: maximum CZ_PS_NODES.maximum%TYPE,
28: minimum CZ_PS_NODES.minimum%TYPE,
29: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
30: feature_type CZ_PS_NODES.feature_type%TYPE,
31: reference_id CZ_PS_NODES.reference_id%TYPE,
32: atp_flag BOOLEAN);
33:
34: TYPE optionStructure IS RECORD( id CZ_UI_NODES.ui_node_id%TYPE,

Line 31: reference_id CZ_PS_NODES.reference_id%TYPE,

27: maximum CZ_PS_NODES.maximum%TYPE,
28: minimum CZ_PS_NODES.minimum%TYPE,
29: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
30: feature_type CZ_PS_NODES.feature_type%TYPE,
31: reference_id CZ_PS_NODES.reference_id%TYPE,
32: atp_flag BOOLEAN);
33:
34: TYPE optionStructure IS RECORD( id CZ_UI_NODES.ui_node_id%TYPE,
35: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,

Line 35: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,

31: reference_id CZ_PS_NODES.reference_id%TYPE,
32: atp_flag BOOLEAN);
33:
34: TYPE optionStructure IS RECORD( id CZ_UI_NODES.ui_node_id%TYPE,
35: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
36: parent_id CZ_PS_NODES.parent_id%TYPE,
37: tree_seq CZ_PS_NODES.tree_seq%TYPE,
38: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
39: name CZ_UI_NODES.name%TYPE,

Line 36: parent_id CZ_PS_NODES.parent_id%TYPE,

32: atp_flag BOOLEAN);
33:
34: TYPE optionStructure IS RECORD( id CZ_UI_NODES.ui_node_id%TYPE,
35: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
36: parent_id CZ_PS_NODES.parent_id%TYPE,
37: tree_seq CZ_PS_NODES.tree_seq%TYPE,
38: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
39: name CZ_UI_NODES.name%TYPE,
40: caption_name CZ_INTL_TEXTS.text_str%TYPE,

Line 37: tree_seq CZ_PS_NODES.tree_seq%TYPE,

33:
34: TYPE optionStructure IS RECORD( id CZ_UI_NODES.ui_node_id%TYPE,
35: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
36: parent_id CZ_PS_NODES.parent_id%TYPE,
37: tree_seq CZ_PS_NODES.tree_seq%TYPE,
38: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
39: name CZ_UI_NODES.name%TYPE,
40: caption_name CZ_INTL_TEXTS.text_str%TYPE,
41: atp_flag BOOLEAN);

Line 38: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,

34: TYPE optionStructure IS RECORD( id CZ_UI_NODES.ui_node_id%TYPE,
35: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
36: parent_id CZ_PS_NODES.parent_id%TYPE,
37: tree_seq CZ_PS_NODES.tree_seq%TYPE,
38: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
39: name CZ_UI_NODES.name%TYPE,
40: caption_name CZ_INTL_TEXTS.text_str%TYPE,
41: atp_flag BOOLEAN);
42:

Line 44: model_id CZ_PS_NODES.devl_project_id%TYPE,

40: caption_name CZ_INTL_TEXTS.text_str%TYPE,
41: atp_flag BOOLEAN);
42:
43: TYPE refBOMStructure IS RECORD(ui_parent_id CZ_UI_NODES.parent_id%TYPE,
44: model_id CZ_PS_NODES.devl_project_id%TYPE,
45: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
46: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
47: maximum CZ_PS_NODES.maximum%TYPE,
48: minimum CZ_PS_NODES.minimum%TYPE,

Line 45: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,

41: atp_flag BOOLEAN);
42:
43: TYPE refBOMStructure IS RECORD(ui_parent_id CZ_UI_NODES.parent_id%TYPE,
44: model_id CZ_PS_NODES.devl_project_id%TYPE,
45: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
46: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
47: maximum CZ_PS_NODES.maximum%TYPE,
48: minimum CZ_PS_NODES.minimum%TYPE,
49: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);

Line 46: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,

42:
43: TYPE refBOMStructure IS RECORD(ui_parent_id CZ_UI_NODES.parent_id%TYPE,
44: model_id CZ_PS_NODES.devl_project_id%TYPE,
45: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
46: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
47: maximum CZ_PS_NODES.maximum%TYPE,
48: minimum CZ_PS_NODES.minimum%TYPE,
49: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
50:

Line 47: maximum CZ_PS_NODES.maximum%TYPE,

43: TYPE refBOMStructure IS RECORD(ui_parent_id CZ_UI_NODES.parent_id%TYPE,
44: model_id CZ_PS_NODES.devl_project_id%TYPE,
45: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
46: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
47: maximum CZ_PS_NODES.maximum%TYPE,
48: minimum CZ_PS_NODES.minimum%TYPE,
49: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
50:
51:

Line 48: minimum CZ_PS_NODES.minimum%TYPE,

44: model_id CZ_PS_NODES.devl_project_id%TYPE,
45: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
46: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
47: maximum CZ_PS_NODES.maximum%TYPE,
48: minimum CZ_PS_NODES.minimum%TYPE,
49: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
50:
51:
52: TYPE buttonsStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,

Line 49: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);

45: ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
46: intl_text_id CZ_PS_NODES.intl_text_id%TYPE,
47: maximum CZ_PS_NODES.maximum%TYPE,
48: minimum CZ_PS_NODES.minimum%TYPE,
49: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
50:
51:
52: TYPE buttonsStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
53: ps_parent_id CZ_PS_NODES.parent_id%TYPE,

Line 53: ps_parent_id CZ_PS_NODES.parent_id%TYPE,

49: virtual_flag CZ_PS_NODES.virtual_flag%TYPE);
50:
51:
52: TYPE buttonsStructure IS RECORD(id CZ_UI_NODES.ui_node_id%TYPE,
53: ps_parent_id CZ_PS_NODES.parent_id%TYPE,
54: ui_parent_id CZ_UI_NODES.parent_id%TYPE,
55: name CZ_UI_NODES.name%TYPE,
56: rel_top_pos CZ_UI_NODES.rel_top_pos%TYPE);
57:

Line 58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,

54: ui_parent_id CZ_UI_NODES.parent_id%TYPE,
55: name CZ_UI_NODES.name%TYPE,
56: rel_top_pos CZ_UI_NODES.rel_top_pos%TYPE);
57:
58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
59: ui_node_id CZ_UI_NODES.ui_node_id%TYPE,
60: text_id CZ_PS_NODES.intl_text_id%TYPE,
61: label_id CZ_UI_NODES.caption_id%TYPE,
62: label_txt_id CZ_UI_NODES.caption_id%TYPE,

Line 60: text_id CZ_PS_NODES.intl_text_id%TYPE,

56: rel_top_pos CZ_UI_NODES.rel_top_pos%TYPE);
57:
58: TYPE pageStructure IS RECORD(ps_node_id CZ_PS_NODES.ps_node_id%TYPE,
59: ui_node_id CZ_UI_NODES.ui_node_id%TYPE,
60: text_id CZ_PS_NODES.intl_text_id%TYPE,
61: label_id CZ_UI_NODES.caption_id%TYPE,
62: label_txt_id CZ_UI_NODES.caption_id%TYPE,
63: tree_label_id CZ_UI_NODES.caption_id%TYPE,
64: name CZ_UI_NODES.name%TYPE);

Line 98: Project_Id CZ_PS_NODES.devl_project_id%TYPE;

94: mCONCAT_SYMBOL VARCHAR2(10):=' , ';
95:
96: ERROR_CODE VARCHAR2(50):='0000';
97:
98: Project_Id CZ_PS_NODES.devl_project_id%TYPE;
99: Model_Id CZ_UI_DEFS.devl_project_id%TYPE;
100: UI_Product_Id CZ_UI_DEFS.component_id%TYPE;
101: current_UI_DEF_ID CZ_UI_DEFS.ui_def_id%TYPE;
102: currUISeqVal CZ_UI_NODES.ui_node_id%TYPE:=0;

Line 106: Model_Name CZ_PS_NODES.name%TYPE;

102: currUISeqVal CZ_UI_NODES.ui_node_id%TYPE:=0;
103: currentUINode CZ_UI_NODES.ui_node_id%TYPE:=mINCREMENT;
104: currTXTSeqVal CZ_INTL_TEXTS.intl_text_id%TYPE;
105: currentTXTNode CZ_INTL_TEXTS.intl_text_id%TYPE;
106: Model_Name CZ_PS_NODES.name%TYPE;
107: UI_Version PLS_INTEGER:=1;
108:
109: USABLE_WIDTH CZ_UI_NODES.width%TYPE;
110: USABLE_HEIGHT CZ_UI_NODES.height%TYPE;

Line 1335: SELECT persistent_node_id INTO var_persistent_node_id FROM CZ_PS_NODES

1331: --
1332: -- Execute CZ extension ( GENERATE OUTPUT ) --
1333: --
1334: IF in_ui_type=GENERATE_OUTPUT_EVENT THEN
1335: SELECT persistent_node_id INTO var_persistent_node_id FROM CZ_PS_NODES
1336: WHERE devl_project_id=(select devl_project_id from CZ_UI_DEFS
1337: WHERE ui_def_id=in_ui_def_id) AND ps_node_id=in_ps_node_id AND deleted_flag='0';
1338: set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);
1339: set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'ActionType','31',in_update_flag);

Line 1349: SELECT persistent_node_id INTO var_persistent_node_id FROM CZ_PS_NODES

1345: -- Execute CZ extension ( AUTOCONFIGURE ) --
1346: --
1347: IF in_ui_type=RAISE_COMMAND_EVENT THEN
1348:
1349: SELECT persistent_node_id INTO var_persistent_node_id FROM CZ_PS_NODES
1350: WHERE devl_project_id=(select devl_project_id from CZ_UI_DEFS
1351: WHERE ui_def_id=in_ui_def_id) AND ps_node_id=in_ps_node_id AND deleted_flag='0';
1352:
1353: set_UI_NODE_PROPS(in_ui_node_id,var_ui_def_id,'WindowDressing',YES_FLAG,in_update_flag);

Line 2039: var_nearest_comp_id CZ_PS_NODES.ps_node_id%TYPE;

2035:
2036: var_button_id CZ_UI_NODES.ui_node_id%TYPE;
2037: var_parent_id CZ_UI_NODES.parent_id%TYPE;
2038: var_cx_command_name CZ_UI_NODES.cx_command_name%TYPE;
2039: var_nearest_comp_id CZ_PS_NODES.ps_node_id%TYPE;
2040: var_event_scope CZ_EXPRESSION_NODES.event_execution_scope%TYPE;
2041: var_ps_parent_id CZ_PS_NODES.parent_id%TYPE;
2042: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
2043: var_component_id CZ_UI_NODES.ps_node_id%TYPE;

Line 2041: var_ps_parent_id CZ_PS_NODES.parent_id%TYPE;

2037: var_parent_id CZ_UI_NODES.parent_id%TYPE;
2038: var_cx_command_name CZ_UI_NODES.cx_command_name%TYPE;
2039: var_nearest_comp_id CZ_PS_NODES.ps_node_id%TYPE;
2040: var_event_scope CZ_EXPRESSION_NODES.event_execution_scope%TYPE;
2041: var_ps_parent_id CZ_PS_NODES.parent_id%TYPE;
2042: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
2043: var_component_id CZ_UI_NODES.ps_node_id%TYPE;
2044: var_button_type INTEGER;
2045: ind INTEGER;

Line 2042: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

2038: var_cx_command_name CZ_UI_NODES.cx_command_name%TYPE;
2039: var_nearest_comp_id CZ_PS_NODES.ps_node_id%TYPE;
2040: var_event_scope CZ_EXPRESSION_NODES.event_execution_scope%TYPE;
2041: var_ps_parent_id CZ_PS_NODES.parent_id%TYPE;
2042: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
2043: var_component_id CZ_UI_NODES.ps_node_id%TYPE;
2044: var_button_type INTEGER;
2045: ind INTEGER;
2046: var_suff VARCHAR2(10):='';

Line 2169: SELECT parent_id,ps_node_type INTO var_ps_parent_id,var_ps_node_type FROM CZ_PS_NODES

2165: BEGIN
2166:
2167: var_button_id:=getUISeqVal;
2168:
2169: SELECT parent_id,ps_node_type INTO var_ps_parent_id,var_ps_node_type FROM CZ_PS_NODES
2170: WHERE ps_node_id=i.component_id;
2171:
2172: IF var_ps_node_type IN(BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE,COMPONENT_NODE_TYPE,PRODUCT_NODE_TYPE) THEN
2173: var_nearest_comp_id := i.component_id;

Line 2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;

2544: var_height CZ_UI_NODES.height%TYPE;
2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2547: var_prev_height CZ_UI_NODES.height%TYPE;
2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;
2550: var_name CZ_PS_NODES.name%TYPE;
2551: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
2552: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;

Line 2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;

2545: var_text_label_id CZ_UI_NODES.ui_node_id%TYPE;
2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2547: var_prev_height CZ_UI_NODES.height%TYPE;
2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;
2550: var_name CZ_PS_NODES.name%TYPE;
2551: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
2552: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
2553: var_text_str CZ_INTL_TEXTS.text_str%TYPE;

Line 2550: var_name CZ_PS_NODES.name%TYPE;

2546: var_borders CZ_UI_NODES.borders%TYPE:=NO_FLAG;
2547: var_prev_height CZ_UI_NODES.height%TYPE;
2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;
2550: var_name CZ_PS_NODES.name%TYPE;
2551: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
2552: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
2553: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
2554: var_caption_name CZ_INTL_TEXTS.text_str%TYPE;

Line 2551: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;

2547: var_prev_height CZ_UI_NODES.height%TYPE;
2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;
2550: var_name CZ_PS_NODES.name%TYPE;
2551: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
2552: var_intl_text_id CZ_PS_NODES.intl_text_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;

Line 2552: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;

2548: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2549: var_root_ps_type CZ_PS_NODES.ps_node_type%TYPE;
2550: var_name CZ_PS_NODES.name%TYPE;
2551: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
2552: var_intl_text_id CZ_PS_NODES.intl_text_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;

Line 2568: FROM CZ_PS_NODES WHERE devl_project_id=in_ref_model_id AND parent_id IS NULL

2564: AND ui_node_id=in_ui_parent_id;
2565:
2566: SELECT ps_node_id,name,tree_seq,intl_text_id,ps_node_type
2567: INTO var_ps_node_id,var_name,var_tree_seq,var_intl_text_id,var_root_ps_type
2568: FROM CZ_PS_NODES WHERE devl_project_id=in_ref_model_id AND parent_id IS NULL
2569: AND deleted_flag=NO_FLAG;
2570:
2571: IF var_root_ps_type=BOM_MODEL_NODE_TYPE THEN
2572: NULL;

Line 2576: FROM CZ_PS_NODES WHERE devl_project_id=in_ref_model_id AND parent_id=in_ref_model_id

2572: NULL;
2573: ELSIF var_root_ps_type=PRODUCT_NODE_TYPE THEN
2574: SELECT ps_node_id,name,tree_seq,intl_text_id
2575: INTO var_ps_node_id,var_name,var_tree_seq,var_intl_text_id
2576: FROM CZ_PS_NODES WHERE devl_project_id=in_ref_model_id AND parent_id=in_ref_model_id
2577: AND ps_node_type=BOM_MODEL_NODE_TYPE AND deleted_flag=NO_FLAG;
2578: ELSE
2579: RETURN;
2580: END IF;

Line 2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;

2769: var_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
2770: var_butt_pos CZ_UI_NODES.rel_top_pos%TYPE;
2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2775: var_name CZ_PS_NODES.name%TYPE;
2776: var_ref_name CZ_PS_NODES.name%TYPE;
2777: var_button_name CZ_PS_NODES.name%TYPE;

Line 2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;

2770: var_butt_pos CZ_UI_NODES.rel_top_pos%TYPE;
2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2775: var_name CZ_PS_NODES.name%TYPE;
2776: var_ref_name CZ_PS_NODES.name%TYPE;
2777: var_button_name CZ_PS_NODES.name%TYPE;
2778: var_ui_name CZ_PS_NODES.name%TYPE;

Line 2775: var_name CZ_PS_NODES.name%TYPE;

2771: var_left_pos CZ_UI_NODES.rel_left_pos%TYPE;
2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2775: var_name CZ_PS_NODES.name%TYPE;
2776: var_ref_name CZ_PS_NODES.name%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;

Line 2776: var_ref_name CZ_PS_NODES.name%TYPE;

2772: var_ui_tempo CZ_UI_NODES.ui_node_ref_id%TYPE;
2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2775: var_name CZ_PS_NODES.name%TYPE;
2776: var_ref_name CZ_PS_NODES.name%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;

Line 2777: var_button_name CZ_PS_NODES.name%TYPE;

2773: var_ps_id CZ_PS_NODES.ps_node_id%TYPE;
2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2775: var_name CZ_PS_NODES.name%TYPE;
2776: var_ref_name CZ_PS_NODES.name%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;

Line 2778: var_ui_name CZ_PS_NODES.name%TYPE;

2774: var_ref_id CZ_PS_NODES.reference_id%TYPE;
2775: var_name CZ_PS_NODES.name%TYPE;
2776: var_ref_name CZ_PS_NODES.name%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;

Line 2779: var_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

2775: var_name CZ_PS_NODES.name%TYPE;
2776: var_ref_name CZ_PS_NODES.name%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;

Line 2780: var_model_id CZ_PS_NODES.devl_project_id%TYPE;

2776: var_ref_name CZ_PS_NODES.name%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;

Line 2804: SELECT name INTO var_name FROM CZ_PS_NODES

2800:
2801: RAISE NO_MODEL_REF_EXPL_ID;
2802: END;
2803:
2804: SELECT name INTO var_name FROM CZ_PS_NODES
2805: WHERE ps_node_id=in_arr.reference_id AND deleted_flag=NO_FLAG;
2806: out_ref_ui_id:=get_last_UI(in_arr.reference_id);
2807: ERROR_CODE:='00193';
2808:

Line 2847: FROM CZ_PS_NODES

2843: IF mUI_STYLE=DHTML_STYLE_UI THEN
2844: var_model_id:=in_arr.reference_id;
2845:
2846: SELECT ps_node_type INTO var_ps_node_type
2847: FROM CZ_PS_NODES
2848: WHERE devl_project_id=var_model_id
2849: AND parent_id IS NULL AND deleted_flag=NO_FLAG;
2850: ERROR_CODE:='00197';
2851:

Line 4183: var_ref_label_id CZ_PS_NODES.intl_text_id%TYPE;

4179: var_txt_id CZ_UI_NODES.caption_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;

Line 4282: FROM CZ_PS_NODES

4278: var_txt_id:=getTXTSeqVal;
4279:
4280: SELECT name,intl_text_id
4281: INTO var_ref_name,var_ref_label_id
4282: FROM CZ_PS_NODES
4283: WHERE ps_node_id=in_arr.reference_id AND deleted_flag=NO_FLAG;
4284:
4285: var_button_name:=CZ_CONNECTOR_BUTTON_CAPTION||' '||var_ref_name;
4286:

Line 4945: SELECT parent_id INTO var_model_id FROM CZ_PS_NODES

4941: in_show_all_nodes =>in_show_all_nodes);
4942:
4943: ERROR_CODE:='0005';
4944:
4945: SELECT parent_id INTO var_model_id FROM CZ_PS_NODES
4946: WHERE ps_node_id=in_product_id;
4947:
4948: ERROR_CODE:='0006';
4949:

Line 4959: ui_omit,item_id,feature_type,intl_text_id,reference_id,virtual_flag,orig_sys_ref FROM CZ_PS_NODES

4955:
4956: FOR i IN
4957: (SELECT ps_node_id,parent_id,name,ps_node_type,
4958: tree_seq,counted_options_flag,maximum,minimum,
4959: ui_omit,item_id,feature_type,intl_text_id,reference_id,virtual_flag,orig_sys_ref FROM CZ_PS_NODES
4960: WHERE devl_project_id=Project_Id AND ps_node_type
4961: in (PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,FEATURE_NODE_TYPE,RESOURCE_NODE_TYPE,TOTAL_NODE_TYPE,OPTION_NODE_TYPE,
4962: BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE,BOM_STANDART_NODE_TYPE,REFERENCE_NODE_TYPE,CONNECTOR_NODE_TYPE)
4963: START WITH ps_node_id=in_product_id

Line 5796: maximum,minimum,ui_omit,intl_text_id,reference_id FROM CZ_PS_NODES

5792: ERROR_CODE:='2002';
5793:
5794: FOR i IN
5795: (SELECT ps_node_id,parent_id,ps_node_type,name,counted_options_flag,tree_seq,
5796: maximum,minimum,ui_omit,intl_text_id,reference_id FROM CZ_PS_NODES
5797: WHERE devl_project_id=Project_Id AND ps_node_type
5798: in (BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE,BOM_STANDART_NODE_TYPE,REFERENCE_NODE_TYPE)
5799: START WITH ps_node_id=in_product_id
5800: CONNECT BY PRIOR ps_node_id=parent_id AND (ui_omit=NO_FLAG OR in_show_all_nodes=YES_FLAG)

Line 5838: SELECT ps_node_id INTO temp_node FROM CZ_PS_NODES

5834: boms(i.ps_node_id).intl_text_id:=i.intl_text_id;
5835:
5836: IF i.ps_node_type=REFERENCE_NODE_TYPE THEN
5837: BEGIN
5838: SELECT ps_node_id INTO temp_node FROM CZ_PS_NODES
5839: WHERE devl_project_id=i.reference_id AND ps_node_type=BOM_MODEL_NODE_TYPE AND deleted_flag='0';
5840: boms(i.ps_node_id).reference_id:=i.reference_id;
5841: EXCEPTION
5842: WHEN NO_DATA_FOUND THEN

Line 6012: var_ui_visible CZ_PS_NODES.ui_omit%TYPE;

6008: curr_ui_node INTEGER;
6009: var_ui_root_id INTEGER;
6010: ui_product_id INTEGER;
6011:
6012: var_ui_visible CZ_PS_NODES.ui_omit%TYPE;
6013:
6014: FrameSet1_Id CZ_UI_NODES.ui_node_id%TYPE;
6015: FrameSet2_Id CZ_UI_NODES.ui_node_id%TYPE;
6016: FrameSet3_Id CZ_UI_NODES.ui_node_id%TYPE;

Line 6661: SELECT reference_id INTO var_reference_id FROM CZ_PS_NODES

6657: LOOP
6658: --
6659: -- find devl_project_id of referenced Model
6660: --
6661: SELECT reference_id INTO var_reference_id FROM CZ_PS_NODES
6662: WHERE ps_node_id=i.component_id AND deleted_flag=NO_FLAG;
6663:
6664: --
6665: -- find latest UI of reference Model with the same UI type

Line 6725: SELECT virtual_flag INTO var_virt_flag FROM CZ_PS_NODES

6721: WHEN NO_DATA_FOUND THEN
6722: NULL;
6723: END;
6724:
6725: SELECT virtual_flag INTO var_virt_flag FROM CZ_PS_NODES
6726: WHERE ps_node_id=i.ps_node_id AND deleted_flag=NO_FLAG;
6727:
6728: IF existsDeleteMe=NO_FLAG AND var_virt_flag=NO_FLAG THEN
6729: SELECT ui_node_id INTO var_ui_root_id FROM CZ_UI_NODES

Line 6803: SELECT ui_omit,deleted_flag,parent_id INTO var_ui_omit,var_deleted_flag,var_next_id FROM CZ_PS_NODES

6799: BEGIN
6800: BEGIN
6801: curr_ps_node_id:=in_parent_id;
6802: LOOP
6803: SELECT ui_omit,deleted_flag,parent_id INTO var_ui_omit,var_deleted_flag,var_next_id FROM CZ_PS_NODES
6804: WHERE ps_node_id=curr_ps_node_id;
6805: IF var_ui_omit=YES_FLAG OR var_deleted_flag=YES_FLAG THEN
6806: Flag:=YES_FLAG;
6807: EXIT;

Line 6864: FOR i IN (SELECT ps_node_id,parent_id,ps_node_type,tree_seq FROM CZ_PS_NODES

6860:
6861: SELECT ui_node_id INTO var_limbo_id FROM CZ_UI_NODES
6862: WHERE ui_def_id=in_ui_def_id AND name='Limbo' AND deleted_flag=NO_FLAG;
6863:
6864: FOR i IN (SELECT ps_node_id,parent_id,ps_node_type,tree_seq FROM CZ_PS_NODES
6865: WHERE devl_project_id=in_project_id AND deleted_flag=NO_FLAG)
6866: LOOP
6867: var_choose_conn:=NULL;
6868: IF i.ps_node_type=REFERENCE_NODE_TYPE THEN

Line 7252: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=in_project_id AND

7248: UPDATE CZ_UI_NODES SET parent_id=var_new_limbo_id WHERE
7249: ui_def_id=in_new_def_id AND ui_node_ref_id IN(SELECT ui_node_id FROM CZ_UI_NODES
7250: WHERE ui_def_id=in_new_def_id AND parent_id=var_new_limbo_id) AND ui_node_type=UI_COMPONENT_REF_TYPE;
7251:
7252: FOR i IN(SELECT ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=in_project_id AND
7253: ps_node_type IN(PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,
7254: BOM_MODEL_NODE_TYPE,BOM_CLASS_NODE_TYPE) AND deleted_flag=NO_FLAG)
7255: LOOP
7256: UPDATE CZ_UI_NODES SET deleted_flag='1' WHERE ui_def_id=in_new_def_id AND

Line 7263: FOR i IN(SELECT * FROM CZ_PS_NODES WHERE devl_project_id=in_project_id AND deleted_flag=NO_FLAG)

7259: AND ui_node_type NOT IN(UI_FEATURE_TYPE,UI_RESOURCE_TYPE,UI_TOTAL_TYPE,UI_BOM_STANDART_TYPE)
7260: AND parent_id<>var_new_limbo_id;
7261: END LOOP;
7262:
7263: FOR i IN(SELECT * FROM CZ_PS_NODES WHERE devl_project_id=in_project_id AND deleted_flag=NO_FLAG)
7264: LOOP
7265: IF i.ps_node_type IN (PRODUCT_NODE_TYPE,COMPONENT_NODE_TYPE,BOM_MODEL_NODE_TYPE,
7266: BOM_CLASS_NODE_TYPE) THEN
7267: BEGIN

Line 7464: FOR i IN (SELECT ps_node_id FROM CZ_PS_NODES

7460:
7461: --
7462: -- deleting nodes from PS Tree case --
7463: --
7464: FOR i IN (SELECT ps_node_id FROM CZ_PS_NODES
7465: WHERE devl_project_id=in_project_id
7466: AND (deleted_flag=YES_FLAG OR (ui_omit=YES_FLAG AND mSHOW_ALL_NODES='0')))
7467: LOOP
7468: --

Line 7486: FOR i IN(SELECT b.ui_node_id FROM CZ_PS_NODES a,CZ_UI_NODES b

7482: remove_UI_Subtree(l.ui_node_id,l.ui_node_type);
7483: END LOOP;
7484: END LOOP;
7485:
7486: FOR i IN(SELECT b.ui_node_id FROM CZ_PS_NODES a,CZ_UI_NODES b
7487: WHERE b.ui_def_id=in_ui_def_id AND a.ps_node_id=b.ps_node_id
7488: AND a.ps_node_type=437 AND b.ui_node_type=UI_BOM_OPTION_CLASS_TYPE AND b.page_number<>1 AND
7489: NOT EXISTS(SELECT NULL FROM CZ_UI_NODES WHERE ui_def_id=in_ui_def_id
7490: AND parent_id=b.ui_node_id AND ui_node_type=UI_BOM_STANDART_TYPE AND deleted_flag=NO_FLAG))

Line 7519: FUNCTION get_Property_Value(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,

7515:
7516: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7517: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
7518:
7519: FUNCTION get_Property_Value(p_node_id IN cz_ps_nodes.ps_node_id%TYPE,
7520: p_property_id IN cz_properties.property_id%TYPE,
7521: p_item_id IN cz_item_masters.item_id%TYPE)
7522: RETURN VARCHAR2 IS
7523: TYPE tStringArray IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;

Line 7573: v_item_id CZ_PS_NODES.item_id%TYPE;

7569:
7570: FUNCTION getTextByProperty(p_ps_node_id IN NUMBER,p_ui_node_id IN NUMBER) RETURN VARCHAR2 IS
7571:
7572: v_property_id CZ_PROPERTIES.property_id%TYPE;
7573: v_item_id CZ_PS_NODES.item_id%TYPE;
7574:
7575: BEGIN -- sselahi
7576: v_property_id:=TO_NUMBER(getUseLabelsProperty(p_ui_node_id,'LabelProperty'));
7577:

Line 7578: SELECT item_id INTO v_item_id FROM CZ_PS_NODES

7574:
7575: BEGIN -- sselahi
7576: v_property_id:=TO_NUMBER(getUseLabelsProperty(p_ui_node_id,'LabelProperty'));
7577:
7578: SELECT item_id INTO v_item_id FROM CZ_PS_NODES
7579: WHERE ps_node_id=p_ps_node_id;
7580:
7581: RETURN get_Property_Value(p_node_id => p_ps_node_id,
7582: p_property_id => v_property_id,

Line 7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;

7692: var_screen_top_pos CZ_UI_NODES.rel_top_pos%TYPE;
7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7697: var_parent_name CZ_PS_NODES.name%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;

Line 7697: var_parent_name CZ_PS_NODES.name%TYPE;

7693: var_ui_node_type CZ_UI_NODES.ui_node_type%TYPE;
7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7697: var_parent_name CZ_PS_NODES.name%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;

Line 7698: var_curr_max CZ_PS_NODES.maximum%TYPE;

7694: var_screen_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7697: var_parent_name CZ_PS_NODES.name%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;

Line 7699: var_curr_min CZ_PS_NODES.minimum%TYPE;

7695: var_oc_standart_item CZ_UI_NODES.ui_node_id%TYPE;
7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7697: var_parent_name CZ_PS_NODES.name%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;

Line 7700: var_ref_name CZ_PS_NODES.name%TYPE;

7696: var_tree_seq CZ_PS_NODES.tree_seq%TYPE;
7697: var_parent_name CZ_PS_NODES.name%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;

Line 7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;

7697: var_parent_name CZ_PS_NODES.name%TYPE;
7698: var_curr_max CZ_PS_NODES.maximum%TYPE;
7699: var_curr_min CZ_PS_NODES.minimum%TYPE;
7700: var_ref_name CZ_PS_NODES.name%TYPE;
7701: var_ref_caption_id CZ_PS_NODES.intl_text_id%TYPE;
7702: var_inst_ui_id CZ_UI_NODES.ui_node_id%TYPE;
7703: var_inst_parent_id CZ_UI_NODES.parent_id%TYPE;
7704: var_inst_ps_id CZ_UI_NODES.ps_node_id%TYPE;
7705: var_inst_top_pos CZ_UI_NODES.rel_top_pos%TYPE;

Line 7739: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;

7735: var_ui_counted_options VARCHAR2(1);
7736: BomType VARCHAR2(1);
7737: v_just_OC VARCHAR2(1);
7738:
7739: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
7740: var_name CZ_PS_NODES.name%TYPE;
7741: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
7742: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
7743: var_option_ui_name CZ_UI_NODES.NAME%TYPE;

Line 7740: var_name CZ_PS_NODES.name%TYPE;

7736: BomType VARCHAR2(1);
7737: v_just_OC VARCHAR2(1);
7738:
7739: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
7740: var_name CZ_PS_NODES.name%TYPE;
7741: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
7742: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
7743: var_option_ui_name CZ_UI_NODES.NAME%TYPE;
7744: var_button_label CZ_INTL_TEXTS.TEXT_STR%TYPE;

Line 7741: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;

7737: v_just_OC VARCHAR2(1);
7738:
7739: var_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
7740: var_name CZ_PS_NODES.name%TYPE;
7741: var_intl_text_id CZ_PS_NODES.intl_text_id%TYPE;
7742: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
7743: var_option_ui_name CZ_UI_NODES.NAME%TYPE;
7744: var_button_label CZ_INTL_TEXTS.TEXT_STR%TYPE;
7745: var_screen_name CZ_UI_NODES.NAME%TYPE;

Line 7751: var_ps_node_type CZ_PS_NODES.ps_node_type%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;
7755: NO_LIMBO_NODE EXCEPTION;

Line 7920: EXISTS(SELECT NULL FROM CZ_PS_NODES

7916:
7917: deletedNodes:=0;
7918:
7919: SELECT COUNT('1') INTO deletedNodes FROM dual WHERE
7920: EXISTS(SELECT NULL FROM CZ_PS_NODES
7921: WHERE devl_project_id=Project_Id AND
7922: (ui_omit=YES_FLAG OR deleted_flag=YES_FLAG));
7923:
7924: IF deletedNodes>0 THEN

Line 7953: AND (NOT EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=Project_Id AND

7949: /* *** remove all UI nodes associated with unexisting PS nodes *** */
7950:
7951: FOR i IN (SELECT ui_node_id,ui_node_type,deleted_flag FROM CZ_UI_NODES a
7952: WHERE ui_def_id=in_ui_def_id AND ps_node_id IS NOT NULL AND ui_node_type<>141
7953: AND (NOT EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=Project_Id AND
7954: ps_node_id=a.ps_node_id AND deleted_flag=NO_FLAG) OR a.deleted_flag=YES_FLAG))
7955: LOOP
7956: BEGIN
7957: IF i.ui_node_type IN(UI_BUTTON_TYPE,UI_PICTURE_TYPE,UI_REFERENCE_REF_TYPE) THEN

Line 7977: feature_type,ui_omit,tree_seq,item_id,orig_sys_ref FROM CZ_PS_NODES

7973:
7974:
7975: FOR i IN (SELECT ps_node_id,parent_id,ps_node_type,reference_id,
7976: maximum,minimum,name,intl_text_id,counted_options_flag,virtual_flag,
7977: feature_type,ui_omit,tree_seq,item_id,orig_sys_ref FROM CZ_PS_NODES
7978: WHERE devl_project_id=Project_Id AND deleted_flag=NO_FLAG
7979: AND ui_omit=NO_FLAG)
7980: LOOP
7981: BEGIN

Line 8354: INTO var_ref_name,var_ref_caption_id FROM CZ_PS_NODES

8350: END;
8351:
8352: BEGIN
8353: SELECT name,intl_text_id
8354: INTO var_ref_name,var_ref_caption_id FROM CZ_PS_NODES
8355: WHERE devl_project_id=var_ref_model_id AND parent_id IS NULL
8356: AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=var_ref_model_id
8357: AND ps_node_type=BOM_MODEL_NODE_TYPE AND deleted_flag=NO_FLAG) AND deleted_flag=NO_FLAG;
8358: BomType:=YES_FLAG;

Line 8356: AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=var_ref_model_id

8352: BEGIN
8353: SELECT name,intl_text_id
8354: INTO var_ref_name,var_ref_caption_id FROM CZ_PS_NODES
8355: WHERE devl_project_id=var_ref_model_id AND parent_id IS NULL
8356: AND EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=var_ref_model_id
8357: AND ps_node_type=BOM_MODEL_NODE_TYPE AND deleted_flag=NO_FLAG) AND deleted_flag=NO_FLAG;
8358: BomType:=YES_FLAG;
8359: EXCEPTION
8360: WHEN NO_DATA_FOUND THEN

Line 9164: FOR m IN(SELECT ps_node_id,intl_text_id,tree_seq,name FROM CZ_PS_NODES

9160:
9161: --
9162: -- Update Options Labels --
9163: --
9164: FOR m IN(SELECT ps_node_id,intl_text_id,tree_seq,name FROM CZ_PS_NODES
9165: WHERE devl_project_id=Project_Id
9166: AND parent_id=i.ps_node_id AND deleted_flag=NO_FLAG AND ui_omit=NO_FLAG)
9167: LOOP
9168: BEGIN

Line 9673: SELECT COUNT(ps_node_id) INTO options_number FROM CZ_PS_NODES

9669: IF NOT(temp.EXISTS(features(k).parent_id)) THEN
9670: temp(features(k).parent_id):=features(k).parent_id;
9671: END IF;
9672: IF features(k).counted_options_flag=YES_FLAG OR features(k).maximum>1 OR features(k).maximum IS NULL THEN
9673: SELECT COUNT(ps_node_id) INTO options_number FROM CZ_PS_NODES
9674: WHERE parent_id=features(k).ps_node_id AND deleted_flag=NO_FLAG;
9675: var_feature_height:=DEFAULT_CONTROL_HEIGHT*options_number+DEFAULT_CONTROL_HEIGHT;
9676: ELSE
9677: var_feature_height:=DEFAULT_CONTROL_HEIGHT;

Line 9773: SELECT ps_node_type INTO var_ps_node_type FROM CZ_PS_NODES

9769: BEGIN
9770:
9771: t_pages.Delete;
9772:
9773: SELECT ps_node_type INTO var_ps_node_type FROM CZ_PS_NODES
9774: WHERE ps_node_id=boms(k).parent_id;
9775:
9776: /* *** use latest page for adding new STANDART ITEMS *** */
9777: FOR e IN(SELECT ui_node_id,ps_node_id FROM CZ_UI_NODES WHERE

Line 9796: FROM CZ_PS_NODES

9792: ui_node_type=UI_COMPONENT_REF_TYPE AND deleted_flag=NO_FLAG;
9793:
9794: SELECT intl_text_id,tree_seq,name
9795: INTO var_intl_text_id,var_tree_seq,var_parent_name
9796: FROM CZ_PS_NODES
9797: WHERE ps_node_id=boms(k).parent_id;
9798:
9799: var_width:=set_Text_Width(boms(k).caption_name)+80;
9800: IF var_width<=USABLE_WIDTH THEN

Line 10145: -- with CZ_PS_NODES.tree_seq

10141: END IF;
10142:
10143: --
10144: -- synchronize CZ_UI_NODES.tree_seq of Component Tree nodes
10145: -- with CZ_PS_NODES.tree_seq
10146: --
10147: SELECT mMAX_NUMBER_PAGES*a.tree_seq,b.ui_node_id,b.ps_node_id,mMAX_NUMBER_PAGES*a.tree_seq-b.tree_seq
10148: BULK COLLECT INTO t_tree_seq_tbl,t_ui_node_id_tbl,t_ps_node_id_tbl,t_tree_seq_delta_tbl
10149: FROM CZ_PS_NODES a,CZ_UI_NODES b

Line 10149: FROM CZ_PS_NODES a,CZ_UI_NODES b

10145: -- with CZ_PS_NODES.tree_seq
10146: --
10147: SELECT mMAX_NUMBER_PAGES*a.tree_seq,b.ui_node_id,b.ps_node_id,mMAX_NUMBER_PAGES*a.tree_seq-b.tree_seq
10148: BULK COLLECT INTO t_tree_seq_tbl,t_ui_node_id_tbl,t_ps_node_id_tbl,t_tree_seq_delta_tbl
10149: FROM CZ_PS_NODES a,CZ_UI_NODES b
10150: WHERE b.ui_def_id=in_ui_def_id AND a.devl_project_id=Project_Id AND
10151: a.deleted_flag=NO_FLAG AND b.deleted_flag=NO_FLAG
10152: AND a.ps_node_id=b.ps_node_id AND b.ui_node_type IN(UI_COMPONENT_REF_TYPE,UI_REFERENCE_REF_TYPE) AND b.tree_seq <> mMAX_NUMBER_PAGES*a.tree_seq;
10153:

Line 10236: var_name CZ_PS_NODES.name%TYPE;

10232: PROCEDURE update_Labels
10233: (in_ui_node_id IN INTEGER,
10234: in_use_labels IN VARCHAR2) IS
10235:
10236: var_name CZ_PS_NODES.name%TYPE;
10237: var_keep_it VARCHAR2(1):=NO_FLAG;
10238:
10239: BEGIN
10240: FOR i IN (SELECT a.ui_node_id,a.ps_node_id,a.caption_id,b.name,c.localized_str,c.language

Line 10241: FROM CZ_UI_NODES a,CZ_PS_NODES b, CZ_LOCALIZED_TEXTS c

10237: var_keep_it VARCHAR2(1):=NO_FLAG;
10238:
10239: BEGIN
10240: FOR i IN (SELECT a.ui_node_id,a.ps_node_id,a.caption_id,b.name,c.localized_str,c.language
10241: FROM CZ_UI_NODES a,CZ_PS_NODES b, CZ_LOCALIZED_TEXTS c
10242: WHERE a.parent_id=in_ui_node_id AND
10243: a.ui_node_type IN (UI_OPTION_TYPE,UI_BOM_STANDART_TYPE)
10244: AND a.deleted_flag=NO_FLAG AND a.ps_node_id=b.ps_node_id
10245: AND b.intl_text_id=c.intl_text_id)