eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CAP_INT_PVT dependencies on PA_ALLOC_EXCEPTIONS

Line 1151: FROM pa_alloc_exceptions exc

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

Line 1159: FROM pa_alloc_exceptions exc

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:

Line 1219: c_proj_lock pa_alloc_exceptions.exception_code%TYPE :=

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 :=

Line 1221: c_proj_batches 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 :=

Line 1223: c_proj_sched 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 :=

Line 1225: c_proj_sch_no_rate 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 :=

Line 1227: c_proj_threshold 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 :=

Line 1229: c_proj_no_txns 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 :=

Line 1231: c_task_threshold 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 :=

Line 1233: c_task_null_target 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 :=

Line 1235: c_task_not_valid 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:

Line 1237: c_rate_mult pa_alloc_exceptions.exception_code%TYPE :=

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

Line 1278: lv_exception_code pa_alloc_exceptions.exception_code%TYPE;

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;

Line 1340: lv_exception_type pa_alloc_exceptions.exception_type%TYPE;

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: