APPS.PA_CAP_INT_PVT dependencies on PA_ALLOC_RUNS

Line 558: ,pa_alloc_runs par

554: FROM DUAL
555: WHERE EXISTS
556: (SELECT 'X'
557: FROM pa_alloc_txn_details patd
558: ,pa_alloc_runs par
559: WHERE patd.project_id = p_project_id
560: AND patd.run_id = par.run_id
561: AND par.run_status <> 'RV'
562: AND par.cint_rate_name = p_rate_name

Line 581: ,pa_alloc_runs par

577: * pa_ind_cost_codes table
578: */
579: OR EXISTS (SELECT 'X'
580: FROM pa_alloc_txn_details patd
581: ,pa_alloc_runs par
582: WHERE patd.run_id = par.run_id
583: AND par.run_status <> 'RV'
584: AND patd.project_id = p_project_id
585: AND par.period_num = p_period_num

Line 993: SELECT pa_alloc_runs_s.nextval

989: ,x_error_msg_count OUT NOCOPY NUMBER
990: ,x_error_msg_code OUT NOCOPY VARCHAR2)
991: IS
992: BEGIN
993: SELECT pa_alloc_runs_s.nextval
994: INTO x_run_id
995: FROM DUAL;
996:
997: pa_alloc_run.insert_alloc_runs

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 1330: lv_rate_status pa_alloc_runs.run_status%TYPE;

1326:
1327: ln_curr_task_id pa_tasks.task_id%TYPE;
1328: lv_curr_task_num pa_tasks.task_number%TYPE;
1329: ln_rate_trans_amt NUMBER;
1330: lv_rate_status pa_alloc_runs.run_status%TYPE;
1331: ln_proj_tot_amt NUMBER;
1332: ln_proj_open_amt NUMBER;
1333: ln_task_tot_amt NUMBER;
1334: ln_task_open_amt NUMBER;

Line 2845: UPDATE pa_alloc_runs_all run

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