APPS.FII_AP_PAY_MGT dependencies on BIS_QUERY_ATTRIBUTES

Line 9: inv_graph_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

5: /* Package for Holds Graph portlet */
6: PROCEDURE get_hold_cat_graph (
7: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
8: inv_graph_sql OUT NOCOPY VARCHAR2,
9: inv_graph_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
10: IS
11: l_viewby_dim VARCHAR2(240); -- what is the viewby
12: l_as_of_date DATE;
13: l_organization VARCHAR2(240);

Line 20: inv_trend_rec BIS_QUERY_ATTRIBUTES;

16: l_viewby_id VARCHAR2(240); -- org_id or supplier_id
17: l_record_type_id NUMBER; --
18: l_gid NUMBER; -- 0,4 or 8
19: l_viewby_string VARCHAR2(240);
20: inv_trend_rec BIS_QUERY_ATTRIBUTES;
21: l_param_join VARCHAR2(240);
22: l_cur_period NUMBER;
23: l_id_column VARCHAR2(100);
24: sqlstmt VARCHAR2(14000);

Line 98: inv_graph_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

94:
95: PROCEDURE get_late_ontime_payment (
96: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
97: inv_graph_sql OUT NOCOPY VARCHAR2,
98: inv_graph_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
99: IS
100: l_viewby_dim VARCHAR2(240); -- what is the viewby
101: l_as_of_date DATE;
102: l_organization VARCHAR2(240);

Line 215: inv_graph_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

211:
212: PROCEDURE get_inv_graph (
213: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
214: inv_graph_sql OUT NOCOPY VARCHAR2,
215: inv_graph_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
216: IS
217: l_stmt VARCHAR2(10000);
218: l_page_period_type VARCHAR2(32000);
219: l_pk VARCHAR2(30);

Line 224: inv_graph_rec BIS_QUERY_ATTRIBUTES;

220: l_name VARCHAR2(100);
221: l_actual_period_type NUMBER;
222: l_period_type VARCHAR2(1000);
223: l_week_num NUMBER;
224: inv_graph_rec BIS_QUERY_ATTRIBUTES;
225: l_time_comp VARCHAR2(20);
226: l_as_of_date DATE;
227: l_p_as_of_date DATE;
228: l_ent_pyr_start DATE;

Line 270: inv_graph_output := BIS_QUERY_ATTRIBUTES_TBL();

266: /* Removing the hard coded value for bug # 3262629*/
267: -- l_gid := 4;
268:
269: l_week_num := 13;
270: inv_graph_output := BIS_QUERY_ATTRIBUTES_TBL();
271: inv_graph_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
272:
273: IF (p_page_parameter_tbl.count > 0) THEN
274: i:= p_page_parameter_tbl.first;

Line 698: elec_late_payment_sql out NOCOPY VARCHAR2, elec_late_payment_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

694: /* For Electronic Invoices and Late Payments */
695:
696:
697: PROCEDURE get_elec_late_payment (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
698: elec_late_payment_sql out NOCOPY VARCHAR2, elec_late_payment_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
699: IS
700: l_stmt VARCHAR2(10000);
701: l_page_period_type VARCHAR2(32000);
702: l_pk VARCHAR2(30);

Line 707: elec_late_payment_rec BIS_QUERY_ATTRIBUTES;

703: l_name VARCHAR2(100);
704: l_actual_period_type NUMBER;
705: l_period_type VARCHAR2(1000);
706: l_week_num NUMBER;
707: elec_late_payment_rec BIS_QUERY_ATTRIBUTES;
708: l_time_comp VARCHAR2(20);
709: l_as_of_date DATE;
710: l_p_as_of_date DATE;
711: l_ent_pyr_start DATE;

Line 758: elec_late_payment_output := BIS_QUERY_ATTRIBUTES_TBL();

754: );
755:
756:
757: l_week_num := 13;
758: elec_late_payment_output := BIS_QUERY_ATTRIBUTES_TBL();
759: elec_late_payment_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
760:
761: IF (p_page_parameter_tbl.count > 0) THEN
762: i:= p_page_parameter_tbl.first;

Line 1513: kpi_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS

1509:
1510: PROCEDURE GET_KPI
1511: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1512: kpi_sql out NOCOPY VARCHAR2,
1513: kpi_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
1514: /* declaration section */
1515: sqlstmt VARCHAR2(14000);
1516:
1517: l_viewby_dim VARCHAR2(240); -- what is the viewby