APPS.FII_AP_INV_ACTIVITY dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 10: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

6:
7: g_date_string DATE;
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);

Line 294: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

290:
291:
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);

Line 532: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

528: - Procedure get_electronic_inv */
529:
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);

Line 818: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

814:
815:
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);

Line 1107: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1103: /* Creating a Procedure for the Electronic Invoice trend report */
1104:
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,

Line 1186: PROCEDURE get_period_details(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1182: END Local_Bind_Variable;
1183:
1184: /* Creating Procedure that fetches the period details for the Electronic Invoice Trend reports */
1185:
1186: PROCEDURE get_period_details(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1187: p_period_start OUT NOCOPY Date,
1188: p_cur_period OUT NOCOPY Number,
1189: p_id_column OUT NOCOPY Varchar2,
1190: p_report_start OUT NOCOPY DATE,

Line 1270: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1266:
1267: /* Electronic Invoice trend Report */
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