eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_TASKS_ENUMS_PVT dependencies on IEU_PUB

Line 24: l_tk_list IEU_PUB.EnumeratorDataRecordList;

20: l_lookup_type VARCHAR2(2000);
21: l_view_application_id VARCHAR2(2000);
22: l_lookup_code VARCHAR2(2000);
23:
24: l_tk_list IEU_PUB.EnumeratorDataRecordList;
25: l_tk_bind_list IEU_PUB.BindVariableRecordList;
26: l_ind_own_tk_bind_list IEU_PUB.BindVariableRecordList;
27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;

Line 25: l_tk_bind_list IEU_PUB.BindVariableRecordList;

21: l_view_application_id VARCHAR2(2000);
22: l_lookup_code VARCHAR2(2000);
23:
24: l_tk_list IEU_PUB.EnumeratorDataRecordList;
25: l_tk_bind_list IEU_PUB.BindVariableRecordList;
26: l_ind_own_tk_bind_list IEU_PUB.BindVariableRecordList;
27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;
29: l_grp_asg_tk_bind_list IEU_PUB.BindVariableRecordList;

Line 26: l_ind_own_tk_bind_list IEU_PUB.BindVariableRecordList;

22: l_lookup_code VARCHAR2(2000);
23:
24: l_tk_list IEU_PUB.EnumeratorDataRecordList;
25: l_tk_bind_list IEU_PUB.BindVariableRecordList;
26: l_ind_own_tk_bind_list IEU_PUB.BindVariableRecordList;
27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;
29: l_grp_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
30: l_team_own_tk_bind_list IEU_PUB.BindVariableRecordList;

Line 27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;

23:
24: l_tk_list IEU_PUB.EnumeratorDataRecordList;
25: l_tk_bind_list IEU_PUB.BindVariableRecordList;
26: l_ind_own_tk_bind_list IEU_PUB.BindVariableRecordList;
27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;
29: l_grp_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
30: l_team_own_tk_bind_list IEU_PUB.BindVariableRecordList;
31: l_team_asg_tk_bind_list IEU_PUB.BindVariableRecordList;

Line 28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;

24: l_tk_list IEU_PUB.EnumeratorDataRecordList;
25: l_tk_bind_list IEU_PUB.BindVariableRecordList;
26: l_ind_own_tk_bind_list IEU_PUB.BindVariableRecordList;
27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;
29: l_grp_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
30: l_team_own_tk_bind_list IEU_PUB.BindVariableRecordList;
31: l_team_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
32:

Line 29: l_grp_asg_tk_bind_list IEU_PUB.BindVariableRecordList;

25: l_tk_bind_list IEU_PUB.BindVariableRecordList;
26: l_ind_own_tk_bind_list IEU_PUB.BindVariableRecordList;
27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;
29: l_grp_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
30: l_team_own_tk_bind_list IEU_PUB.BindVariableRecordList;
31: l_team_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
32:
33:

Line 30: l_team_own_tk_bind_list IEU_PUB.BindVariableRecordList;

26: l_ind_own_tk_bind_list IEU_PUB.BindVariableRecordList;
27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;
29: l_grp_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
30: l_team_own_tk_bind_list IEU_PUB.BindVariableRecordList;
31: l_team_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
32:
33:
34: -- 02/07/01 Type_id of 22 is 'Escalations' and Tasks team asked to eliminate these.

Line 31: l_team_asg_tk_bind_list IEU_PUB.BindVariableRecordList;

27: l_ind_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
28: l_grp_own_tk_bind_list IEU_PUB.BindVariableRecordList;
29: l_grp_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
30: l_team_own_tk_bind_list IEU_PUB.BindVariableRecordList;
31: l_team_asg_tk_bind_list IEU_PUB.BindVariableRecordList;
32:
33:
34: -- 02/07/01 Type_id of 22 is 'Escalations' and Tasks team asked to eliminate these.
35:

Line 263: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_tk_bind_list);

259: resource_id+0 = :resource_id';
260: l_tk_bind_list(l_node_counter).bind_var_name := ':resource_id';
261: l_tk_bind_list(l_node_counter).bind_var_value := p_resource_id;
262: l_tk_bind_list(l_node_counter).bind_var_data_type := 'NUMBER';
263: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_tk_bind_list);
264:
265: l_node_counter := l_node_counter + 1;
266:
267: --Now build the subnodes

Line 298: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);

294: l_tk_list(l_node_counter).WHERE_CLAUSE := 'resource_id = :resource_id';
295: l_tk_list(l_node_counter).NODE_TYPE := 0;
296: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
297: l_tk_list(l_node_counter).NODE_DEPTH := 2;
298: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);
299: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
300: /* Bug 16059990 changed to Sec view*/
301: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IO_REF_SEC_V';
302:

Line 327: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);

323: TASK_TYPE_ID = :task_type_id';
324: l_tk_list(l_node_counter).NODE_TYPE := 0;
325: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
326: l_tk_list(l_node_counter).NODE_DEPTH := 3;
327: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);
328: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
329: /* Bug 16059990 changed to Sec view*/
330: l_tk_list(l_node_counter).REFRESH_VIEW_NAME :=
331: 'IEU_UWQ_TASK_IO_REF_SEC_V';

Line 360: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);

356: TASK_TYPE_ID = :task_type_id';
357: l_tk_list(l_node_counter).NODE_TYPE := 0;
358: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
359: l_tk_list(l_node_counter).NODE_DEPTH := 3;
360: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);
361: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
362: /* Bug 16059990 changed to Sec view*/
363: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IO_REF_SEC_V';
364:

Line 399: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);

