DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_CLIENT_EXTN_ALLOC

Line 200: pa_client_extn_alloc.check_dependency(p_rule_id, v_status, v_err_message) ;

196: G_basis_budget_type_code := v_alloc_rule_rec.basis_budget_type_code; /* added bug 2619977 */
197: G_basis_fin_plan_type_id := v_alloc_rule_rec.basis_fin_plan_type_id; /* added bug 2619977 */
198: G_Org_Id := v_alloc_rule_rec.Org_Id ; /* FP.M : Allocation Impact */
199: CLOSE C_get_rule;
200: pa_client_extn_alloc.check_dependency(p_rule_id, v_status, v_err_message) ;
201: IF nvl(v_status,0) <> 0 then
202: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
203: IF P_DEBUG_MODE = 'Y' THEN
204: pa_debug.write_file('allocation_run: ' || 'LOG',v_err_message);

Line 1318: v_src_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_SOURCE_TABTYPE;

1314: WHERE top_task_id = p_tsk_id;
1315: v_top_task_id NUMBER;
1316: v_retcode NUMBER;
1317: v_dummy NUMBER;
1318: v_src_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_SOURCE_TABTYPE;
1319: v_cx_project_id NUMBER;
1320: v_cx_task_id NUMBER;
1321: v_cx_exclude_flag VARCHAR2(1);
1322: v_status NUMBER :=NULL;

Line 1340: pa_client_extn_alloc.source_extn(p_rule_id, v_src_extn_tabtype,v_status,v_err_message);

1336: pa_debug.write_file('populate_run_sources: ' || 'LOG', pa_debug.G_err_stage);
1337: END IF;
1338: /* reset the error_flag */
1339: G_fatal_err_found := FALSE;
1340: pa_client_extn_alloc.source_extn(p_rule_id, v_src_extn_tabtype,v_status,v_err_message);
1341: IF P_DEBUG_MODE = 'Y' THEN
1342: pa_debug.write_file('populate_run_sources: ' || 'LOG','Client return message: '|| v_err_message);
1343: END IF;
1344: IF nvl(v_status,0) <> 0 then

Line 1538: pa_client_extn_alloc.source_extn( p_rule_id, v_src_extn_tabtype,v_status,v_err_message);

1534: pa_debug.G_err_stage:= 'READING SRC CLIENT EXTENSION FOR INCLUDES';
1535: IF P_DEBUG_MODE = 'Y' THEN
1536: pa_debug.write_file('populate_run_sources: ' || 'LOG', pa_debug.G_err_stage);
1537: END IF;
1538: pa_client_extn_alloc.source_extn( p_rule_id, v_src_extn_tabtype,v_status,v_err_message);
1539: IF P_DEBUG_MODE = 'Y' THEN
1540: pa_debug.write_file('populate_run_sources: ' || 'LOG','Client return message: '|| v_err_message);
1541: END IF;
1542: IF nvl(v_status,0) <> 0 then

Line 2090: v_trg_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_TARGET_TABTYPE;

2086: CURSOR C_target_line_exists IS
2087: SELECT 1
2088: FROM pa_alloc_target_lines
2089: WHERE rule_id = p_rule_id;
2090: v_trg_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_TARGET_TABTYPE;
2091: v_top_task_id NUMBER;
2092: v_retcode NUMBER;
2093: v_dummy NUMBER;
2094: v_dummy_target NUMBER;

Line 2158: pa_client_extn_alloc.target_extn(p_rule_id, v_trg_extn_tabtype,v_status,v_err_message);

2154: pa_debug.G_err_stage:= 'READING TRG CLIENT EXTENSION FOR EXCLUDES';
2155: IF P_DEBUG_MODE = 'Y' THEN
2156: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);
2157: END IF;
2158: pa_client_extn_alloc.target_extn(p_rule_id, v_trg_extn_tabtype,v_status,v_err_message);
2159: IF nvl(v_status,0) <>0 THEN
2160: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
2161: alloc_errors(p_rule_id,p_run_id,'T','E',v_err_message,TRUE);
2162: END IF;

Line 2324: pa_client_extn_alloc.target_extn( p_rule_id, v_trg_extn_tabtype,v_status, v_err_message);

