APPS.CZ_IMP_AC_XFR dependencies on CZ_IMP_CONTACT

Line 14: SELECT * FROM CZ_IMP_CONTACT

10: inXFR_GROUP IN VARCHAR2
11: ) IS
12: BEGIN
13: DECLARE CURSOR c_xfr_contact IS
14: SELECT * FROM CZ_IMP_CONTACT
15: WHERE CZ_IMP_CONTACT.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
16: x_xfr_contact_f BOOLEAN:=FALSE;
17: x_error BOOLEAN:=FALSE;
18: p_xfr_contact c_xfr_contact%ROWTYPE;

Line 15: WHERE CZ_IMP_CONTACT.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

11: ) IS
12: BEGIN
13: DECLARE CURSOR c_xfr_contact IS
14: SELECT * FROM CZ_IMP_CONTACT
15: WHERE CZ_IMP_CONTACT.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
16: x_xfr_contact_f BOOLEAN:=FALSE;
17: x_error BOOLEAN:=FALSE;
18: p_xfr_contact c_xfr_contact%ROWTYPE;
19: /* Internal vars */

Line 132: UPDATE CZ_IMP_contact

128: p_xfr_contact.CHECKOUT_USER,p_xfr_contact.PRIMARY_ROLE,
129: p_xfr_contact.ORIG_SYS_REF);
130: nInsertCount:=nInsertCount+1;
131: BEGIN
132: UPDATE CZ_IMP_contact
133: SET REC_STATUS='OK'
134: WHERE CONTACT_ID=p_xfr_contact.CONTACT_ID AND RUN_ID=inRUN_ID;
135: END;
136: EXCEPTION

Line 140: UPDATE CZ_IMP_contact

136: EXCEPTION
137: WHEN OTHERS THEN
138: nFailed:=nFailed +1;
139: BEGIN
140: UPDATE CZ_IMP_contact
141: SET REC_STATUS='ERR'
142: WHERE CONTACT_ID=p_xfr_contact.CONTACT_ID AND RUN_ID=inRUN_ID;
143: END;
144: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_CONTACT',11276);

Line 187: UPDATE CZ_IMP_contact

183: nFailed:=nFailed+1;
184: ELSE
185: nUpdateCount:=nUpdateCount+1;
186: BEGIN
187: UPDATE CZ_IMP_contact
188: SET REC_STATUS='OK'
189: WHERE CONTACT_ID=p_xfr_contact.CONTACT_ID AND RUN_ID=inRUN_ID;
190: END;
191: END IF;

Line 196: UPDATE CZ_IMP_contact

192: EXCEPTION
193: WHEN OTHERS THEN
194: nFailed:=nFailed +1;
195: BEGIN
196: UPDATE CZ_IMP_contact
197: SET REC_STATUS='ERR'
198: WHERE CONTACT_ID=p_xfr_contact.CONTACT_ID AND RUN_ID=inRUN_ID;
199: END;
200: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_CONTACT',11276);