APPS.CZ_IMP_IM_MAIN dependencies on CZ_PROPERTIES

Line 153: FROM CZ_IMP_ITEM_PROPERTY_VALUE a, cz_properties b

149: ) IS
150: CURSOR c_imp_itempropertyvalue IS
151: SELECT a.DELETED_FLAG,a.PROPERTY_VALUE,a.PROPERTY_NUM_VALUE,
152: a.FSK_PROPERTY_1_1,a.FSK_PROPERTY_1_EXT,a.ORIG_SYS_REF,a.DISPOSITION,a.REC_STATUS,b.data_type
153: FROM CZ_IMP_ITEM_PROPERTY_VALUE a, cz_properties b
154: WHERE a.REC_STATUS IS NULL AND a.RUN_ID = inRUN_ID
155: AND (b.orig_sys_ref = a.fsk_property_1_1 OR b.orig_sys_ref = a.fsk_property_1_ext)
156: AND b.deleted_flag='0';
157:

Line 177: TYPE tDataType IS TABLE OF cz_properties.data_type%TYPE INDEX BY BINARY_INTEGER;

173: TYPE tDisposition IS TABLE OF cz_imp_item_property_value.disposition%TYPE INDEX BY BINARY_INTEGER;
174: TYPE tRecStatus IS TABLE OF cz_imp_item_property_value.rec_status%TYPE INDEX BY BINARY_INTEGER;
175: TYPE tDeletedFlag IS TABLE OF cz_imp_item_property_value.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
176: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
177: TYPE tDataType IS TABLE OF cz_properties.data_type%TYPE INDEX BY BINARY_INTEGER;
178:
179: iFskProperty tFskProperty;
180: iFskPropertyExt tFskPropertyExt;
181: iOrigSysRef tOrigSysRef;

Line 1275: v_table_name VARCHAR2(30) := 'CZ_PROPERTIES';

1271:
1272: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1273: PROCEDURE RPT_PROPERTY ( inRUN_ID IN PLS_INTEGER ) AS
1274: x_error BOOLEAN:=FALSE;
1275: v_table_name VARCHAR2(30) := 'CZ_PROPERTIES';
1276: v_ok VARCHAR2(4) := 'OK';
1277: v_completed VARCHAR2(1) := '1';
1278: BEGIN
1279: BEGIN