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 BIS_UTILITIES_PUB

Line 5: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

1: PACKAGE BODY POA_REPORT_UTIL AS
2: /* $Header: poarutlb.pls 115.12 2003/01/23 18:59:15 rvickrey ship $ */
3:
4: PROCEDURE Build_OrderDates(
5: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
6: p_index IN NUMBER) IS
7: BEGIN
8: p_param(p_index).Label :=
9: FND_MESSAGE.get_string('PO', 'POA_ORDER_DATES');

Line 18: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

14: icx_sec.g_date_format));
15: END Build_OrderDates;
16:
17: PROCEDURE Build_ReportingDates(
18: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
19: p_index IN NUMBER) IS
20: BEGIN
21: p_param(p_index).Label :=
22: FND_MESSAGE.get_string('PO', 'POA_REPORTING_DATES');

Line 31: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

27: icx_sec.g_date_format));
28: END Build_ReportingDates;
29:
30: PROCEDURE Build_SupplierItem(
31: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
32: p_index IN NUMBER) IS
33: BEGIN
34: p_param(p_index).Label :=
35: FND_MESSAGE.get_string('PO', 'POA_ITEM');

Line 47: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
48: p_index IN NUMBER) IS
49: BEGIN
50: p_param(p_index).Label :=
51: FND_MESSAGE.get_string('PO', 'POA_PREF_SUPPLIER');

Line 63: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
64: p_index IN NUMBER) IS
65: BEGIN
66: p_param(p_index).Label :=
67: FND_MESSAGE.get_string('PO', 'POA_CONS_SUPPLIER');

Line 79: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
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 ||

Line 88: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
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 ||

Line 97: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
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 ||

Line 106: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
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 ||

Line 115: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
116: p_index IN NUMBER) IS
117: BEGIN
118: p_param(p_index).Label :=
119: FND_MESSAGE.get_string('PO', 'POA_SUPPLIER_NUM');

Line 125: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

121: to_char(3));
122: END Build_SupplierNum;
123:
124: PROCEDURE Build_QualityCost(
125: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
126: p_index IN NUMBER) IS
127: BEGIN
128: p_param(p_index).Label :=
129: FND_MESSAGE.get_string('PO', 'POA_QUALITY_COST');

Line 135: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

131: to_char(25));
132: END Build_QualityCost;
133:
134: PROCEDURE Build_DeliveryCost(
135: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
136: p_index IN NUMBER) IS
137: BEGIN
138: p_param(p_index).Label :=
139: FND_MESSAGE.get_string('PO', 'POA_DELIVERY_COST');

Line 145: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

141: to_char(25));
142: END Build_DeliveryCost;
143:
144: PROCEDURE Build_SupplierOrderBy(
145: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
146: p_index IN NUMBER) IS
147: BEGIN
148: p_param(p_index).Label :=
149: FND_MESSAGE.get_string('PO', 'POA_ORDER_BY');

Line 170: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

166:
167: END Build_SupplierOrderBy;
168:
169: PROCEDURE Build_SavingsOperatingUnit(
170: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
171: p_index IN NUMBER) IS
172: l_where_clause VARCHAR2(1000);
173: l_return_status VARCHAR2(1000);
174: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 174: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

170: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
171: p_index IN NUMBER) IS
172: l_where_clause VARCHAR2(1000);
173: l_return_status VARCHAR2(1000);
174: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
175: l_region_code VARCHAR2(30);
176: BEGIN
177:
178: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

Line 181: BIS_UTILITIES_PUB.Retrieve_Where_Clause

177:
178: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN
179: -- Use region pointing to BIS lov restricted based on responsibilities
180: l_region_code := 'POA_BIS_SAVINGS_RPT';
181: BIS_UTILITIES_PUB.Retrieve_Where_Clause
182: (p_user_id => FND_GLOBAL.user_id,
183: p_region_code => 'BIS_OPERATING_UNIT',
184: x_where_clause => l_where_clause,
185: x_return_status => l_return_status,

Line 206: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
207: p_index IN NUMBER) IS
208: l_where_clause VARCHAR2(1000);
209: l_return_status VARCHAR2(1000);
210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

206: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
207: p_index IN NUMBER) IS
208: l_where_clause VARCHAR2(1000);
209: l_return_status VARCHAR2(1000);
210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
211: l_region_code VARCHAR2(30);
212: BEGIN
213:
214: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

Line 217: BIS_UTILITIES_PUB.Retrieve_Where_Clause

213:
214: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN
215: -- Use region pointing to BIS lov restricted based on responsibilities
216: l_region_code := 'POA_BIS_PPS_RPT';
217: BIS_UTILITIES_PUB.Retrieve_Where_Clause
218: (p_user_id => FND_GLOBAL.user_id,
219: p_region_code => 'BIS_OPERATING_UNIT',
220: x_where_clause => l_where_clause,
221: x_return_status => l_return_status,

Line 243: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
244: p_index IN NUMBER) IS
245: BEGIN
246: p_param(p_index).Label :=
247: FND_MESSAGE.get_string('PO', 'POA_BUYER');

Line 259: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
260: p_index IN NUMBER) IS
261: BEGIN
262: p_param(p_index).Label :=
263: FND_MESSAGE.get_string('PO', 'POA_COMMODITY');

Line 275: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
276: p_index IN NUMBER) IS
277: BEGIN
278: p_param(p_index).Label :=
279: FND_MESSAGE.get_string('PO', 'POA_ITEM');

Line 291: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
292: p_index IN NUMBER) IS
293: BEGIN
294: p_param(p_index).Label :=
295: FND_MESSAGE.get_string('PO', 'POA_SUPPLIER');

Line 307: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

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,
308: p_index IN NUMBER) IS
309: BEGIN
310: p_param(p_index).Label :=
311: FND_MESSAGE.get_string('PO', 'POA_PERIOD_TYPE');

Line 325: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

321: order by gpt.user_period_type', p_param(p_index).Value);
322: END Build_KPIPeriodType;
323:
324: PROCEDURE Build_KPI_2PeriodType(
325: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
326: p_index IN NUMBER) IS
327: BEGIN
328: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
329: Build_Selection('POA_BIS_PERIOD_TYPE2',

Line 339: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

335: p_param(p_index).Value);
336: END Build_KPI_2PeriodType;
337:
338: PROCEDURE Build_CTL_ViewBy(
339: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
340: p_index IN NUMBER) IS
341: BEGIN
342: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
343: Build_Selection('POA_BIS_VIEW_BY',

Line 352: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

348: p_param(p_index).Value);
349: END Build_CTL_ViewBy;
350:
351: PROCEDURE Build_LSS_ViewBy(
352: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
353: p_index IN NUMBER) IS
354: BEGIN
355: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
356: Build_Selection('POA_BIS_VIEW_BY',

Line 367: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

363: p_param(p_index).Value);
364: END Build_LSS_ViewBy;
365:
366: PROCEDURE Build_SPA_ViewBy(
367: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
368: p_index IN NUMBER) IS
369: BEGIN
370: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
371: Build_Selection('POA_BIS_VIEW_BY',

Line 386: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

382: p_param(p_index).Value);
383: END Build_SPA_ViewBy;
384:
385: PROCEDURE Build_SavingsShipToOrg(
386: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
387: p_index IN NUMBER) IS
388: l_where_clause VARCHAR2(1000);
389: l_return_status VARCHAR2(1000);
390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

386: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
387: p_index IN NUMBER) IS
388: l_where_clause VARCHAR2(1000);
389: l_return_status VARCHAR2(1000);
390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
391: l_region_code VARCHAR2(30);
392: BEGIN
393:
394: IF nvl(fnd_profile.value('POA_GLOBAL_SECURITY'), 'N') = 'N' THEN

Line 467: p_param IN BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type) IS

463: RAISE;
464: END Build_Selection;
465:
466: PROCEDURE Build_ErrorPage(
467: p_param IN BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type) IS
468: l_count NUMBER;
469: BEGIN
470: IF p_param.count > 0 THEN
471: htp.p('
Line 975: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

971: (p_user_id IN NUMBER := NULL
972: ,p_user_name IN VARCHAR2 := NULL
973: ,x_where_clause OUT NOCOPY VARCHAR2
974: ,x_return_status OUT NOCOPY VARCHAR2
975: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
976: )
977: IS
978: l_user_id NUMBER;
979: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;