APPS.BIS_PMV_QUERY_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 3671: p_bind_Datatype => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND,

3667:
3668: replace_with_bind_variables
3669: (p_search_string => START_INDEX_SUBST_VAR,
3670: p_bind_value => p_lower_bound,
3671: p_bind_Datatype => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND,
3672: p_initial_index => l_index,
3673: p_bind_function => NULL,
3674: p_bind_to_date => 'N',
3675: p_original_sql => p_original_sql,

Line 3691: p_bind_Datatype => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND,

3687:
3688: replace_with_bind_variables
3689: (p_search_string => END_INDEX_SUBST_VAR,
3690: p_bind_value => p_upper_bound,
3691: p_bind_Datatype => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND,
3692: p_initial_index => l_index,
3693: p_bind_function => NULL,
3694: p_bind_to_date => 'N',
3695: p_original_sql => p_original_sql,

Line 4247: p_bind_Datatype => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND,

4243: );
4244: replace_with_bind_variables
4245: (p_search_string => '&BIS_NESTED_PATTERN',
4246: p_bind_value => l_nested_pattern,
4247: p_bind_Datatype => BIS_PMV_PARAMETERS_PUB.INTEGER_BIND,
4248: p_initial_index => l_index,
4249: p_original_sql => l_original_sql,
4250: x_custom_sql => l_custom_sql,
4251: x_bind_variables => x_bind_variables,

Line 4612: if (p_bind_datatype = BIS_PMV_PARAMETERS_PUB.DATE_BIND) THEN

4608: x_bind_variables := x_bind_variables || l_split_bind_values;
4609: l_bind_string := l_split_bind_vars;
4610: else
4611: x_bind_indexes := x_bind_indexes || SEPERATOR || l_bind_index;
4612: if (p_bind_datatype = BIS_PMV_PARAMETERS_PUB.DATE_BIND) THEN
4613: x_bind_datatypes := x_bind_datatypes || SEPERATOR|| BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4614: else
4615: x_bind_datatypes := x_bind_datatypes || SEPERATOR || p_bind_datatype;
4616: end if;

Line 4613: x_bind_datatypes := x_bind_datatypes || SEPERATOR|| BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

4609: l_bind_string := l_split_bind_vars;
4610: else
4611: x_bind_indexes := x_bind_indexes || SEPERATOR || l_bind_index;
4612: if (p_bind_datatype = BIS_PMV_PARAMETERS_PUB.DATE_BIND) THEN
4613: x_bind_datatypes := x_bind_datatypes || SEPERATOR|| BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4614: else
4615: x_bind_datatypes := x_bind_datatypes || SEPERATOR || p_bind_datatype;
4616: end if;
4617: x_bind_variables := x_bind_variables || SEPERATOR || p_bind_value;

Line 4621: elsif (p_bind_datatype = BIS_PMV_PARAMETERS_PUB.DATE_BIND) THEN

4617: x_bind_variables := x_bind_variables || SEPERATOR || p_bind_value;
4618:
4619: if p_bind_to_date = 'Y' then
4620: l_bind_string := 'TO_DATE(:' || x_bind_count || ',''DD-MON-YYYY'')';
4621: elsif (p_bind_datatype = BIS_PMV_PARAMETERS_PUB.DATE_BIND) THEN
4622: l_bind_string := 'TO_DATE(:' || x_bind_count ||',''DD/MM/YYYY'')';
4623: else
4624: l_bind_string := ':' || x_bind_count;
4625: end if;

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 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,