APPS.CZ_IMP_AC_XFR dependencies on CZ_IMP_END_USER

Line 834: FROM CZ_IMP_END_USER

830: ) IS
831: BEGIN
832: DECLARE CURSOR c_xfr_enduser IS
833: SELECT *
834: FROM CZ_IMP_END_USER
835: WHERE CZ_IMP_END_USER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
836: x_xfr_enduser_f BOOLEAN:=FALSE;
837: x_error BOOLEAN:=FALSE;
838: p_xfr_enduser c_xfr_enduser%ROWTYPE;

Line 835: WHERE CZ_IMP_END_USER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

831: BEGIN
832: DECLARE CURSOR c_xfr_enduser IS
833: SELECT *
834: FROM CZ_IMP_END_USER
835: WHERE CZ_IMP_END_USER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
836: x_xfr_enduser_f BOOLEAN:=FALSE;
837: x_error BOOLEAN:=FALSE;
838: p_xfr_enduser c_xfr_enduser%ROWTYPE;
839: -- Internal vars --

Line 969: UPDATE CZ_IMP_end_user

965: p_xfr_enduser.ORIG_SYS_REF,
966: p_xfr_enduser.NAME);
967: nInsertCount:=nInsertCount+1;
968: BEGIN
969: UPDATE CZ_IMP_end_user
970: SET REC_STATUS='OK'
971: WHERE END_USER_ID=p_xfr_enduser.END_USER_ID AND RUN_ID=inRUN_ID;
972: END;
973:

Line 978: UPDATE CZ_IMP_end_user

974: EXCEPTION
975: WHEN OTHERS THEN
976: nFailed:=nFailed +1;
977: BEGIN
978: UPDATE CZ_IMP_end_user
979: SET REC_STATUS='ERR'
980: WHERE END_USER_ID=p_xfr_enduser.END_USER_ID AND RUN_ID=inRUN_ID;
981: END;
982: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_END_USER',11276);

Line 1031: UPDATE CZ_IMP_end_user

1027: nFailed:=nFailed+1;
1028: ELSE
1029: nUpdateCount:=nUpdateCount+1;
1030: BEGIN
1031: UPDATE CZ_IMP_end_user
1032: SET REC_STATUS='OK'
1033: WHERE END_USER_ID=p_xfr_enduser.END_USER_ID AND RUN_ID=inRUN_ID;
1034: END;
1035: END IF;

Line 1040: UPDATE CZ_IMP_end_user

1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: nFailed:=nFailed +1;
1039: BEGIN
1040: UPDATE CZ_IMP_end_user
1041: SET REC_STATUS='ERR'
1042: WHERE END_USER_ID=p_xfr_enduser.END_USER_ID AND RUN_ID=inRUN_ID;
1043: END;
1044: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_END_USER',11276);

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;