220: and trunc(nvl(end_date_active, sysdate))
221: ORDER BY 2;
222:
223: BEGIN
224: IF (FND_PROFILE.VALUE('IEU_QEN_NEW_TASKS') = 'N' ) THEN
225: RETURN;
226: END IF;
227:
228: l_node_counter := 0;
301: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IO_REF_SEC_V';
302:
303: l_node_counter := l_node_counter + 1;
304:
305: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
306: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
307:
308: FOR cur_rec IN c_ind_own_task_nodes_1 LOOP
309:
302:
303: l_node_counter := l_node_counter + 1;
304:
305: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
306: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
307:
308: FOR cur_rec IN c_ind_own_task_nodes_1 LOOP
309:
310: l_ind_own_tk_bind_list(1).bind_var_name := ':resource_id';
402: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IA_REF_SEC_V';
403:
404: l_node_counter := l_node_counter + 1;
405:
406: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
407: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
408:
409: FOR cur_rec IN c_assign_ind_task_nodes_1 LOOP
410:
403:
404: l_node_counter := l_node_counter + 1;
405:
406: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
407: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
408:
409: FOR cur_rec IN c_assign_ind_task_nodes_1 LOOP
410:
411: l_ind_asg_tk_bind_list(1).bind_var_name := ':resource_id';
470: -- Group Owned
471: -- This node will be displayed if the Profile Option valus is 'A' - Show Groups and Teams
472: -- or 'S' - Show Groups.
473:
474: IF ( (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'A') OR
475: (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'S') )
476: then
477:
478:
471: -- This node will be displayed if the Profile Option valus is 'A' - Show Groups and Teams
472: -- or 'S' - Show Groups.
473:
474: IF ( (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'A') OR
475: (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'S') )
476: then
477:
478:
479: l_lookup_type := 'IEU_NODE_LABELS';
524: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GO_REF_SEC_V v';
525:
526: l_node_counter := l_node_counter + 1;
527:
528: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
529: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
530:
531: FOR cur_rec IN c_grp_own_task_nodes_1 LOOP
532:
525:
526: l_node_counter := l_node_counter + 1;
527:
528: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
529: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
530:
531: FOR cur_rec IN c_grp_own_task_nodes_1 LOOP
532:
533: l_grp_own_tk_bind_list(1).bind_var_name := ':resource_id';
644: /* Bug 16059990 changed to Sec view*/
645: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GA_REF_SEC_V v';
646: l_node_counter := l_node_counter + 1;
647:
648: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
649: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
650:
651: FOR cur_rec IN c_assign_grp_task_nodes_1 LOOP
652:
645: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GA_REF_SEC_V v';
646: l_node_counter := l_node_counter + 1;
647:
648: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
649: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
650:
651: FOR cur_rec IN c_assign_grp_task_nodes_1 LOOP
652:
653: l_grp_asg_tk_bind_list(1).bind_var_name := ':resource_id';
730: -- Team Owned
731: -- This node will be displayed if the Profile Option valus is 'A' - Show Groups and Teams
732: -- or 'ST' - Show Groups.
733:
734: IF ( (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'A') OR
735: (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'ST') )
736: then
737:
738: l_lookup_type := 'IEU_NODE_LABELS';
731: -- This node will be displayed if the Profile Option valus is 'A' - Show Groups and Teams
732: -- or 'ST' - Show Groups.
733:
734: IF ( (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'A') OR
735: (nvl(FND_PROFILE.VALUE('IEU_ENT_TASK_RES_TYPES'), 'H') = 'ST') )
736: then
737:
738: l_lookup_type := 'IEU_NODE_LABELS';
739: l_view_application_id := 696;
773: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TO_REF_SEC_V';
774:
775: l_node_counter := l_node_counter + 1;
776:
777: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
778: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
779:
780: FOR cur_rec IN c_team_own_task_nodes_1 LOOP
781:
774:
775: l_node_counter := l_node_counter + 1;
776:
777: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
778: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
779:
780: FOR cur_rec IN c_team_own_task_nodes_1 LOOP
781:
782: l_team_own_tk_bind_list(1).bind_var_name := ':resource_id';
895: /* Bug 16059990 changed to Sec view*/
896: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TA_REF_SEC_V';
897: l_node_counter := l_node_counter + 1;
898:
899: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
900: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
901:
902: FOR cur_rec IN c_assign_team_task_nodes_1 LOOP
903:
896: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TA_REF_SEC_V';
897: l_node_counter := l_node_counter + 1;
898:
899: IF (FND_PROFILE.VALUE('IEU_TASK_TYPES') = 'Y') THEN
900: IF (FND_PROFILE.VALUE('IEU_CLI_UI_SHOW_ALL_NODES') = 'N') THEN
901:
902: FOR cur_rec IN c_assign_team_task_nodes_1 LOOP
903:
904: l_team_asg_tk_bind_list(1).bind_var_name := ':resource_id';