APPS.CZ_IMP_AC_XFR dependencies on CZ_IMP_END_USER_GROUP

Line 1070: FROM CZ_IMP_END_USER_GROUP WHERE CZ_IMP_END_USER_GROUP.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

1066: ) IS
1067: BEGIN
1068: DECLARE CURSOR c_xfr_endusergroup IS
1069: SELECT *
1070: FROM CZ_IMP_END_USER_GROUP WHERE CZ_IMP_END_USER_GROUP.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
1071: x_xfr_endusergroup_f BOOLEAN:=FALSE;
1072: x_error BOOLEAN:=FALSE;
1073: p_xfr_endusergroup c_xfr_endusergroup%ROWTYPE;
1074: -- Internal vars --

Line 1147: UPDATE CZ_IMP_end_user_group

1143: NULL,
1144: p_xfr_endusergroup.CHECKOUT_USER);
1145: nInsertCount:=nInsertCount+1;
1146: BEGIN
1147: UPDATE CZ_IMP_end_user_group
1148: SET REC_STATUS='OK'
1149: WHERE END_USER_ID=p_xfr_endusergroup.END_USER_ID
1150: AND USER_GROUP_ID=p_xfr_endusergroup.USER_GROUP_ID AND RUN_ID=inRUN_ID;
1151: END;

Line 1156: UPDATE CZ_IMP_end_user_group

1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: nFailed:=nFailed +1;
1155: BEGIN
1156: UPDATE CZ_IMP_end_user_group
1157: SET REC_STATUS='ERR'
1158: WHERE END_USER_ID=p_xfr_endusergroup.END_USER_ID
1159: AND USER_GROUP_ID=p_xfr_endusergroup.USER_GROUP_ID AND RUN_ID=inRUN_ID;
1160: END;

Line 1182: UPDATE CZ_IMP_end_user_group

1178: nFailed:=nFailed+1;
1179: ELSE
1180: nUpdateCount:=nUpdateCount+1;
1181: BEGIN
1182: UPDATE CZ_IMP_end_user_group
1183: SET REC_STATUS='OK'
1184: WHERE END_USER_ID=p_xfr_endusergroup.END_USER_ID
1185: AND USER_GROUP_ID=p_xfr_endusergroup.USER_GROUP_ID AND RUN_ID=inRUN_ID;
1186: END;

Line 1192: UPDATE CZ_IMP_end_user_group

1188: EXCEPTION
1189: WHEN OTHERS THEN
1190: nFailed:=nFailed +1;
1191: BEGIN
1192: UPDATE CZ_IMP_end_user_group
1193: SET REC_STATUS='ERR'
1194: WHERE END_USER_ID=p_xfr_endusergroup.END_USER_ID
1195: AND USER_GROUP_ID=p_xfr_endusergroup.USER_GROUP_ID AND RUN_ID=inRUN_ID;
1196: END;