APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_PROPERTY

Line 802: FROM CZ_IMP_property WHERE CZ_IMP_property.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

798: SELECT PROPERTY_ID,PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,DEF_NUM_VALUE,RUN_ID,
799: REC_STATUS,DISPOSITION,DELETED_FLAG,CHECKOUT_USER,
800: USER_STR01,USER_STR02,USER_STR03,USER_STR04,USER_NUM01,USER_NUM02,
801: USER_NUM03,USER_NUM04,ORIG_SYS_REF,SRC_APPLICATION_ID, rec_nbr
802: FROM CZ_IMP_property WHERE CZ_IMP_property.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
803: x_xfr_property_f BOOLEAN:=FALSE;
804: x_error BOOLEAN:=FALSE;
805:
806: p_xfr_property c_xfr_property%ROWTYPE;

Line 942: UPDATE CZ_IMP_property

938: p_xfr_property.DELETED_FLAG,p_xfr_property.CHECKOUT_USER,
939: 1, 1, NULL, p_xfr_property.ORIG_SYS_REF,p_xfr_property.SRC_APPLICATION_ID);
940: nInsertCount:=nInsertCount+1;
941: BEGIN
942: UPDATE CZ_IMP_property
943: SET REC_STATUS='OK'
944: WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
945: AND DISPOSITION='I';
946: END;

Line 966: UPDATE CZ_IMP_property

962: EXCEPTION
963: WHEN OTHERS THEN
964: FAILED:=FAILED +1;
965: BEGIN
966: UPDATE CZ_IMP_property
967: SET REC_STATUS='ERR'
968: WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
969: AND DISPOSITION='I';
970: END;

Line 1164: UPDATE CZ_IMP_property

1160: FAILED:=FAILED+1;
1161: ELSE
1162: nUpdateCount:=nUpdateCount+1;
1163: BEGIN
1164: UPDATE CZ_IMP_property
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;

Line 1183: UPDATE CZ_IMP_property

1179: END IF;
1180: EXCEPTION WHEN INVALID_NUMBER THEN
1181: FAILED:=FAILED +1;
1182: BEGIN
1183: UPDATE CZ_IMP_property
1184: SET REC_STATUS='ERR'
1185: WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
1186: AND DISPOSITION='M';
1187: END;

Line 1191: UPDATE CZ_IMP_property

1187: END;
1188: WHEN OTHERS THEN
1189: FAILED:=FAILED +1;
1190: BEGIN
1191: UPDATE CZ_IMP_property
1192: SET REC_STATUS='ERR'
1193: WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
1194: AND DISPOSITION='M';
1195: END;

Line 1201: UPDATE CZ_IMP_property

1197: END ;
1198:
1199: ELSIF (p_xfr_property.DISPOSITION = 'N') THEN
1200: BEGIN
1201: UPDATE CZ_IMP_property
1202: SET REC_STATUS='OK'
1203: WHERE PROPERTY_ID=p_xfr_property.PROPERTY_ID AND RUN_ID=inRUN_ID
1204: AND DISPOSITION='N';
1205: END;