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.POA_REPORT_UTIL dependencies on HTF

Line 10: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,

6: p_index IN NUMBER) IS
7: BEGIN
8: p_param(p_index).Label :=
9: FND_MESSAGE.get_string('PO', 'POA_ORDER_DATES');
10: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
11: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
12: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
13: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),
14: icx_sec.g_date_format));

Line 13: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),

9: FND_MESSAGE.get_string('PO', 'POA_ORDER_DATES');
10: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
11: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
12: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
13: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),
14: icx_sec.g_date_format));
15: END Build_OrderDates;
16:
17: PROCEDURE Build_ReportingDates(

Line 23: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,

19: p_index IN NUMBER) IS
20: BEGIN
21: p_param(p_index).Label :=
22: FND_MESSAGE.get_string('PO', 'POA_REPORTING_DATES');
23: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
24: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
25: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
26: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),
27: icx_sec.g_date_format));

Line 26: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),

22: FND_MESSAGE.get_string('PO', 'POA_REPORTING_DATES');
23: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
24: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
25: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
26: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),
27: icx_sec.g_date_format));
28: END Build_ReportingDates;
29:
30: PROCEDURE Build_SupplierItem(

Line 36: p_param(p_index).Value := htf.formText('POA_BIS_ITEM_NAME');

32: p_index IN NUMBER) IS
33: BEGIN
34: p_param(p_index).Label :=
35: FND_MESSAGE.get_string('PO', 'POA_ITEM');
36: p_param(p_index).Value := htf.formText('POA_BIS_ITEM_NAME');
37: p_param(p_index).Action :=
38: '
40:

Line 43: htf.formHidden('POA_BIS_ITEM_ID');

39: ''POA_BIS_SUPPERF_RPT'',''RPTPFORM'','''','''','''')">
40: 41: ="List of Values">';
42: p_param(p_index).Action := p_param(p_index).Action ||
43: htf.formHidden('POA_BIS_ITEM_ID');
44: END Build_SupplierItem;
45:
46: PROCEDURE Build_PrefSupplier(
47: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 52: p_param(p_index).Value := htf.formText('POA_BIS_PREF_SUPP_NAME');

48: p_index IN NUMBER) IS
49: BEGIN
50: p_param(p_index).Label :=
51: FND_MESSAGE.get_string('PO', 'POA_PREF_SUPPLIER');
52: p_param(p_index).Value := htf.formText('POA_BIS_PREF_SUPP_NAME');
53: p_param(p_index).Action :=
54: '
56:

Line 59: htf.formHidden('POA_BIS_PREF_SUPP_ID');

55: ''POA_BIS_SUPPERF_RPT'',''RPTPFORM'','''','''','''')">
56: 57: ="List of Values">';
58: p_param(p_index).Action := p_param(p_index).Action ||
59: htf.formHidden('POA_BIS_PREF_SUPP_ID');
60: END Build_PrefSupplier;
61:
62: PROCEDURE Build_ConsSupplier(
63: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 68: p_param(p_index).Value := htf.formText('POA_BIS_CONS_SUPP_NAME');

64: p_index IN NUMBER) IS
65: BEGIN
66: p_param(p_index).Label :=
67: FND_MESSAGE.get_string('PO', 'POA_CONS_SUPPLIER');
68: p_param(p_index).Value := htf.formText('POA_BIS_CONS_SUPP_NAME');
69: p_param(p_index).Action :=
70: '
72:

Line 75: htf.formHidden('POA_BIS_CONS_SUPP_ID');

