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_DBI_SUTIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 40: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

36:
37: l_last_refresh_date := fnd_date.displaydt_to_date(
38: bis_collection_utilities.get_last_refresh_period('POAREQLN'));
39:
40: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
41: l_custom_rec.attribute_name := '&REQ_FACT_UPDATE_DATE';
42: l_custom_rec.attribute_value := to_char(l_last_refresh_date,'DD/MM/YYYY HH24:MI:SS');
43: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
44: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

Line 43: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

39:
40: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
41: l_custom_rec.attribute_name := '&REQ_FACT_UPDATE_DATE';
42: l_custom_rec.attribute_value := to_char(l_last_refresh_date,'DD/MM/YYYY HH24:MI:SS');
43: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
44: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
45: p_custom_output.extend;
46: p_custom_output(p_custom_output.count) := l_custom_rec;
47:

Line 44: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

40: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
41: l_custom_rec.attribute_name := '&REQ_FACT_UPDATE_DATE';
42: l_custom_rec.attribute_value := to_char(l_last_refresh_date,'DD/MM/YYYY HH24:MI:SS');
43: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
44: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
45: p_custom_output.extend;
46: p_custom_output(p_custom_output.count) := l_custom_rec;
47:
48: END bind_reqfact_date;

Line 2376: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

2372: */
2373: l_top_cost_ctr_value := '-9999';
2374: end if;
2375:
2376: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
2377:
2378: if x_custom_output is null then
2379: x_custom_output := bis_query_attributes_tbl();
2380: end if;

Line 2384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2380: end if;
2381:
2382: l_custom_rec.attribute_name := '®IONCODE';
2383: l_custom_rec.attribute_value := l_region_code;
2384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2386: x_custom_output.EXTEND;
2387: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2388:

Line 2385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;

2381:
2382: l_custom_rec.attribute_name := '®IONCODE';
2383: l_custom_rec.attribute_value := l_region_code;
2384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2386: x_custom_output.EXTEND;
2387: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2388:
2389: l_custom_rec.attribute_name := '&COMPANYID';

Line 2391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2387: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2388:
2389: l_custom_rec.attribute_name := '&COMPANYID';
2390: l_custom_rec.attribute_value := l_company_value;
2391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2393: x_custom_output.EXTEND;
2394: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2395:

Line 2392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;

2388:
2389: l_custom_rec.attribute_name := '&COMPANYID';
2390: l_custom_rec.attribute_value := l_company_value;
2391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2393: x_custom_output.EXTEND;
2394: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2395:
2396: l_custom_rec.attribute_name := '&TOPCOMPANYID';

Line 2398: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2394: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2395:
2396: l_custom_rec.attribute_name := '&TOPCOMPANYID';
2397: l_custom_rec.attribute_value := l_top_company_value;
2398: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2399: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2400: x_custom_output.EXTEND;
2401: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2402:

Line 2399: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;

2395:
2396: l_custom_rec.attribute_name := '&TOPCOMPANYID';
2397: l_custom_rec.attribute_value := l_top_company_value;
2398: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2399: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2400: x_custom_output.EXTEND;
2401: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2402:
2403: l_custom_rec.attribute_name := '&COSTCTRID';

Line 2405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2401: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2402:
2403: l_custom_rec.attribute_name := '&COSTCTRID';
2404: l_custom_rec.attribute_value := l_cost_ctr_value;
2405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2407: x_custom_output.EXTEND;
2408: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2409:

Line 2406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;

2402:
2403: l_custom_rec.attribute_name := '&COSTCTRID';
2404: l_custom_rec.attribute_value := l_cost_ctr_value;
2405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2407: x_custom_output.EXTEND;
2408: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2409:
2410: l_custom_rec.attribute_name := '&TOPCOSTCTRID';

Line 2412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2408: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2409:
2410: l_custom_rec.attribute_name := '&TOPCOSTCTRID';
2411: l_custom_rec.attribute_value := l_top_cost_ctr_value;
2412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2413: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2414: x_custom_output.EXTEND;
2415: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2416: end bind_com_cc_values;

Line 2413: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;

2409:
2410: l_custom_rec.attribute_name := '&TOPCOSTCTRID';
2411: l_custom_rec.attribute_value := l_top_cost_ctr_value;
2412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2413: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.CHARACTER_BIND;
2414: x_custom_output.EXTEND;
2415: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
2416: end bind_com_cc_values;
2417: