APPS.CZ_IMP_IM_MAIN dependencies on CZ_IMP_PROPERTY

Line 402: FROM CZ_IMP_property WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;

398: BEGIN
399: DECLARE
400: CURSOR c_imp_property IS
401: SELECT DELETED_FLAG, DATA_TYPE, ROWID
402: FROM CZ_IMP_property WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
403: /* Internal vars */
404: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
405: nErrorCount PLS_INTEGER:=0; /*Error index */
406: nDups PLS_INTEGER:=0; /*Dupl records */

Line 429: UPDATE CZ_IMP_property SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_property.ROWID;

425: END IF;
426:
427: IF (p_imp_property.DELETED_FLAG IS NULL) THEN
428: BEGIN
429: UPDATE CZ_IMP_property SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_property.ROWID;
430: nCOmmitCount:=nCommitCount+1;
431: /* COMMIT if the buffer size is reached */
432: IF (nCommitCount>= COMMIT_SIZE) THEN
433: COMMIT;

Line 446: UPDATE CZ_IMP_property SET DATA_TYPE = 4 WHERE ROWID = p_imp_property.ROWID;

442:
443: IF (p_imp_property.DATA_TYPE IS NULL) THEN
444: BEGIN
445:
446: UPDATE CZ_IMP_property SET DATA_TYPE = 4 WHERE ROWID = p_imp_property.ROWID;
447:
448: nCOmmitCount:=nCommitCount+1;
449: /* COMMIT if the buffer size is reached */
450: IF (nCommitCount>= COMMIT_SIZE) THEN

Line 1289: FROM CZ_IMP_property

1285:
1286: DECLARE
1287: CURSOR c_xfr_run_result IS
1288: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1289: FROM CZ_IMP_property
1290: WHERE RUN_ID = inRUN_ID
1291: GROUP BY DISPOSITION,REC_STATUS;
1292:
1293: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;