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_SALES_MGMT_RPTS_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 30: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

26: * 26 Nov 2004 hrpandey Drill Down to Oppty Line Detail report
27: ******************************************************************************/
28: PROCEDURE BIL_BI_SALES_MGMT_SUMRY(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
29: ,x_custom_sql OUT NOCOPY VARCHAR2
30: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
31: AS
32:
33: l_page_period_type VARCHAR2(100);
34: l_period_type VARCHAR2(200);

Line 86: l_custom_rec BIS_QUERY_ATTRIBUTES;

82: l_bind_ctr NUMBER;
83: l_curr_as_of_date DATE;
84: l_prev_date DATE;
85: l_bis_sysdate DATE;
86: l_custom_rec BIS_QUERY_ATTRIBUTES;
87: l_userCurrency BOOLEAN;
88: l_proc VARCHAR2(100);
89: l_rpt_str VARCHAR2(80);
90: l_parameter_valid BOOLEAN;

Line 1115: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1111: END LOOP;
1112: END IF;
1113:
1114:
1115: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1116: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1117:
1118: l_bind_ctr := 1;
1119: l_custom_rec.attribute_name :=':l_sg_id_num';

Line 1190: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )

1186: * 26 Nov 2004 hrpandey Drill Down to Oppty Line Detail report
1187: ******************************************************************************/
1188: PROCEDURE BIL_BI_OPPTY_OVERVIEW( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1189: ,x_custom_sql OUT NOCOPY VARCHAR2
1190: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
1191: IS
1192:
1193: l_period_type VARCHAR2(50);
1194: l_sg_id VARCHAR2(50);

Line 1199: l_custom_rec BIS_QUERY_ATTRIBUTES;

1195: l_resource_id VARCHAR2(50);
1196: l_conv_rate_selected VARCHAR2(50);
1197: l_curr_page_time_id NUMBER;
1198: l_prev_page_time_id NUMBER;
1199: l_custom_rec BIS_QUERY_ATTRIBUTES;
1200: l_region_id VARCHAR2(50);
1201: l_comp_type VARCHAR2(50);
1202: l_parameter_valid BOOLEAN;
1203: l_bitand_id VARCHAR2(50);

Line 1303: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

1299:
1300: END IF;
1301:
1302:
1303: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1304: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1305: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
1306: ,p_region_id => l_region_id
1307: ,x_period_type => l_period_type

Line 2766: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

2762: END IF;
2763:
2764:
2765:
2766: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2767: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2768:
2769: l_bind_ctr := 1;
2770: l_custom_rec.attribute_name :=':l_yes';

Line 2852: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )

2848:
2849:
2850: PROCEDURE BIL_BI_OPPTY_WIN_LOSS_COUNTS( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
2851: ,x_custom_sql OUT NOCOPY VARCHAR2
2852: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
2853: IS
2854:
2855: l_period_type VARCHAR2(50);
2856: l_sg_id VARCHAR2(50);

Line 2861: l_custom_rec BIS_QUERY_ATTRIBUTES;

2857: l_resource_id VARCHAR2(50);
2858: l_conv_rate_selected VARCHAR2(50);
2859: l_curr_page_time_id NUMBER;
2860: l_prev_page_time_id NUMBER;
2861: l_custom_rec BIS_QUERY_ATTRIBUTES;
2862: l_region_id VARCHAR2(50);
2863: l_comp_type VARCHAR2(50);
2864: l_parameter_valid BOOLEAN;
2865: l_bitand_id VARCHAR2(50);

Line 2963: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

2959: MESSAGE => 'Start of Procedure '|| l_proc);
2960:
2961: END IF;
2962:
2963: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2964: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2965: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
2966: ,p_region_id => l_region_id
2967: ,x_period_type => l_period_type

Line 3923: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )

3919:
3920:
3921: PROCEDURE BIL_BI_GRP_FRCST ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
3922: ,x_custom_sql OUT NOCOPY VARCHAR2
3923: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
3924:
3925: IS
3926:
3927: l_period_type VARCHAR2(50);

Line 3932: l_custom_rec BIS_QUERY_ATTRIBUTES;

3928: l_sg_id VARCHAR2(50);
3929: l_conv_rate_selected VARCHAR2(50);
3930: l_curr_page_time_id NUMBER;
3931: l_prev_page_time_id NUMBER;
3932: l_custom_rec BIS_QUERY_ATTRIBUTES;
3933: l_region_id VARCHAR2(50);
3934: l_comp_type VARCHAR2(50);
3935: l_parameter_valid BOOLEAN;
3936: l_bitand_id VARCHAR2(50);

Line 3982: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

3978:
3979: END IF;
3980:
3981:
3982: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
3983: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3984:
3985: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS( p_page_parameter_tbl => p_page_parameter_tbl
3986: ,p_region_id => l_region_id

Line 4299: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

4295: * 26 Nov 2004 hrpandey Drill Down to Oppty Line Detail report
4296: *****************************************************************************/
4297: PROCEDURE BIL_BI_OPEN_LDOPBKLOG (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
4298: ,x_custom_sql OUT NOCOPY VARCHAR2
4299: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
4300: AS
4301:
4302: l_start_date DATE;
4303: l_period_type VARCHAR2(50);

Line 4308: l_custom_rec BIS_QUERY_ATTRIBUTES;

4304: l_sg_id VARCHAR2(50);
4305: l_conv_rate_selected VARCHAR2(50);
4306: l_curr_page_time_id NUMBER;
4307: l_prev_page_time_id NUMBER;
4308: l_custom_rec BIS_QUERY_ATTRIBUTES;
4309: l_region_id VARCHAR2(50);
4310: l_comp_type VARCHAR2(50);
4311: l_parameter_valid BOOLEAN;
4312: l_bitand_id VARCHAR2(50);

Line 4412: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

4408: MESSAGE => 'Start of Procedure '||l_proc);
4409:
4410: END IF;
4411:
4412: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
4413: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
4414:
4415: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
4416: ,p_region_id => l_region_id

Line 5916: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

5912: PROCEDURE BIL_LDOPP_CAMP
5913: (
5914: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
5915: ,x_custom_sql OUT NOCOPY VARCHAR2
5916: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
5917: )
5918: IS
5919:
5920: l_period_type VARCHAR2(50);

Line 5939: l_custom_rec BIS_QUERY_ATTRIBUTES;

5935:
5936: l_curr_page_time_id NUMBER;
5937: l_prev_page_time_id NUMBER;
5938:
5939: l_custom_rec BIS_QUERY_ATTRIBUTES;
5940: l_region_id VARCHAR2(50);
5941: l_comp_type VARCHAR2(50);
5942: l_parameter_valid BOOLEAN;
5943:

Line 6022: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

6018: MESSAGE => 'Start of Procedure '|| l_proc);
6019:
6020: END IF;
6021:
6022: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
6023: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
6024: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(
6025: p_page_parameter_tbl => p_page_parameter_tbl
6026: ,p_region_id => l_region_id

Line 6737: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

6733:
6734: PROCEDURE BIL_BI_SLS_PERF(
6735: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
6736: ,x_custom_sql OUT NOCOPY VARCHAR2
6737: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
6738: IS
6739: l_custom_rec BIS_QUERY_ATTRIBUTES;
6740: l_currency VARCHAR2(100);
6741: l_parameter_valid BOOLEAN;

Line 6739: l_custom_rec BIS_QUERY_ATTRIBUTES;

6735: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
6736: ,x_custom_sql OUT NOCOPY VARCHAR2
6737: ,x_custom_attr OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
6738: IS
6739: l_custom_rec BIS_QUERY_ATTRIBUTES;
6740: l_currency VARCHAR2(100);
6741: l_parameter_valid BOOLEAN;
6742: l_salesgroup_id VARCHAR2(50);
6743: l_resource_id VARCHAR2(50);

Line 6813: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();

6809: l_amt_where varchar2(4000);
6810:
6811: BEGIN
6812: /* Initializing variables*/
6813: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
6814: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
6815: l_bind_ctr := 1;
6816: l_parameter_valid := TRUE;
6817: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';