71: ''POA_BIS_SUPPERF_RPT'',''RPTPFORM'','''','''','''')">
72: 73: ="List of Values">';
74: p_param(p_index).Action := p_param(p_index).Action ||
75: htf.formHidden('POA_BIS_CONS_SUPP_ID');
76: END Build_ConsSupplier;
77:
78: PROCEDURE Build_HiddenStartDate(p_start_date IN VARCHAR2,
79: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 84: htf.formHidden('P_FDATE', p_start_date);

80: p_index IN NUMBER) IS
81: BEGIN
82: -- p_param(p_index).Label := 'Reporting Start Date';
83: p_param(p_index).Action := p_param(p_index).Action ||
84: htf.formHidden('P_FDATE', p_start_date);
85: END Build_HiddenStartDate;
86:
87: PROCEDURE Build_HiddenEndDate(p_end_date IN VARCHAR2,
88: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 93: htf.formHidden('P_TDATE', p_end_date);

89: p_index IN NUMBER) IS
90: BEGIN
91: -- p_param(p_index).Label := 'Reporting End Date';
92: p_param(p_index).Action := p_param(p_index).Action ||
93: htf.formHidden('P_TDATE', p_end_date);
94: END Build_HiddenEndDate;
95:
96: PROCEDURE Build_HiddenCurrency(p_currency_code IN VARCHAR2,
97: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 102: htf.formHidden('POA_BIS_CURRENCY', p_currency_code);

98: p_index IN NUMBER) IS
99: BEGIN
100: -- p_param(p_index).Label := 'Currency';
101: p_param(p_index).Action := p_param(p_index).Action ||
102: htf.formHidden('POA_BIS_CURRENCY', p_currency_code);
103: END Build_HiddenCurrency;
104:
105: PROCEDURE Build_HiddenItem(p_item_id IN VARCHAR2,
106: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 111: htf.formHidden('POA_BIS_ITEM_ID', p_item_id);

107: p_index IN NUMBER) IS
108: BEGIN
109: -- p_param(p_index).Label := 'Item';
110: p_param(p_index).Action := p_param(p_index).Action ||
111: htf.formHidden('POA_BIS_ITEM_ID', p_item_id);
112: END Build_HiddenItem;
113:
114: PROCEDURE Build_SupplierNum(
115: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 120: p_param(p_index).Value := htf.formText('POA_BIS_SUPPLIER_NUM', NULL, NULL,

116: p_index IN NUMBER) IS
117: BEGIN
118: p_param(p_index).Label :=
119: FND_MESSAGE.get_string('PO', 'POA_SUPPLIER_NUM');
120: p_param(p_index).Value := htf.formText('POA_BIS_SUPPLIER_NUM', NULL, NULL,
121: to_char(3));
122: END Build_SupplierNum;
123:
124: PROCEDURE Build_QualityCost(

Line 130: p_param(p_index).Value := htf.formText('POA_BIS_QUALITY_COST', NULL, NULL,

126: p_index IN NUMBER) IS
127: BEGIN
128: p_param(p_index).Label :=
129: FND_MESSAGE.get_string('PO', 'POA_QUALITY_COST');
130: p_param(p_index).Value := htf.formText('POA_BIS_QUALITY_COST', NULL, NULL,
131: to_char(25));
132: END Build_QualityCost;
133:
134: PROCEDURE Build_DeliveryCost(

Line 140: p_param(p_index).Value := htf.formText('POA_BIS_DELIVERY_COST', NULL, NULL,

136: p_index IN NUMBER) IS
137: BEGIN
138: p_param(p_index).Label :=
139: FND_MESSAGE.get_string('PO', 'POA_DELIVERY_COST');
140: p_param(p_index).Value := htf.formText('POA_BIS_DELIVERY_COST', NULL, NULL,
141: to_char(25));
142: END Build_DeliveryCost;
143:
144: PROCEDURE Build_SupplierOrderBy(

Line 195: p_param(p_index).Value := htf.formText('POA_BIS_OPER_UNIT_NAME');

191: END IF;
192:
193: p_param(p_index).Label :=
194: FND_MESSAGE.get_string('PO', 'POA_OPERATING_UNIT');
195: p_param(p_index).Value := htf.formText('POA_BIS_OPER_UNIT_NAME');
196: p_param(p_index).Action :=
197: '
199:

Line 202: htf.formHidden('POA_BIS_OPER_UNIT_ID');

198: l_region_code || ''',''RPTPFORM'','''', '''', '''||l_where_clause ||''')">
199: 200: ="List of Values">';
201: p_param(p_index).Action := p_param(p_index).Action ||
202: htf.formHidden('POA_BIS_OPER_UNIT_ID');
203: END Build_SavingsOperatingUnit;
204:
205: PROCEDURE Build_PPS_OperatingUnit(
206: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 231: p_param(p_index).Value := htf.formText('POA_BIS_PPS_OPER_UNIT_NAME');

227: END IF;
228:
229: p_param(p_index).Label :=
230: FND_MESSAGE.get_string('PO', 'POA_OPERATING_UNIT');
231: p_param(p_index).Value := htf.formText('POA_BIS_PPS_OPER_UNIT_NAME');
232: p_param(p_index).Action :=
233: '

Line 239: htf.formHidden('POA_BIS_PPS_OPER_UNIT_ID');

235: l_where_clause || ''')">
236: 237: ="List of Values">';
238: p_param(p_index).Action := p_param(p_index).Action ||
239: htf.formHidden('POA_BIS_PPS_OPER_UNIT_ID');
240: END Build_PPS_OperatingUnit;
241:
242: PROCEDURE Build_SavingsBuyer(
243: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 248: p_param(p_index).Value := htf.formText('POA_BIS_BUYER_NAME');

244: p_index IN NUMBER) IS
245: BEGIN
246: p_param(p_index).Label :=
247: FND_MESSAGE.get_string('PO', 'POA_BUYER');
248: p_param(p_index).Value := htf.formText('POA_BIS_BUYER_NAME');
249: p_param(p_index).Action :=
250: '
252:

Line 255: htf.formHidden('POA_BIS_BUYER_ID');