395: l_tk_list(l_node_counter).WHERE_CLAUSE := 'resource_id = :resource_id';
396: l_tk_list(l_node_counter).NODE_TYPE := 0;
397: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
398: l_tk_list(l_node_counter).NODE_DEPTH := 2;
399: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);
400: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
401: /* Bug 16059990 changed to Sec view*/
402: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IA_REF_SEC_V';
403:

Line 427: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);

423: TASK_TYPE_ID = :task_type_id';
424: l_tk_list(l_node_counter).NODE_TYPE := 0;
425: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
426: l_tk_list(l_node_counter).NODE_DEPTH := 3;
427: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);
428: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
429: /* Bug 16059990 changed to Sec view*/
430: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IA_REF_SEC_V';
431:

Line 458: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);

454: TASK_TYPE_ID = :task_type_id';
455: l_tk_list(l_node_counter).NODE_TYPE := 0;
456: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
457: l_tk_list(l_node_counter).NODE_DEPTH := 3;
458: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);
459: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
460: /* Bug 16059990 changed to Sec view*/
461: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IA_REF_SEC_V';
462:

Line 521: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);

517: -- End fix by spamujul for 7024226
518: l_tk_list(l_node_counter).NODE_TYPE := 0;
519: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
520: l_tk_list(l_node_counter).NODE_DEPTH := 2;
521: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);
522: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
523: /* Bug 16059990 changed to Sec view*/
524: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GO_REF_SEC_V v';
525:

Line 557: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);

553: TASK_TYPE_ID = :task_type_id';
554: l_tk_list(l_node_counter).NODE_TYPE := 0;
555: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
556: l_tk_list(l_node_counter).NODE_DEPTH := 3;
557: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);
558: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
559: /* Bug 16059990 changed to Sec view*/
560: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GO_REF_SEC_V v';
561:

Line 597: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);

593: TASK_TYPE_ID = :task_type_id';
594: l_tk_list(l_node_counter).NODE_TYPE := 0;
595: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
596: l_tk_list(l_node_counter).NODE_DEPTH := 3;
597: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);
598: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
599: /* Bug 16059990 changed to Sec view*/
600: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GO_REF_SEC_V v';
601:

Line 642: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);

638: ' and m.resource_id = :resource_id) ';
639: l_tk_list(l_node_counter).NODE_TYPE := 0;
640: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
641: l_tk_list(l_node_counter).NODE_DEPTH := 2;
642: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);
643: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
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;

Line 677: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);

673: TASK_TYPE_ID = :task_type_id';
674: l_tk_list(l_node_counter).NODE_TYPE := 0;
675: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
676: l_tk_list(l_node_counter).NODE_DEPTH := 3;
677: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);
678: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
679: /* Bug 16059990 changed to Sec view*/
680: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GA_REF_SEC_V v';
681:

Line 716: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);

712: TASK_TYPE_ID = :task_type_id';
713: l_tk_list(l_node_counter).NODE_TYPE := 0;
714: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
715: l_tk_list(l_node_counter).NODE_DEPTH := 3;
716: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);
717: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
718: /* Bug 16059990 changed to Sec view*/
719: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GA_REF_SEC_V v';
720:

Line 770: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_own_tk_bind_list);

766: ' and m.team_resource_id = :resource_id)';
767: l_tk_list(l_node_counter).NODE_TYPE := 0;
768: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
769: l_tk_list(l_node_counter).NODE_DEPTH := 2;
770: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_own_tk_bind_list);
771: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
772: /* Bug 16059990 changed to Sec view*/
773: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TO_REF_SEC_V';
774:

Line 806: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_own_tk_bind_list);

802: TASK_TYPE_ID = :task_type_id';
803: l_tk_list(l_node_counter).NODE_TYPE := 0;
804: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
805: l_tk_list(l_node_counter).NODE_DEPTH := 3;
806: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_own_tk_bind_list);
807: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
808: /* Bug 16059990 changed to Sec view*/
809: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TO_REF_SEC_V';
810:

Line 846: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_own_tk_bind_list);

842: TASK_TYPE_ID = :task_type_id';
843: l_tk_list(l_node_counter).NODE_TYPE := 0;
844: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
845: l_tk_list(l_node_counter).NODE_DEPTH := 3;
846: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_own_tk_bind_list);
847: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
848: /* Bug 16059990 changed to Sec view*/
849: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TO_REF_SEC_V';
850:

Line 893: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);

889: ' and m.team_resource_id = :resource_id)';
890: l_tk_list(l_node_counter).NODE_TYPE := 0;
891: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
892: l_tk_list(l_node_counter).NODE_DEPTH := 2;
893: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);
894: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
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;

Line 928: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);

924: TASK_TYPE_ID = :task_type_id';
925: l_tk_list(l_node_counter).NODE_TYPE := 0;
926: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
927: l_tk_list(l_node_counter).NODE_DEPTH := 3;
928: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);
929: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
930: /* Bug 16059990 changed to Sec view*/
931: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TA_REF_SEC_V';
932:

Line 967: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);

963: TASK_TYPE_ID = :task_type_id';
964: l_tk_list(l_node_counter).NODE_TYPE := 0;
965: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
966: l_tk_list(l_node_counter).NODE_DEPTH := 3;
967: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);
968: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
969: /* Bug 16059990 changed to Sec view*/
970: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TA_REF_SEC_V';
971:

Line 981: IEU_PUB.ADD_UWQ_NODE_DATA

977: END IF;
978: end if ; -- show team
979:
980:
981: IEU_PUB.ADD_UWQ_NODE_DATA
982: (P_RESOURCE_ID,
983: P_SEL_ENUM_ID,
984: l_tk_list
985: );