DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_CLIENT_EXTN_ALLOC

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

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

Line 1308: v_src_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_SOURCE_TABTYPE;

1304: WHERE top_task_id = p_tsk_id;
1305: v_top_task_id NUMBER;
1306: v_retcode NUMBER;
1307: v_dummy NUMBER;
1308: v_src_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_SOURCE_TABTYPE;
1309: v_cx_project_id NUMBER;
1310: v_cx_task_id NUMBER;
1311: v_cx_exclude_flag VARCHAR2(1);
1312: v_status NUMBER :=NULL;

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

1326: pa_debug.write_file('populate_run_sources: ' || 'LOG', pa_debug.G_err_stage);
1327: END IF;
1328: /* reset the error_flag */
1329: G_fatal_err_found := FALSE;
1330: pa_client_extn_alloc.source_extn(p_rule_id, v_src_extn_tabtype,v_status,v_err_message);
1331: IF P_DEBUG_MODE = 'Y' THEN
1332: pa_debug.write_file('populate_run_sources: ' || 'LOG','Client return message: '|| v_err_message);
1333: END IF;
1334: IF nvl(v_status,0) <> 0 then

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

1524: pa_debug.G_err_stage:= 'READING SRC CLIENT EXTENSION FOR INCLUDES';
1525: IF P_DEBUG_MODE = 'Y' THEN
1526: pa_debug.write_file('populate_run_sources: ' || 'LOG', pa_debug.G_err_stage);
1527: END IF;
1528: pa_client_extn_alloc.source_extn( p_rule_id, v_src_extn_tabtype,v_status,v_err_message);
1529: IF P_DEBUG_MODE = 'Y' THEN
1530: pa_debug.write_file('populate_run_sources: ' || 'LOG','Client return message: '|| v_err_message);
1531: END IF;
1532: IF nvl(v_status,0) <> 0 then

Line 2080: v_trg_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_TARGET_TABTYPE;

2076: CURSOR C_target_line_exists IS
2077: SELECT 1
2078: FROM pa_alloc_target_lines
2079: WHERE rule_id = p_rule_id;
2080: v_trg_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_TARGET_TABTYPE;
2081: v_top_task_id NUMBER;
2082: v_retcode NUMBER;
2083: v_dummy NUMBER;
2084: v_dummy_target NUMBER;

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

2144: pa_debug.G_err_stage:= 'READING TRG CLIENT EXTENSION FOR EXCLUDES';
2145: IF P_DEBUG_MODE = 'Y' THEN
2146: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);
2147: END IF;
2148: pa_client_extn_alloc.target_extn(p_rule_id, v_trg_extn_tabtype,v_status,v_err_message);
2149: IF nvl(v_status,0) <>0 THEN
2150: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
2151: alloc_errors(p_rule_id,p_run_id,'T','E',v_err_message,TRUE);
2152: END IF;

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

2310: pa_debug.G_err_stage:= 'READING TRG CLIENT EXTENSION FOR INCLUDES';
2311: IF P_DEBUG_MODE = 'Y' THEN
2312: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);
2313: END IF;
2314: pa_client_extn_alloc.target_extn( p_rule_id, v_trg_extn_tabtype,v_status, v_err_message);
2315: IF nvl(v_status,0) <>0 THEN
2316: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
2317: alloc_errors(p_rule_id,p_run_id,'T','E',v_err_message,TRUE);
2318: END IF;

Line 3116: PA_CLIENT_EXTN_ALLOC.txn_dff_extn( p_rule_id

3112: IF nvl(p_rule_id,0) <> -1 Then
3113: --For Capitalized Interest the DFF will be derived outside the
3114: --table handler by calling client extn
3115: If p_transaction_type='T' then
3116: PA_CLIENT_EXTN_ALLOC.txn_dff_extn( p_rule_id
3117: ,p_run_id
3118: ,p_transaction_type
3119: ,p_project_id
3120: ,P_task_id

Line 3146: PA_CLIENT_EXTN_ALLOC.txn_dff_extn( p_rule_id

3142: END IF;
3143: alloc_errors(p_rule_id, p_run_id, 'R', 'E',v_err_message, TRUE) ;
3144: END IF ;
3145: Elsif p_transaction_type='O' then
3146: PA_CLIENT_EXTN_ALLOC.txn_dff_extn( p_rule_id
3147: ,p_run_id
3148: ,p_transaction_type
3149: ,p_project_id
3150: ,P_task_id

Line 3697: v_offset_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_OFFSET_TABTYPE;

3693: v_period_num NUMBER;
3694: v_status NUMBER :=NULL;
3695: v_err_message VARCHAR2(250);
3696: v_returned_amount NUMBER := 0;
3697: v_offset_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_OFFSET_TABTYPE;
3698: BEGIN
3699: pa_debug.set_err_stack('Create_Offset_txns');
3700: pa_debug.G_err_stage:= 'CREATING OFFSET TRANSACTIONS';
3701: IF P_DEBUG_MODE = 'Y' THEN

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

3787: IF P_DEBUG_MODE = 'Y' THEN
3788: pa_debug.write_file('create_offset_txns: ' || 'LOG', 'Test offset method B ');
3789: END IF;
3790: FOR offset_proj_sum_rec IN c_offset_proj_sum LOOP
3791: pa_client_extn_alloc.offset_task_extn(p_rule_id, offset_proj_sum_rec.project_id, v_task_id,v_status,v_err_message);
3792: IF nvl(v_status,0) <>0 THEN
3793: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
3794: alloc_errors(p_rule_id, p_run_id,'O','E',v_err_message,TRUE);
3795: END IF;

Line 3993: pa_client_extn_alloc.offset_extn( p_rule_id, v_tot_offset_amount

3989: G_num_txns := G_num_txns + 1 ;
3990: END IF ;
3991: ELSIF (p_offset_method = 'D') THEN -- Offset Method: CLient Extension
3992: v_tot_offset_amount:= p_allocated_amount * (-1);
3993: pa_client_extn_alloc.offset_extn( p_rule_id, v_tot_offset_amount
3994: , v_offset_extn_tabtype,v_status,v_err_message);
3995: IF nvl(v_status,0) <> 0 THEN
3996: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
3997: alloc_errors(p_rule_id,p_run_id,'O','E',v_err_message,TRUE);

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

8012: IF P_DEBUG_MODE = 'Y' THEN
8013: pa_debug.write_file('cal_proj_basis_amounts: ' || 'LOG', pa_debug.G_Err_Stage);
8014: END IF;
8015: For run_targets_rec in C_run_targets LOOP
8016: pa_client_extn_alloc.basis_extn(p_rule_id, run_targets_rec.project_id,
8017: run_targets_rec.task_id, v_amount,v_status,v_err_message) ;
8018: IF nvl(v_status,0) <> 0 THEN
8019: v_err_message:=nvl(v_err_message,'PA_AL_CE_FAILED');
8020: alloc_errors(p_rule_id,p_run_id,'B','E',v_err_message,TRUE);