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 2448: SELECT pa_alloc_txn_details_s.nextval

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

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

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

Line 2566: INSERT INTO pa_alloc_txn_details

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

Line 2848: from pa_alloc_txn_details txn

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
2850: )
2851: ,run.run_status = lv_rate_status
2852: WHERE run.run_id = ln_run_id;

Line 2868: * no successful transactions exists in pa_alloc_txn_details table

2864:
2865: -- Auto-release if specified
2866: IF p_autorelease = 'Y' THEN
2867: /* Bug fix:3005559 : The release process should not be called if there
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');

Line 2899: * no successful transactions exists in pa_alloc_txn_details table

2895: -- Execution section if called from the form button in 'Release' mode
2896: ELSE
2897:
2898: /* Bug fix:3005559 : The release process should not be called if there
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');