eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on BUDGET_IN_OBJ

Line 2995: ,P_budget_IN IN SYSTEM.budget_IN_OBJ_TBL

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: )
2997: IS
2998:
2999: l_budget_line_out_tbl pa_budget_pub.budget_line_out_tbl_type;

Line 3015: l_budget_in_obj SYSTEM.budget_in_obj ;

3011: l_task_line_obj SYSTEM.task_line_obj ;
3012: l_task_line_OBJ_tbl SYSTEM.task_line_OBJ_tbl;
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:

Line 3016: l_budget_in_obj_TBL SYSTEM.budget_in_obj_TBL ;

3012: l_task_line_OBJ_tbl SYSTEM.task_line_OBJ_tbl;
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';

Line 3097: l_budget_in_obj := P_budget_in(i);

3093: l_budget_line_out_tbl.delete;
3094:
3095: --------- START ---------- reading one budget data into AMG API budget records ------------------
3096:
3097: l_budget_in_obj := P_budget_in(i);
3098:
3099: log_pvt('BUDGET_DATA',' BEFORE HEAD project_id '||l_budget_in_obj.PROJECT_ID);
3100: log_pvt('BUDGET_DATA',' BEFORE HEAD Currency_Code '||l_budget_in_obj.Currency_Code);
3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);

Line 3099: log_pvt('BUDGET_DATA',' BEFORE HEAD project_id '||l_budget_in_obj.PROJECT_ID);

3095: --------- START ---------- reading one budget data into AMG API budget records ------------------
3096:
3097: l_budget_in_obj := P_budget_in(i);
3098:
3099: log_pvt('BUDGET_DATA',' BEFORE HEAD project_id '||l_budget_in_obj.PROJECT_ID);
3100: log_pvt('BUDGET_DATA',' BEFORE HEAD Currency_Code '||l_budget_in_obj.Currency_Code);
3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);

Line 3100: log_pvt('BUDGET_DATA',' BEFORE HEAD Currency_Code '||l_budget_in_obj.Currency_Code);

3096:
3097: l_budget_in_obj := P_budget_in(i);
3098:
3099: log_pvt('BUDGET_DATA',' BEFORE HEAD project_id '||l_budget_in_obj.PROJECT_ID);
3100: log_pvt('BUDGET_DATA',' BEFORE HEAD Currency_Code '||l_budget_in_obj.Currency_Code);
3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:

Line 3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);

3097: l_budget_in_obj := P_budget_in(i);
3098:
3099: log_pvt('BUDGET_DATA',' BEFORE HEAD project_id '||l_budget_in_obj.PROJECT_ID);
3100: log_pvt('BUDGET_DATA',' BEFORE HEAD Currency_Code '||l_budget_in_obj.Currency_Code);
3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);

3098:
3099: log_pvt('BUDGET_DATA',' BEFORE HEAD project_id '||l_budget_in_obj.PROJECT_ID);
3100: log_pvt('BUDGET_DATA',' BEFORE HEAD Currency_Code '||l_budget_in_obj.Currency_Code);
3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

Line 3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);

3099: log_pvt('BUDGET_DATA',' BEFORE HEAD project_id '||l_budget_in_obj.PROJECT_ID);
3100: log_pvt('BUDGET_DATA',' BEFORE HEAD Currency_Code '||l_budget_in_obj.Currency_Code);
3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;

Line 3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

Line 3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

Line 3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

Line 3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

Line 3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

Line 3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

Line 3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

Line 3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

Line 3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

Line 3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

Line 3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

Line 3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

Line 3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
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 ;

Line 3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
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;

