DBA Data[Home] [Help]

APPS.AMS_DCF_LEADS_TITLE dependencies on AMS_UTILITY_PVT

Line 54: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');

50: and language = userenv('LANG');
51: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
52: -- vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
53: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
54: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
55: select to_char(start_date,'mm-dd') ||' to '|| to_char(end_date,'mm-dd') into xPeriod from bim_r_periods where calc_type = 'FIXED' and period_type = vPeriod;
56:
57: return (vRepName||' '||vFor||' '|| xPeriod);
58: EXCEPTION

Line 83: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

79: where
80: lookup_type= 'BIM_DBC_DCF_TITLES'
81: and lookup_code = vCompCode
82: and language = userenv('LANG');
83: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
84: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
85: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
86: if (vScaleByCode <> '1') then
87: select meaning into vScaleByMeaning from ams_lookups

Line 120: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

116: where
117: lookup_type= 'BIM_DBC_DCF_TITLES'
118: and lookup_code = vCompCode
119: and language = userenv('LANG');
120: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
121: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
122: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_LS');
123: if (vScaleByCode <> '1') then
124: select meaning into vScaleByMeaning from ams_lookups

Line 156: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

152: where
153: lookup_type= 'BIM_DBC_DCF_TITLES'
154: and lookup_code = vCompCode
155: and language = userenv('LANG');
156: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
157: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
158: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_LQ');
159: if (vScaleByCode <> '1') then
160: select meaning into vScaleByMeaning from ams_lookups

Line 192: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

188: where
189: lookup_type= 'BIM_DBC_DCF_TITLES'
190: and lookup_code = vCompCode
191: and language = userenv('LANG');
192: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
193: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
194: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_WS');
195: if (vScaleByCode <> '1') then
196: select meaning into vScaleByMeaning from ams_lookups

Line 228: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

224: where
225: lookup_type= 'BIM_DBC_DCF_TITLES'
226: and lookup_code = vCompCode
227: and language = userenv('LANG');
228: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
229: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
230: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_IS');
231: if (vScaleByCode <> '1') then
232: select meaning into vScaleByMeaning from ams_lookups

Line 264: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

260: where
261: lookup_type= 'BIM_DBC_DCF_TITLES'
262: and lookup_code = vCompCode
263: and language = userenv('LANG');
264: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
265: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
266: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_WR');
267: if (vScaleByCode <> '1') then
268: select meaning into vScaleByMeaning from ams_lookups

Line 319: --vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');

315: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
316: vDefPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_DEF_PERIOD');
317: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
318: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
319: --vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');
320: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
321:
322: xRetString := 'x';
323: xDisplayType := 'Z';

Line 320: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');

316: vDefPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_DEF_PERIOD');
317: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
318: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
319: --vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');
320: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
321:
322: xRetString := 'x';
323: xDisplayType := 'Z';
324: if (vContext is NULL OR vContext = 'NOT_FOUND' OR vContext = '') then