DBA Data[Home] [Help]

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 284: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);

280: l_tk_list(l_node_counter).WHERE_CLAUSE := 'resource_id = :resource_id';
281: l_tk_list(l_node_counter).NODE_TYPE := 0;
282: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
283: l_tk_list(l_node_counter).NODE_DEPTH := 2;
284: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);
285: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
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;

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

307: TASK_TYPE_ID = :task_type_id';
308: l_tk_list(l_node_counter).NODE_TYPE := 0;
309: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
310: l_tk_list(l_node_counter).NODE_DEPTH := 3;
311: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);
312: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
313: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IO_REF_V';
314:
315: l_node_counter := l_node_counter + 1;

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

337: TASK_TYPE_ID = :task_type_id';
338: l_tk_list(l_node_counter).NODE_TYPE := 0;
339: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
340: l_tk_list(l_node_counter).NODE_DEPTH := 3;
341: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_tk_bind_list);
342: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
343: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IO_REF_V';
344:
345: l_node_counter := l_node_counter + 1;

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

375: l_tk_list(l_node_counter).WHERE_CLAUSE := 'resource_id = :resource_id';
376: l_tk_list(l_node_counter).NODE_TYPE := 0;
377: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
378: l_tk_list(l_node_counter).NODE_DEPTH := 2;
379: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);
380: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
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;

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

402: TASK_TYPE_ID = :task_type_id';
403: l_tk_list(l_node_counter).NODE_TYPE := 0;
404: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
405: l_tk_list(l_node_counter).NODE_DEPTH := 3;
406: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);
407: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
408: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IA_REF_V';
409:
410: l_node_counter := l_node_counter + 1;

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

432: TASK_TYPE_ID = :task_type_id';
433: l_tk_list(l_node_counter).NODE_TYPE := 0;
434: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
435: l_tk_list(l_node_counter).NODE_DEPTH := 3;
436: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_tk_bind_list);
437: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
438: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_IA_REF_V';
439:
440: l_node_counter := l_node_counter + 1;

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

493: -- End fix by spamujul for 7024226
494: l_tk_list(l_node_counter).NODE_TYPE := 0;
495: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
496: l_tk_list(l_node_counter).NODE_DEPTH := 2;
497: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);
498: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
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;

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

527: TASK_TYPE_ID = :task_type_id';
528: l_tk_list(l_node_counter).NODE_TYPE := 0;
529: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
530: l_tk_list(l_node_counter).NODE_DEPTH := 3;
531: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);
532: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
533: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GO_REF_V v';
534:
535:

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

565: TASK_TYPE_ID = :task_type_id';
566: l_tk_list(l_node_counter).NODE_TYPE := 0;
567: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
568: l_tk_list(l_node_counter).NODE_DEPTH := 3;
569: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_tk_bind_list);
570: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
571: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GO_REF_V v';
572:
573: l_node_counter := l_node_counter + 1;

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

608: ' and m.resource_id = :resource_id) ';
609: l_tk_list(l_node_counter).NODE_TYPE := 0;
610: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
611: l_tk_list(l_node_counter).NODE_DEPTH := 2;
612: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);
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:

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

641: TASK_TYPE_ID = :task_type_id';
642: l_tk_list(l_node_counter).NODE_TYPE := 0;
643: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
644: l_tk_list(l_node_counter).NODE_DEPTH := 3;
645: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);
646: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
647: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GA_REF_V v';
648:
649: l_node_counter := l_node_counter + 1;

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

678: TASK_TYPE_ID = :task_type_id';
679: l_tk_list(l_node_counter).NODE_TYPE := 0;
680: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
681: l_tk_list(l_node_counter).NODE_DEPTH := 3;
682: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_tk_bind_list);
683: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
684: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_GA_REF_V v';
685:
686: l_node_counter := l_node_counter + 1;

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

730: ' and m.team_resource_id = :resource_id)';
731: l_tk_list(l_node_counter).NODE_TYPE := 0;
732: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
733: l_tk_list(l_node_counter).NODE_DEPTH := 2;
734: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_own_tk_bind_list);
735: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
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;

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

764: TASK_TYPE_ID = :task_type_id';
765: l_tk_list(l_node_counter).NODE_TYPE := 0;
766: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
767: l_tk_list(l_node_counter).NODE_DEPTH := 3;
768: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_own_tk_bind_list);
769: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
770: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TO_REF_V';
771:
772:

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: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TO_REF_V';
809:
810: l_node_counter := l_node_counter + 1;

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

847: ' and m.team_resource_id = :resource_id)';
848: l_tk_list(l_node_counter).NODE_TYPE := 0;
849: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
850: l_tk_list(l_node_counter).NODE_DEPTH := 2;
851: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);
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:

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

880: TASK_TYPE_ID = :task_type_id';
881: l_tk_list(l_node_counter).NODE_TYPE := 0;
882: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
883: l_tk_list(l_node_counter).NODE_DEPTH := 3;
884: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);
885: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
886: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TA_REF_V';
887:
888: l_node_counter := l_node_counter + 1;

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

917: TASK_TYPE_ID = :task_type_id';
918: l_tk_list(l_node_counter).NODE_TYPE := 0;
919: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
920: l_tk_list(l_node_counter).NODE_DEPTH := 3;
921: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_team_asg_tk_bind_list);
922: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
923: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEU_UWQ_TASK_TA_REF_V';
924:
925: l_node_counter := l_node_counter + 1;

Line 934: IEU_PUB.ADD_UWQ_NODE_DATA

930: END IF;
931: end if ; -- show team
932:
933:
934: IEU_PUB.ADD_UWQ_NODE_DATA
935: (P_RESOURCE_ID,
936: P_SEL_ENUM_ID,
937: l_tk_list
938: );