DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_VBAG_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 20: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

16: l_period_from DATE;
17: l_period_to DATE;
18: l_where_clause varchar2(32000);
19: l_other_account VARCHAR2(1000);
20: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
21: l_classification VARCHAR2(32000);
22: l_view_by varchar2(1000);
23: l_row_type varchar2(10) := 'AC';
24:

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

88: p_custom_sql := l_sqltext;
89:
90: l_custom_rec.attribute_name := ':l_other_account' ;
91: l_custom_rec.attribute_value:= l_other_account;
92: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
93: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
94:
95: p_custom_output.Extend();
96: p_custom_output(p_custom_output.count) := l_custom_rec;

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

89:
90: l_custom_rec.attribute_name := ':l_other_account' ;
91: l_custom_rec.attribute_value:= l_other_account;
92: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
93: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
94:
95: p_custom_output.Extend();
96: p_custom_output(p_custom_output.count) := l_custom_rec;
97:

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

97:
98: IF ( l_account IS NOT NULL) THEN
99: l_custom_rec.attribute_name := ':l_account' ;
100: l_custom_rec.attribute_value:= l_account;
101: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
102: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
103:
104: p_custom_output.Extend();
105: p_custom_output(p_custom_output.count) := l_custom_rec;

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

98: IF ( l_account IS NOT NULL) THEN
99: l_custom_rec.attribute_name := ':l_account' ;
100: l_custom_rec.attribute_value:= l_account;
101: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
102: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
103:
104: p_custom_output.Extend();
105: p_custom_output(p_custom_output.count) := l_custom_rec;
106: END IF;

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

107:
108: IF ( l_classification IS NOT NULL) THEN
109: l_custom_rec.attribute_name := ':l_classification' ;
110: l_custom_rec.attribute_value:= l_classification;
111: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
112: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
113:
114: p_custom_output.Extend();
115: p_custom_output(p_custom_output.count) := l_custom_rec;

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

108: IF ( l_classification IS NOT NULL) THEN
109: l_custom_rec.attribute_name := ':l_classification' ;
110: l_custom_rec.attribute_value:= l_classification;
111: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
112: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
113:
114: p_custom_output.Extend();
115: p_custom_output(p_custom_output.count) := l_custom_rec;
116: END IF;

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

116: END IF;
117:
118: l_custom_rec.attribute_name := ':l_row_type' ;
119: l_custom_rec.attribute_value:= l_row_type;
120: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
121: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
122:
123: p_custom_output.Extend();
124: p_custom_output(p_custom_output.count) := l_custom_rec;

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

117:
118: l_custom_rec.attribute_name := ':l_row_type' ;
119: l_custom_rec.attribute_value:= l_row_type;
120: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
121: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
122:
123: p_custom_output.Extend();
124: p_custom_output(p_custom_output.count) := l_custom_rec;
125: