[Home] [Help]
555: a.header_id = b.header_id AND
556: b.line_id = v_source_line_id AND
557: a.header_id = v_source_header_id ;
558:
559: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
560: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
561: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
562: v_conv_rate NUMBER;
563: v_conv_date DATE;
2058: FROM wsh_delivery_assignments
2059: WHERE delivery_detail_id = pr_trig_row.delivery_detail_id;
2060:
2061: /*
2062: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books
2063: */
2064:
2065: CURSOR Sob_Cur IS
2066: SELECT gsb.currency_code
2063: */
2064:
2065: CURSOR Sob_Cur IS
2066: SELECT gsb.currency_code
2067: FROM hr_operating_units hru, gl_sets_of_books gsb
2068: WHERE gsb.set_of_books_id = hru.set_of_books_id
2069: AND hru.organization_id = pr_trig_row.org_id;
2070:
2071: CURSOR c_curr_precision(cp_curr_code VARCHAR2) IS
2083:
2084: lv_inclusive_tax_flag NUMBER;
2085: ln_precision NUMBER;
2086:
2087: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
2088: v_set_of_books_id NUMBER;
2089: r_il_setup c_get_il_setup%ROWTYPE;
2090: r_rg23d_details c_rg23d_details%ROWTYPE;
2091: ln_cost_of_goods_sold_ac mtl_parameters.cost_of_sales_account%TYPE;
2941: a.header_id = b.header_id AND
2942: b.line_id = v_source_line_id AND
2943: a.header_id = v_source_header_id ;
2944:
2945: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
2946: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
2947: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
2948: v_conv_rate NUMBER;
2949: v_conv_date DATE;