1147: FROM PA_ALLOC_TXN_DETAILS det
1148: WHERE det.run_id = p_run_id)
1149: OR
1150: EXISTS (SELECT null
1151: FROM pa_alloc_exceptions exc
1152: where exc.run_id = p_run_id ) ;
1153:
1154: IF l_exists = 'Y' Then
1155: UPDATE pa_alloc_runs_all run
1155: UPDATE pa_alloc_runs_all run
1156: SET run.run_status = 'DF'
1157: WHERE run.run_id = p_run_id
1158: AND EXISTS (SELECT null
1159: FROM pa_alloc_exceptions exc
1160: WHERE exc.run_id = run.run_id ) ;
1161: Commit;
1162: End If;
1163:
1215: ,x_error_msg_code OUT NOCOPY VARCHAR2)
1216: IS
1217:
1218: -- Alloc Exception Codes
1219: c_proj_lock pa_alloc_exceptions.exception_code%TYPE :=
1220: 'PA_CINT_PROJ_LOCK';
1221: c_proj_batches pa_alloc_exceptions.exception_code%TYPE :=
1222: 'PA_CINT_PROJ_BATCHES';
1223: c_proj_sched pa_alloc_exceptions.exception_code%TYPE :=
1217:
1218: -- Alloc Exception Codes
1219: c_proj_lock pa_alloc_exceptions.exception_code%TYPE :=
1220: 'PA_CINT_PROJ_LOCK';
1221: c_proj_batches pa_alloc_exceptions.exception_code%TYPE :=
1222: 'PA_CINT_PROJ_BATCHES';
1223: c_proj_sched pa_alloc_exceptions.exception_code%TYPE :=
1224: 'PA_CINT_PROJ_SCHEDULES';
1225: c_proj_sch_no_rate pa_alloc_exceptions.exception_code%TYPE :=
1219: c_proj_lock pa_alloc_exceptions.exception_code%TYPE :=
1220: 'PA_CINT_PROJ_LOCK';
1221: c_proj_batches pa_alloc_exceptions.exception_code%TYPE :=
1222: 'PA_CINT_PROJ_BATCHES';
1223: c_proj_sched pa_alloc_exceptions.exception_code%TYPE :=
1224: 'PA_CINT_PROJ_SCHEDULES';
1225: c_proj_sch_no_rate pa_alloc_exceptions.exception_code%TYPE :=
1226: 'PA_CINT_PROJ_SCH_NO_RATE';
1227: c_proj_threshold pa_alloc_exceptions.exception_code%TYPE :=
1221: c_proj_batches pa_alloc_exceptions.exception_code%TYPE :=
1222: 'PA_CINT_PROJ_BATCHES';
1223: c_proj_sched pa_alloc_exceptions.exception_code%TYPE :=
1224: 'PA_CINT_PROJ_SCHEDULES';
1225: c_proj_sch_no_rate pa_alloc_exceptions.exception_code%TYPE :=
1226: 'PA_CINT_PROJ_SCH_NO_RATE';
1227: c_proj_threshold pa_alloc_exceptions.exception_code%TYPE :=
1228: 'PA_CINT_PROJ_THRESHOLDS';
1229: c_proj_no_txns pa_alloc_exceptions.exception_code%TYPE :=
1223: c_proj_sched pa_alloc_exceptions.exception_code%TYPE :=
1224: 'PA_CINT_PROJ_SCHEDULES';
1225: c_proj_sch_no_rate pa_alloc_exceptions.exception_code%TYPE :=
1226: 'PA_CINT_PROJ_SCH_NO_RATE';
1227: c_proj_threshold pa_alloc_exceptions.exception_code%TYPE :=
1228: 'PA_CINT_PROJ_THRESHOLDS';
1229: c_proj_no_txns pa_alloc_exceptions.exception_code%TYPE :=
1230: 'PA_CINT_PROJ_NO_TXNS';
1231: c_task_threshold pa_alloc_exceptions.exception_code%TYPE :=
1225: c_proj_sch_no_rate pa_alloc_exceptions.exception_code%TYPE :=
1226: 'PA_CINT_PROJ_SCH_NO_RATE';
1227: c_proj_threshold pa_alloc_exceptions.exception_code%TYPE :=
1228: 'PA_CINT_PROJ_THRESHOLDS';
1229: c_proj_no_txns pa_alloc_exceptions.exception_code%TYPE :=
1230: 'PA_CINT_PROJ_NO_TXNS';
1231: c_task_threshold pa_alloc_exceptions.exception_code%TYPE :=
1232: 'PA_CINT_TASK_THRESHOLDS';
1233: c_task_null_target pa_alloc_exceptions.exception_code%TYPE :=
1227: c_proj_threshold pa_alloc_exceptions.exception_code%TYPE :=
1228: 'PA_CINT_PROJ_THRESHOLDS';
1229: c_proj_no_txns pa_alloc_exceptions.exception_code%TYPE :=
1230: 'PA_CINT_PROJ_NO_TXNS';
1231: c_task_threshold pa_alloc_exceptions.exception_code%TYPE :=
1232: 'PA_CINT_TASK_THRESHOLDS';
1233: c_task_null_target pa_alloc_exceptions.exception_code%TYPE :=
1234: 'PA_CINT_TASK_NULL_TARGET';
1235: c_task_not_valid pa_alloc_exceptions.exception_code%TYPE :=
1229: c_proj_no_txns pa_alloc_exceptions.exception_code%TYPE :=
1230: 'PA_CINT_PROJ_NO_TXNS';
1231: c_task_threshold pa_alloc_exceptions.exception_code%TYPE :=
1232: 'PA_CINT_TASK_THRESHOLDS';
1233: c_task_null_target pa_alloc_exceptions.exception_code%TYPE :=
1234: 'PA_CINT_TASK_NULL_TARGET';
1235: c_task_not_valid pa_alloc_exceptions.exception_code%TYPE :=
1236: 'PA_CINT_TASK_NOT_VALID';
1237: c_rate_mult pa_alloc_exceptions.exception_code%TYPE :=
1231: c_task_threshold pa_alloc_exceptions.exception_code%TYPE :=
1232: 'PA_CINT_TASK_THRESHOLDS';
1233: c_task_null_target pa_alloc_exceptions.exception_code%TYPE :=
1234: 'PA_CINT_TASK_NULL_TARGET';
1235: c_task_not_valid pa_alloc_exceptions.exception_code%TYPE :=
1236: 'PA_CINT_TASK_NOT_VALID';
1237: c_rate_mult pa_alloc_exceptions.exception_code%TYPE :=
1238: 'PA_CINT_RATE_MULTIPLIER';
1239:
1233: c_task_null_target pa_alloc_exceptions.exception_code%TYPE :=
1234: 'PA_CINT_TASK_NULL_TARGET';
1235: c_task_not_valid pa_alloc_exceptions.exception_code%TYPE :=
1236: 'PA_CINT_TASK_NOT_VALID';
1237: c_rate_mult pa_alloc_exceptions.exception_code%TYPE :=
1238: 'PA_CINT_RATE_MULTIPLIER';
1239:
1240:
1241: -- PLSQL table types and variables
1274: -- Process control variables
1275:
1276: lv_bypass_project VARCHAR2(1);
1277: lv_bypass_task VARCHAR2(1);
1278: lv_exception_code pa_alloc_exceptions.exception_code%TYPE;
1279:
1280: ln_proj_processed NUMBER;
1281: ln_proj_written NUMBER;
1282: ln_trans_written NUMBER;
1336: ln_task_start NUMBER;
1337: ln_task_last NUMBER;
1338:
1339: lv_first_exp_flag VARCHAR2(1);
1340: lv_exception_type pa_alloc_exceptions.exception_type%TYPE;
1341:
1342: ln_cap_int_amt NUMBER;
1343: v_success_flag NUMBER;
1344: