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);
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;
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;
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;
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);