[Home] [Help]
327: TYPE num_tbl_type_idx_vc2 IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
328: TYPE v2k_tbl_type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
329: TYPE psn_tbl_type IS TABLE OF NUMBER INDEX BY VARCHAR2(15);
330: TYPE prj_psn_tbl_type IS TABLE OF psn_tbl_type INDEX BY VARCHAR2(15);
331: TYPE prp_rec_type IS RECORD (name cz_properties.name%TYPE, val cz_ps_prop_vals.data_value%TYPE);
332: TYPE prp_tbl_type IS TABLE OF prp_rec_type INDEX BY BINARY_INTEGER;
333: TYPE psn_prp_tbl_type IS TABLE OF prp_tbl_type INDEX BY VARCHAR2(15);
334: TYPE prj_psn_prp_tbl_type IS TABLE OF psn_prp_tbl_type INDEX BY VARCHAR2(15);
335: TYPE osr_tbl_type IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY VARCHAR2(15);
900: BEGIN
901: FOR i IN (SELECT prp.property_id id, prp.name name, prp.data_type type, prp.def_value defval,
902: psp.data_value strval, prp.def_num_value defnumval, psp.data_num_value numval,
903: psn.devl_project_id project, psn.persistent_node_id persistentid
904: FROM cz_ps_nodes psn, cz_ps_prop_vals psp, cz_properties prp
905: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
906: (SELECT component_id FROM cz_model_ref_expls
907: WHERE deleted_flag = '0' AND model_id = p_model_id
908: AND (model_id = component_id OR ps_node_type = PS_NODE_TYPE_REFERENCE))
912: UNION ALL
913: SELECT prp.property_id id, prp.name name, prp.data_type type, deftxt.text_str defval,
914: txt.text_str strval, prp.def_num_value defnumval, psp.data_num_value numval,
915: psn.devl_project_id project, psn.persistent_node_id persistentid
916: FROM cz_ps_nodes psn, cz_ps_prop_vals psp, cz_properties prp,
917: cz_intl_texts deftxt, cz_intl_texts txt
918: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
919: (SELECT component_id FROM cz_model_ref_expls
920: WHERE deleted_flag = '0' AND model_id = p_model_id