DBA Data[Home] [Help]

APPS.FII_AP_PAY_STATUS dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 7: open_pay_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

3:
4: PROCEDURE GET_OPEN_PAY_TABLE_PORTLET (
5: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
6: open_pay_sum_sql OUT NOCOPY VARCHAR2,
7: open_pay_sum_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
8: IS
9: i NUMBER;
10: l_viewby_dim VARCHAR2(240); -- what is the viewby
11: l_as_of_date DATE;

Line 197: inv_age_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

193:
194: PROCEDURE get_inv_aging (
195: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
196: inv_age_sql OUT NOCOPY VARCHAR2,
197: inv_age_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
198: IS
199: l_viewby_dim VARCHAR2(240); -- what is the viewby
200: l_as_of_date DATE;
201: l_organization VARCHAR2(240);

Line 309: open_pay_sum_pie_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

305:
306: PROCEDURE get_pay_liability_pie (
307: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
308: open_pay_sum_pie_sql OUT NOCOPY VARCHAR2,
309: open_pay_sum_pie_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
310: IS
311: l_viewby_dim VARCHAR2(240); -- what is the viewby
312: l_as_of_date DATE;
313: l_organization VARCHAR2(240);

Line 419: kpi_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

415:
416: PROCEDURE get_kpi (
417: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
418: kpi_sql OUT NOCOPY VARCHAR2,
419: kpi_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
420: IS
421: l_viewby_dim VARCHAR2(240); -- what is the viewby
422: l_as_of_date DATE;
423: l_organization VARCHAR2(240);

Line 511: get_hold_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS

507:
508: PROCEDURE get_hold_sum
509: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
510: get_hold_sum_sql out NOCOPY VARCHAR2,
511: get_hold_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
512:
513: -- declaration section
514: sqlstmt VARCHAR2(14000);
515: