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.AST_UWQ_OPP_ENUMS_PVT dependencies on IEU_PUB

Line 15: l_opp_list IEU_PUB.EnumeratorDataRecordList;

11: )
12: AS
13:
14: l_node_label VARCHAR2(200);
15: l_opp_list IEU_PUB.EnumeratorDataRecordList;
16: l_node_counter NUMBER;
17: l_bind_list IEU_PUB.BindVariableRecordList ;
18: l_bind_list2 IEU_PUB.BindVariableRecordList ;
19: l_Access varchar2(10);

Line 17: l_bind_list IEU_PUB.BindVariableRecordList ;

13:
14: l_node_label VARCHAR2(200);
15: l_opp_list IEU_PUB.EnumeratorDataRecordList;
16: l_node_counter NUMBER;
17: l_bind_list IEU_PUB.BindVariableRecordList ;
18: l_bind_list2 IEU_PUB.BindVariableRecordList ;
19: l_Access varchar2(10);
20: l_OrgID number;
21: l_view_name VARCHAR2(50);

Line 18: l_bind_list2 IEU_PUB.BindVariableRecordList ;

14: l_node_label VARCHAR2(200);
15: l_opp_list IEU_PUB.EnumeratorDataRecordList;
16: l_node_counter NUMBER;
17: l_bind_list IEU_PUB.BindVariableRecordList ;
18: l_bind_list2 IEU_PUB.BindVariableRecordList ;
19: l_Access varchar2(10);
20: l_OrgID number;
21: l_view_name VARCHAR2(50);
22: l_ds_name VARCHAR2(50);

Line 91: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

87: l_bind_list(2).bind_var_data_type := 'NUMBER' ;
88:
89: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_SALESOPP_UWQ_REF_SUB_V';
90: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID ';
91: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
92: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
93: end if;
94:
95: l_opp_list(l_node_counter).NODE_TYPE := 0;

Line 118: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

114: l_bind_list(2).bind_var_data_type := 'NUMBER' ;
115:
116: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID AND ' ||
117: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 30' ;
118: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
119: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
120: end if;
121:
122: -- Get Node Label from message

Line 173: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

169: l_opp_list(l_node_counter).NODE_DEPTH := 3;
170: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
171: --added by vimpi on 2nd nov/01
172:
173: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
174:
175: l_node_counter := l_node_counter + 1;
176: END LOOP;
177: --

Line 197: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

193: l_bind_list(2).bind_var_data_type := 'NUMBER' ;
194:
195: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID AND ' ||
196: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 90' ;
197: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
198: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
199: end if;
200:
201: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;

Line 247: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

243: l_opp_list(l_node_counter).HIDE_IF_EMPTY := '';
244: --l_ld_list(l_node_counter).NODE_DEPTH := 2;
245: l_opp_list(l_node_counter).NODE_DEPTH := 3;
246:
247: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
248: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
249:
250: l_node_counter := l_node_counter + 1;
251:

Line 270: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

266:
267: --added by vimpi in 7th dec to lower cost
268: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID AND ' ||
269: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 180' ;
270: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
271: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
272: end if;
273:
274: -- Get Node Label from message

Line 327: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

323: --l_opp_list(l_node_counter).NODE_DEPTH := 2;
324: l_opp_list(l_node_counter).NODE_DEPTH := 3;
325: --added by vimpi on 2nd nov/01
326:
327: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
328: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
329:
330: l_node_counter := l_node_counter + 1;
331:

Line 350: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

346: l_bind_list(2).bind_var_data_type := 'NUMBER' ;
347:
348: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID AND ' ||
349: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 365' ;
350: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
351: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
352: end if;
353:
354: -- Get Node Label from message

Line 406: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

402: l_opp_list(l_node_counter).HIDE_IF_EMPTY := '';
403: --l_opp_list(l_node_counter).NODE_DEPTH := 2;
404: l_opp_list(l_node_counter).NODE_DEPTH := 3;
405:
406: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
407: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
408:
409:
410:

Line 432: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

428:
429: --added by vimpi in 7th dec to lower cost
430: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID';
431: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_SALESOPP_UWQ_REF_SUB_V';
432: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
433: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
434: end if;
435:
436: -- Get Node Label from message

Line 484: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

480: l_opp_list(l_node_counter).HIDE_IF_EMPTY := '';
481: --l_opp_list(l_node_counter).NODE_DEPTH := 2;
482: l_opp_list(l_node_counter).NODE_DEPTH := 3;
483:
484: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
485: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
486:
487: l_node_counter := l_node_counter + 1;
488:

Line 492: IEU_PUB.ADD_UWQ_NODE_DATA

488:
489: END LOOP;
490:
491:
492: IEU_PUB.ADD_UWQ_NODE_DATA
493: (P_RESOURCE_ID,
494: P_SEL_ENUM_ID,
495: l_opp_list
496: );

Line 514: l_opp_list IEU_PUB.EnumeratorDataRecordList;

510: )
511: AS
512:
513: l_node_label VARCHAR2(200);
514: l_opp_list IEU_PUB.EnumeratorDataRecordList;
515: l_node_counter NUMBER;
516: l_bind_list IEU_PUB.BindVariableRecordList ;
517: l_bind_list2 IEU_PUB.BindVariableRecordList ;
518: l_Access varchar2(10);

Line 516: l_bind_list IEU_PUB.BindVariableRecordList ;

512:
513: l_node_label VARCHAR2(200);
514: l_opp_list IEU_PUB.EnumeratorDataRecordList;
515: l_node_counter NUMBER;
516: l_bind_list IEU_PUB.BindVariableRecordList ;
517: l_bind_list2 IEU_PUB.BindVariableRecordList ;
518: l_Access varchar2(10);
519: l_OrgID number;
520: l_view_name VARCHAR2(50);

Line 517: l_bind_list2 IEU_PUB.BindVariableRecordList ;

513: l_node_label VARCHAR2(200);
514: l_opp_list IEU_PUB.EnumeratorDataRecordList;
515: l_node_counter NUMBER;
516: l_bind_list IEU_PUB.BindVariableRecordList ;
517: l_bind_list2 IEU_PUB.BindVariableRecordList ;
518: l_Access varchar2(10);
519: l_OrgID number;
520: l_view_name VARCHAR2(50);
521: l_ds_name VARCHAR2(50);

Line 582: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

578: l_bind_list(2).bind_var_data_type := 'NUMBER' ;
579:
580: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_MYTEAM_SALESOPP_UWQ_R_S_V';
581: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID ';
582: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
583: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
584: end if;
585:
586: l_opp_list(l_node_counter).NODE_TYPE := 0;

Line 608: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

604: l_bind_list(2).bind_var_data_type := 'NUMBER' ;
605:
606: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID AND ' ||
607: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 30' ;
608: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
609: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
610: end if;
611:
612: -- Get Node Label from message

Line 663: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

659: l_opp_list(l_node_counter).NODE_DEPTH := 3;
660: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
661: --added by vimpi on 2nd nov/01
662:
663: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
664:
665: l_node_counter := l_node_counter + 1;
666: END LOOP;
667: --

Line 687: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

683: l_bind_list(2).bind_var_data_type := 'NUMBER' ;
684:
685: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID AND ' ||
686: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 90' ;
687: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
688: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
689: end if;
690:
691: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;

Line 737: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

733: l_opp_list(l_node_counter).HIDE_IF_EMPTY := '';
734: --l_ld_list(l_node_counter).NODE_DEPTH := 2;
735: l_opp_list(l_node_counter).NODE_DEPTH := 3;
736:
737: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
738: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
739:
740: l_node_counter := l_node_counter + 1;
741:

Line 760: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

756:
757: --added by vimpi in 7th dec to lower cost
758: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID AND ' ||
759: ' DECISION_DATE >= trunc(sysdate) AND (DECISION_DATE - trunc(sysdate) ) <= 180' ;
760: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
761: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
762: end if;
763:
764: -- Get Node Label from message

Line 817: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

813: --l_opp_list(l_node_counter).NODE_DEPTH := 2;
814: l_opp_list(l_node_counter).NODE_DEPTH := 3;
815: --added by vimpi on 2nd nov/01
816:
817: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
818: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
819:
820: l_node_counter := l_node_counter + 1;
821:

Line 840: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

836: l_bind_list(2).bind_var_data_type := 'NUMBER' ;
837:
838: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID AND ' ||
839: ' DECISION_DATE >= trunc(sysdate) AND (DECISION_DATE - trunc(sysdate) ) <= 365' ;
840: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
841: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
842: end if;
843:
844: -- Get Node Label from message

Line 896: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

892: l_opp_list(l_node_counter).HIDE_IF_EMPTY := '';
893: --l_opp_list(l_node_counter).NODE_DEPTH := 2;
894: l_opp_list(l_node_counter).NODE_DEPTH := 3;
895:
896: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
897: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
898:
899:
900:

Line 922: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

918:
919: --added by vimpi in 7th dec to lower cost
920: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_MYTEAM_SALESOPP_UWQ_R_S_V';
921: l_Opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND ORG_ID = :ORG_ID';
922: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
923: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
924: end if;
925:
926: -- Get Node Label from message

Line 974: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;

970: l_opp_list(l_node_counter).HIDE_IF_EMPTY := '';
971: --l_opp_list(l_node_counter).NODE_DEPTH := 2;
972: l_opp_list(l_node_counter).NODE_DEPTH := 3;
973:
974: l_opp_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
975: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
976:
977: l_node_counter := l_node_counter + 1;
978:

Line 981: IEU_PUB.ADD_UWQ_NODE_DATA

977: l_node_counter := l_node_counter + 1;
978:
979: END LOOP;
980:
981: IEU_PUB.ADD_UWQ_NODE_DATA
982: (P_RESOURCE_ID,
983: P_SEL_ENUM_ID,
984: l_opp_list
985: );