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 PLAN_TASK_OBJ

Line 3013: l_plan_task_obj SYSTEM.plan_task_obj ;

3009: l_budget_cnt number := 0;
3010:
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 ;

Line 3014: l_Plan_Task_OBJ_tbl SYSTEM.Plan_Task_OBJ_tbl ;

3010:
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 ;

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 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

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
3334:
3335: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP

Line 3333: if ( l_Plan_Task_OBJ_tbl.count > 0 ) then

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
3334:
3335: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3336:
3337: log_pvt('BUDGET_DATA',' BEFORE LINE plan_task_id '||l_plan_task_obj.plan_task_id);

Line 3335: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP

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
3334:
3335: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3336:
3337: log_pvt('BUDGET_DATA',' BEFORE LINE plan_task_id '||l_plan_task_obj.plan_task_id);
3338: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3339: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);

Line 3337: log_pvt('BUDGET_DATA',' BEFORE LINE plan_task_id '||l_plan_task_obj.plan_task_id);

3333: if ( l_Plan_Task_OBJ_tbl.count > 0 ) then
3334:
3335: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3336:
3337: log_pvt('BUDGET_DATA',' BEFORE LINE plan_task_id '||l_plan_task_obj.plan_task_id);
3338: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3339: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3340:
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);

Line 3338: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);

3334:
3335: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3336:
3337: log_pvt('BUDGET_DATA',' BEFORE LINE plan_task_id '||l_plan_task_obj.plan_task_id);
3338: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3339: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3340:
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;

Line 3339: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);

3335: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3336:
3337: log_pvt('BUDGET_DATA',' BEFORE LINE plan_task_id '||l_plan_task_obj.plan_task_id);
3338: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3339: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3340:
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3343:

Line 3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);

3337: log_pvt('BUDGET_DATA',' BEFORE LINE plan_task_id '||l_plan_task_obj.plan_task_id);
3338: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3339: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3340:
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3343:
3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

Line 3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;

3338: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3339: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3340:
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3343:
3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;

Line 3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3340:
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3343:
3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

Line 3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3343:
3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

Line 3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

Line 3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

Line 3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

Line 3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

Line 3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
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 ;

Line 3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
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

Line 3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
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 ;

Line 3372: log_pvt('BUDGET_DATA',' AFTER LINE task_id '||l_plan_task_obj.task_id);

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);
3374: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3375: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3376:

Line 3373: log_pvt('BUDGET_DATA',' AFTER LINE plan_task_id '||l_plan_task_obj.plan_task_id);

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);
3374: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3375: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3376:
3377:

Line 3374: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);

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);
3374: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3375: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3376:
3377:
3378: if ( ( l_level_code <> 'P' ) AND ( nvl(l_res_list_id,1000) = 1000 ) ) then --Kmaddi

Line 3375: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);

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);
3374: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_RAW_COST '||l_plan_task_obj.TOTAL_RAW_COST);
3375: log_pvt('BUDGET_DATA',' AFTER LINE TOTAL_BURDENED_COST '||l_plan_task_obj.TOTAL_BURDENED_COST);
3376:
3377:
3378: if ( ( l_level_code <> 'P' ) AND ( nvl(l_res_list_id,1000) = 1000 ) ) then --Kmaddi
3379:

Line 3380: l_budget_line_in_rec.pa_task_id := l_plan_task_obj.task_id;

3376:
3377:
3378: if ( ( l_level_code <> 'P' ) AND ( nvl(l_res_list_id,1000) = 1000 ) ) then --Kmaddi
3379:
3380: l_budget_line_in_rec.pa_task_id := l_plan_task_obj.task_id;
3381: l_budget_line_in_rec.raw_cost := l_plan_task_obj.TOTAL_RAW_COST;
3382: --l_budget_line_in_rec.burdened_cost := l_plan_task_obj.TOTAL_BURDENED_COST; --Bug 8811777
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;

Line 3381: l_budget_line_in_rec.raw_cost := l_plan_task_obj.TOTAL_RAW_COST;

3377:
3378: if ( ( l_level_code <> 'P' ) AND ( nvl(l_res_list_id,1000) = 1000 ) ) then --Kmaddi
3379:
3380: l_budget_line_in_rec.pa_task_id := l_plan_task_obj.task_id;
3381: l_budget_line_in_rec.raw_cost := l_plan_task_obj.TOTAL_RAW_COST;
3382: --l_budget_line_in_rec.burdened_cost := l_plan_task_obj.TOTAL_BURDENED_COST; --Bug 8811777
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;

Line 3382: --l_budget_line_in_rec.burdened_cost := l_plan_task_obj.TOTAL_BURDENED_COST; --Bug 8811777

3378: if ( ( l_level_code <> 'P' ) AND ( nvl(l_res_list_id,1000) = 1000 ) ) then --Kmaddi
3379:
3380: l_budget_line_in_rec.pa_task_id := l_plan_task_obj.task_id;
3381: l_budget_line_in_rec.raw_cost := l_plan_task_obj.TOTAL_RAW_COST;
3382: --l_budget_line_in_rec.burdened_cost := l_plan_task_obj.TOTAL_BURDENED_COST; --Bug 8811777
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;

Line 3384: l_budget_line_in_rec.pm_budget_line_reference := l_plan_task_obj.plan_task_id;

3380: l_budget_line_in_rec.pa_task_id := l_plan_task_obj.task_id;
3381: l_budget_line_in_rec.raw_cost := l_plan_task_obj.TOTAL_RAW_COST;
3382: --l_budget_line_in_rec.burdened_cost := l_plan_task_obj.TOTAL_BURDENED_COST; --Bug 8811777
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:

Line 3385: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;

3381: l_budget_line_in_rec.raw_cost := l_plan_task_obj.TOTAL_RAW_COST;
3382: --l_budget_line_in_rec.burdened_cost := l_plan_task_obj.TOTAL_BURDENED_COST; --Bug 8811777
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

Line 3386: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;

3382: --l_budget_line_in_rec.burdened_cost := l_plan_task_obj.TOTAL_BURDENED_COST; --Bug 8811777
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 );

Line 3389: OPEN l_period_date_csr( l_plan_task_obj.Startdate

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:
3392: FETCH l_period_date_csr
3393: INTO l_budget_line_in_rec.budget_start_date,

Line 3398: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;

3394: l_budget_line_in_rec.budget_end_date;
3395:
3396: IF l_period_date_csr%NOTFOUND
3397: THEN
3398: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;
3399: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;
3400: END IF;
3401: CLOSE l_period_date_csr;
3402:

Line 3399: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;

3395:
3396: IF l_period_date_csr%NOTFOUND
3397: THEN
3398: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;
3399: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;
3400: END IF;
3401: CLOSE l_period_date_csr;
3402:
3403: log_pvt('BUDGET','Level Non P :budget_start_date: '||l_budget_line_in_rec.budget_start_date||' :budget_end_date: '||l_budget_line_in_rec.budget_end_date);

Line 3412: l_budget_line_in_rec.pa_task_id := l_plan_task_obj.task_id;

3408: end if;
3409:
3410: if ( ( l_level_code <> 'P' ) and ( nvl(l_res_list_id,1000) <> 1000 ) ) then
3411:
3412: l_budget_line_in_rec.pa_task_id := l_plan_task_obj.task_id;
3413:
3414: end if;
3415:
3416: IF ( ( l_level_code = 'P' ) and ( nvl(l_res_list_id,1000) <> 1000 ) ) THEN -- Bug 8813761

Line 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

3460: l_budget_line_in_rec.resource_list_member_id := l_task_line_obj.RESOURCE_LIST_MEMBER_ID;
3461: l_budget_line_in_rec.raw_cost := l_task_line_obj.TOTAL_RAW_COST;
3462: --l_budget_line_in_rec.burdened_cost := l_task_line_obj.TOTAL_BURDENED_COST; --Bug 8811777
3463: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
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;

Line 3465: l_budget_line_in_rec.pm_budget_line_reference := l_plan_task_obj.plan_task_id; --Kmaddi

3461: l_budget_line_in_rec.raw_cost := l_task_line_obj.TOTAL_RAW_COST;
3462: --l_budget_line_in_rec.burdened_cost := l_task_line_obj.TOTAL_BURDENED_COST; --Bug 8811777
3463: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
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:

Line 3466: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;

3462: --l_budget_line_in_rec.burdened_cost := l_task_line_obj.TOTAL_BURDENED_COST; --Bug 8811777
3463: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
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

Line 3467: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;

3463: l_budget_line_in_rec.pm_product_code := 'PRIMAVERA';
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 );

Line 3470: OPEN l_period_date_csr( l_plan_task_obj.Startdate

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:
3473: FETCH l_period_date_csr
3474: INTO l_budget_line_in_rec.budget_start_date,

Line 3479: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;

3475: l_budget_line_in_rec.budget_end_date;
3476:
3477: IF l_period_date_csr%NOTFOUND
3478: THEN
3479: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;
3480: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;
3481: END IF;
3482:
3483: CLOSE l_period_date_csr;

Line 3480: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;

3476:
3477: IF l_period_date_csr%NOTFOUND
3478: THEN
3479: l_budget_line_in_rec.budget_start_date := l_plan_task_obj.Startdate;
3480: l_budget_line_in_rec.budget_end_date := l_plan_task_obj.Enddate;
3481: END IF;
3482:
3483: CLOSE l_period_date_csr;
3484:

Line 3497: end if; --l_Plan_Task_OBJ_tbl.count > 0

3493: end if; -- l_task_line_OBJ_tbl is not null
3494: end if; -- l_task_line_OBJ_tbl.count > 0
3495:
3496: end loop ;
3497: end if; --l_Plan_Task_OBJ_tbl.count > 0
3498: end if; -- l_Plan_Task_OBJ_tbl is not null
3499:
3500: --------- END ---------- reading one budget data into AMG API budget records ------------------
3501:

Line 3498: end if; -- l_Plan_Task_OBJ_tbl is not null

3494: end if; -- l_task_line_OBJ_tbl.count > 0
3495:
3496: end loop ;
3497: end if; --l_Plan_Task_OBJ_tbl.count > 0
3498: end if; -- l_Plan_Task_OBJ_tbl is not null
3499:
3500: --------- END ---------- reading one budget data into AMG API budget records ------------------
3501:
3502: log_pvt('BUDGET_CALL',' l_return_status '||l_return_status);

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 3627: if ( l_Plan_Task_OBJ_tbl.count > 0 ) then

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);
3630: l_plan_task_out_obj := SYSTEM.plan_task_out_obj(null,null,null);
3631:

Line 3629: l_plan_task_OUT_TBL.extend(l_Plan_Task_OBJ_tbl.count);

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);
3630: l_plan_task_out_obj := SYSTEM.plan_task_out_obj(null,null,null);
3631:
3632: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3633:

Line 3632: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP

3628:
3629: l_plan_task_OUT_TBL.extend(l_Plan_Task_OBJ_tbl.count);
3630: l_plan_task_out_obj := SYSTEM.plan_task_out_obj(null,null,null);
3631:
3632: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3633:
3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3635: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3636: null;

Line 3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);

3630: l_plan_task_out_obj := SYSTEM.plan_task_out_obj(null,null,null);
3631:
3632: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3633:
3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3635: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3636: null;
3637: l_plan_task_out_obj.AIA_COMMON_ID := l_plan_task_obj.AIA_COMMON_ID;
3638: l_plan_task_out_obj.plan_task_id := l_plan_task_obj.task_id;

Line 3635: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;

3631:
3632: for j in l_Plan_Task_OBJ_tbl.first .. l_Plan_Task_OBJ_tbl.last LOOP
3633:
3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3635: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3636: null;
3637: l_plan_task_out_obj.AIA_COMMON_ID := l_plan_task_obj.AIA_COMMON_ID;
3638: l_plan_task_out_obj.plan_task_id := l_plan_task_obj.task_id;
3639:

Line 3637: l_plan_task_out_obj.AIA_COMMON_ID := l_plan_task_obj.AIA_COMMON_ID;

3633:
3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3635: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3636: null;
3637: l_plan_task_out_obj.AIA_COMMON_ID := l_plan_task_obj.AIA_COMMON_ID;
3638: l_plan_task_out_obj.plan_task_id := l_plan_task_obj.task_id;
3639:
3640: l_task_line_OUT_TBL := SYSTEM.task_line_OUT_OBJ_TBL();
3641:

Line 3638: l_plan_task_out_obj.plan_task_id := l_plan_task_obj.task_id;

3634: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3635: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3636: null;
3637: l_plan_task_out_obj.AIA_COMMON_ID := l_plan_task_obj.AIA_COMMON_ID;
3638: l_plan_task_out_obj.plan_task_id := l_plan_task_obj.task_id;
3639:
3640: l_task_line_OUT_TBL := SYSTEM.task_line_OUT_OBJ_TBL();
3641:
3642:

Line 3654: l_task_line_out_obj.task_line_id := l_plan_task_obj.task_id||'-'||l_task_line_obj.RESOURCE_LIST_MEMBER_ID;

3650:
3651: l_task_line_obj := l_task_line_OBJ_tbl(k);
3652:
3653: l_task_line_out_obj.AIA_COMMON_ID := l_task_line_obj.AIA_COMMON_ID;
3654: l_task_line_out_obj.task_line_id := l_plan_task_obj.task_id||'-'||l_task_line_obj.RESOURCE_LIST_MEMBER_ID;
3655:
3656: l_task_line_OUT_TBL(k) := l_task_line_out_obj;
3657:
3658: end loop;