APPS.CZ_IMP_IM_XFR dependencies on CZ_PS_PROP_VALS

Line 811: SELECT ROWID FROM cz_ps_prop_vals

807: SELECT ROWID FROM cz_item_property_values
808: WHERE property_id = p_xfr_property.property_id;
809:
810: CURSOR c_ps_prop IS
811: SELECT ROWID FROM cz_ps_prop_vals
812: WHERE property_id = p_xfr_property.property_id;
813:
814: -- Make sure that the DataSet exists
815: BEGIN

Line 976: UPDATE cz_ps_prop_vals SET

972: FETCH c_ps_prop BULK COLLECT INTO t_rowid LIMIT COMMIT_SIZE;
973: EXIT WHEN c_ps_prop%NOTFOUND AND t_rowid.COUNT = 0;
974:
975: FORALL i IN 1..t_rowid.COUNT
976: UPDATE cz_ps_prop_vals SET
977: data_value = TO_CHAR(data_num_value),
978: data_num_value = NULL
979: WHERE ROWID = t_rowid(i);
980:

Line 1006: FROM cz_ps_prop_vals

1002: FROM cz_item_property_values
1003: WHERE property_id = p_xfr_property.property_id;
1004:
1005: SELECT TO_NUMBER(data_value) BULK COLLECT INTO t_value
1006: FROM cz_ps_prop_vals
1007: WHERE property_id = p_xfr_property.property_id;
1008:
1009: OPEN c_item_prop;
1010: LOOP

Line 1038: UPDATE cz_ps_prop_vals SET

1034: FETCH c_ps_prop BULK COLLECT INTO t_rowid LIMIT COMMIT_SIZE;
1035: EXIT WHEN c_ps_prop%NOTFOUND AND t_rowid.COUNT = 0;
1036:
1037: FORALL i IN 1..t_rowid.COUNT
1038: UPDATE cz_ps_prop_vals SET
1039: data_num_value = TO_NUMBER(data_value),
1040: data_value = NULL
1041: WHERE ROWID = t_rowid(i);
1042: