DBA Data[Home] [Help]

APPS.FII_AP_DETAIL dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 19: inv_dist_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

15:
16: PROCEDURE Get_Inv_Distribution_Detail (
17: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
18: inv_dist_sql OUT NOCOPY VARCHAR2,
19: inv_dist_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
20: ) IS
21: l_as_of_date DATE;
22: l_operating_unit VARCHAR2(240);
23: l_supplier VARCHAR2(240);

Line 107: hold_history_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS

103:
104: PROCEDURE Get_Hold_History
105: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
106: hold_history_sql out NOCOPY VARCHAR2,
107: hold_history_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
108: /* declaration section */
109: sqlstmt VARCHAR2(14000);
110:
111: l_as_of_date DATE;

Line 190: inv_act_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS

186:
187: PROCEDURE Get_Inv_Activity_History
188: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
189: inv_act_sql out NOCOPY VARCHAR2,
190: inv_act_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
191: /* declaration section */
192: sqlstmt VARCHAR2(14000);
193:
194: l_as_of_date DATE;

Line 363: sched_pay_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS

359:
360: PROCEDURE Get_Sched_Pay_Discount
361: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
362: sched_pay_sql out NOCOPY VARCHAR2,
363: sched_pay_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
364: /* declaration section */
365: sqlstmt VARCHAR2(14000);
366:
367: l_as_of_date DATE;

Line 458: p_inv_lines_detail_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

454:
455: PROCEDURE get_inv_lines_detail (
456: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
457: p_inv_lines_detail_sql OUT NOCOPY VARCHAR2,
458: p_inv_lines_detail_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
459: ) IS
460: l_invoice_id NUMBER; -- Variable to retrieve Invoice ID from parameter passed from parent report
461: l_as_of_date DATE; -- Variables for get_parameters
462: l_operating_unit VARCHAR2(240);