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

Line 46: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

42:
43: BEGIN
44:
45: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
46: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
47: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_APPR_RULES';
48:
49: -- Set up the parameters
50: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,

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

321: END IF;
322:
323: l_custom_rec.attribute_name := ':l_curr_value';
324: l_custom_rec.attribute_value := l_curr_value;
325: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
326: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
327: rec_index := rec_index + 1;
328: x_custom_output.EXTEND;
329: x_custom_output(rec_index) := l_custom_rec;

Line 326: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

322:
323: l_custom_rec.attribute_name := ':l_curr_value';
324: l_custom_rec.attribute_value := l_curr_value;
325: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
326: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
327: rec_index := rec_index + 1;
328: x_custom_output.EXTEND;
329: x_custom_output(rec_index) := l_custom_rec;
330:

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

329: x_custom_output(rec_index) := l_custom_rec;
330:
331: l_custom_rec.attribute_name := ':l_prev_value';
332: l_custom_rec.attribute_value := l_prev_value;
333: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
334: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
335: rec_index := rec_index + 1;
336: x_custom_output.EXTEND;
337: x_custom_output(rec_index) := l_custom_rec;

Line 334: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

330:
331: l_custom_rec.attribute_name := ':l_prev_value';
332: l_custom_rec.attribute_value := l_prev_value;
333: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
334: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
335: rec_index := rec_index + 1;
336: x_custom_output.EXTEND;
337: x_custom_output(rec_index) := l_custom_rec;
338:

Line 427: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

423:
424: --Initialise here to get around File.sql.35
425: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.APPR_BY_SALESGRP_SQL';
426: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
427: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
428:
429: -- Set up the parameters
430: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,
431: x_conv_rate => l_conv_rate,

Line 761: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

757: END IF;
758:
759: rec_index := 1;
760:
761: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
762: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
763: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
764: x_custom_output.Extend;
765: x_custom_output(rec_index):=l_custom_rec;

Line 762: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

758:
759: rec_index := 1;
760:
761: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
762: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
763: l_custom_rec.attribute_value := 'ORGANIZATION+JTF_ORG_SALES_GROUP';
764: x_custom_output.Extend;
765: x_custom_output(rec_index):=l_custom_rec;
766: EXCEPTION

Line 847: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

843:
844: BEGIN
845:
846: --Initialize
847: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
848: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_SALESGRP_SQL';
849:
850: -- Set up the parameters
851: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,

Line 1502: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

1498: x_custom_sql := l_SQLTEXT11;
1499:
1500: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1501:
1502: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1503: l_custom_rec.attribute_value:= 'ORGANIZATION+JTF_ORG_SALES_GROUP';
1504: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1505:
1506: x_custom_output.Extend();

Line 1504: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1500: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1501:
1502: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1503: l_custom_rec.attribute_value:= 'ORGANIZATION+JTF_ORG_SALES_GROUP';
1504: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1505:
1506: x_custom_output.Extend();
1507: x_custom_output(1) := l_custom_rec;
1508:

Line 1546: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1542: BEGIN
1543:
1544: --Initialize
1545: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_PRODUCTCAT_SQL';
1546: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1547:
1548: -- Set up the parameters
1549: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,
1550: x_conv_rate => l_conv_rate,

Line 1895: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1891:
1892: --Initialize
1893: l_status := ' ';
1894: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_DISCOUNT_SQL';
1895: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1896:
1897: -- Set up the parameters
1898: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,
1899: x_conv_rate => l_conv_rate,

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

2345:
2346: --20 binds for range low and range name
2347: l_custom_rec.attribute_name := ':range1_low';
2348: l_custom_rec.attribute_value := l_bucket_rec.range1_low;
2349: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2350: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2351: rec_index := rec_index + 1;
2352: x_custom_output.EXTEND;
2353: x_custom_output(rec_index) := l_custom_rec;

Line 2350: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2346: --20 binds for range low and range name
2347: l_custom_rec.attribute_name := ':range1_low';
2348: l_custom_rec.attribute_value := l_bucket_rec.range1_low;
2349: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2350: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2351: rec_index := rec_index + 1;
2352: x_custom_output.EXTEND;
2353: x_custom_output(rec_index) := l_custom_rec;
2354:

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

2353: x_custom_output(rec_index) := l_custom_rec;
2354:
2355: l_custom_rec.attribute_name := ':range1_name';
2356: l_custom_rec.attribute_value := l_bucket_rec.range1_name;
2357: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2358: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2359: rec_index := rec_index + 1;
2360: x_custom_output.EXTEND;
2361: x_custom_output(rec_index) := l_custom_rec;

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

2354:
2355: l_custom_rec.attribute_name := ':range1_name';
2356: l_custom_rec.attribute_value := l_bucket_rec.range1_name;
2357: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2358: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2359: rec_index := rec_index + 1;
2360: x_custom_output.EXTEND;
2361: x_custom_output(rec_index) := l_custom_rec;
2362:

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

2361: x_custom_output(rec_index) := l_custom_rec;
2362:
2363: l_custom_rec.attribute_name := ':range2_low';
2364: l_custom_rec.attribute_value := l_bucket_rec.range2_low;
2365: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2366: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2367: rec_index := rec_index + 1;
2368: x_custom_output.EXTEND;
2369: x_custom_output(rec_index) := l_custom_rec;

Line 2366: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2362:
2363: l_custom_rec.attribute_name := ':range2_low';
2364: l_custom_rec.attribute_value := l_bucket_rec.range2_low;
2365: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2366: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2367: rec_index := rec_index + 1;
2368: x_custom_output.EXTEND;
2369: x_custom_output(rec_index) := l_custom_rec;
2370:

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

2369: x_custom_output(rec_index) := l_custom_rec;
2370:
2371: l_custom_rec.attribute_name := ':range2_name';
2372: l_custom_rec.attribute_value := l_bucket_rec.range2_name;
2373: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2374: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2375: rec_index := rec_index + 1;
2376: x_custom_output.EXTEND;
2377: x_custom_output(rec_index) := l_custom_rec;

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

2370:
2371: l_custom_rec.attribute_name := ':range2_name';
2372: l_custom_rec.attribute_value := l_bucket_rec.range2_name;
2373: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2374: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2375: rec_index := rec_index + 1;
2376: x_custom_output.EXTEND;
2377: x_custom_output(rec_index) := l_custom_rec;
2378:

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

2377: x_custom_output(rec_index) := l_custom_rec;
2378:
2379: l_custom_rec.attribute_name := ':range3_low';
2380: l_custom_rec.attribute_value := l_bucket_rec.range3_low;
2381: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2382: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2383: rec_index := rec_index + 1;
2384: x_custom_output.EXTEND;
2385: x_custom_output(rec_index) := l_custom_rec;

Line 2382: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2378:
2379: l_custom_rec.attribute_name := ':range3_low';
2380: l_custom_rec.attribute_value := l_bucket_rec.range3_low;
2381: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2382: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2383: rec_index := rec_index + 1;
2384: x_custom_output.EXTEND;
2385: x_custom_output(rec_index) := l_custom_rec;
2386:

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

2385: x_custom_output(rec_index) := l_custom_rec;
2386:
2387: l_custom_rec.attribute_name := ':range3_name';
2388: l_custom_rec.attribute_value := l_bucket_rec.range3_name;
2389: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2390: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2391: rec_index := rec_index + 1;
2392: x_custom_output.EXTEND;
2393: x_custom_output(rec_index) := l_custom_rec;

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

2386:
2387: l_custom_rec.attribute_name := ':range3_name';
2388: l_custom_rec.attribute_value := l_bucket_rec.range3_name;
2389: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2390: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2391: rec_index := rec_index + 1;
2392: x_custom_output.EXTEND;
2393: x_custom_output(rec_index) := l_custom_rec;
2394:

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

2393: x_custom_output(rec_index) := l_custom_rec;
2394:
2395: l_custom_rec.attribute_name := ':range4_low';
2396: l_custom_rec.attribute_value := l_bucket_rec.range4_low;
2397: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2398: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2399: rec_index := rec_index + 1;
2400: x_custom_output.EXTEND;
2401: x_custom_output(rec_index) := l_custom_rec;

