DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on AR_LOOKUPS

Line 7610: l_return_reason_code AR_LOOKUPS.LOOKUP_CODE%TYPE;

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

Line 7611: l_return_reason AR_LOOKUPS.MEANING%TYPE;

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

Line 7667: FROM ar_lookups

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