DBA Data[Home] [Help]

APPS.CZ_PSFT_INTEGRATION_PVT dependencies on CZ_ITEM_MASTERS

Line 335: TYPE osr_tbl_type IS TABLE OF cz_item_masters.orig_sys_ref%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);
336: TYPE pkg_osr_tbl_type IS TABLE OF osr_tbl_type INDEX BY VARCHAR2(15);
337:
338: TYPE cfg_msg_tbl_type IS TABLE of v2k_tbl_type INDEX BY VARCHAR2(15);-- Bug 6892148;
339:

Line 861: FROM cz_ps_nodes psn, cz_item_masters itm

857: l_type INTEGER;
858: BEGIN
859: FOR i IN (SELECT devl_project_id, ps_node_id, persistent_node_id, ps_node_type,
860: reference_id, feature_type, minimum, maximum, itm.orig_sys_ref osr
861: FROM cz_ps_nodes psn, cz_item_masters itm
862: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
863: (SELECT component_id FROM cz_model_ref_expls
864: WHERE deleted_flag = '0' AND model_id = p_model_id
865: AND (model_id = component_id OR ps_node_type = PS_NODE_TYPE_REFERENCE))