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.AMS_DCF_LEADS_TITLE dependencies on JTFB_DCF

Line 21: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');

17: vPeriod varchar2(80);
18: xPeriod varchar2(80);
19:
20: BEGIN
21: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
22: 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;
23: return (xPeriod);
24: EXCEPTION
25: WHEN OTHERS THEN

Line 42: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');

38: vFor varchar2(80);
39: vCompCode varchar2(80);
40:
41: BEGIN
42: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
43: select
44: meaning into vRepName
45: from
46: fnd_lookup_values

Line 51: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');

47: where
48: lookup_type= 'BIM_DBC_DCF_TITLES'
49: and lookup_code = vCompCode
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;

Line 52: -- vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');

48: lookup_type= 'BIM_DBC_DCF_TITLES'
49: and lookup_code = vCompCode
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:

Line 53: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');

49: and lookup_code = vCompCode
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);

Line 74: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');

70: vScaleByMeaning varchar2(80);
71: vCompCode varchar2(80);
72:
73: BEGIN
74: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
75: select
76: meaning into vRepName
77: from
78: fnd_lookup_values

Line 84: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
88: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 85: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');

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
88: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
89: else

Line 111: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');

107: vScaleByMeaning varchar2(80);
108: vCompCode varchar2(80);
109:
110: BEGIN
111: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
112: select
113: meaning into vRepName
114: from
115: fnd_lookup_values

Line 121: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
125: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 122: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_LS');

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
125: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
126: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');

Line 147: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');

143: vScaleByMeaning varchar2(80);
144: vCompCode varchar2(80);
145:
146: BEGIN
147: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
148: select
149: meaning into vRepName
150: from
151: fnd_lookup_values

Line 157: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
161: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 158: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_LQ');

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
161: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
162: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');

Line 183: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');

179: vScaleByMeaning varchar2(80);
180: vCompCode varchar2(80);
181:
182: BEGIN
183: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
184: select
185: meaning into vRepName
186: from
187: fnd_lookup_values

Line 193: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
197: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 194: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_WS');

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
197: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
198: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');

Line 219: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');

215: vScaleByMeaning varchar2(80);
216: vCompCode varchar2(80);
217:
218: BEGIN
219: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
220: select
221: meaning into vRepName
222: from
223: fnd_lookup_values

Line 229: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
233: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 230: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_IS');

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
233: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
234: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');

Line 255: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');

251: vScaleByMeaning varchar2(80);
252: vCompCode varchar2(80);
253:
254: BEGIN
255: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
256: select
257: meaning into vRepName
258: from
259: fnd_lookup_values

Line 265: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
269: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 266: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_WR');

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
269: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
270: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');

Line 305: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');

301: vCompCode varchar2(80);
302:
303:
304: BEGIN
305: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
306: select
307: meaning into vRepName
308: from
309: fnd_lookup_values

Line 314: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');

310: where
311: lookup_type= 'BIM_DBC_DCF_TITLES'
312: and lookup_code = vCompCode
313: and language = userenv('LANG');
314: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
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');

Line 315: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');

311: lookup_type= 'BIM_DBC_DCF_TITLES'
312: and lookup_code = vCompCode
313: and language = userenv('LANG');
314: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
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');

Line 316: vDefPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_DEF_PERIOD');

312: and lookup_code = vCompCode
313: and language = userenv('LANG');
314: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
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');

Line 317: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');

313: and language = userenv('LANG');
314: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
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:

Line 318: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

314: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
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';