Line 2398: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2394:
2395: l_custom_rec.attribute_name := ':range4_low';
2396: l_custom_rec.attribute_value := l_bucket_rec.range4_low;
2397: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2398: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2399: rec_index := rec_index + 1;
2400: x_custom_output.EXTEND;
2401: x_custom_output(rec_index) := l_custom_rec;
2402:

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

2401: x_custom_output(rec_index) := l_custom_rec;
2402:
2403: l_custom_rec.attribute_name := ':range4_name';
2404: l_custom_rec.attribute_value := l_bucket_rec.range4_name;
2405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2407: rec_index := rec_index + 1;
2408: x_custom_output.EXTEND;
2409: x_custom_output(rec_index) := l_custom_rec;

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

2402:
2403: l_custom_rec.attribute_name := ':range4_name';
2404: l_custom_rec.attribute_value := l_bucket_rec.range4_name;
2405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2407: rec_index := rec_index + 1;
2408: x_custom_output.EXTEND;
2409: x_custom_output(rec_index) := l_custom_rec;
2410:

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

2409: x_custom_output(rec_index) := l_custom_rec;
2410:
2411: l_custom_rec.attribute_name := ':range5_low';
2412: l_custom_rec.attribute_value := l_bucket_rec.range5_low;
2413: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2414: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2415: rec_index := rec_index + 1;
2416: x_custom_output.EXTEND;
2417: x_custom_output(rec_index) := l_custom_rec;

Line 2414: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2410:
2411: l_custom_rec.attribute_name := ':range5_low';
2412: l_custom_rec.attribute_value := l_bucket_rec.range5_low;
2413: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2414: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2415: rec_index := rec_index + 1;
2416: x_custom_output.EXTEND;
2417: x_custom_output(rec_index) := l_custom_rec;
2418:

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

2417: x_custom_output(rec_index) := l_custom_rec;
2418:
2419: l_custom_rec.attribute_name := ':range5_name';
2420: l_custom_rec.attribute_value := l_bucket_rec.range5_name;
2421: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2422: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2423: rec_index := rec_index + 1;
2424: x_custom_output.EXTEND;
2425: x_custom_output(rec_index) := l_custom_rec;

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

2418:
2419: l_custom_rec.attribute_name := ':range5_name';
2420: l_custom_rec.attribute_value := l_bucket_rec.range5_name;
2421: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2422: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2423: rec_index := rec_index + 1;
2424: x_custom_output.EXTEND;
2425: x_custom_output(rec_index) := l_custom_rec;
2426:

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

2425: x_custom_output(rec_index) := l_custom_rec;
2426:
2427: l_custom_rec.attribute_name := ':range6_low';
2428: l_custom_rec.attribute_value := l_bucket_rec.range6_low;
2429: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2430: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2431: rec_index := rec_index + 1;
2432: x_custom_output.EXTEND;
2433: x_custom_output(rec_index) := l_custom_rec;

Line 2430: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2426:
2427: l_custom_rec.attribute_name := ':range6_low';
2428: l_custom_rec.attribute_value := l_bucket_rec.range6_low;
2429: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2430: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2431: rec_index := rec_index + 1;
2432: x_custom_output.EXTEND;
2433: x_custom_output(rec_index) := l_custom_rec;
2434:

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

2433: x_custom_output(rec_index) := l_custom_rec;
2434:
2435: l_custom_rec.attribute_name := ':range6_name';
2436: l_custom_rec.attribute_value := l_bucket_rec.range6_name;
2437: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2438: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2439: rec_index := rec_index + 1;
2440: x_custom_output.EXTEND;
2441: x_custom_output(rec_index) := l_custom_rec;

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

2434:
2435: l_custom_rec.attribute_name := ':range6_name';
2436: l_custom_rec.attribute_value := l_bucket_rec.range6_name;
2437: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2438: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2439: rec_index := rec_index + 1;
2440: x_custom_output.EXTEND;
2441: x_custom_output(rec_index) := l_custom_rec;
2442:

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

2441: x_custom_output(rec_index) := l_custom_rec;
2442:
2443: l_custom_rec.attribute_name := ':range7_low';
2444: l_custom_rec.attribute_value := l_bucket_rec.range7_low;
2445: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2446: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2447: rec_index := rec_index + 1;
2448: x_custom_output.EXTEND;
2449: x_custom_output(rec_index) := l_custom_rec;

