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.BIL_BI_OPPTY_MGMT_RPTS_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 32: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )

28: * 25 Mar 2004 krsundar Drill and pivot fix
29: ******************************************************************************/
30: PROCEDURE BIL_BI_WTD_PIPELINE(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
31: ,x_custom_sql OUT NOCOPY VARCHAR2
32: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
33: AS
34: l_curr_page_time_id NUMBER;
35: l_prev_page_time_id NUMBER;
36: l_bind_ctr NUMBER;

Line 43: l_custom_rec BIS_QUERY_ATTRIBUTES;

39: l_curr_as_of_date DATE;
40: l_snap_date DATE;
41: l_prev_date DATE;
42: l_bis_sysdate DATE;
43: l_custom_rec BIS_QUERY_ATTRIBUTES;
44: l_comp_type VARCHAR2(50);
45: l_bitand_id VARCHAR2(50);
46: l_calendar_id VARCHAR2(50);
47: l_period_type VARCHAR2(50);

Line 1100: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1096:
1097:
1098: /* Binds */
1099:
1100: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1101: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1102:
1103: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1104: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

Line 1367: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )

1363: ******************************************************************************/
1364:
1365: PROCEDURE BIL_BI_TOP_OPEN_OPP( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1366: ,x_custom_sql OUT NOCOPY VARCHAR2
1367: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
1368: IS
1369: BEGIN
1370: NULL;
1371: END BIL_BI_TOP_OPEN_OPP;

Line 1394: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )

1390: ******************************************************************************/
1391:
1392: PROCEDURE BIL_BI_TOP_OPEN_OPP_PORTLET( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1393: ,x_custom_sql OUT NOCOPY VARCHAR2
1394: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
1395: IS
1396: BEGIN
1397: NULL;
1398: END BIL_BI_TOP_OPEN_OPP_PORTLET;

Line 1428: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1424:
1425:
1426: PROCEDURE BIL_BI_OPPTY_ACTIVITY (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1427: ,x_custom_sql OUT NOCOPY VARCHAR2
1428: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1429: IS
1430: l_custom_rec BIS_QUERY_ATTRIBUTES;
1431: l_comp_type VARCHAR2(50);
1432: l_bitand_id VARCHAR2(50);

Line 1430: l_custom_rec BIS_QUERY_ATTRIBUTES;

1426: PROCEDURE BIL_BI_OPPTY_ACTIVITY (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1427: ,x_custom_sql OUT NOCOPY VARCHAR2
1428: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1429: IS
1430: l_custom_rec BIS_QUERY_ATTRIBUTES;
1431: l_comp_type VARCHAR2(50);
1432: l_bitand_id VARCHAR2(50);
1433: l_calendar_id VARCHAR2(50);
1434: l_period_type VARCHAR2(50);

Line 1526: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1522:
1523: END IF;
1524:
1525:
1526: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1527: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1528:
1529: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
1530: ,p_region_id => l_region_id

Line 2443: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

2439:
2440: PROCEDURE BIL_BI_TOP_OPP(
2441: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
2442: ,x_custom_sql OUT NOCOPY VARCHAR2
2443: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
2444: IS
2445:
2446: l_custom_rec BIS_QUERY_ATTRIBUTES;
2447: l_region_id VARCHAR2(50);

Line 2446: l_custom_rec BIS_QUERY_ATTRIBUTES;

2442: ,x_custom_sql OUT NOCOPY VARCHAR2
2443: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
2444: IS
2445:
2446: l_custom_rec BIS_QUERY_ATTRIBUTES;
2447: l_region_id VARCHAR2(50);
2448: l_parameter_valid BOOLEAN;
2449: l_err_msg VARCHAR2(320);
2450: l_err_desc VARCHAR2(4000);

Line 2500: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

2496:
2497: END IF;
2498:
2499:
2500: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2501: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2502:
2503: FOR i IN 1..p_page_parameter_tbl.count
2504: LOOP

Line 2842: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

2838:
2839: PROCEDURE BIL_BI_OPPTY_LINE_DETAIL(
2840: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
2841: ,x_custom_sql OUT NOCOPY VARCHAR2
2842: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
2843: IS
2844:
2845:
2846: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 2846: l_custom_rec BIS_QUERY_ATTRIBUTES;

2842: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
2843: IS
2844:
2845:
2846: l_custom_rec BIS_QUERY_ATTRIBUTES;
2847: l_currency VARCHAR2(100);
2848: l_parameter_valid BOOLEAN;
2849: l_err_msg VARCHAR2(100);
2850: l_err VARCHAR2(500);

Line 2884: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

2880: BEGIN
2881:
2882: /* Initializing variables*/
2883:
2884: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2885: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2886: l_bind_ctr := 1;
2887: l_parameter_valid := TRUE;
2888: