APPS.CZ_IMP_AC_XFR dependencies on CZ_IMP_USER_GROUP

Line 1224: FROM CZ_IMP_USER_GROUP

1220: ) IS
1221: BEGIN
1222: DECLARE CURSOR c_xfr_usergroup IS
1223: SELECT *
1224: FROM CZ_IMP_USER_GROUP
1225: WHERE CZ_IMP_USER_GROUP.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
1226: x_xfr_usergroup_f BOOLEAN:=FALSE;
1227: x_error BOOLEAN:=FALSE;
1228: p_xfr_usergroup c_xfr_usergroup%ROWTYPE;

Line 1225: WHERE CZ_IMP_USER_GROUP.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

1221: BEGIN
1222: DECLARE CURSOR c_xfr_usergroup IS
1223: SELECT *
1224: FROM CZ_IMP_USER_GROUP
1225: WHERE CZ_IMP_USER_GROUP.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
1226: x_xfr_usergroup_f BOOLEAN:=FALSE;
1227: x_error BOOLEAN:=FALSE;
1228: p_xfr_usergroup c_xfr_usergroup%ROWTYPE;
1229: -- Internal vars --

Line 1302: UPDATE CZ_IMP_user_group

1298: p_xfr_usergroup.DELETED_FLAG, SYSDATE,
1299: SYSDATE, 1, 1, NULL,p_xfr_usergroup.CHECKOUT_USER);
1300: nInsertCount:=nInsertCount+1;
1301: BEGIN
1302: UPDATE CZ_IMP_user_group
1303: SET REC_STATUS='OK'
1304: WHERE USER_GROUP_ID=p_xfr_usergroup.USER_GROUP_ID AND RUN_ID=inRUN_ID;
1305: END;
1306: EXCEPTION

Line 1310: UPDATE CZ_IMP_user_group

1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: nFailed:=nFailed +1;
1309: BEGIN
1310: UPDATE CZ_IMP_user_group
1311: SET REC_STATUS='ERR'
1312: WHERE USER_GROUP_ID=p_xfr_usergroup.USER_GROUP_ID AND RUN_ID=inRUN_ID;
1313: END;
1314: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_USER_GROUP',11276);

Line 1341: UPDATE CZ_IMP_user_group

1337: nFailed:=nFailed+1;
1338: ELSE
1339: nUpdateCount:=nUpdateCount+1;
1340: BEGIN
1341: UPDATE CZ_IMP_user_group
1342: SET REC_STATUS='OK'
1343: WHERE USER_GROUP_ID=p_xfr_usergroup.USER_GROUP_ID AND RUN_ID=inRUN_ID;
1344: END;
1345: END IF;

Line 1350: UPDATE CZ_IMP_user_group

1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: nFailed:=nFailed +1;
1349: BEGIN
1350: UPDATE CZ_IMP_user_group
1351: SET REC_STATUS='ERR'
1352: WHERE USER_GROUP_ID=p_xfr_usergroup.USER_GROUP_ID AND RUN_ID=inRUN_ID;
1353: END;
1354: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_USER_GROUP',11276);