DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_UTILS

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

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

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

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

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

972: IF P_DEBUG_MODE = 'Y' THEN
973: pa_debug.write_file('validate_rule: ' || 'LOG', pa_debug.G_err_stage);
974: END IF;
975: IF( p_target_exp_org_id IS NULL OR
976: pa_utils2.CheckExpOrg( p_target_exp_org_id) = 'N') THEN
977: G_fatal_err_found := TRUE;
978: alloc_errors( p_rule_id, p_run_id, 'R', 'E',
979: 'PA_AL_INVALID_TARGET_EXP_ORG') ;
980: END IF;

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

1004: IF( p_offset_exp_org_id IS NULL ) THEN
1005: G_fatal_err_found := TRUE;
1006: alloc_errors( p_rule_id, p_run_id, 'R', 'E',
1007: 'PA_AL_UNDEFINED_OFFSET_EXP_ORG') ;
1008: ELSIF(pa_utils2.CheckExpOrg( p_offset_exp_org_id) = 'N') THEN
1009: G_fatal_err_found := TRUE;
1010: alloc_errors( p_rule_id, p_run_id, 'R', 'E',
1011: 'PA_AL_INVALID_OFFSET_EXP_ORG') ;
1012: END IF;

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

9365: 'R', 'E', NULL, NULL, 'PA_AL_RUN_NOT_EXISTS');
9366: x_errbuf := 'PA_AL_RUN_NOT_EXISTS' ;
9367: END IF;
9368: CLOSE C_run;
9369: v_target_expnd_org := pa_utils.GetOrgName(run_rec.target_exp_org_id ) ;
9370: v_offset_expnd_org := pa_utils.GetOrgName(run_rec.offset_exp_org_id ) ;
9371: If (nvl(p_rule_id,-99) <> -1) AND --Added this condition for capital project changes
9372: v_target_expnd_org is NULL THEN
9373: G_fatal_err_found := TRUE;

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

9366: x_errbuf := 'PA_AL_RUN_NOT_EXISTS' ;
9367: END IF;
9368: CLOSE C_run;
9369: v_target_expnd_org := pa_utils.GetOrgName(run_rec.target_exp_org_id ) ;
9370: v_offset_expnd_org := pa_utils.GetOrgName(run_rec.offset_exp_org_id ) ;
9371: If (nvl(p_rule_id,-99) <> -1) AND --Added this condition for capital project changes
9372: v_target_expnd_org is NULL THEN
9373: G_fatal_err_found := TRUE;
9374: pa_alloc_run.ins_alloc_exceptions( p_rule_id, p_run_id, G_creation_date,

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

9386: G_last_updated_by, G_last_update_login,
9387: 'R', 'E', NULL, NULL, 'PA_AL_INVALID_OFFSET_EXP_ORG');
9388: x_errbuf := 'PA_AL_INVALID_OFFSET_EXP_ORG' ;
9389: End if ;
9390: v_expnd_end_date := pa_utils.GetWeekEnding(run_rec.expnd_item_date) ;
9391: If v_expnd_end_date is NULL then
9392: G_fatal_err_found := TRUE;
9393: alloc_errors(p_rule_id, p_run_id, 'R', 'E','PA_AL_INVALID_EXP_ITEM_DATE',TRUE) ;
9394: x_errbuf := 'PA_AL_INVALID_EXP_ITEM_DATE' ;

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

9474: , decode(patd.transaction_type,'T', run_rec.target_exp_type_class,
9475: run_rec.offset_exp_type_class)
9476: , v_batch_name
9477: , decode(p_rule_id, --Changed for capital project changes
9478: -1,pa_utils.GetOrgName(patd.cint_exp_org_id ),
9479: decode(patd.transaction_type,
9480: 'T',v_target_expnd_org,
9481: v_offset_expnd_org))
9482: , v_expnd_end_date

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

9528: , decode(p_rule_id,-1,patd.cint_exp_org_id,
9529: decode(patd.transaction_type,'T',run_rec.target_exp_org_id,
9530: run_rec.offset_exp_org_id))
9531: , decode(p_rule_id,
9532: -1,pa_utils4.GetOrgBusinessGrpId(patd.cint_exp_org_id ),
9533: decode(patd.transaction_type,
9534: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)
9535: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9536: /* end of performance changes */

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

9530: run_rec.offset_exp_org_id))
9531: , decode(p_rule_id,
9532: -1,pa_utils4.GetOrgBusinessGrpId(patd.cint_exp_org_id ),
9533: decode(patd.transaction_type,
9534: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)
9535: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9536: /* end of performance changes */
9537: from pa_alloc_txn_details patd
9538: , pa_projects_all pp

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

9531: , decode(p_rule_id,
9532: -1,pa_utils4.GetOrgBusinessGrpId(patd.cint_exp_org_id ),
9533: decode(patd.transaction_type,
9534: 'T',pa_utils4.GetOrgBusinessGrpId(run_rec.target_exp_org_id)
9535: ,pa_utils4.GetOrgBusinessGrpId(run_rec.offset_exp_org_id)))
9536: /* end of performance changes */
9537: from pa_alloc_txn_details patd
9538: , pa_projects_all pp
9539: , pa_tasks pt