DBA Data[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on BUDGET_OUT_OBJ

Line 2992: X_budget_OUT OUT NOCOPY SYSTEM.budget_OUT_OBJ_TBL

2988: raise;
2989: end get_project_org_name;
2990:
2991: PROCEDURE SYNC_BUDGETS(
2992: X_budget_OUT OUT NOCOPY SYSTEM.budget_OUT_OBJ_TBL
2993: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
2994: ,P_SYNC_MODE IN CHAR := 'S'
2995: ,P_budget_IN IN SYSTEM.budget_IN_OBJ_TBL
2996: )

Line 3017: l_budget_out_obj SYSTEM.budget_out_obj ;

3013: l_plan_task_obj SYSTEM.plan_task_obj ;
3014: l_Plan_Task_OBJ_tbl SYSTEM.Plan_Task_OBJ_tbl ;
3015: l_budget_in_obj SYSTEM.budget_in_obj ;
3016: l_budget_in_obj_TBL SYSTEM.budget_in_obj_TBL ;
3017: l_budget_out_obj SYSTEM.budget_out_obj ;
3018: l_budget_out_obj_tbl SYSTEM.budget_out_obj_tbl ;
3019:
3020: l_return_status varchar2(3) := 'S';
3021: lx_return_status varchar2(3) := 'S';

Line 3018: l_budget_out_obj_tbl SYSTEM.budget_out_obj_tbl ;

3014: l_Plan_Task_OBJ_tbl SYSTEM.Plan_Task_OBJ_tbl ;
3015: l_budget_in_obj SYSTEM.budget_in_obj ;
3016: l_budget_in_obj_TBL SYSTEM.budget_in_obj_TBL ;
3017: l_budget_out_obj SYSTEM.budget_out_obj ;
3018: l_budget_out_obj_tbl SYSTEM.budget_out_obj_tbl ;
3019:
3020: l_return_status varchar2(3) := 'S';
3021: lx_return_status varchar2(3) := 'S';
3022: l_return_message varchar2(200);

Line 3083: l_budget_out_obj_tbl := SYSTEM.budget_out_obj_tbl();

3079: log_pvt('BUDGET', '############# FND_GLOBAL.ORG_ID '|| FND_GLOBAL.ORG_ID);
3080:
3081: MO_GLOBAL.SET_POLICY_CONTEXT('S',fnd_global.ORG_ID); -- Bug 10254776
3082:
3083: l_budget_out_obj_tbl := SYSTEM.budget_out_obj_tbl();
3084:
3085: l_budget_out_obj_tbl.extend(P_budget_IN.count);
3086:
3087: l_budget_out_obj := SYSTEM.budget_out_obj(null,null,null,null,null);

Line 3085: l_budget_out_obj_tbl.extend(P_budget_IN.count);

3081: MO_GLOBAL.SET_POLICY_CONTEXT('S',fnd_global.ORG_ID); -- Bug 10254776
3082:
3083: l_budget_out_obj_tbl := SYSTEM.budget_out_obj_tbl();
3084:
3085: l_budget_out_obj_tbl.extend(P_budget_IN.count);
3086:
3087: l_budget_out_obj := SYSTEM.budget_out_obj(null,null,null,null,null);
3088:
3089:

Line 3087: l_budget_out_obj := SYSTEM.budget_out_obj(null,null,null,null,null);

3083: l_budget_out_obj_tbl := SYSTEM.budget_out_obj_tbl();
3084:
3085: l_budget_out_obj_tbl.extend(P_budget_IN.count);
3086:
3087: l_budget_out_obj := SYSTEM.budget_out_obj(null,null,null,null,null);
3088:
3089:
3090: FOR i in P_budget_IN.first .. P_budget_IN.last LOOP
3091:

Line 3157: l_budget_out_obj.AIA_COMMON_ID := l_budget_in_obj.AIA_COMMON_ID;

3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3154: l_budget_in_obj.Description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3155: end if;
3156:
3157: l_budget_out_obj.AIA_COMMON_ID := l_budget_in_obj.AIA_COMMON_ID;
3158: l_budget_out_obj.budget_id := l_budget_in_obj.project_id;
3159: l_budget_out_obj.RETURN_STATUS := 'S';
3160:
3161: log_pvt('BUDGET_DATA',' AFTER HEAD project_id '||l_budget_in_obj.PROJECT_ID);

Line 3158: l_budget_out_obj.budget_id := l_budget_in_obj.project_id;

3154: l_budget_in_obj.Description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3155: end if;
3156:
3157: l_budget_out_obj.AIA_COMMON_ID := l_budget_in_obj.AIA_COMMON_ID;
3158: l_budget_out_obj.budget_id := l_budget_in_obj.project_id;
3159: l_budget_out_obj.RETURN_STATUS := 'S';
3160:
3161: log_pvt('BUDGET_DATA',' AFTER HEAD project_id '||l_budget_in_obj.PROJECT_ID);
3162: log_pvt('BUDGET_DATA',' AFTER HEAD Currency_Code '||l_budget_in_obj.Currency_Code);

Line 3159: l_budget_out_obj.RETURN_STATUS := 'S';

3155: end if;
3156:
3157: l_budget_out_obj.AIA_COMMON_ID := l_budget_in_obj.AIA_COMMON_ID;
3158: l_budget_out_obj.budget_id := l_budget_in_obj.project_id;
3159: l_budget_out_obj.RETURN_STATUS := 'S';
3160:
3161: log_pvt('BUDGET_DATA',' AFTER HEAD project_id '||l_budget_in_obj.PROJECT_ID);
3162: log_pvt('BUDGET_DATA',' AFTER HEAD Currency_Code '||l_budget_in_obj.Currency_Code);
3163: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);

