DBA Data[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PLAN_TASK_OBJ_TBL

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