Line 2446: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2442:
2443: l_custom_rec.attribute_name := ':range7_low';
2444: l_custom_rec.attribute_value := l_bucket_rec.range7_low;
2445: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2446: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2447: rec_index := rec_index + 1;
2448: x_custom_output.EXTEND;
2449: x_custom_output(rec_index) := l_custom_rec;
2450:

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

2449: x_custom_output(rec_index) := l_custom_rec;
2450:
2451: l_custom_rec.attribute_name := ':range7_name';
2452: l_custom_rec.attribute_value := l_bucket_rec.range7_name;
2453: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2454: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2455: rec_index := rec_index + 1;
2456: x_custom_output.EXTEND;
2457: x_custom_output(rec_index) := l_custom_rec;

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

2450:
2451: l_custom_rec.attribute_name := ':range7_name';
2452: l_custom_rec.attribute_value := l_bucket_rec.range7_name;
2453: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2454: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2455: rec_index := rec_index + 1;
2456: x_custom_output.EXTEND;
2457: x_custom_output(rec_index) := l_custom_rec;
2458:

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

2457: x_custom_output(rec_index) := l_custom_rec;
2458:
2459: l_custom_rec.attribute_name := ':range8_low';
2460: l_custom_rec.attribute_value := l_bucket_rec.range8_low;
2461: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2462: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2463: rec_index := rec_index + 1;
2464: x_custom_output.EXTEND;
2465: x_custom_output(rec_index) := l_custom_rec;

Line 2462: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2458:
2459: l_custom_rec.attribute_name := ':range8_low';
2460: l_custom_rec.attribute_value := l_bucket_rec.range8_low;
2461: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2462: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2463: rec_index := rec_index + 1;
2464: x_custom_output.EXTEND;
2465: x_custom_output(rec_index) := l_custom_rec;
2466:

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

2465: x_custom_output(rec_index) := l_custom_rec;
2466:
2467: l_custom_rec.attribute_name := ':range8_name';
2468: l_custom_rec.attribute_value := l_bucket_rec.range8_name;
2469: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2470: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2471: rec_index := rec_index + 1;
2472: x_custom_output.EXTEND;
2473: x_custom_output(rec_index) := l_custom_rec;

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

2466:
2467: l_custom_rec.attribute_name := ':range8_name';
2468: l_custom_rec.attribute_value := l_bucket_rec.range8_name;
2469: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2470: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2471: rec_index := rec_index + 1;
2472: x_custom_output.EXTEND;
2473: x_custom_output(rec_index) := l_custom_rec;
2474:

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

2473: x_custom_output(rec_index) := l_custom_rec;
2474:
2475: l_custom_rec.attribute_name := ':range9_low';
2476: l_custom_rec.attribute_value := l_bucket_rec.range9_low;
2477: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2478: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2479: rec_index := rec_index + 1;
2480: x_custom_output.EXTEND;
2481: x_custom_output(rec_index) := l_custom_rec;

Line 2478: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2474:
2475: l_custom_rec.attribute_name := ':range9_low';
2476: l_custom_rec.attribute_value := l_bucket_rec.range9_low;
2477: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2478: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2479: rec_index := rec_index + 1;
2480: x_custom_output.EXTEND;
2481: x_custom_output(rec_index) := l_custom_rec;
2482:

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

2481: x_custom_output(rec_index) := l_custom_rec;
2482:
2483: l_custom_rec.attribute_name := ':range9_name';
2484: l_custom_rec.attribute_value := l_bucket_rec.range9_name;
2485: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2486: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2487: rec_index := rec_index + 1;
2488: x_custom_output.EXTEND;
2489: x_custom_output(rec_index) := l_custom_rec;

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

2482:
2483: l_custom_rec.attribute_name := ':range9_name';
2484: l_custom_rec.attribute_value := l_bucket_rec.range9_name;
2485: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2486: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2487: rec_index := rec_index + 1;
2488: x_custom_output.EXTEND;
2489: x_custom_output(rec_index) := l_custom_rec;
2490:

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

2489: x_custom_output(rec_index) := l_custom_rec;
2490:
2491: l_custom_rec.attribute_name := ':range10_low';
2492: l_custom_rec.attribute_value := l_bucket_rec.range10_low;
2493: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2494: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2495: rec_index := rec_index + 1;
2496: x_custom_output.EXTEND;
2497: x_custom_output(rec_index) := l_custom_rec;

