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.OKI_DBI_UTIL_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 2137: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

2133: x_custom_output IN OUT NOCOPY bis_query_attributes_tbl)
2134: IS
2135: l_custom_rec bis_query_attributes;
2136: BEGIN
2137: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
2138: -- Unassigned bind variable
2139: fnd_message.set_name (application => 'BIS'
2140: , NAME => 'EDW_UNASSIGNED');
2141: l_custom_rec.attribute_name := '&UNASSIGNED';

Line 2143: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2139: fnd_message.set_name (application => 'BIS'
2140: , NAME => 'EDW_UNASSIGNED');
2141: l_custom_rec.attribute_name := '&UNASSIGNED';
2142: l_custom_rec.attribute_value := fnd_message.get;
2143: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2144: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2145: x_custom_output.EXTEND;
2146: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2147: -- Direct Report bind variable

Line 2144: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2140: , NAME => 'EDW_UNASSIGNED');
2141: l_custom_rec.attribute_name := '&UNASSIGNED';
2142: l_custom_rec.attribute_value := fnd_message.get;
2143: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2144: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2145: x_custom_output.EXTEND;
2146: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2147: -- Direct Report bind variable
2148: fnd_message.set_name (application => 'BIS'

Line 2152: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2148: fnd_message.set_name (application => 'BIS'
2149: , NAME => 'BIS_PMF_DIRECT_REP');
2150: l_custom_rec.attribute_name := '&DIRECT_REPORT';
2151: l_custom_rec.attribute_value := fnd_message.get;
2152: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2153: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2154: x_custom_output.EXTEND;
2155: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2156:

Line 2153: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2149: , NAME => 'BIS_PMF_DIRECT_REP');
2150: l_custom_rec.attribute_name := '&DIRECT_REPORT';
2151: l_custom_rec.attribute_value := fnd_message.get;
2152: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2153: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2154: x_custom_output.EXTEND;
2155: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2156:
2157: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';

Line 2159: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2155: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2156:
2157: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';
2158: l_custom_rec.attribute_value := 119;
2159: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2160: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2161: x_custom_output.EXTEND;
2162: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2163:

Line 2160: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

2156:
2157: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';
2158: l_custom_rec.attribute_value := 119;
2159: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2160: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2161: x_custom_output.EXTEND;
2162: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2163:
2164: l_custom_rec.attribute_name := '&OKI_RG';

Line 2166: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2162: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2163:
2164: l_custom_rec.attribute_name := '&OKI_RG';
2165: l_custom_rec.attribute_value := g_rs_group_id;
2166: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2167: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2168: x_custom_output.EXTEND;
2169: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2170: l_custom_rec.attribute_name := '&OKI_RS';

Line 2167: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

2163:
2164: l_custom_rec.attribute_name := '&OKI_RG';
2165: l_custom_rec.attribute_value := g_rs_group_id;
2166: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2167: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2168: x_custom_output.EXTEND;
2169: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2170: l_custom_rec.attribute_name := '&OKI_RS';
2171: l_custom_rec.attribute_value := g_resource_id;

Line 2172: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2168: x_custom_output.EXTEND;
2169: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2170: l_custom_rec.attribute_name := '&OKI_RS';
2171: l_custom_rec.attribute_value := g_resource_id;
2172: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2173: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2174: x_custom_output.EXTEND;
2175: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2176:

Line 2173: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

2169: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2170: l_custom_rec.attribute_name := '&OKI_RS';
2171: l_custom_rec.attribute_value := g_resource_id;
2172: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2173: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2174: x_custom_output.EXTEND;
2175: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2176:
2177: l_custom_rec.attribute_name := '&SITEM_ID';

Line 2179: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2175: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2176:
2177: l_custom_rec.attribute_name := '&SITEM_ID';
2178: l_custom_rec.attribute_value := g_itemid;
2179: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2180: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2181: x_custom_output.EXTEND;
2182: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2183: l_custom_rec.attribute_name := '&INV_ORGID';

Line 2180: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

2176:
2177: l_custom_rec.attribute_name := '&SITEM_ID';
2178: l_custom_rec.attribute_value := g_itemid;
2179: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2180: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2181: x_custom_output.EXTEND;
2182: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2183: l_custom_rec.attribute_name := '&INV_ORGID';
2184: l_custom_rec.attribute_value := g_invorgid ;

Line 2185: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2181: x_custom_output.EXTEND;
2182: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2183: l_custom_rec.attribute_name := '&INV_ORGID';
2184: l_custom_rec.attribute_value := g_invorgid ;
2185: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2186: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2187: x_custom_output.EXTEND;
2188: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2189:

Line 2186: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

2182: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2183: l_custom_rec.attribute_name := '&INV_ORGID';
2184: l_custom_rec.attribute_value := g_invorgid ;
2185: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2186: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
2187: x_custom_output.EXTEND;
2188: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2189:
2190: END get_bind_vars;

Line 2225: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

2221: x_bis_bucket IN bis_bucket_pub.BIS_BUCKET_REC_TYPE)
2222: IS
2223: l_custom_rec bis_query_attributes;
2224: BEGIN
2225: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
2226:
2227: l_custom_rec.attribute_name := '&RANGE1_NAME';
2228: l_custom_rec.attribute_value := x_bis_bucket.range1_name;
2229: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

Line 2229: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2225: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
2226:
2227: l_custom_rec.attribute_name := '&RANGE1_NAME';
2228: l_custom_rec.attribute_value := x_bis_bucket.range1_name;
2229: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2230: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2231: x_custom_output.EXTEND;
2232: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2233:

Line 2230: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2226:
2227: l_custom_rec.attribute_name := '&RANGE1_NAME';
2228: l_custom_rec.attribute_value := x_bis_bucket.range1_name;
2229: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2230: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2231: x_custom_output.EXTEND;
2232: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2233:
2234: l_custom_rec.attribute_name := '&RANGE2_NAME';

Line 2236: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2232: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2233:
2234: l_custom_rec.attribute_name := '&RANGE2_NAME';
2235: l_custom_rec.attribute_value := x_bis_bucket.range2_name;
2236: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2237: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2238: x_custom_output.EXTEND;
2239: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2240:

Line 2237: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2233:
2234: l_custom_rec.attribute_name := '&RANGE2_NAME';
2235: l_custom_rec.attribute_value := x_bis_bucket.range2_name;
2236: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2237: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2238: x_custom_output.EXTEND;
2239: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2240:
2241: l_custom_rec.attribute_name := '&RANGE3_NAME';

Line 2243: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2239: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2240:
2241: l_custom_rec.attribute_name := '&RANGE3_NAME';
2242: l_custom_rec.attribute_value := x_bis_bucket.range3_name;
2243: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2244: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2245: x_custom_output.EXTEND;
2246: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2247:

Line 2244: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2240:
2241: l_custom_rec.attribute_name := '&RANGE3_NAME';
2242: l_custom_rec.attribute_value := x_bis_bucket.range3_name;
2243: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2244: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2245: x_custom_output.EXTEND;
2246: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2247:
2248: l_custom_rec.attribute_name := '&RANGE4_NAME';

Line 2250: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2246: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2247:
2248: l_custom_rec.attribute_name := '&RANGE4_NAME';
2249: l_custom_rec.attribute_value := x_bis_bucket.range4_name;
2250: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2251: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2252: x_custom_output.EXTEND;
2253: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2254:

Line 2251: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2247:
2248: l_custom_rec.attribute_name := '&RANGE4_NAME';
2249: l_custom_rec.attribute_value := x_bis_bucket.range4_name;
2250: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2251: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2252: x_custom_output.EXTEND;
2253: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2254:
2255: l_custom_rec.attribute_name := '&RANGE5_NAME';

Line 2257: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2253: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2254:
2255: l_custom_rec.attribute_name := '&RANGE5_NAME';
2256: l_custom_rec.attribute_value := x_bis_bucket.range5_name;
2257: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2258: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2259: x_custom_output.EXTEND;
2260: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2261:

Line 2258: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2254:
2255: l_custom_rec.attribute_name := '&RANGE5_NAME';
2256: l_custom_rec.attribute_value := x_bis_bucket.range5_name;
2257: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2258: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2259: x_custom_output.EXTEND;
2260: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2261:
2262: l_custom_rec.attribute_name := '&RANGE6_NAME';

Line 2264: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2260: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2261:
2262: l_custom_rec.attribute_name := '&RANGE6_NAME';
2263: l_custom_rec.attribute_value := x_bis_bucket.range6_name;
2264: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2265: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2266: x_custom_output.EXTEND;
2267: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2268:

Line 2265: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2261:
2262: l_custom_rec.attribute_name := '&RANGE6_NAME';
2263: l_custom_rec.attribute_value := x_bis_bucket.range6_name;
2264: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2265: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2266: x_custom_output.EXTEND;
2267: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2268:
2269: l_custom_rec.attribute_name := '&RANGE7_NAME';

Line 2271: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2267: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2268:
2269: l_custom_rec.attribute_name := '&RANGE7_NAME';
2270: l_custom_rec.attribute_value := x_bis_bucket.range7_name;
2271: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2273: x_custom_output.EXTEND;
2274: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2275:

Line 2272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2268:
2269: l_custom_rec.attribute_name := '&RANGE7_NAME';
2270: l_custom_rec.attribute_value := x_bis_bucket.range7_name;
2271: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2272: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2273: x_custom_output.EXTEND;
2274: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2275:
2276: l_custom_rec.attribute_name := '&RANGE8_NAME';

Line 2278: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2274: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2275:
2276: l_custom_rec.attribute_name := '&RANGE8_NAME';
2277: l_custom_rec.attribute_value := x_bis_bucket.range8_name;
2278: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2279: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2280: x_custom_output.EXTEND;
2281: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2282:

Line 2279: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2275:
2276: l_custom_rec.attribute_name := '&RANGE8_NAME';
2277: l_custom_rec.attribute_value := x_bis_bucket.range8_name;
2278: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2279: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2280: x_custom_output.EXTEND;
2281: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2282:
2283: l_custom_rec.attribute_name := '&RANGE9_NAME';

Line 2285: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2281: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2282:
2283: l_custom_rec.attribute_name := '&RANGE9_NAME';
2284: l_custom_rec.attribute_value := x_bis_bucket.range9_name;
2285: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2287: x_custom_output.EXTEND;
2288: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2289:

Line 2286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2282:
2283: l_custom_rec.attribute_name := '&RANGE9_NAME';
2284: l_custom_rec.attribute_value := x_bis_bucket.range9_name;
2285: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2286: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2287: x_custom_output.EXTEND;
2288: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2289:
2290: l_custom_rec.attribute_name := '&RANGE10_NAME';

Line 2292: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

2288: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2289:
2290: l_custom_rec.attribute_name := '&RANGE10_NAME';
2291: l_custom_rec.attribute_value := x_bis_bucket.range10_name;
2292: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2294: x_custom_output.EXTEND;
2295: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2296:

Line 2293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

2289:
2290: l_custom_rec.attribute_name := '&RANGE10_NAME';
2291: l_custom_rec.attribute_value := x_bis_bucket.range10_name;
2292: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2293: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2294: x_custom_output.EXTEND;
2295: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2296:
2297: END get_bis_bucket_binds;