APPS.CZ_IMP_IM_XFR dependencies on CZ_RP_ENTRIES

Line 950: INSERT INTO cz_rp_entries

946: END;
947:
948: -- insert into an entry into cz_rp_entires for this property
949: BEGIN
950: INSERT INTO cz_rp_entries
951: (object_id,object_type,enclosing_folder,name,description)
952: VALUES (p_xfr_property.property_id,
953: 'PRP',
954: p_rp_folder_id,

Line 959: x_error:=CZ_UTILS.LOG_REPORT('Insert into cz_rp_entries FAILED. PROPERTY_ID:'|| p_xfr_property.property_id||'. '||SQLERRM,1,'CZ_IM_XFR.XFR_PROPERTY' ,11276,inRUN_ID);

955: p_xfr_property.name,
956: p_xfr_property.desc_text);
957: EXCEPTION
958: WHEN OTHERS THEN
959: x_error:=CZ_UTILS.LOG_REPORT('Insert into cz_rp_entries FAILED. PROPERTY_ID:'|| p_xfr_property.property_id||'. '||SQLERRM,1,'CZ_IM_XFR.XFR_PROPERTY' ,11276,inRUN_ID);
960: END;
961:
962: EXCEPTION
963: WHEN OTHERS THEN

Line 1169: -- update the entry for this property in cz_rp_entries

1165: SET REC_STATUS='OK'
1166: WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
1167: AND DISPOSITION='M';
1168: END;
1169: -- update the entry for this property in cz_rp_entries
1170: BEGIN
1171: UPDATE cz_rp_entries
1172: SET name = p_xfr_property.name, description = p_xfr_property.desc_text
1173: WHERE object_id = p_xfr_property.property_id

Line 1171: UPDATE cz_rp_entries

1167: AND DISPOSITION='M';
1168: END;
1169: -- update the entry for this property in cz_rp_entries
1170: BEGIN
1171: UPDATE cz_rp_entries
1172: SET name = p_xfr_property.name, description = p_xfr_property.desc_text
1173: WHERE object_id = p_xfr_property.property_id
1174: AND object_type = 'PRP';
1175: EXCEPTION

Line 1177: x_error:=CZ_UTILS.LOG_REPORT('Update of PROPERTY_ID:'|| p_xfr_property.property_id||' in cz_rp_entries FAILED. '||SQLERRM,1,'CZ_IM_XFR.XFR_PROPERTY' ,11276,inRUN_ID);

1173: WHERE object_id = p_xfr_property.property_id
1174: AND object_type = 'PRP';
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: x_error:=CZ_UTILS.LOG_REPORT('Update of PROPERTY_ID:'|| p_xfr_property.property_id||' in cz_rp_entries FAILED. '||SQLERRM,1,'CZ_IM_XFR.XFR_PROPERTY' ,11276,inRUN_ID);
1178: END;
1179: END IF;
1180: EXCEPTION WHEN INVALID_NUMBER THEN
1181: FAILED:=FAILED +1;