APPS.FII_AP_INV_ACTIVITY dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 12: inv_act_anal_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

8:
9: PROCEDURE get_inv_activity (
10: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
11: inv_act_anal_sql OUT NOCOPY VARCHAR2,
12: inv_act_anal_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
13: IS
14: sqlstmt varchar2(14000);
15: l_viewby_dim VARCHAR2(240); -- what is the viewby
16: l_as_of_date DATE;

Line 296: inv_type_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

292:
293: PROCEDURE get_inv_type (
294: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
295: inv_type_sql OUT NOCOPY VARCHAR2,
296: inv_type_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
297: IS
298: sqlstmt varchar2(14000);
299: l_num NUMBER;
300: l_viewby_dim VARCHAR2(240); -- what is the viewby

Line 534: elec_inv_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

530:
531: PROCEDURE get_electronic_inv (
532: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
533: elec_inv_sql OUT NOCOPY VARCHAR2,
534: elec_inv_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
535: IS
536: sqlstmt varchar2(14000);
537: l_num NUMBER;
538: l_viewby_dim VARCHAR2(240); -- what is the viewby

Line 820: get_hold_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

816:
817: PROCEDURE get_hold_activity (
818: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
819: get_hold_sql OUT NOCOPY VARCHAR2,
820: get_hold_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
821: IS
822: sqlstmt varchar2(14000);
823: l_num NUMBER;
824: l_viewby_dim VARCHAR2(240); -- what is the viewby

Line 1109: p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,

1105: PROCEDURE Local_Bind_Variable
1106: (p_sqlstmt IN Varchar2,
1107: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1108: p_sql_output OUT NOCOPY Varchar2,
1109: p_bind_output_table OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
1110: p_record_type_id IN Number Default Null,
1111: p_view_by IN Varchar2 Default Null,
1112: p_gid IN Number Default Null,
1113: p_period_start IN Date Default null,

Line 1121: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();

1117: ) IS
1118: l_bind_rec BIS_QUERY_ATTRIBUTES;
1119:
1120: BEGIN
1121: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
1122: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1123: p_sql_output := p_sqlstmt;
1124: p_bind_output_table.EXTEND;
1125: l_bind_rec.attribute_name := ':VIEW_BY';

Line 1272: electronic_inv_trend_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1268:
1269: PROCEDURE get_electronic_inv_trend (
1270: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1271: electronic_inv_trend_sql OUT NOCOPY VARCHAR2,
1272: electronic_inv_trend_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1273: IS
1274: l_viewby_dim VARCHAR2(240); -- what is the viewby
1275: l_as_of_date DATE;
1276: l_organization VARCHAR2(240);