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_IMP_IM_MAIN dependencies on CZ_IMP_ITEM_PROPERTY_VALUE

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 168: TYPE tPropertyValue IS TABLE OF cz_imp_item_property_value.property_value%TYPE INDEX BY BINARY_INTEGER;

164: p_imp_itempropertyvalue c_imp_itempropertyvalue%ROWTYPE;
165: x_imp_itempropertyvalue_f BOOLEAN:=FALSE;
166: xERROR BOOLEAN:=FALSE;
167:
168: TYPE tPropertyValue IS TABLE OF cz_imp_item_property_value.property_value%TYPE INDEX BY BINARY_INTEGER;
169: TYPE tPropertyNumValue IS TABLE OF cz_imp_item_property_value.property_num_value%TYPE INDEX BY BINARY_INTEGER;
170: TYPE tFskProperty IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;
172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;

Line 169: TYPE tPropertyNumValue IS TABLE OF cz_imp_item_property_value.property_num_value%TYPE INDEX BY BINARY_INTEGER;

165: x_imp_itempropertyvalue_f BOOLEAN:=FALSE;
166: xERROR BOOLEAN:=FALSE;
167:
168: TYPE tPropertyValue IS TABLE OF cz_imp_item_property_value.property_value%TYPE INDEX BY BINARY_INTEGER;
169: TYPE tPropertyNumValue IS TABLE OF cz_imp_item_property_value.property_num_value%TYPE INDEX BY BINARY_INTEGER;
170: TYPE tFskProperty IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;
172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;
173: TYPE tDisposition IS TABLE OF cz_imp_item_property_value.disposition%TYPE INDEX BY BINARY_INTEGER;

Line 170: TYPE tFskProperty IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;

166: xERROR BOOLEAN:=FALSE;
167:
168: TYPE tPropertyValue IS TABLE OF cz_imp_item_property_value.property_value%TYPE INDEX BY BINARY_INTEGER;
169: TYPE tPropertyNumValue IS TABLE OF cz_imp_item_property_value.property_num_value%TYPE INDEX BY BINARY_INTEGER;
170: TYPE tFskProperty IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;
172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%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;

Line 171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;

167:
168: TYPE tPropertyValue IS TABLE OF cz_imp_item_property_value.property_value%TYPE INDEX BY BINARY_INTEGER;
169: TYPE tPropertyNumValue IS TABLE OF cz_imp_item_property_value.property_num_value%TYPE INDEX BY BINARY_INTEGER;
170: TYPE tFskProperty IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;
172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%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;

Line 172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;

168: TYPE tPropertyValue IS TABLE OF cz_imp_item_property_value.property_value%TYPE INDEX BY BINARY_INTEGER;
169: TYPE tPropertyNumValue IS TABLE OF cz_imp_item_property_value.property_num_value%TYPE INDEX BY BINARY_INTEGER;
170: TYPE tFskProperty IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;
172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%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;

Line 173: TYPE tDisposition IS TABLE OF cz_imp_item_property_value.disposition%TYPE INDEX BY BINARY_INTEGER;

169: TYPE tPropertyNumValue IS TABLE OF cz_imp_item_property_value.property_num_value%TYPE INDEX BY BINARY_INTEGER;
170: TYPE tFskProperty IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;
172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%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;

Line 174: TYPE tRecStatus IS TABLE OF cz_imp_item_property_value.rec_status%TYPE INDEX BY BINARY_INTEGER;

170: TYPE tFskProperty IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;
172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%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:

Line 175: TYPE tDeletedFlag IS TABLE OF cz_imp_item_property_value.deleted_flag%TYPE INDEX BY BINARY_INTEGER;

171: TYPE tFskPropertyExt IS TABLE OF cz_imp_item_property_value.fsk_property_1_ext%TYPE INDEX BY BINARY_INTEGER;
172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%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;

Line 176: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

172: TYPE tFskItemMaster IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%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;

Line 246: UPDATE cz_imp_item_property_value

242: 1,'EXTR_ITEM_PROPERTY_VALUES',11276,inRun_ID);
243: END;
244: END LOOP;
245: FORALL i IN iDeletedFlag.FIRST..iDeletedFlag.LAST
246: UPDATE cz_imp_item_property_value
247: SET deleted_flag = iDeletedFlag(i),
248: property_value = iPropertyValue(i),
249: property_num_value = iPropertyNumValue(i),
250: disposition = iDisposition(i),

Line 1078: FROM CZ_IMP_item_property_value

1074:
1075: DECLARE
1076: CURSOR c_xfr_run_result IS
1077: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1078: FROM CZ_IMP_item_property_value
1079: WHERE RUN_ID = inRUN_ID
1080: GROUP BY DISPOSITION,REC_STATUS;
1081:
1082: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;