251: ''POA_BIS_SAVINGS_RPT'',''RPTPFORM'','''','''','''')">
252: 253: ="List of Values">';
254: p_param(p_index).Action := p_param(p_index).Action ||
255: htf.formHidden('POA_BIS_BUYER_ID');
256: END Build_SavingsBuyer;
257:
258: PROCEDURE Build_SavingsCommodity(
259: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 264: p_param(p_index).Value := htf.formText('POA_BIS_COMMODITY_NAME');

260: p_index IN NUMBER) IS
261: BEGIN
262: p_param(p_index).Label :=
263: FND_MESSAGE.get_string('PO', 'POA_COMMODITY');
264: p_param(p_index).Value := htf.formText('POA_BIS_COMMODITY_NAME');
265: p_param(p_index).Action :=
266: '
268:

Line 271: htf.formHidden('POA_BIS_COMMODITY_ID');

267: ''POA_BIS_SAVINGS_RPT'',''RPTPFORM'','''','''','''')">
268: 269: ="List of Values">';
270: p_param(p_index).Action := p_param(p_index).Action ||
271: htf.formHidden('POA_BIS_COMMODITY_ID');
272: END Build_SavingsCommodity;
273:
274: PROCEDURE Build_SavingsItem(
275: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 280: p_param(p_index).Value := htf.formText('POA_BIS_ITEM_NAME');

276: p_index IN NUMBER) IS
277: BEGIN
278: p_param(p_index).Label :=
279: FND_MESSAGE.get_string('PO', 'POA_ITEM');
280: p_param(p_index).Value := htf.formText('POA_BIS_ITEM_NAME');
281: p_param(p_index).Action :=
282: '
284:

Line 287: htf.formHidden('POA_BIS_ITEM_ID');

283: ''POA_BIS_SAVINGS_RPT'',''RPTPFORM'','''','''','''')">
284: 285: ="List of Values">';
286: p_param(p_index).Action := p_param(p_index).Action ||
287: htf.formHidden('POA_BIS_ITEM_ID');
288: END Build_SavingsItem;
289:
290: PROCEDURE Build_SavingsSupplier(
291: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 296: p_param(p_index).Value := htf.formText('POA_BIS_SUPPLIER_NAME');

292: p_index IN NUMBER) IS
293: BEGIN
294: p_param(p_index).Label :=
295: FND_MESSAGE.get_string('PO', 'POA_SUPPLIER');
296: p_param(p_index).Value := htf.formText('POA_BIS_SUPPLIER_NAME');
297: p_param(p_index).Action :=
298: '
300:

Line 303: htf.formHidden('POA_BIS_SUPPLIER_ID');

299: ''POA_BIS_SAVINGS_RPT'',''RPTPFORM'','''','''','''')">
300: 301: ="List of Values">';
302: p_param(p_index).Action := p_param(p_index).Action ||
303: htf.formHidden('POA_BIS_SUPPLIER_ID');
304: END Build_SavingsSupplier;
305:
306: PROCEDURE Build_KPIPeriodType(
307: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 409: p_param(p_index).Value := htf.formText('POA_BIS_ORG_NAME');

405: END IF;
406:
407: p_param(p_index).Label :=
408: FND_MESSAGE.get_string('PO', 'POA_SHIP_TO_ORG');
409: p_param(p_index).Value := htf.formText('POA_BIS_ORG_NAME');
410: p_param(p_index).Action :=
411: '
413:

Line 416: htf.formHidden('POA_BIS_ORG_ID');

412: l_region_code || ''',''RPTPFORM'','''','''','''|| l_where_clause ||''')">
413: 414: ="List of Values">';
415: p_param(p_index).Action := p_param(p_index).Action ||
416: htf.formHidden('POA_BIS_ORG_ID');
417: END Build_SavingsShipToOrg;
418:
419: PROCEDURE Build_Selection(p_name IN VARCHAR2,
420: p_select IN VARCHAR2, p_output IN OUT NOCOPY VARCHAR2) IS

Line 433: p_output := p_output || ' ' || htf.formSelectOpen(p_name);

429: dbms_sql.define_column(l_cursor, 1, l_value, 254);
430: dbms_sql.define_column(l_cursor, 2, l_display, 254);
431: l_ret_code := dbms_sql.execute(l_cursor);
432: l_count := 0;
433: p_output := p_output || ' ' || htf.formSelectOpen(p_name);
434:
435: LOOP
436:
437: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN

Line 444: htf.formSelectOption(l_display, 'YES', 'value="' || l_value || '"');

440: dbms_sql.column_value(l_cursor, 2, l_display);
441:
442: IF l_count = 1 THEN
443: p_output := p_output || ' ' ||
444: htf.formSelectOption(l_display, 'YES', 'value="' || l_value || '"');
445: ELSE
446: p_output := p_output || ' ' ||
447: htf.formSelectOption(l_display, NULL, 'value="' || l_value || '"');
448: END IF;

Line 447: htf.formSelectOption(l_display, NULL, 'value="' || l_value || '"');

443: p_output := p_output || ' ' ||
444: htf.formSelectOption(l_display, 'YES', 'value="' || l_value || '"');
445: ELSE
446: p_output := p_output || ' ' ||
447: htf.formSelectOption(l_display, NULL, 'value="' || l_value || '"');
448: END IF;
449:
450: ELSE
451: EXIT;

Line 457: p_output := p_output || ' ' || htf.formSelectClose;

453:
454: END LOOP;
455:
456: dbms_sql.close_cursor(l_cursor);
457: p_output := p_output || ' ' || htf.formSelectClose;
458:
459: EXCEPTION
460: WHEN others THEN
461: POA_LOG.put_line('Error in Build_Selection procedure:');