[Home] [Help]
380:
381:
382: /*
383: The following cursor has been added by aiyer for the bug #3039521.
384: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books
385: */
386: -- Start of cursor added by aiyer for the bug #3039521
387: /* bug 5243532. Added by Lakshmi Gopalsami
388: Removed the reference to cursor sob_cur
388: Removed the reference to cursor sob_cur
389: as this is not used anywhere.
390: */
391:
392: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
393:
394: -- End of cursor Sob_Cur added for the bug #3039521.
395: -- Start Of Bug #
396: CURSOR c_chk_exc_exmpt_rule
1445: a.header_id = b.header_id AND
1446: b.line_id = v_source_line_id AND
1447: a.header_id = v_source_header_id ;
1448:
1449: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
1450: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
1451: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
1452: v_conv_rate NUMBER;
1453: v_conv_date DATE;
3687: FROM wsh_delivery_assignments
3688: WHERE delivery_detail_id = pr_trig_row.delivery_detail_id;
3689:
3690: /*
3691: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books
3692: */
3693:
3694: CURSOR Sob_Cur
3695: IS
3694: CURSOR Sob_Cur
3695: IS
3696: SELECT gsb.currency_code
3697: FROM hr_operating_units hru ,
3698: gl_sets_of_books gsb
3699: WHERE gsb.set_of_books_id = hru.set_of_books_id AND
3700: hru.organization_id = pr_trig_row.org_id ;
3701:
3702: CURSOR c_curr_precision (cp_curr_code VARCHAR2) IS
3715:
3716: lv_inclusive_tax_flag NUMBER ; --Added by abezgam for bug#10213327
3717: ln_precision NUMBER;
3718:
3719: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
3720: v_set_of_books_id NUMBER;
3721: r_il_setup c_get_il_setup%ROWTYPE;
3722: r_rg23d_details c_rg23d_details%ROWTYPE;
3723: ln_cost_of_goods_sold_ac mtl_parameters.cost_of_sales_account%TYPE;