DBA Data[Home] [Help]

APPS.FII_AR_UTIL dependencies on BIS_PMV_PARAMETERS_PUB

Line 160: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

156: l_bind_rec BIS_QUERY_ATTRIBUTES;
157:
158: BEGIN
159: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
160: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
161: p_sql_output := p_sqlstmt;
162:
163: p_bind_output_table.EXTEND;
164: l_bind_rec.attribute_name := ':FIIBIND1';

Line 166: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

162:
163: p_bind_output_table.EXTEND;
164: l_bind_rec.attribute_name := ':FIIBIND1';
165: l_bind_rec.attribute_value := to_char(p_fiibind1);
166: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
167: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
168: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
169: p_bind_output_table.EXTEND;
170: l_bind_rec.attribute_name := ':FIIBIND2';

Line 167: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

163: p_bind_output_table.EXTEND;
164: l_bind_rec.attribute_name := ':FIIBIND1';
165: l_bind_rec.attribute_value := to_char(p_fiibind1);
166: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
167: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
168: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
169: p_bind_output_table.EXTEND;
170: l_bind_rec.attribute_name := ':FIIBIND2';
171: l_bind_rec.attribute_value := to_char(p_fiibind2);

Line 172: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

168: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
169: p_bind_output_table.EXTEND;
170: l_bind_rec.attribute_name := ':FIIBIND2';
171: l_bind_rec.attribute_value := to_char(p_fiibind2);
172: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
173: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
174: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
175: p_bind_output_table.EXTEND;
176: l_bind_rec.attribute_name := ':VIEW_BY';

Line 173: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

169: p_bind_output_table.EXTEND;
170: l_bind_rec.attribute_name := ':FIIBIND2';
171: l_bind_rec.attribute_value := to_char(p_fiibind2);
172: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
173: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
174: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
175: p_bind_output_table.EXTEND;
176: l_bind_rec.attribute_name := ':VIEW_BY';
177: l_bind_rec.attribute_value := to_char(p_view_by);

Line 178: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

174: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
175: p_bind_output_table.EXTEND;
176: l_bind_rec.attribute_name := ':VIEW_BY';
177: l_bind_rec.attribute_value := to_char(p_view_by);
178: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
179: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
180: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
181: p_bind_output_table.EXTEND;
182: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';

Line 179: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

175: p_bind_output_table.EXTEND;
176: l_bind_rec.attribute_name := ':VIEW_BY';
177: l_bind_rec.attribute_value := to_char(p_view_by);
178: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
179: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
180: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
181: p_bind_output_table.EXTEND;
182: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
183: l_bind_rec.attribute_value := to_char(p_record_type_id);

Line 184: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

180: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
181: p_bind_output_table.EXTEND;
182: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
183: l_bind_rec.attribute_value := to_char(p_record_type_id);
184: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
185: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
186: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
187: p_bind_output_table.EXTEND;
188:

Line 185: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

181: p_bind_output_table.EXTEND;
182: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
183: l_bind_rec.attribute_value := to_char(p_record_type_id);
184: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
185: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
186: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
187: p_bind_output_table.EXTEND;
188:
189: