[Home] [Help]
1: package body PA_SCHEDULE_OBJECTS_PVT as
2: /*$Header: PASCHOBB.pls 120.21.12020000.5 2013/03/22 17:50:08 srakitin ship $*/
3:
4: G_Pkg_Name CONSTANT VARCHAR2(30):= 'PA _SCHEDULE_OBJECTS_PVT';
5: G1_Debug_Mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: G1_Debug_Mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6: -------------------------------------------------------------
7: PROCEDURE log1
8: (p_msg IN VARCHAR2,
9: p_module IN VARCHAR2 DEFAULT 'PA_SCHEDULE_OBJECTS_PVT')
10: IS
11: pragma autonomous_transaction;
12: l_debug_mode varchar2(1);
13: BEGIN
1314:
1315: BEGIN
1316: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
1317: IF(p_debug_mode = 'Y') and g1_debug_mode = 'Y' THEN
1318: PA_DEBUG.init_err_stack('PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE');
1319: END IF;
1320:
1321: -- Initialize the return status to success
1322:
1335:
1336: l_data_count := P_Data_Structure.COUNT;
1337:
1338: IF g1_debug_mode = 'Y' THEN
1339: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Start', x_Log_Level=> 3);
1340: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'l_data_count='||l_data_count, x_Log_Level=> 3);
1341: END IF;
1342:
1343:
1336: l_data_count := P_Data_Structure.COUNT;
1337:
1338: IF g1_debug_mode = 'Y' THEN
1339: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Start', x_Log_Level=> 3);
1340: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'l_data_count='||l_data_count, x_Log_Level=> 3);
1341: END IF;
1342:
1343:
1344: IF l_data_count <= 0 THEN
1411: l_partial_rollup6 := FALSE;
1412: END IF;
1413:
1414: IF g1_debug_mode = 'Y' THEN
1415: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After deriving partial rollup flags', x_Log_Level=> 3);
1416: END IF;
1417:
1418:
1419:
1715:
1716: END LOOP; -- FOR i IN 1..P_Data_Structure.COUNT LOOP
1717:
1718: IF g1_debug_mode = 'Y' THEN
1719: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After building the table', x_Log_Level=> 3);
1720: END IF;
1721:
1722: FORALL i IN 1..P_Data_Structure.COUNT
1723: INSERT INTO PA_PROJ_ROLLUP_BULK_TEMP(
2068: l_SUMMARY_OBJECT_FLAG(i) -- 4370746
2069: );
2070:
2071: IF g1_debug_mode = 'Y' THEN
2072: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After insertion into table', x_Log_Level=> 3);
2073: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before dirty processing', x_Log_Level=> 3);
2074: END IF;
2075:
2076: -- p_process_flag1 to 6 to decide whether to process anything or not....
2069: );
2070:
2071: IF g1_debug_mode = 'Y' THEN
2072: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After insertion into table', x_Log_Level=> 3);
2073: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before dirty processing', x_Log_Level=> 3);
2074: END IF;
2075:
2076: -- p_process_flag1 to 6 to decide whether to process anything or not....
2077: -- p_process_rollup_flag1 to 6 determine whether the following processing is required
2364:
2365: -- ********* DIRTY PROCESSING END ***********
2366:
2367: IF g1_debug_mode = 'Y' THEN
2368: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After dirty processing', x_Log_Level=> 3);
2369: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before Date processing', x_Log_Level=> 3);
2370: END IF;
2371:
2372: -- ********* NEW DATES PROCESSING BEGIN **********
2365: -- ********* DIRTY PROCESSING END ***********
2366:
2367: IF g1_debug_mode = 'Y' THEN
2368: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After dirty processing', x_Log_Level=> 3);
2369: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before Date processing', x_Log_Level=> 3);
2370: END IF;
2371:
2372: -- ********* NEW DATES PROCESSING BEGIN **********
2373:
4027:
4028: -- ********* DATES PROCESSING END ***********
4029: */
4030: IF g1_debug_mode = 'Y' THEN
4031: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After Date processing', x_Log_Level=> 3);
4032: END IF;
4033:
4034:
4035: -- ********* EFFORT PROCESSING BEGIN **********
4039:
4040: -- ********* PROGRESS STATUS PROCESSING BEGIN ***********
4041:
4042: IF g1_debug_mode = 'Y' THEN
4043: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before Progress Status processing', x_Log_Level=> 3);
4044: END IF;
4045:
4046:
4047: IF ((p_process_flag1 = 'Y' OR p_process_flag2 = 'Y' OR p_process_flag3 = 'Y' OR p_process_flag4 = 'Y'
4060: l_update_required := 'N';
4061:
4062:
4063: IF g1_debug_mode = 'Y' THEN
4064: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before data fetch', x_Log_Level=> 3);
4065: END IF;
4066:
4067: OPEN Parent_Objects_List_prog_sts;
4068: FETCH Parent_Objects_List_prog_sts BULK COLLECT INTO l_object_ids_tab, l_object_types_tab
4069: , l_sum_tab1, l_sum_tab2, l_sum_tab3, l_sum_tab4, l_sum_tab5, l_sum_tab6;
4070: CLOSE Parent_Objects_List_prog_sts;
4071:
4072: IF g1_debug_mode = 'Y' THEN
4073: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Afetr data fetch', x_Log_Level=> 3);
4074: END IF;
4075:
4076: FOR i IN 1..l_object_ids_tab.count LOOP
4077: l_Weight1 := null;
4212: */
4213: END IF; -- ((p_process_flag1 = 'Y' OR p_process_flag2 = 'Y' OR p_process_flag3 = 'Y' OR p_process_flag4 = 'Y'
4214:
4215: IF g1_debug_mode = 'Y' THEN
4216: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After Progress Status processing', x_Log_Level=> 3);
4217: END IF;
4218:
4219: -- ********* PROGRESS STATUS PROCESSING END **************
4220:
4220:
4221: -- ********* TASK STATUS PROCESSING BEGIN **************
4222:
4223: IF g1_debug_mode = 'Y' THEN
4224: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before Task Status processing', x_Log_Level=> 3);
4225: END IF;
4226:
4227:
4228: IF ((p_process_flag1 = 'Y' OR p_process_flag2 = 'Y' OR p_process_flag3 = 'Y' OR p_process_flag4 = 'Y'
4293: IF p_process_flag1 = 'Y' AND p_process_task_status_flag1 = 'Y'
4294: AND l_task_status_tab1.count > 0
4295: THEN
4296: l_update_required := 'Y';
4297: l_weight := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
4298: p_not_started => l_not_started
4299: ,p_completed => l_completed
4300: ,p_in_progress => l_in_progress
4301: ,p_on_hold => l_on_hold);
4323: IF p_process_flag2 = 'Y' AND p_process_task_status_flag2 = 'Y'
4324: AND l_task_status_tab2.count > 0
4325: THEN
4326: l_update_required := 'Y';
4327: l_weight := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
4328: p_not_started => l_not_started
4329: ,p_completed => l_completed
4330: ,p_in_progress => l_in_progress
4331: ,p_on_hold => l_on_hold);
4352: IF p_process_flag3 = 'Y' AND p_process_task_status_flag3 = 'Y'
4353: AND l_task_status_tab3.count > 0
4354: THEN
4355: l_update_required := 'Y';
4356: l_weight := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
4357: p_not_started => l_not_started
4358: ,p_completed => l_completed
4359: ,p_in_progress => l_in_progress
4360: ,p_on_hold => l_on_hold);
4381: IF p_process_flag4 = 'Y' AND p_process_task_status_flag4 = 'Y'
4382: AND l_task_status_tab4.count > 0
4383: THEN
4384: l_update_required := 'Y';
4385: l_weight := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
4386: p_not_started => l_not_started
4387: ,p_completed => l_completed
4388: ,p_in_progress => l_in_progress
4389: ,p_on_hold => l_on_hold);
4410: IF p_process_flag5 = 'Y' AND p_process_task_status_flag5 = 'Y'
4411: AND l_task_status_tab5.count > 0
4412: THEN
4413: l_update_required := 'Y';
4414: l_weight := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
4415: p_not_started => l_not_started
4416: ,p_completed => l_completed
4417: ,p_in_progress => l_in_progress
4418: ,p_on_hold => l_on_hold);
4439: IF p_process_flag6 = 'Y' AND p_process_task_status_flag6 = 'Y'
4440: AND l_task_status_tab6.count > 0
4441: THEN
4442: l_update_required := 'Y';
4443: l_weight := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
4444: p_not_started => l_not_started
4445: ,p_completed => l_completed
4446: ,p_in_progress => l_in_progress
4447: ,p_on_hold => l_on_hold);
4481: */
4482: END IF; -- ((p_process_flag1 = 'Y' OR p_process_flag2 = 'Y' OR p_process_flag3 = 'Y' OR p_process_flag4 = 'Y'
4483:
4484: IF g1_debug_mode = 'Y' THEN
4485: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After Task Status processing', x_Log_Level=> 3);
4486: END IF;
4487:
4488:
4489: -- ********* TASK STATUS PROCESSING END **************
4490:
4491: -- ********* PERCENT COMPLETE PROCESSING BEGIN ***********
4492:
4493: IF g1_debug_mode = 'Y' THEN
4494: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before % Complete processing', x_Log_Level=> 3);
4495: END IF;
4496:
4497: IF ((p_process_flag1 = 'Y' OR p_process_flag2 = 'Y' OR p_process_flag3 = 'Y' OR p_process_flag4 = 'Y'
4498: OR p_process_flag5 = 'Y' OR p_process_flag6 = 'Y')
5442: */
5443: END IF; -- ((p_process_flag1 = 'Y' OR p_process_flag2 = 'Y' OR p_process_flag3 = 'Y' OR p_process_flag4 = 'Y'
5444:
5445: IF g1_debug_mode = 'Y' THEN
5446: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After % Complete processing', x_Log_Level=> 3);
5447: END IF;
5448:
5449: -- ********* PERCENT COMPLETE PROCESSING END ******************
5450:
5449: -- ********* PERCENT COMPLETE PROCESSING END ******************
5450:
5451: -- ********* ETC COST ROLLUP BEGIN ****************
5452: IF g1_debug_mode = 'Y' THEN
5453: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before ETC Cost processing', x_Log_Level=> 3);
5454: END IF;
5455:
5456:
5457: -- Bug 4218507 : To do effort or ETC processing, atleast one of the flags p_process_ETC_Flag1 or p_process_effort_flag1
5935: */
5936: END IF; -- ((p_process_flag1 = 'Y' OR p_process_flag2 = 'Y' OR p_process_flag3 = 'Y' OR p_process_flag4 = 'Y'
5937:
5938: IF g1_debug_mode = 'Y' THEN
5939: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After ETC Cost processing', x_Log_Level=> 3);
5940: END IF;
5941:
5942: -- ********* ETC COST ROLLUP END *************
5943:
5943:
5944:
5945:
5946: IF g1_debug_mode = 'Y' THEN
5947: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'Before Assigning data back to plsql table', x_Log_Level=> 3);
5948: END IF;
5949:
5950: l_data_count := 1;
5951:
5969: CLOSE processed_data_structure;
5970: END IF;
5971:
5972: IF g1_debug_mode = 'Y' THEN
5973: pa_debug.write(x_Module=>'PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE', x_Msg => 'After Assigning data back to plsql table', x_Log_Level=> 3);
5974: END IF;
5975:
5976: -- Bug 4289748 : removed rollback, used delete instead
5977: --ROLLBACK TO SAVEPOINT GENERATE_SCHEDULE_SP;
5992: -- x_return_status := FND_API.G_RET_STS_ERROR;
5993: --END IF;
5994:
5995: IF (p_debug_mode = 'Y') AND g1_debug_mode = 'Y' THEN
5996: pa_debug.debug('PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE END');
5997: END IF;
5998:
5999: EXCEPTION
6000: WHEN API_ERROR THEN
6009: END IF;
6010: x_return_status := FND_API.G_RET_STS_ERROR;
6011: WHEN OTHERS THEN
6012: ROLLBACK TO SAVEPOINT GENERATE_SCHEDULE_SP;
6013: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_SCHEDULE_OBJECTS_PVT'
6014: ,p_procedure_name => 'GENERATE_SCHEDULE'
6015: , p_error_text => SUBSTRB(SQLERRM,1,120));
6016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6017: x_msg_data := substr(sqlerrm, 1, 120);
6116: ,p_number_digit IN NUMBER default 4
6117: ,x_return_status OUT NOCOPY VARCHAR2
6118: ,x_msg_count OUT NOCOPY NUMBER
6119: ,x_msg_data OUT NOCOPY VARCHAR2
6120: ,p_data_structure IN OUT NOCOPY PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
6121: ,x_Process_Number OUT NOCOPY NUMBER
6122: ,p_process_flag1 IN VARCHAR2 default 'N'
6123: ,p_derived_field1 IN VARCHAR2 default 'DURATION'
6124: ,p_process_rollup_flag1 IN VARCHAR2 default 'N'
6235: ,p_partial_ETC_Flag6 IN VARCHAR2 default 'N'
6236: ,p_Rollup_Method IN VARCHAR2 default 'COST'
6237: )
6238: AS
6239: p_data PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE;
6240: --Amit Changes for percent complete
6241: l_percent_complte1 number;
6242: l_percent_complte2 number;
6243: l_percent_complte3 number;
6444: end if;
6445:
6446: if ( l_defer_on_hold1.exists(p_data(i).object_id ) ) then
6447:
6448: l_defer_task_status1 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
6449: p_not_started => l_defer_not_started1(p_data(i).object_id )
6450: ,p_completed => l_defer_completed1(p_data(i).object_id )
6451: ,p_in_progress => l_defer_progress1(p_data(i).object_id )
6452: ,p_on_hold => l_defer_on_hold1(p_data(i).object_id ));
6474: l_defer_progress2(p_data(i).parent_object_id ) := 'N';
6475: end if;
6476:
6477: if (l_defer_on_hold2.exists(p_data(i).object_id )) then
6478: l_defer_task_status2 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
6479: p_not_started => l_defer_not_started2(p_data(i).object_id )
6480: ,p_completed => l_defer_completed2(p_data(i).object_id )
6481: ,p_in_progress => l_defer_progress2(p_data(i).object_id )
6482: ,p_on_hold => l_defer_on_hold2(p_data(i).object_id ));
6503: l_defer_progress3(p_data(i).parent_object_id ) := 'N';
6504: end if;
6505:
6506: if(l_defer_on_hold3.exists(p_data(i).object_id ) ) then
6507: l_defer_task_status3 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
6508: p_not_started => l_defer_not_started3(p_data(i).object_id )
6509: ,p_completed => l_defer_completed3(p_data(i).object_id )
6510: ,p_in_progress => l_defer_progress3(p_data(i).object_id )
6511: ,p_on_hold => l_defer_on_hold3(p_data(i).object_id ));
6532: l_defer_progress4(p_data(i).parent_object_id ) := 'N';
6533: end if;
6534:
6535: if ( l_defer_on_hold4.exists(p_data(i).object_id ) ) then
6536: l_defer_task_status4 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
6537: p_not_started => l_defer_not_started4(p_data(i).object_id )
6538: ,p_completed => l_defer_completed4(p_data(i).object_id )
6539: ,p_in_progress => l_defer_progress4(p_data(i).object_id )
6540: ,p_on_hold => l_defer_on_hold4(p_data(i).object_id ));
6562: end if;
6563:
6564: if ( l_defer_on_hold5.exists(p_data(i).object_id ) ) then
6565:
6566: l_defer_task_status5 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
6567: p_not_started => l_defer_not_started5(p_data(i).object_id )
6568: ,p_completed => l_defer_completed5(p_data(i).object_id )
6569: ,p_in_progress => l_defer_progress5(p_data(i).object_id )
6570: ,p_on_hold => l_defer_on_hold5(p_data(i).object_id ));
6592: end if;
6593:
6594: if ( l_defer_on_hold6.exists(p_data(i).object_id ) ) then
6595:
6596: l_defer_task_status6 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
6597: p_not_started => l_defer_not_started6(p_data(i).object_id )
6598: ,p_completed => l_defer_completed6(p_data(i).object_id )
6599: ,p_in_progress => l_defer_progress6(p_data(i).object_id )
6600: ,p_on_hold => l_defer_on_hold6(p_data(i).object_id ));
7149: log1('@defer_generate_Schedule: l_defer_progress1(l_upd_object_id)= '||l_defer_progress1(l_upd_object_id), 'Nov_22');
7150: log1('@defer_generate_Schedule: l_defer_on_hold1(l_upd_object_id)= '||l_defer_on_hold1(l_upd_object_id), 'Nov_22');
7151:
7152: -- Status rollup
7153: l_defer_upd_task_status1 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
7154: p_not_started => l_defer_not_started1(l_upd_object_id )
7155: ,p_completed => l_defer_completed1(l_upd_object_id)
7156: ,p_in_progress => l_defer_progress1(l_upd_object_id )
7157: ,p_on_hold => l_defer_on_hold1(l_upd_object_id ));
7157: ,p_on_hold => l_defer_on_hold1(l_upd_object_id ));
7158:
7159: log1('@defer_generate_Schedule: l_defer_upd_task_status1= '||l_defer_upd_task_status1, 'Nov_22');
7160:
7161: l_defer_upd_task_status2 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
7162: p_not_started => l_defer_not_started2(l_upd_object_id )
7163: ,p_completed => l_defer_completed2(l_upd_object_id)
7164: ,p_in_progress => l_defer_progress2(l_upd_object_id )
7165: ,p_on_hold => l_defer_on_hold2(l_upd_object_id ));
7163: ,p_completed => l_defer_completed2(l_upd_object_id)
7164: ,p_in_progress => l_defer_progress2(l_upd_object_id )
7165: ,p_on_hold => l_defer_on_hold2(l_upd_object_id ));
7166:
7167: l_defer_upd_task_status3 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
7168: p_not_started => l_defer_not_started3(l_upd_object_id )
7169: ,p_completed => l_defer_completed3(l_upd_object_id)
7170: ,p_in_progress => l_defer_progress3(l_upd_object_id )
7171: ,p_on_hold => l_defer_on_hold3(l_upd_object_id ));
7169: ,p_completed => l_defer_completed3(l_upd_object_id)
7170: ,p_in_progress => l_defer_progress3(l_upd_object_id )
7171: ,p_on_hold => l_defer_on_hold3(l_upd_object_id ));
7172:
7173: l_defer_upd_task_status4 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
7174: p_not_started => l_defer_not_started4(l_upd_object_id )
7175: ,p_completed => l_defer_completed4(l_upd_object_id)
7176: ,p_in_progress => l_defer_progress4(l_upd_object_id )
7177: ,p_on_hold => l_defer_on_hold4(l_upd_object_id ));
7175: ,p_completed => l_defer_completed4(l_upd_object_id)
7176: ,p_in_progress => l_defer_progress4(l_upd_object_id )
7177: ,p_on_hold => l_defer_on_hold4(l_upd_object_id ));
7178:
7179: l_defer_upd_task_status5 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
7180: p_not_started => l_defer_not_started5(l_upd_object_id )
7181: ,p_completed => l_defer_completed5(l_upd_object_id)
7182: ,p_in_progress => l_defer_progress5(l_upd_object_id )
7183: ,p_on_hold => l_defer_on_hold5(l_upd_object_id ));
7181: ,p_completed => l_defer_completed5(l_upd_object_id)
7182: ,p_in_progress => l_defer_progress5(l_upd_object_id )
7183: ,p_on_hold => l_defer_on_hold5(l_upd_object_id ));
7184:
7185: l_defer_upd_task_status6 := PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS(
7186: p_not_started => l_defer_not_started6(l_upd_object_id )
7187: ,p_completed => l_defer_completed6(l_upd_object_id)
7188: ,p_in_progress => l_defer_progress6(l_upd_object_id )
7189: ,p_on_hold => l_defer_on_hold6(l_upd_object_id ));
7570: END defer_generate_Schedule;
7571:
7572:
7573:
7574: End PA_SCHEDULE_OBJECTS_PVT;