Line 3506: l_budget_out_obj.RETURN_STATUS := l_return_status;

3502: log_pvt('BUDGET_CALL',' l_return_status '||l_return_status);
3503: log_pvt('BUDGET_CALL','Before Call l_fin_plan_type_id '||l_fin_plan_type_id||' l_budget_ver_id '||l_budget_ver_id);
3504: log_pvt('BUDGET_CALL','Before Call l_budget_type '||l_budget_type||' l_res_list_id '||l_res_list_id);
3505:
3506: l_budget_out_obj.RETURN_STATUS := l_return_status;
3507: l_budget_out_obj.msg_data := l_return_message;
3508:
3509: if ( ( l_return_status = 'S' ) and ( l_fin_plan_type_id is not null ) ) then
3510:

Line 3507: l_budget_out_obj.msg_data := l_return_message;

3503: log_pvt('BUDGET_CALL','Before Call l_fin_plan_type_id '||l_fin_plan_type_id||' l_budget_ver_id '||l_budget_ver_id);
3504: log_pvt('BUDGET_CALL','Before Call l_budget_type '||l_budget_type||' l_res_list_id '||l_res_list_id);
3505:
3506: l_budget_out_obj.RETURN_STATUS := l_return_status;
3507: l_budget_out_obj.msg_data := l_return_message;
3508:
3509: if ( ( l_return_status = 'S' ) and ( l_fin_plan_type_id is not null ) ) then
3510:
3511: if ( l_budget_ver_id is not null ) then

Line 3552: l_budget_out_obj.RETURN_STATUS := l_return_status;

3548: if ( l_return_status <> 'S' ) then
3549: l_return_status := 'E';
3550: end if;
3551:
3552: l_budget_out_obj.RETURN_STATUS := l_return_status;
3553:
3554:
3555: x_msg_count := nvl(x_msg_count,1);
3556:

Line 3568: l_budget_out_obj.msg_data := l_data;

3564: ,p_msg_index_out => l_msg_index_out
3565: );
3566:
3567: log_pvt('BUDGET_MAIN','ERORRS : '||l_data);
3568: l_budget_out_obj.msg_data := l_data;
3569:
3570: end loop;
3571:
3572: end if; -- end if for plan types calling.

Line 3601: l_budget_out_obj.RETURN_STATUS := l_return_status;

3597: if ( l_return_status <> 'S' ) then
3598: l_return_status := 'E';
3599: end if;
3600:
3601: l_budget_out_obj.RETURN_STATUS := l_return_status;
3602:
3603:
3604: x_msg_count := nvl(x_msg_count,1);
3605:

Line 3617: l_budget_out_obj.msg_data := l_data;

3613: ,p_msg_index_out => l_msg_index_out
3614: );
3615:
3616: log_pvt('BUDGET_MAIN','ERORRS : '||l_data);
3617: l_budget_out_obj.msg_data := l_data;
3618:
3619: end loop;
3620: end if; -- budget type code calling;
3621:

Line 3625: if ( ( l_Plan_Task_OBJ_tbl is not null ) and ( l_budget_out_obj.return_status = 'S' ) ) then

3621:
3622:
3623: l_plan_task_OUT_TBL := SYSTEM.plan_task_OUT_OBJ_TBL();
3624:
3625: if ( ( l_Plan_Task_OBJ_tbl is not null ) and ( l_budget_out_obj.return_status = 'S' ) ) then
3626:
3627: if ( l_Plan_Task_OBJ_tbl.count > 0 ) then
3628:
3629: l_plan_task_OUT_TBL.extend(l_Plan_Task_OBJ_tbl.count);

Line 3671: lX_RETURN_STATUS := l_budget_out_obj.return_status;

3667: end if;
3668:
3669: if ( nvl(lx_return_status,'S') = 'S') then
3670:
3671: lX_RETURN_STATUS := l_budget_out_obj.return_status;
3672:
3673: end if;
3674:
3675: l_budget_out_obj.o_plan_task_tbl := l_plan_task_OUT_TBL;

Line 3675: l_budget_out_obj.o_plan_task_tbl := l_plan_task_OUT_TBL;

3671: lX_RETURN_STATUS := l_budget_out_obj.return_status;
3672:
3673: end if;
3674:
3675: l_budget_out_obj.o_plan_task_tbl := l_plan_task_OUT_TBL;
3676: l_budget_out_obj_tbl(i) := l_budget_out_obj;
3677:
3678:
3679: end loop; -- end loop for budgets object

Line 3676: l_budget_out_obj_tbl(i) := l_budget_out_obj;

3672:
3673: end if;
3674:
3675: l_budget_out_obj.o_plan_task_tbl := l_plan_task_OUT_TBL;
3676: l_budget_out_obj_tbl(i) := l_budget_out_obj;
3677:
3678:
3679: end loop; -- end loop for budgets object
3680:

Line 3681: X_budget_OUT := l_budget_out_obj_tbl;

3677:
3678:
3679: end loop; -- end loop for budgets object
3680:
3681: X_budget_OUT := l_budget_out_obj_tbl;
3682: x_return_status := lx_return_status;
3683:
3684: END SYNC_BUDGETS;
3685: