DBA Data[Home] [Help]

APPS.AST_UWQ_OPP_ENUMS_PVT dependencies on FND_MESSAGE

Line 123: fnd_message.set_name('AST','AST_UWQ_30_DAYS_FOR_OPP');

119: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
120: end if;
121:
122: -- Get Node Label from message
123: fnd_message.set_name('AST','AST_UWQ_30_DAYS_FOR_OPP');
124: l_node_label := fnd_message.get;
125: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
126: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
127: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_SALESOPP_UWQ_REF_SUB_V';

Line 124: l_node_label := fnd_message.get;

120: end if;
121:
122: -- Get Node Label from message
123: fnd_message.set_name('AST','AST_UWQ_30_DAYS_FOR_OPP');
124: l_node_label := fnd_message.get;
125: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
126: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
127: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_SALESOPP_UWQ_REF_SUB_V';
128: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;

Line 185: fnd_message.set_name('AST','AST_UWQ_90_DAYS_FOR_OPP');

181: l_bind_list(1).bind_var_name := ':RESOURCE_ID' ;
182: l_bind_list(1).bind_var_value := P_RESOURCE_ID ;
183: l_bind_list(1).bind_var_data_type := 'NUMBER' ;
184: -- Get Node Label from message
185: fnd_message.set_name('AST','AST_UWQ_90_DAYS_FOR_OPP');
186: l_node_label := fnd_message.get;
187:
188: l_opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND '||
189: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 90';

Line 186: l_node_label := fnd_message.get;

182: l_bind_list(1).bind_var_value := P_RESOURCE_ID ;
183: l_bind_list(1).bind_var_data_type := 'NUMBER' ;
184: -- Get Node Label from message
185: fnd_message.set_name('AST','AST_UWQ_90_DAYS_FOR_OPP');
186: l_node_label := fnd_message.get;
187:
188: l_opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND '||
189: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 90';
190: if (l_Access = 'O') then

Line 275: fnd_message.set_name('AST','AST_UWQ_6_MNTHS_FOR_OPP');

271: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
272: end if;
273:
274: -- Get Node Label from message
275: fnd_message.set_name('AST','AST_UWQ_6_MNTHS_FOR_OPP');
276: l_node_label := fnd_message.get;
277: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
278: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
279: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_SALESOPP_UWQ_REF_SUB_V';

Line 276: l_node_label := fnd_message.get;

272: end if;
273:
274: -- Get Node Label from message
275: fnd_message.set_name('AST','AST_UWQ_6_MNTHS_FOR_OPP');
276: l_node_label := fnd_message.get;
277: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
278: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
279: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_SALESOPP_UWQ_REF_SUB_V';
280: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;

Line 355: fnd_message.set_name('AST','AST_UWQ_1_YEAR_FOR_OPP');

351: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
352: end if;
353:
354: -- Get Node Label from message
355: fnd_message.set_name('AST','AST_UWQ_1_YEAR_FOR_OPP');
356: l_node_label := fnd_message.get;
357: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
358: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
359: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_SALESOPP_UWQ_REF_SUB_V';

Line 356: l_node_label := fnd_message.get;

352: end if;
353:
354: -- Get Node Label from message
355: fnd_message.set_name('AST','AST_UWQ_1_YEAR_FOR_OPP');
356: l_node_label := fnd_message.get;
357: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
358: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
359: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_SALESOPP_UWQ_REF_SUB_V';
360: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;

Line 437: fnd_message.set_name('AST','AST_UWQ_ALL_OPPS');

433: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
434: end if;
435:
436: -- Get Node Label from message
437: fnd_message.set_name('AST','AST_UWQ_ALL_OPPS');
438: l_node_label := fnd_message.get;
439: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
440: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
441: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;

Line 438: l_node_label := fnd_message.get;

434: end if;
435:
436: -- Get Node Label from message
437: fnd_message.set_name('AST','AST_UWQ_ALL_OPPS');
438: l_node_label := fnd_message.get;
439: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
440: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
441: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;
442: l_opp_list(l_node_counter).MEDIA_TYPE_ID := '';

Line 613: fnd_message.set_name('AST','AST_UWQ_30_DAYS_FOR_OPP');

609: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
610: end if;
611:
612: -- Get Node Label from message
613: fnd_message.set_name('AST','AST_UWQ_30_DAYS_FOR_OPP');
614: l_node_label := fnd_message.get;
615: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
616: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
617: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_MYTEAM_SALESOPP_UWQ_R_S_V';

Line 614: l_node_label := fnd_message.get;

610: end if;
611:
612: -- Get Node Label from message
613: fnd_message.set_name('AST','AST_UWQ_30_DAYS_FOR_OPP');
614: l_node_label := fnd_message.get;
615: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
616: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
617: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_MYTEAM_SALESOPP_UWQ_R_S_V';
618: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;

Line 675: fnd_message.set_name('AST','AST_UWQ_90_DAYS_FOR_OPP');

671: l_bind_list(1).bind_var_name := ':RESOURCE_ID' ;
672: l_bind_list(1).bind_var_value := P_RESOURCE_ID ;
673: l_bind_list(1).bind_var_data_type := 'NUMBER' ;
674: -- Get Node Label from message
675: fnd_message.set_name('AST','AST_UWQ_90_DAYS_FOR_OPP');
676: l_node_label := fnd_message.get;
677:
678: l_opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND '||
679: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 90';

Line 676: l_node_label := fnd_message.get;

672: l_bind_list(1).bind_var_value := P_RESOURCE_ID ;
673: l_bind_list(1).bind_var_data_type := 'NUMBER' ;
674: -- Get Node Label from message
675: fnd_message.set_name('AST','AST_UWQ_90_DAYS_FOR_OPP');
676: l_node_label := fnd_message.get;
677:
678: l_opp_list(l_node_counter).WHERE_CLAUSE := 'RESOURCE_ID = :RESOURCE_ID AND RESOURCE_ID+0 = :RESOURCE_ID AND '||
679: ' DECISION_DATE >= trunc(SYSDATE) AND (DECISION_DATE - trunc(SYSDATE)) <= 90';
680: if (l_Access = 'O') then

Line 765: fnd_message.set_name('AST','AST_UWQ_6_MNTHS_FOR_OPP');

761: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
762: end if;
763:
764: -- Get Node Label from message
765: fnd_message.set_name('AST','AST_UWQ_6_MNTHS_FOR_OPP');
766: l_node_label := fnd_message.get;
767: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
768: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
769: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_MYTEAM_SALESOPP_UWQ_R_S_V';

Line 766: l_node_label := fnd_message.get;

762: end if;
763:
764: -- Get Node Label from message
765: fnd_message.set_name('AST','AST_UWQ_6_MNTHS_FOR_OPP');
766: l_node_label := fnd_message.get;
767: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
768: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
769: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_MYTEAM_SALESOPP_UWQ_R_S_V';
770: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;

Line 845: fnd_message.set_name('AST','AST_UWQ_1_YEAR_FOR_OPP');

841: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
842: end if;
843:
844: -- Get Node Label from message
845: fnd_message.set_name('AST','AST_UWQ_1_YEAR_FOR_OPP');
846: l_node_label := fnd_message.get;
847: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
848: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
849: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_MYTEAM_SALESOPP_UWQ_R_S_V';

Line 846: l_node_label := fnd_message.get;

842: end if;
843:
844: -- Get Node Label from message
845: fnd_message.set_name('AST','AST_UWQ_1_YEAR_FOR_OPP');
846: l_node_label := fnd_message.get;
847: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
848: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
849: l_opp_list(l_node_counter).REFRESH_VIEW_NAME := 'AST_MYTEAM_SALESOPP_UWQ_R_S_V';
850: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;

Line 927: fnd_message.set_name('AST','AST_UWQ_ALL_OPPS');

923: l_opp_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
924: end if;
925:
926: -- Get Node Label from message
927: fnd_message.set_name('AST','AST_UWQ_ALL_OPPS');
928: l_node_label := fnd_message.get;
929: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
930: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
931: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;

Line 928: l_node_label := fnd_message.get;

924: end if;
925:
926: -- Get Node Label from message
927: fnd_message.set_name('AST','AST_UWQ_ALL_OPPS');
928: l_node_label := fnd_message.get;
929: l_opp_list(l_node_counter).NODE_LABEL := l_node_label;
930: l_opp_list(l_node_counter).VIEW_NAME := l_view_name;
931: l_opp_list(l_node_counter).DATA_SOURCE := l_ds_name;
932: l_opp_list(l_node_counter).MEDIA_TYPE_ID := '';