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

Line 3876: l_query_attributes_tbl BIS_QUERY_ATTRIBUTES_TBL := BIS_QUERY_ATTRIBUTES_TBL();

3872: l_paramlvlparam_Tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type;
3873: l_page_parameter_rec BIS_PMV_PAGE_PARAMETER_REC :=
3874: BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null); --msaran:4600562 - added null for operator
3875: l_page_parameter_tbl BIS_PMV_PAGE_PARAMETER_TBL := BIS_PMV_PAGE_PARAMETER_TBL();
3876: l_query_attributes_tbl BIS_QUERY_ATTRIBUTES_TBL := BIS_QUERY_ATTRIBUTES_TBL();
3877: l_time_comp_value VARCHAR2(2000);
3878: l_index INTEGER;
3879: l_period_type VARCHAR2(2000);
3880: l_order_by VARCHAR2(2000);

Line 4645: p_custom_output IN BIS_QUERY_ATTRIBUTES_TBL,

4641:
4642: procedure replace_product_binds
4643: (pUSerSession IN BIS_PMV_SESSION_PVT.SESSION_REC_TYPE,
4644: p_original_sql IN VARCHAR2,
4645: p_custom_output IN BIS_QUERY_ATTRIBUTES_TBL,
4646: x_custom_sql IN OUT NOCOPY VARCHAR2,
4647: x_bind_variables IN OUT NOCOPY VARCHAR2,
4648: x_plsql_bind_variables IN OUT NOCOPY VARCHAR2,
4649: x_bind_indexes IN OUT NOCOPY VARCHAR2,

Line 4656: l_bis_query_attributes BIS_QUERY_ATTRIBUTES;

4652: x_view_by_value OUT NOCOPY VARCHAR2
4653: )
4654: IS
4655: l_index number;
4656: l_bis_query_attributes BIS_QUERY_ATTRIBUTES;
4657: BEGIN
4658: if (p_custom_output is not null and p_custom_output.COUNT > 0 )
4659: then
4660:

Line 4662: l_bis_Query_attributes := p_custom_output(i);

4658: if (p_custom_output is not null and p_custom_output.COUNT > 0 )
4659: then
4660:
4661: for i in p_custom_output.FIRST..p_custom_output.LAST loop
4662: l_bis_Query_attributes := p_custom_output(i);
4663: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE)
4664: then
4665: if (l_bis_query_attributes.attribute_value is not null and
4666: length(l_bis_query_attributes.attribute_value) > 0) then

Line 4663: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE)

4659: then
4660:
4661: for i in p_custom_output.FIRST..p_custom_output.LAST loop
4662: l_bis_Query_attributes := p_custom_output(i);
4663: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE)
4664: then
4665: if (l_bis_query_attributes.attribute_value is not null and
4666: length(l_bis_query_attributes.attribute_value) > 0) then
4667: process_custom_view_by(pusersession, l_bis_query_attributes.attribute_value);

Line 4665: if (l_bis_query_attributes.attribute_value is not null and

4661: for i in p_custom_output.FIRST..p_custom_output.LAST loop
4662: l_bis_Query_attributes := p_custom_output(i);
4663: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE)
4664: then
4665: if (l_bis_query_attributes.attribute_value is not null and
4666: length(l_bis_query_attributes.attribute_value) > 0) then
4667: process_custom_view_by(pusersession, l_bis_query_attributes.attribute_value);
4668: x_view_by_value := l_bis_query_attributes.attribute_value;
4669: l_index := instrb(p_original_Sql,'&BIS_VIEW_BY');

Line 4666: length(l_bis_query_attributes.attribute_value) > 0) then

4662: l_bis_Query_attributes := p_custom_output(i);
4663: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE)
4664: then
4665: if (l_bis_query_attributes.attribute_value is not null and
4666: length(l_bis_query_attributes.attribute_value) > 0) then
4667: process_custom_view_by(pusersession, l_bis_query_attributes.attribute_value);
4668: x_view_by_value := l_bis_query_attributes.attribute_value;
4669: l_index := instrb(p_original_Sql,'&BIS_VIEW_BY');
4670: if (l_index > 0) then

Line 4667: process_custom_view_by(pusersession, l_bis_query_attributes.attribute_value);

4663: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE)
4664: then
4665: if (l_bis_query_attributes.attribute_value is not null and
4666: length(l_bis_query_attributes.attribute_value) > 0) then
4667: process_custom_view_by(pusersession, l_bis_query_attributes.attribute_value);
4668: x_view_by_value := l_bis_query_attributes.attribute_value;
4669: l_index := instrb(p_original_Sql,'&BIS_VIEW_BY');
4670: if (l_index > 0) then
4671: replaceNameWithValue(

Line 4668: x_view_by_value := l_bis_query_attributes.attribute_value;

4664: then
4665: if (l_bis_query_attributes.attribute_value is not null and
4666: length(l_bis_query_attributes.attribute_value) > 0) then
4667: process_custom_view_by(pusersession, l_bis_query_attributes.attribute_value);
4668: x_view_by_value := l_bis_query_attributes.attribute_value;
4669: l_index := instrb(p_original_Sql,'&BIS_VIEW_BY');
4670: if (l_index > 0) then
4671: replaceNameWithValue(
4672: pParamName => '&BIS_VIEW_BY',

Line 4673: pParamValue => l_bis_query_attributes.attribute_value,

4669: l_index := instrb(p_original_Sql,'&BIS_VIEW_BY');
4670: if (l_index > 0) then
4671: replaceNameWithValue(
4672: pParamName => '&BIS_VIEW_BY',
4673: pParamValue => l_bis_query_attributes.attribute_value,
4674: pUseBindVariable => true ,
4675: p_initial_index => l_index,
4676: p_original_sql => p_original_sql,
4677: xClause => x_custom_sql,

Line 4687: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.BIND_TYPE) THEN

4683: );
4684: end if;
4685: end if;
4686: end if;
4687: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.BIND_TYPE) THEN
4688: l_index := instrb(p_original_sql, l_bis_query_attributes.attribute_name);
4689: if (l_index > 0) then
4690: replace_with_bind_variables
4691: (p_search_string => l_bis_query_attributes.attribute_name,

Line 4688: l_index := instrb(p_original_sql, l_bis_query_attributes.attribute_name);

4684: end if;
4685: end if;
4686: end if;
4687: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.BIND_TYPE) THEN
4688: l_index := instrb(p_original_sql, l_bis_query_attributes.attribute_name);
4689: if (l_index > 0) then
4690: replace_with_bind_variables
4691: (p_search_string => l_bis_query_attributes.attribute_name,
4692: p_bind_value => l_bis_Query_attributes.attribute_value,

Line 4691: (p_search_string => l_bis_query_attributes.attribute_name,

4687: if (l_bis_query_attributes.attribute_type = BIS_PMV_PARAMETERS_PUB.BIND_TYPE) THEN
4688: l_index := instrb(p_original_sql, l_bis_query_attributes.attribute_name);
4689: if (l_index > 0) then
4690: replace_with_bind_variables
4691: (p_search_string => l_bis_query_attributes.attribute_name,
4692: p_bind_value => l_bis_Query_attributes.attribute_value,
4693: p_bind_datatype => l_bis_query_attributes.attribute_data_type,
4694: p_initial_index => l_index,
4695: p_original_sql => p_original_sql,

Line 4692: p_bind_value => l_bis_Query_attributes.attribute_value,

4688: l_index := instrb(p_original_sql, l_bis_query_attributes.attribute_name);
4689: if (l_index > 0) then
4690: replace_with_bind_variables
4691: (p_search_string => l_bis_query_attributes.attribute_name,
4692: p_bind_value => l_bis_Query_attributes.attribute_value,
4693: p_bind_datatype => l_bis_query_attributes.attribute_data_type,
4694: p_initial_index => l_index,
4695: p_original_sql => p_original_sql,
4696: x_custom_sql => x_custom_sql,

Line 4693: p_bind_datatype => l_bis_query_attributes.attribute_data_type,

4689: if (l_index > 0) then
4690: replace_with_bind_variables
4691: (p_search_string => l_bis_query_attributes.attribute_name,
4692: p_bind_value => l_bis_Query_attributes.attribute_value,
4693: p_bind_datatype => l_bis_query_attributes.attribute_data_type,
4694: p_initial_index => l_index,
4695: p_original_sql => p_original_sql,
4696: x_custom_sql => x_custom_sql,
4697: x_bind_variables => x_bind_variables,