DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_UTILS

Line 314: G_tgt_expnd_org:=pa_utils.GetOrgName( v_alloc_rule_rec.target_exp_org_id);

310: , v_alloc_rule_rec.BASIS_RESOURCE_STRUCT_TYPE
311: , v_alloc_rule_rec.ALLOC_RBS_VERSION
312: , v_alloc_rule_rec.BASIS_RBS_VERSION
313: );
314: G_tgt_expnd_org:=pa_utils.GetOrgName( v_alloc_rule_rec.target_exp_org_id);
315: G_tgt_expnd_type_class:= v_alloc_rule_rec.target_exp_type_class;
316: G_tgt_expnd_type:=v_alloc_rule_rec.target_exp_type;
317: G_offset_expnd_org:=pa_utils.GetOrgName( v_alloc_rule_rec.offset_exp_org_id);
318: G_offset_expnd_type_class:= v_alloc_rule_rec.offset_exp_type_class;

Line 317: G_offset_expnd_org:=pa_utils.GetOrgName( v_alloc_rule_rec.offset_exp_org_id);

313: );
314: G_tgt_expnd_org:=pa_utils.GetOrgName( v_alloc_rule_rec.target_exp_org_id);
315: G_tgt_expnd_type_class:= v_alloc_rule_rec.target_exp_type_class;
316: G_tgt_expnd_type:=v_alloc_rule_rec.target_exp_type;
317: G_offset_expnd_org:=pa_utils.GetOrgName( v_alloc_rule_rec.offset_exp_org_id);
318: G_offset_expnd_type_class:= v_alloc_rule_rec.offset_exp_type_class;
319: G_offset_expnd_type:=v_alloc_rule_rec.offset_exp_type;
320: pa_debug.G_err_stage := 'VALIDATING RULE';
321: IF P_DEBUG_MODE = 'Y' THEN

Line 984: pa_utils2.CheckExpOrg( p_target_exp_org_id) = 'N') THEN

980: IF P_DEBUG_MODE = 'Y' THEN
981: pa_debug.write_file('validate_rule: ' || 'LOG', pa_debug.G_err_stage);
982: END IF;
983: IF( p_target_exp_org_id IS NULL OR
984: pa_utils2.CheckExpOrg( p_target_exp_org_id) = 'N') THEN
985: G_fatal_err_found := TRUE;
986: alloc_errors( p_rule_id, p_run_id, 'R', 'E',
987: 'PA_AL_INVALID_TARGET_EXP_ORG') ;
988: END IF;

Line 1016: ELSIF(pa_utils2.CheckExpOrg( p_offset_exp_org_id) = 'N') THEN

1012: IF( p_offset_exp_org_id IS NULL ) THEN
1013: G_fatal_err_found := TRUE;
1014: alloc_errors( p_rule_id, p_run_id, 'R', 'E',
1015: 'PA_AL_UNDEFINED_OFFSET_EXP_ORG') ;
1016: ELSIF(pa_utils2.CheckExpOrg( p_offset_exp_org_id) = 'N') THEN
1017: G_fatal_err_found := TRUE;
1018: alloc_errors( p_rule_id, p_run_id, 'R', 'E',
1019: 'PA_AL_INVALID_OFFSET_EXP_ORG') ;
1020: END IF;

Line 9474: v_target_expnd_org := pa_utils.GetOrgName(run_rec.target_exp_org_id ) ;

9470: 'R', 'E', NULL, NULL, 'PA_AL_RUN_NOT_EXISTS');
9471: x_errbuf := 'PA_AL_RUN_NOT_EXISTS' ;
9472: END IF;
9473: CLOSE C_run;
9474: v_target_expnd_org := pa_utils.GetOrgName(run_rec.target_exp_org_id ) ;
9475: v_offset_expnd_org := pa_utils.GetOrgName(run_rec.offset_exp_org_id ) ;
9476: If (nvl(p_rule_id,-99) <> -1) AND --Added this condition for capital project changes
9477: v_target_expnd_org is NULL THEN
9478: G_fatal_err_found := TRUE;

Line 9475: v_offset_expnd_org := pa_utils.GetOrgName(run_rec.offset_exp_org_id ) ;

9471: x_errbuf := 'PA_AL_RUN_NOT_EXISTS' ;
9472: END IF;
9473: CLOSE C_run;
9474: v_target_expnd_org := pa_utils.GetOrgName(run_rec.target_exp_org_id ) ;
9475: v_offset_expnd_org := pa_utils.GetOrgName(run_rec.offset_exp_org_id ) ;
9476: If (nvl(p_rule_id,-99) <> -1) AND --Added this condition for capital project changes
9477: v_target_expnd_org is NULL THEN
9478: G_fatal_err_found := TRUE;
9479: pa_alloc_run.ins_alloc_exceptions( p_rule_id, p_run_id, G_creation_date,

Line 9495: v_expnd_end_date := pa_utils.GetWeekEnding(run_rec.expnd_item_date) ;

9491: G_last_updated_by, G_last_update_login,
9492: 'R', 'E', NULL, NULL, 'PA_AL_INVALID_OFFSET_EXP_ORG');
9493: x_errbuf := 'PA_AL_INVALID_OFFSET_EXP_ORG' ;
9494: End if ;
9495: v_expnd_end_date := pa_utils.GetWeekEnding(run_rec.expnd_item_date) ;
9496: If v_expnd_end_date is NULL then
9497: G_fatal_err_found := TRUE;
9498: alloc_errors(p_rule_id, p_run_id, 'R', 'E','PA_AL_INVALID_EXP_ITEM_DATE',TRUE) ;
9499: x_errbuf := 'PA_AL_INVALID_EXP_ITEM_DATE' ;

Line 9583: -1,pa_utils.GetOrgName(patd.cint_exp_org_id ),

9579: , decode(patd.transaction_type,'T', run_rec.target_exp_type_class,
9580: run_rec.offset_exp_type_class)
9581: , v_batch_name
9582: , decode(p_rule_id, --Changed for capital project changes
9583: -1,pa_utils.GetOrgName(patd.cint_exp_org_id ),
9584: decode(patd.transaction_type,
9585: 'T',v_target_expnd_org,
9586: v_offset_expnd_org))
9587: , v_expnd_end_date

Line 9637: -1,pa_utils4.GetOrgBusinessGrpId(patd.cint_exp_org_id ),

9633: , decode(p_rule_id,-1,patd.cint_exp_org_id,
9634: decode(patd.transaction_type,'T',run_rec.target_exp_org_id,
9635: run_rec.offset_exp_org_id))
9636: , decode(p_rule_id,
9637: -1,pa_utils4.GetOrgBusinessGrpId(patd.cint_exp_org_id ),
9638: decode(patd.transaction_type,
9639: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)
9640: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9641: /* end of performance changes */

Line 9639: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)

9635: run_rec.offset_exp_org_id))
9636: , decode(p_rule_id,
9637: -1,pa_utils4.GetOrgBusinessGrpId(patd.cint_exp_org_id ),
9638: decode(patd.transaction_type,
9639: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)
9640: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9641: /* end of performance changes */
9642: from pa_alloc_txn_details patd
9643: , pa_projects_all pp

Line 9640: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))

9636: , decode(p_rule_id,
9637: -1,pa_utils4.GetOrgBusinessGrpId(patd.cint_exp_org_id ),
9638: decode(patd.transaction_type,
9639: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)
9640: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9641: /* end of performance changes */
9642: from pa_alloc_txn_details patd
9643: , pa_projects_all pp
9644: , pa_tasks pt