211: and trunc(nvl(end_date_active, sysdate))
212: ORDER BY 2;
213:
214: BEGIN
215: IF (FND_PROFILE.VALUE('IEU_QEN_NEW_TASKS') = 'N' ) THEN
216: RETURN;
217: END IF;
218:
219: l_node_counter := 0;
286: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IO_REF_V';
287:
288: l_node_counter := l_node_counter + 1;
289:
290: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
291: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
292:
293: FOR cur_rec IN c_ind_own_task_nodes_1 LOOP
294:
287:
288: l_node_counter := l_node_counter + 1;
289:
290: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
291: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
292:
293: FOR cur_rec IN c_ind_own_task_nodes_1 LOOP
294:
295: l_ind_own_tk_bind_list(1).bind_var_name := ':resource_id';
381: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IA_REF_V';
382:
383: l_node_counter := l_node_counter + 1;
384:
385: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
386: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
387:
388: FOR cur_rec IN c_assign_ind_task_nodes_1 LOOP
389:
382:
383: l_node_counter := l_node_counter + 1;
384:
385: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
386: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
387:
388: FOR cur_rec IN c_assign_ind_task_nodes_1 LOOP
389:
390: l_ind_asg_tk_bind_list(1).bind_var_name := ':resource_id';
447: -- Group Owned
448: -- This node will be displayed if the Profile Option valus is 'A' - Show Groups and Teams
449: -- or 'S' - Show Groups.
450:
451: IF ( (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'A') OR
452: (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'S') )
453: then
454:
455:
448: -- This node will be displayed if the Profile Option valus is 'A' - Show Groups and Teams
449: -- or 'S' - Show Groups.
450:
451: IF ( (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'A') OR
452: (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'S') )
453: then
454:
455:
456: l_lookup_type := 'IEU_NODE_LABELS';
499: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GO_REF_V v';
500:
501: l_node_counter := l_node_counter + 1;
502:
503: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
504: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
505:
506: FOR cur_rec IN c_grp_own_task_nodes_1 LOOP
507:
500:
501: l_node_counter := l_node_counter + 1;
502:
503: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
504: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
505:
506: FOR cur_rec IN c_grp_own_task_nodes_1 LOOP
507:
508: l_grp_own_tk_bind_list(1).bind_var_name := ':resource_id';
613: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
614: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GA_REF_V v';
615: l_node_counter := l_node_counter + 1;
616:
617: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
618: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
619:
620: FOR cur_rec IN c_assign_grp_task_nodes_1 LOOP
621:
614: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GA_REF_V v';
615: l_node_counter := l_node_counter + 1;
616:
617: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
618: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
619:
620: FOR cur_rec IN c_assign_grp_task_nodes_1 LOOP
621:
622: l_grp_asg_tk_bind_list(1).bind_var_name := ':resource_id';
695: -- Team Owned
696: -- This node will be displayed if the Profile Option valus is 'A' - Show Groups and Teams
697: -- or 'ST' - Show Groups.
698:
699: IF ( (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'A') OR
700: (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'ST') )
701: then
702:
703: l_lookup_type := 'IEU_NODE_LABELS';
696: -- This node will be displayed if the Profile Option valus is 'A' - Show Groups and Teams
697: -- or 'ST' - Show Groups.
698:
699: IF ( (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'A') OR
700: (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'ST') )
701: then
702:
703: l_lookup_type := 'IEU_NODE_LABELS';
704: l_view_application_id := 696;
736: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TO_REF_V';
737:
738: l_node_counter := l_node_counter + 1;
739:
740: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
741: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
742:
743: FOR cur_rec IN c_team_own_task_nodes_1 LOOP
744:
737:
738: l_node_counter := l_node_counter + 1;
739:
740: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
741: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
742:
743: FOR cur_rec IN c_team_own_task_nodes_1 LOOP
744:
745: l_team_own_tk_bind_list(1).bind_var_name := ':resource_id';
852: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
853: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TA_REF_V';
854: l_node_counter := l_node_counter + 1;
855:
856: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
857: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
858:
859: FOR cur_rec IN c_assign_team_task_nodes_1 LOOP
860:
853: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TA_REF_V';
854: l_node_counter := l_node_counter + 1;
855:
856: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
857: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
858:
859: FOR cur_rec IN c_assign_team_task_nodes_1 LOOP
860:
861: l_team_asg_tk_bind_list(1).bind_var_name := ':resource_id';