APPS.FII_AP_OPEN_PAY_SUM dependencies on BIS_QUERY_ATTRIBUTES

Line 8: open_pay_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

4: -- For the Open Payables Summary report --
5: PROCEDURE get_pay_liability (
6: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
7: open_pay_sum_sql OUT NOCOPY VARCHAR2,
8: open_pay_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
9: IS
10: i NUMBER;
11: l_viewby_dim VARCHAR2(240); -- what is the viewby
12: l_as_of_date DATE;

Line 211: disc_opp_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

207: -- For the Discount Opportunities Summary report --
208: PROCEDURE get_discount_opp_sum (
209: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
210: disc_opp_sum_sql OUT NOCOPY VARCHAR2,
211: disc_opp_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
212: IS
213: i NUMBER;
214: l_viewby_dim VARCHAR2(240); -- what is the viewby
215: l_as_of_date DATE;

Line 391: inv_due_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

387:
388: PROCEDURE get_inv_due_age (
389: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
390: inv_due_sum_sql OUT NOCOPY VARCHAR2,
391: inv_due_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
392: IS
393: i NUMBER;
394: l_viewby_dim VARCHAR2(240); -- what is the viewby
395: l_as_of_date DATE;

Line 586: inv_past_due_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

582:
583: PROCEDURE get_inv_past_due_age (
584: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
585: inv_past_due_sum_sql OUT NOCOPY VARCHAR2,
586: inv_past_due_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
587: IS
588: i NUMBER;
589: l_viewby_dim VARCHAR2(240); -- what is the viewby
590: l_as_of_date DATE;

Line 598: inv_past_due_rec BIS_QUERY_ATTRIBUTES;

594: l_viewby_id VARCHAR2(240); -- org_id or supplier_id
595: l_record_type_id NUMBER; --
596: l_gid NUMBER; -- 0,4 or 8
597: l_viewby_string VARCHAR2(240);
598: inv_past_due_rec BIS_QUERY_ATTRIBUTES;
599: l_org_where VARCHAR2(240);
600: l_sup_where VARCHAR2(240);
601: l_curr_suffix VARCHAR2(240);
602: sqlstmt VARCHAR2(14000);