APPS.PA_CAP_INT_PVT dependencies on PA_ALLOC_TXN_DETAILS

Line 125: /* This API returns 'Y' if the transactions exists in pa_alloc_txn_details

121: FUNCTION rate_name RETURN VARCHAR2 IS
122: BEGIN RETURN g_rate_name; END;
123:
124:
125: /* This API returns 'Y' if the transactions exists in pa_alloc_txn_details
126: * based on this the release of Transaction import process will be called
127: */
128: FUNCTION release_capint_txns_exists
129: (p_run_id IN NUMBER) RETURN VARCHAR2 IS

Line 141: FROM PA_ALLOC_TXN_DETAILS

137: INTO l_exists
138: FROM dual
139: WHERE EXISTS
140: (SELECT NULL
141: FROM PA_ALLOC_TXN_DETAILS
142: WHERE run_id = p_run_id);
143: End If;
144:
145: IF g_debug_mode = 'Y' THEN

Line 557: FROM pa_alloc_txn_details patd

553: INTO x_bypass
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'

Line 580: FROM pa_alloc_txn_details patd

576: * for the given project and period and the rate name doesnot exists in the
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

Line 1147: FROM PA_ALLOC_TXN_DETAILS det

1143: INTO l_exists
1144: FROM dual
1145: WHERE EXISTS
1146: (SELECT NULL
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

Line 2445: SELECT pa_alloc_txn_details_s.nextval

2441: lt_cap_int_amt(i) := ln_cap_int_amt;
2442: lt_target_task_id(i) := ln_target_task_id;
2443:
2444: BEGIN
2445: SELECT pa_alloc_txn_details_s.nextval
2446: INTO lt_alloc_txn_id(i)
2447: FROM DUAL;
2448: EXCEPTION
2449: WHEN OTHERS THEN

Line 2538: pa_debug.write_file('LOG','Insert pa_alloc_txn_details');

2534: END IF;
2535:
2536: BEGIN
2537: IF g_debug_mode = 'Y' THEN
2538: pa_debug.write_file('LOG','Insert pa_alloc_txn_details');
2539: pa_debug.write_file('LOG','Task_count'||lt_task_id.count||
2540: ']alloctxnid_count ['||lt_alloc_txn_id.count||
2541: ']target_task_count['||lt_target_task_id.count||
2542: ']capintamtcount[' ||lt_cap_int_amt.count||

Line 2563: INSERT INTO pa_alloc_txn_details

2559: ']proc flag count[' ||lt_process_task_flag.count||
2560: ']' );
2561: End If;
2562: FORALL k IN lt_task_id.FIRST..lt_task_id.LAST
2563: INSERT INTO pa_alloc_txn_details
2564: (alloc_txn_id
2565: ,run_id
2566: ,rule_id
2567: ,transaction_type

Line 2845: from pa_alloc_txn_details txn

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
2847: )
2848: ,run.run_status = lv_rate_status
2849: WHERE run.run_id = ln_run_id;

Line 2865: * no successful transactions exists in pa_alloc_txn_details table

2861:
2862: -- Auto-release if specified
2863: IF p_autorelease = 'Y' THEN
2864: /* Bug fix:3005559 : The release process should not be called if there
2865: * no successful transactions exists in pa_alloc_txn_details table
2866: */
2867: IF release_capint_txns_exists(ln_run_id) = 'Y' THEN
2868: IF g_debug_mode = 'Y' THEN
2869: pa_debug.write_file('LOG','Calling pa_alloc_run.release_capint_txns API');

Line 2896: * no successful transactions exists in pa_alloc_txn_details table

2892: -- Execution section if called from the form button in 'Release' mode
2893: ELSE
2894:
2895: /* Bug fix:3005559 : The release process should not be called if there
2896: * no successful transactions exists in pa_alloc_txn_details table
2897: */
2898: IF release_capint_txns_exists(x_run_id) = 'Y' THEN
2899: IF g_debug_mode = 'Y' THEN
2900: pa_debug.write_file('LOG','Calling pa_alloc_run.release_capint_txns API');