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_RUN

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 997: pa_alloc_run.insert_alloc_runs

993: SELECT pa_alloc_runs_s.nextval
994: INTO x_run_id
995: FROM DUAL;
996:
997: pa_alloc_run.insert_alloc_runs
998: (x_run_id => x_run_id
999: ,p_rule_id => p_rule_id
1000: ,p_run_period => p_gl_period
1001: ,p_expnd_item_date => p_exp_item_date

Line 1084: pa_alloc_run.ins_alloc_exceptions

1080: ,x_error_msg_code OUT NOCOPY VARCHAR2)
1081: IS
1082: BEGIN
1083:
1084: pa_alloc_run.ins_alloc_exceptions
1085: (p_rule_id => p_rule_id
1086: ,p_run_id => p_run_id
1087: ,p_creation_date => SYSDATE
1088: ,p_created_by => g_created_by

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

Line 2872: pa_debug.write_file('LOG','Calling pa_alloc_run.release_capint_txns API');

2868: * no successful transactions exists in pa_alloc_txn_details table
2869: */
2870: IF release_capint_txns_exists(ln_run_id) = 'Y' THEN
2871: IF g_debug_mode = 'Y' THEN
2872: pa_debug.write_file('LOG','Calling pa_alloc_run.release_capint_txns API');
2873: End If;
2874:
2875: pa_alloc_run.release_capint_txns
2876: (ln_run_id

Line 2875: pa_alloc_run.release_capint_txns

2871: IF g_debug_mode = 'Y' THEN
2872: pa_debug.write_file('LOG','Calling pa_alloc_run.release_capint_txns API');
2873: End If;
2874:
2875: pa_alloc_run.release_capint_txns
2876: (ln_run_id
2877: ,x_return_status
2878: ,x_error_msg_count
2879: ,x_error_msg_code);

Line 2903: pa_debug.write_file('LOG','Calling pa_alloc_run.release_capint_txns API');

2899: * no successful transactions exists in pa_alloc_txn_details table
2900: */
2901: IF release_capint_txns_exists(x_run_id) = 'Y' THEN
2902: IF g_debug_mode = 'Y' THEN
2903: pa_debug.write_file('LOG','Calling pa_alloc_run.release_capint_txns API');
2904: End If;
2905:
2906: pa_alloc_run.release_capint_txns
2907: (x_run_id

Line 2906: pa_alloc_run.release_capint_txns

2902: IF g_debug_mode = 'Y' THEN
2903: pa_debug.write_file('LOG','Calling pa_alloc_run.release_capint_txns API');
2904: End If;
2905:
2906: pa_alloc_run.release_capint_txns
2907: (x_run_id
2908: ,x_return_status
2909: ,x_error_msg_count
2910: ,x_error_msg_code);