Line 2494: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2490:
2491: l_custom_rec.attribute_name := ':range10_low';
2492: l_custom_rec.attribute_value := l_bucket_rec.range10_low;
2493: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2494: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2495: rec_index := rec_index + 1;
2496: x_custom_output.EXTEND;
2497: x_custom_output(rec_index) := l_custom_rec;
2498:

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

2497: x_custom_output(rec_index) := l_custom_rec;
2498:
2499: l_custom_rec.attribute_name := ':range10_name';
2500: l_custom_rec.attribute_value := l_bucket_rec.range10_name;
2501: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2502: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2503: rec_index := rec_index + 1;
2504: x_custom_output.EXTEND;
2505: x_custom_output(rec_index) := l_custom_rec;

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

2498:
2499: l_custom_rec.attribute_name := ':range10_name';
2500: l_custom_rec.attribute_value := l_bucket_rec.range10_name;
2501: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2502: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2503: rec_index := rec_index + 1;
2504: x_custom_output.EXTEND;
2505: x_custom_output(rec_index) := l_custom_rec;
2506:

Line 2573: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

2569:
2570: BEGIN
2571:
2572: --Initialize
2573: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
2574: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_TOPQUOT_SQL';
2575:
2576: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

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

2724: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
2725:
2726: l_custom_rec.attribute_name := ':l_sg_id_num';
2727: l_custom_rec.attribute_value := l_sg_id_num;
2728: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2729: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2730: rec_index := rec_index + 1;
2731: x_custom_output.EXTEND;
2732: x_custom_output(rec_index) := l_custom_rec;

Line 2729: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2725:
2726: l_custom_rec.attribute_name := ':l_sg_id_num';
2727: l_custom_rec.attribute_value := l_sg_id_num;
2728: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2729: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2730: rec_index := rec_index + 1;
2731: x_custom_output.EXTEND;
2732: x_custom_output(rec_index) := l_custom_rec;
2733:

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

2732: x_custom_output(rec_index) := l_custom_rec;
2733:
2734: l_custom_rec.attribute_name := ':l_sr_id_num';
2735: l_custom_rec.attribute_value := l_sr_id_num;
2736: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2737: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2738: rec_index := rec_index + 1;
2739: x_custom_output.EXTEND;
2740: x_custom_output(rec_index) := l_custom_rec;

Line 2737: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2733:
2734: l_custom_rec.attribute_name := ':l_sr_id_num';
2735: l_custom_rec.attribute_value := l_sr_id_num;
2736: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2737: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2738: rec_index := rec_index + 1;
2739: x_custom_output.EXTEND;
2740: x_custom_output(rec_index) := l_custom_rec;
2741:

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

2740: x_custom_output(rec_index) := l_custom_rec;
2741:
2742: l_custom_rec.attribute_name := ':l_rep_r_grp';
2743: l_custom_rec.attribute_value := l_rep_r_grp;
2744: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2745: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2746: rec_index := rec_index + 1;
2747: x_custom_output.EXTEND;
2748: x_custom_output(rec_index) := l_custom_rec;

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

2741:
2742: l_custom_rec.attribute_name := ':l_rep_r_grp';
2743: l_custom_rec.attribute_value := l_rep_r_grp;
2744: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2745: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2746: rec_index := rec_index + 1;
2747: x_custom_output.EXTEND;
2748: x_custom_output(rec_index) := l_custom_rec;
2749:

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

2748: x_custom_output(rec_index) := l_custom_rec;
2749:
2750: l_custom_rec.attribute_name := ':l_report_by';
2751: l_custom_rec.attribute_value := l_report_by;
2752: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2753: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2754: rec_index := rec_index + 1;
2755: x_custom_output.EXTEND;
2756: x_custom_output(rec_index) := l_custom_rec;

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

2749:
2750: l_custom_rec.attribute_name := ':l_report_by';
2751: l_custom_rec.attribute_value := l_report_by;
2752: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2753: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2754: rec_index := rec_index + 1;
2755: x_custom_output.EXTEND;
2756: x_custom_output(rec_index) := l_custom_rec;
2757: