7606: l_view_net_price_flag VARCHAR2(2);
7607: l_tax_flag VARCHAR2(1);
7608: l_parent_line_id NUMBER;
7609: p_index NUMBER;
7610: l_return_reason_code AR_LOOKUPS.LOOKUP_CODE%TYPE;
7611: l_return_reason AR_LOOKUPS.MEANING%TYPE;
7612: p_mdl_source_line_id VARCHAR2(240);
7613: l_print_len NUMBER;
7614: l_can_qty VARCHAR2(50);
7607: l_tax_flag VARCHAR2(1);
7608: l_parent_line_id NUMBER;
7609: p_index NUMBER;
7610: l_return_reason_code AR_LOOKUPS.LOOKUP_CODE%TYPE;
7611: l_return_reason AR_LOOKUPS.MEANING%TYPE;
7612: p_mdl_source_line_id VARCHAR2(240);
7613: l_print_len NUMBER;
7614: l_can_qty VARCHAR2(50);
7615: l_can_amt VARCHAR2(50);
7663: c_detail_rec2 cursor_for_mdl_components%rowtype;
7664:
7665: CURSOR c_return_reason(l_return_reason_code VARCHAR2) IS
7666: SELECT meaning
7667: FROM ar_lookups
7668: WHERE lookup_type = 'CREDIT_MEMO_REASON'
7669: AND lookup_code = l_return_reason_code;
7670:
7671: type order_details_tbl_type is table of ibe_return_detail_v%rowtype