Line 3154: l_budget_in_obj.Description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
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;

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 3161: log_pvt('BUDGET_DATA',' AFTER HEAD project_id '||l_budget_in_obj.PROJECT_ID);

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);
3164: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3165: log_pvt('BUDGET_DATA',' AFTER HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);

Line 3162: log_pvt('BUDGET_DATA',' AFTER HEAD Currency_Code '||l_budget_in_obj.Currency_Code);

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);
3164: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3165: log_pvt('BUDGET_DATA',' AFTER HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3166:

Line 3163: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);

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);
3164: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3165: log_pvt('BUDGET_DATA',' AFTER HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3166:
3167: log_pvt('BUDGET','before selecting intg options l_budget_in_obj.project_id '||l_budget_in_obj.project_id );

Line 3164: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);

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);
3164: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3165: log_pvt('BUDGET_DATA',' AFTER HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3166:
3167: log_pvt('BUDGET','before selecting intg options l_budget_in_obj.project_id '||l_budget_in_obj.project_id );
3168:

Line 3165: log_pvt('BUDGET_DATA',' AFTER HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);

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);
3164: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3165: log_pvt('BUDGET_DATA',' AFTER HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3166:
3167: log_pvt('BUDGET','before selecting intg options l_budget_in_obj.project_id '||l_budget_in_obj.project_id );
3168:
3169: begin

Line 3167: log_pvt('BUDGET','before selecting intg options l_budget_in_obj.project_id '||l_budget_in_obj.project_id );

3163: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3164: log_pvt('BUDGET_DATA',' AFTER HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3165: log_pvt('BUDGET_DATA',' AFTER HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3166:
3167: log_pvt('BUDGET','before selecting intg options l_budget_in_obj.project_id '||l_budget_in_obj.project_id );
3168:
3169: begin
3170:
3171: l_fin_plan_type_id := null;

Line 3176: where i1.project_id = l_budget_in_obj.project_id

3172: l_budget_type := null;
3173: select i1.fin_plan_type_id , i1.budget_type, p1.start_date , p1.completion_date
3174: into l_fin_plan_type_id , l_budget_type, l_start_date , l_end_date
3175: from pa_integration_settings i1, pa_projects_all p1
3176: where i1.project_id = l_budget_in_obj.project_id
3177: and i1.project_id = p1.project_id
3178: and i1.enable_integration = 'Y';
3179:
3180: exception

Line 3208: where a.project_id = l_budget_in_obj.project_id

3204: begin
3205: select b.cost_fin_plan_level_code , b.cost_resource_list_id , a.budget_version_id , b.cost_time_phased_code --a.* -- <> 1000
3206: into l_level_code , l_res_list_id , l_budget_ver_id , l_cost_time_phased_code
3207: from pa_budget_versions a , pa_proj_fp_options b
3208: where a.project_id = l_budget_in_obj.project_id
3209: and a.budget_status_code = 'W'
3210: and a.current_working_flag = 'Y'
3211: and a.fin_plan_type_id = b.fin_plan_type_id
3212: and a.budget_version_id = b.fin_plan_version_id --Kmaddi

Line 3234: where b.project_id = l_budget_in_obj.project_id

3230: begin
3231: select b.cost_fin_plan_level_code , b.cost_resource_list_id , to_number(null) , b.cost_time_phased_code --a.* -- <> 1000
3232: into l_level_code , l_res_list_id , l_budget_ver_id , l_cost_time_phased_code
3233: from pa_proj_fp_options b
3234: where b.project_id = l_budget_in_obj.project_id
3235: and b.fin_plan_option_level_code = 'PLAN_TYPE'
3236: and b.fin_plan_preference_code like '%COST%'
3237: and b.fin_plan_type_id = l_fin_plan_type_id;
3238:

Line 3266: and a.project_id = l_budget_in_obj.project_id

3262: b.time_phased_type_code --Bug 8821532
3263: into l_res_list_id, l_level_code, l_budget_ver_id, l_ver_name , l_ver_number,l_cost_time_phased_code --Bug 8821532
3264: FROM PA_BUDGET_VERSIONS a , pa_budget_entry_methods b
3265: where a.fin_plan_type_id is null
3266: and a.project_id = l_budget_in_obj.project_id
3267: and a.budget_status_code = 'W'
3268: --and a.current_working_flag = 'Y' --Bug 8821532
3269: and a.budget_type_code = l_budget_type
3270: and b.budget_entry_method_code = a.budget_entry_method_code ;

Line 3296: l_budget_line_in_rec.raw_cost := l_budget_in_obj.TOTAL_RAW_COST;

3292:
3293: if ( l_level_code = 'P' and nvl(l_res_list_id,1000) = 1000 ) and l_return_status = 'S' then
3294:
3295:
3296: l_budget_line_in_rec.raw_cost := l_budget_in_obj.TOTAL_RAW_COST;
3297: --l_budget_line_in_rec.burdened_cost := l_budget_in_obj.TOTAL_BURDENED_COST; --Bug 8811777
3298: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
3299: l_budget_line_in_rec.pm_budget_line_reference := l_budget_in_obj.project_id;
3300: l_budget_line_in_rec.budget_start_date := l_start_date;

Line 3297: --l_budget_line_in_rec.burdened_cost := l_budget_in_obj.TOTAL_BURDENED_COST; --Bug 8811777

3293: if ( l_level_code = 'P' and nvl(l_res_list_id,1000) = 1000 ) and l_return_status = 'S' then
3294:
3295:
3296: l_budget_line_in_rec.raw_cost := l_budget_in_obj.TOTAL_RAW_COST;
3297: --l_budget_line_in_rec.burdened_cost := l_budget_in_obj.TOTAL_BURDENED_COST; --Bug 8811777
3298: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
3299: l_budget_line_in_rec.pm_budget_line_reference := l_budget_in_obj.project_id;
3300: l_budget_line_in_rec.budget_start_date := l_start_date;
3301: l_budget_line_in_rec.budget_end_date := l_end_date;

Line 3299: l_budget_line_in_rec.pm_budget_line_reference := l_budget_in_obj.project_id;

3295:
3296: l_budget_line_in_rec.raw_cost := l_budget_in_obj.TOTAL_RAW_COST;
3297: --l_budget_line_in_rec.burdened_cost := l_budget_in_obj.TOTAL_BURDENED_COST; --Bug 8811777
3298: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
3299: l_budget_line_in_rec.pm_budget_line_reference := l_budget_in_obj.project_id;
3300: l_budget_line_in_rec.budget_start_date := l_start_date;
3301: l_budget_line_in_rec.budget_end_date := l_end_date;
3302: l_budget_line_in_rec.txn_currency_code := l_budget_in_obj.Currency_Code;
3303: l_budget_line_in_rec.pa_task_id := 0; --Bug 8813761

Line 3302: l_budget_line_in_rec.txn_currency_code := l_budget_in_obj.Currency_Code;

3298: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
3299: l_budget_line_in_rec.pm_budget_line_reference := l_budget_in_obj.project_id;
3300: l_budget_line_in_rec.budget_start_date := l_start_date;
3301: l_budget_line_in_rec.budget_end_date := l_end_date;
3302: l_budget_line_in_rec.txn_currency_code := l_budget_in_obj.Currency_Code;
3303: l_budget_line_in_rec.pa_task_id := 0; --Bug 8813761
3304:
3305: OPEN l_period_date_csr( l_start_date
3306: ,l_cost_time_phased_code );

Line 3329: l_Plan_Task_obj_tbl := l_budget_in_obj.Plan_Task_tbl;

3325:
3326:
3327: end if;
3328:
3329: l_Plan_Task_obj_tbl := l_budget_in_obj.Plan_Task_tbl;
3330:
3331: if ( ( l_Plan_Task_OBJ_tbl is not null ) and ( ( l_level_code <> 'P' ) or ( nvl(l_res_list_id,1000) <> 1000 ) ) ) and l_return_status = 'S' then
3332:
3333: if ( l_Plan_Task_OBJ_tbl.count > 0 ) then

Line 3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3366: end if;
3367:
3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3369: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3370: end if;
3371:
3372: log_pvt('BUDGET_DATA',' AFTER LINE task_id '||l_plan_task_obj.task_id);

Line 3369: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3366: end if;
3367:
3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3369: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3370: end if;
3371:
3372: log_pvt('BUDGET_DATA',' AFTER LINE task_id '||l_plan_task_obj.task_id);
3373: log_pvt('BUDGET_DATA',' AFTER LINE plan_task_id '||l_plan_task_obj.plan_task_id);

Line 3387: l_budget_line_in_rec.txn_currency_code := l_budget_in_obj.Currency_Code;

3383: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
3384: l_budget_line_in_rec.pm_budget_line_reference := l_plan_task_obj.plan_task_id;
3385: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;
3386: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;
3387: l_budget_line_in_rec.txn_currency_code := l_budget_in_obj.Currency_Code;
3388:
3389: OPEN l_period_date_csr( l_plan_task_obj.Startdate
3390: ,l_cost_time_phased_code );
3391:

Line 3468: l_budget_line_in_rec.txn_currency_code := l_budget_in_obj.Currency_Code;

3464: --l_budget_line_in_rec.pm_budget_line_reference := l_plan_task_obj.plan_task_id||'-'||l_task_line_obj.RESOURCE_LIST_MEMBER_ID; --Kmaddi
3465: l_budget_line_in_rec.pm_budget_line_reference := l_plan_task_obj.plan_task_id; --Kmaddi
3466: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;
3467: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;
3468: l_budget_line_in_rec.txn_currency_code := l_budget_in_obj.Currency_Code;
3469:
3470: OPEN l_period_date_csr( l_plan_task_obj.Startdate
3471: ,l_cost_time_phased_code );
3472:

Line 3531: ,p_pm_budget_reference => l_budget_in_obj.PROJECT_ID

3527: ,p_msg_count => x_msg_count
3528: ,p_msg_data => x_msg_data
3529: ,p_return_status => l_return_status
3530: ,p_pm_product_code => 'PRIMAVERA'
3531: ,p_pm_budget_reference => l_budget_in_obj.PROJECT_ID
3532: ,p_budget_version_name => 'Draft Budget'
3533: ,p_pa_project_id => l_budget_in_obj.PROJECT_ID
3534: ,p_budget_lines_in => l_budget_line_in_tbl
3535: ,p_budget_lines_out => l_budget_line_out_tbl

Line 3533: ,p_pa_project_id => l_budget_in_obj.PROJECT_ID

3529: ,p_return_status => l_return_status
3530: ,p_pm_product_code => 'PRIMAVERA'
3531: ,p_pm_budget_reference => l_budget_in_obj.PROJECT_ID
3532: ,p_budget_version_name => 'Draft Budget'
3533: ,p_pa_project_id => l_budget_in_obj.PROJECT_ID
3534: ,p_budget_lines_in => l_budget_line_in_tbl
3535: ,p_budget_lines_out => l_budget_line_out_tbl
3536: ,p_fin_plan_type_id => l_fin_plan_type_id
3537: ,p_create_new_curr_working_flag => l_create_flag

Line 3586: ,p_pa_project_id => l_budget_in_obj.PROJECT_ID

3582: ,p_msg_count => x_msg_count
3583: ,p_msg_data => x_msg_data
3584: ,p_return_status => l_return_status
3585: ,p_pm_product_code => 'PRIMAVERA'
3586: ,p_pa_project_id => l_budget_in_obj.PROJECT_ID
3587: ,p_budget_type_code => l_budget_type
3588: ,p_budget_lines_in => l_budget_line_in_tbl
3589: ,p_budget_lines_out => l_budget_line_out_tbl
3590: ,p_budget_version_number => l_ver_number