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_RUNTIME dependencies on CZ_PROPERTIES

Line 29: v_property_data_type cz_properties.data_type%TYPE;

25: v_ps_nodes_tbl NUM_TBL_TYPE;
26: v_ps_nodes_ref NUM_TBL_TYPE;
27: v_ui_feat_ref NUM_TBL_TYPE;
28: v_ui_node_count NUMBER;
29: v_property_data_type cz_properties.data_type%TYPE;
30: BEGIN
31: v_ui_features_ref.DELETE;
32: v_ui_opt_meth_ref.DELETE;
33: v_ui_opt_prop_ref.DELETE;

Line 108: FROM cz_properties

104: -----get the data_type of the property
105: IF (v_ui_opt_prop_ref(i) IS NOT NULL) THEN
106: BEGIN
107: SELECT data_type INTO v_property_data_type
108: FROM cz_properties
109: WHERE cz_properties.property_id = v_ui_opt_prop_ref(i)
110: AND cz_properties.deleted_flag = '0';
111: EXCEPTION
112: WHEN OTHERS THEN

Line 109: WHERE cz_properties.property_id = v_ui_opt_prop_ref(i)

105: IF (v_ui_opt_prop_ref(i) IS NOT NULL) THEN
106: BEGIN
107: SELECT data_type INTO v_property_data_type
108: FROM cz_properties
109: WHERE cz_properties.property_id = v_ui_opt_prop_ref(i)
110: AND cz_properties.deleted_flag = '0';
111: EXCEPTION
112: WHEN OTHERS THEN
113: RAISE;

Line 110: AND cz_properties.deleted_flag = '0';

106: BEGIN
107: SELECT data_type INTO v_property_data_type
108: FROM cz_properties
109: WHERE cz_properties.property_id = v_ui_opt_prop_ref(i)
110: AND cz_properties.deleted_flag = '0';
111: EXCEPTION
112: WHEN OTHERS THEN
113: RAISE;
114: END;

Line 141: cz_properties prp1

137: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
138: from cz_ps_nodes psn1,
139: cz_ps_prop_vals psp1,
140: CZ_UI_NODES uin,
141: cz_properties prp1
142: where psn1.deleted_flag = '0'
143: and psn1.ps_node_id =psp1.ps_node_id
144: and uin.ps_node_id = psn1.ps_node_id
145: and uin.PARENT_ID = v_ui_features_ref(i)

Line 160: cz_properties prp2,

156: , prp2.def_value as default_value, uin.ui_node_id
157: from cz_ps_nodes psn2,
158: cz_ui_nodes uin,
159: cz_item_property_values ipv2,
160: cz_properties prp2,
161: cz_item_masters itm2
162: where psn2.deleted_flag = '0'
163: and psn2.item_id = ipv2.item_id
164: and ipv2.deleted_flag = '0'

Line 184: cz_properties prp3

180: cz_ps_nodes psn3,
181: cz_item_masters itm3,
182: cz_ui_nodes uin,
183: cz_item_type_properties itp3,
184: cz_properties prp3
185: where psn3.deleted_flag = '0'
186: and psn3.item_id = itm3.item_id
187: and itm3.deleted_flag = '0'
188: and itm3.item_type_id = itp3.item_type_id

Line 222: cz_properties prp1

218: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
219: from cz_ps_nodes psn1,
220: cz_ps_prop_vals psp1,
221: CZ_UI_NODES uin,
222: cz_properties prp1
223: where psn1.deleted_flag = '0'
224: and psn1.ps_node_id =psp1.ps_node_id
225: and uin.ps_node_id = psn1.ps_node_id
226: and uin.PARENT_ID = v_ui_features_ref(i)

Line 241: cz_properties prp2,

237: , prp2.def_value as default_value, uin.ui_node_id
238: from cz_ps_nodes psn2,
239: cz_ui_nodes uin,
240: cz_item_property_values ipv2,
241: cz_properties prp2,
242: cz_item_masters itm2
243: where psn2.deleted_flag = '0'
244: and psn2.item_id = ipv2.item_id
245: and ipv2.deleted_flag = '0'

Line 265: cz_properties prp3

261: cz_ps_nodes psn3,
262: cz_item_masters itm3,
263: cz_ui_nodes uin,
264: cz_item_type_properties itp3,
265: cz_properties prp3
266: where psn3.deleted_flag = '0'
267: and psn3.item_id = itm3.item_id
268: and itm3.deleted_flag = '0'
269: and itm3.item_type_id = itp3.item_type_id

Line 313: cz_properties prp1

309: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
310: from cz_ps_nodes psn1,
311: cz_ps_prop_vals psp1,
312: CZ_UI_NODES uin,
313: cz_properties prp1
314: where psn1.deleted_flag = '0'
315: and psn1.ps_node_id =psp1.ps_node_id
316: and uin.ps_node_id = psn1.ps_node_id
317: and uin.PARENT_ID = v_ui_features_ref(i)

Line 332: cz_properties prp2,

328: , prp2.def_value as default_value, uin.ui_node_id
329: from cz_ps_nodes psn2,
330: cz_ui_nodes uin,
331: cz_item_property_values ipv2,
332: cz_properties prp2,
333: cz_item_masters itm2
334: where psn2.deleted_flag = '0'
335: and psn2.item_id = ipv2.item_id
336: and ipv2.deleted_flag = '0'

Line 356: cz_properties prp3

352: cz_ps_nodes psn3,
353: cz_item_masters itm3,
354: cz_ui_nodes uin,
355: cz_item_type_properties itp3,
356: cz_properties prp3
357: where psn3.deleted_flag = '0'
358: and psn3.item_id = itm3.item_id
359: and itm3.deleted_flag = '0'
360: and itm3.item_type_id = itp3.item_type_id

Line 394: cz_properties prp1

390: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
391: from cz_ps_nodes psn1,
392: cz_ps_prop_vals psp1,
393: CZ_UI_NODES uin,
394: cz_properties prp1
395: where psn1.deleted_flag = '0'
396: and psn1.ps_node_id =psp1.ps_node_id
397: and uin.ps_node_id = psn1.ps_node_id
398: and uin.PARENT_ID = v_ui_features_ref(i)

Line 413: cz_properties prp2,

409: , prp2.def_value as default_value, uin.ui_node_id
410: from cz_ps_nodes psn2,
411: cz_ui_nodes uin,
412: cz_item_property_values ipv2,
413: cz_properties prp2,
414: cz_item_masters itm2
415: where psn2.deleted_flag = '0'
416: and psn2.item_id = ipv2.item_id
417: and ipv2.deleted_flag = '0'

Line 437: cz_properties prp3

433: cz_ps_nodes psn3,
434: cz_item_masters itm3,
435: cz_ui_nodes uin,
436: cz_item_type_properties itp3,
437: cz_properties prp3
438: where psn3.deleted_flag = '0'
439: and psn3.item_id = itm3.item_id
440: and itm3.deleted_flag = '0'
441: and itm3.item_type_id = itp3.item_type_id