2320: pa_debug.G_err_stage:= 'READING TRG CLIENT EXTENSION FOR INCLUDES';
2321: IF P_DEBUG_MODE = 'Y' THEN
2322: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);
2323: END IF;
2324: pa_client_extn_alloc.target_extn( p_rule_id, v_trg_extn_tabtype,v_status, v_err_message);
2325: IF nvl(v_status,0) <>0 THEN
2326: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
2327: alloc_errors(p_rule_id,p_run_id,'T','E',v_err_message,TRUE);
2328: END IF;

Line 3128: PA_CLIENT_EXTN_ALLOC.txn_dff_extn( p_rule_id

3124: IF nvl(p_rule_id,0) <> -1 Then
3125: --For Capitalized Interest the DFF will be derived outside the
3126: --table handler by calling client extn
3127: If p_transaction_type='T' then
3128: PA_CLIENT_EXTN_ALLOC.txn_dff_extn( p_rule_id
3129: ,p_run_id
3130: ,p_transaction_type
3131: ,p_project_id
3132: ,P_task_id

Line 3158: PA_CLIENT_EXTN_ALLOC.txn_dff_extn( p_rule_id

3154: END IF;
3155: alloc_errors(p_rule_id, p_run_id, 'R', 'E',v_err_message, TRUE) ;
3156: END IF ;
3157: Elsif p_transaction_type='O' then
3158: PA_CLIENT_EXTN_ALLOC.txn_dff_extn( p_rule_id
3159: ,p_run_id
3160: ,p_transaction_type
3161: ,p_project_id
3162: ,P_task_id

Line 3720: v_offset_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_OFFSET_TABTYPE;

3716: v_period_num NUMBER;
3717: v_status NUMBER :=NULL;
3718: v_err_message VARCHAR2(250);
3719: v_returned_amount NUMBER := 0;
3720: v_offset_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_OFFSET_TABTYPE;
3721: BEGIN
3722: pa_debug.set_err_stack('Create_Offset_txns');
3723: pa_debug.G_err_stage:= 'CREATING OFFSET TRANSACTIONS';
3724: IF P_DEBUG_MODE = 'Y' THEN

Line 3814: pa_client_extn_alloc.offset_task_extn(p_rule_id, offset_proj_sum_rec.project_id, v_task_id,v_status,v_err_message);

3810: IF P_DEBUG_MODE = 'Y' THEN
3811: pa_debug.write_file('create_offset_txns: ' || 'LOG', 'Test offset method B ');
3812: END IF;
3813: FOR offset_proj_sum_rec IN c_offset_proj_sum LOOP
3814: pa_client_extn_alloc.offset_task_extn(p_rule_id, offset_proj_sum_rec.project_id, v_task_id,v_status,v_err_message);
3815: IF nvl(v_status,0) <>0 THEN
3816: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
3817: alloc_errors(p_rule_id, p_run_id,'O','E',v_err_message,TRUE);
3818: END IF;

Line 4016: pa_client_extn_alloc.offset_extn( p_rule_id, v_tot_offset_amount

4012: G_num_txns := G_num_txns + 1 ;
4013: END IF ;
4014: ELSIF (p_offset_method = 'D') THEN -- Offset Method: CLient Extension
4015: v_tot_offset_amount:= p_allocated_amount * (-1);
4016: pa_client_extn_alloc.offset_extn( p_rule_id, v_tot_offset_amount
4017: , v_offset_extn_tabtype,v_status,v_err_message);
4018: IF nvl(v_status,0) <> 0 THEN
4019: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
4020: alloc_errors(p_rule_id,p_run_id,'O','E',v_err_message,TRUE);

Line 8121: pa_client_extn_alloc.basis_extn(p_rule_id, run_targets_rec.project_id,

8117: IF P_DEBUG_MODE = 'Y' THEN
8118: pa_debug.write_file('cal_proj_basis_amounts: ' || 'LOG', pa_debug.G_Err_Stage);
8119: END IF;
8120: For run_targets_rec in C_run_targets LOOP
8121: pa_client_extn_alloc.basis_extn(p_rule_id, run_targets_rec.project_id,
8122: run_targets_rec.task_id, v_amount,v_status,v_err_message) ;
8123: IF nvl(v_status,0) <> 0 THEN
8124: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
8125: alloc_errors(p_rule_id,p_run_id,'B','E',v_err_message,TRUE);