DBA Data[Home] [Help]

APPS.CZ_IMP_IM_XFR dependencies on CZ_RP_ENTRIES

Line 910: INSERT INTO cz_rp_entries

906: END;
907:
908: -- insert into an entry into cz_rp_entires for this property
909: BEGIN
910: INSERT INTO cz_rp_entries
911: (object_id,object_type,enclosing_folder,name,description)
912: VALUES (p_xfr_property.property_id,
913: 'PRP',
914: p_rp_folder_id,

Line 919: 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);

915: p_xfr_property.name,
916: p_xfr_property.desc_text);
917: EXCEPTION
918: WHEN OTHERS THEN
919: 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);
920: END;
921:
922: EXCEPTION
923: WHEN OTHERS THEN

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

1117: SET REC_STATUS='OK'
1118: WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
1119: AND DISPOSITION='M';
1120: END;
1121: -- update the entry for this property in cz_rp_entries
1122: BEGIN
1123: UPDATE cz_rp_entries
1124: SET name = p_xfr_property.name, description = p_xfr_property.desc_text
1125: WHERE object_id = p_xfr_property.property_id

Line 1123: UPDATE cz_rp_entries

1119: AND DISPOSITION='M';
1120: END;
1121: -- update the entry for this property in cz_rp_entries
1122: BEGIN
1123: UPDATE cz_rp_entries
1124: SET name = p_xfr_property.name, description = p_xfr_property.desc_text
1125: WHERE object_id = p_xfr_property.property_id
1126: AND object_type = 'PRP';
1127: EXCEPTION

Line 1129: 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);

1125: WHERE object_id = p_xfr_property.property_id
1126: AND object_type = 'PRP';
1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: 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);
1130: END;
1131: END IF;
1132: EXCEPTION
1133: WHEN OTHERS THEN