APPS.CZ_IMP_IM_XFR dependencies on CZ_PS_PROP_VALS

Line 851: SELECT ROWID FROM cz_ps_prop_vals

847: SELECT ROWID FROM cz_item_property_values
848: WHERE property_id = p_xfr_property.property_id;
849:
850: CURSOR c_ps_prop IS
851: SELECT ROWID FROM cz_ps_prop_vals
852: WHERE property_id = p_xfr_property.property_id;
853:
854: -- Make sure that the DataSet exists
855: BEGIN

Line 1016: UPDATE cz_ps_prop_vals SET

1012: FETCH c_ps_prop BULK COLLECT INTO t_rowid LIMIT COMMIT_SIZE;
1013: EXIT WHEN c_ps_prop%NOTFOUND AND t_rowid.COUNT = 0;
1014:
1015: FORALL i IN 1..t_rowid.COUNT
1016: UPDATE cz_ps_prop_vals SET
1017: data_value = TO_CHAR(data_num_value),
1018: data_num_value = NULL
1019: WHERE ROWID = t_rowid(i);
1020:

Line 1050: FROM cz_ps_prop_vals

1046: FROM cz_item_property_values
1047: WHERE property_id = p_xfr_property.property_id;
1048:
1049: SELECT TO_NUMBER(data_value) BULK COLLECT INTO t_value
1050: FROM cz_ps_prop_vals
1051: WHERE property_id = p_xfr_property.property_id;
1052:
1053: OPEN c_item_prop;
1054: LOOP

Line 1082: UPDATE cz_ps_prop_vals SET

1078: FETCH c_ps_prop BULK COLLECT INTO t_rowid LIMIT COMMIT_SIZE;
1079: EXIT WHEN c_ps_prop%NOTFOUND AND t_rowid.COUNT = 0;
1080:
1081: FORALL i IN 1..t_rowid.COUNT
1082: UPDATE cz_ps_prop_vals SET
1083: data_num_value = TO_NUMBER(data_value),
1084: data_value = NULL
1085: WHERE ROWID = t_rowid(i);
1086: