APPS.PA_CAP_INT_PVT dependencies on PA_ALLOC_RUNS_ALL

Line 1130: DELETE FROM pa_alloc_runs_all

1126: IS
1127: l_exists varchar2(1) := 'N';
1128: BEGIN
1129: IF p_mode <> 'EXCEPTION' Then
1130: DELETE FROM pa_alloc_runs_all
1131: WHERE run_id = p_run_id;
1132: ELSE
1133: BEGIN
1134: /* Bug fix:3051131 if there is any un-expected error encounters and If there are no trxn or exceptions

Line 1155: UPDATE pa_alloc_runs_all run

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

Line 1174: Delete from pa_alloc_runs_all

1170: IF g_debug_mode = 'Y' THEN
1171: pa_debug.write_file('LOG',' No Trxn found, Removing the run');
1172: End If;
1173: IF l_exists = 'N' Then
1174: Delete from pa_alloc_runs_all
1175: where run_id = p_run_id;
1176: Commit;
1177: End If;
1178: WHEN OTHERS THEN

Line 1308: ln_run_id pa_alloc_runs_all.run_id%TYPE;

1304: ln_curr_period_mult NUMBER;
1305: ln_period_mult NUMBER;
1306: ln_rate_mult pa_ind_cost_multipliers.multiplier%TYPE;
1307:
1308: ln_run_id pa_alloc_runs_all.run_id%TYPE;
1309: lv_exp_org_source pa_cint_rate_info_all.exp_org_source%TYPE;
1310: lv_interest_calc_method pa_cint_rate_info_all.interest_calculation_method%TYPE;
1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%TYPE;
1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;

Line 2842: UPDATE pa_alloc_runs_all run

2838: END IF;
2839:
2840: BEGIN
2841: -- Update the total transaction amount for the run
2842: UPDATE pa_alloc_runs_all run
2843: SET run.allocated_amount = -- Bug fix:2959030 ln_rate_trans_amt
2844: (select sum(nvl(txn.current_allocation,0))
2845: from pa_alloc_txn_details txn
2846: where txn.run_id = run.run_id