Use of ROWTYPE in a package, expert advise
Dear Colleagues,
I have written a package with following specification of two procedures which retrieves the data and insert into temp table respectively ;
| PROCEDURE raw_packing_materials( p_legal_entity IN NUMBER | ||
| , p_itm_mst_id IN NUMBER | ||
| , p_catg_seg1 IN VARCHAR2 | ||
| , p_catg_seg2 IN VARCHAR2 | ||
| , p_from_segment IN VARCHAR2 | ||
| , p_to_segment IN VARCHAR2 | ||
| , p_from_date IN VARCHAR2 | ||
| , p_to_date IN VARCHAR2 | ||
| , p_cost_type IN VARCHAR2); |
| PROCEDURE insert_materials( p_invrowmat_rec IN xxdcsl.xxcust_income_tax_accounting%rowtype); |
In side the procedure "raw_packing_materials" i have used a cursor sql and within that cursor i called the procedure "insert_materials" to insert records into temp table rather having that insert statement within the same procedure of "raw_packing_materials".
0