APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_COLLECT_MAIN

Line 844: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN

840: IF ( ref_res_count <> 0 ) THEN
841:
842: -- Check the profile option value for collecting lowest tasks
843:
844: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN
845:
846: -- Refresh the lowest tasks numbers
847:
848: x_err_stage := 'Refreshing txns at lowest task level';

Line 893: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')

889: x_err_code);
890:
891: END LOOP; -- FOR ref_lowest_act_cmts_r IN sel_ref_lowest_act_cmts
892:
893: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
894:
895: -- Check the profile option value for collecting top tasks
896:
897: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN

Line 897: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN

893: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
894:
895: -- Check the profile option value for collecting top tasks
896:
897: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN
898:
899: -- Refresh the top tasks numbers
900:
901: x_err_stage := 'Refreshing txns at top task level';

Line 946: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')

942: x_err_code);
943:
944: END LOOP; -- FOR ref_top_act_cmts_r IN sel_ref_top_act_cmts
945:
946: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')
947:
948: -- Refresh the project level Numbers
949:
950: x_err_stage := 'Refreshing txns at Project level';

Line 1013: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN

1009: IF ( ref_ser_type_count <> 0 ) THEN
1010:
1011: -- Check the profile option value for collecting lowest tasks
1012:
1013: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN
1014:
1015: -- Refresh the lowest tasks numbers
1016:
1017: x_err_stage := 'Refreshing txns at lowest task level for service type change';

Line 1062: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')

1058: x_err_code);
1059:
1060: END LOOP; -- FOR ref_lowest_ser_type_act_cmts_r IN sel_ref_lowest_stype_act_cmts
1061:
1062: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
1063:
1064: -- Check the profile option value for collecting top tasks
1065:
1066: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN

Line 1066: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN

1062: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
1063:
1064: -- Check the profile option value for collecting top tasks
1065:
1066: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN
1067:
1068: -- Refresh the top tasks numbers
1069:
1070: x_err_stage := 'Refreshing txns at top task level for service type change';

Line 1115: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')

1111: x_err_code);
1112:
1113: END LOOP; -- FOR ref_top_ser_type_act_cmts_r IN sel_ref_top_ser_type_act_cmts
1114:
1115: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')
1116:
1117: -- Refresh the project level Numbers
1118:
1119: x_err_stage := 'Refreshing txns at Project level';

Line 1229: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN

1225: IF ( txn_count <> 0 OR res_count <> 0 ) THEN
1226:
1227: -- Check the profile option value for collecting lowest tasks
1228:
1229: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN
1230:
1231: -- collect Actuals/Cmts at lowest tasks level
1232:
1233: x_err_stage := 'Collecting Actuals/Cmts txns at lowest task level';

Line 1279: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')

1275: x_err_code);
1276:
1277: END LOOP; -- FOR lowest_act_cmts_r IN sel_lowest_act_cmts
1278:
1279: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
1280:
1281: -- Check the profile option value for collecting top tasks
1282:
1283: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN

Line 1283: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN

1279: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
1280:
1281: -- Check the profile option value for collecting top tasks
1282:
1283: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN
1284:
1285: -- collect Actuals/Cmts at top tasks level
1286:
1287: x_err_stage := 'Collecting Actuals/Cmts txns at top task level';

Line 1332: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')

1328: x_err_code);
1329:
1330: END LOOP; -- FOR top_act_cmts_r IN sel_top_act_cmts
1331:
1332: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')
1333:
1334: -- collect Actuals/Cmts at Project level
1335:
1336: x_err_stage := 'Collecting Actuals/Cmts txns at Project level';

Line 2279: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN

2275: );
2276:
2277: -- Check the profile option value for collecting lowest tasks
2278:
2279: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN
2280:
2281: -- refreshing Budgets at lowest tasks level
2282:
2283: x_err_stage := 'Collecting Budgets at lowest task level';

Line 2317: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')

2313: x_err_code);
2314:
2315: END LOOP; -- FOR ref_lowest_budgets_r IN sel_ref_lowest_budgets
2316:
2317: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
2318:
2319: -- Check the profile option value for collecting top tasks
2320: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN
2321:

Line 2320: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN

2316:
2317: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
2318:
2319: -- Check the profile option value for collecting top tasks
2320: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN
2321:
2322: -- refreshing Budgets at top tasks level
2323:
2324: x_err_stage := 'Collecting Budgets at top task level';

Line 2358: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')

2354: x_err_code);
2355:
2356: END LOOP; -- FOR ref_top_budgets_r IN sel_ref_top_budgets
2357:
2358: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')
2359:
2360: -- Refreshing Budgets at Project level
2361:
2362: x_err_stage := 'Refreshing Budgets txns at Project level';

Line 2399: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN

2395:
2396: -- Budget refresh is complete
2397:
2398: -- Check the profile option value for collecting lowest tasks
2399: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN
2400:
2401: -- Collect Budgets at lowest tasks level
2402:
2403: x_err_stage := 'Collecting Budgets at lowest task level';

Line 2437: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')

2433: x_err_code);
2434:
2435: END LOOP; -- FOR lowest_budgets_r IN sel_lowest_budgets
2436:
2437: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
2438:
2439: -- Check the profile option value for collecting top tasks
2440: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN
2441:

Line 2440: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN

2436:
2437: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
2438:
2439: -- Check the profile option value for collecting top tasks
2440: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN
2441:
2442: -- Collect Budgets at top tasks level
2443:
2444: x_err_stage := 'Collecting Budgets at top task level';

Line 2478: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')

2474: x_err_code);
2475:
2476: END LOOP; -- FOR top_budgets_r IN sel_top_budgets
2477:
2478: END IF; -- IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y')
2479:
2480: -- Collect Budgets at Project level
2481:
2482: x_err_stage := 'Collecting Budgets txns at Project level';