[Home] [Help]
441:
442: /*
443: || Added by bgowrava for the forward porting bug 5631784
444: */
445: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;
446: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
447: IS
448: SELECT
449: *
442: /*
443: || Added by bgowrava for the forward porting bug 5631784
444: */
445: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;
446: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
447: IS
448: SELECT
449: *
450: FROM
447: IS
448: SELECT
449: *
450: FROM
451: oe_order_headers_all
452: WHERE
453: header_id = cp_header_id ;
454:
455:
1206: conversion_type_code ,
1207: conversion_rate ,
1208: nvl(b.actual_shipment_date,sysdate) actual_shipment_date
1209: FROM
1210: oe_order_headers_all a ,
1211: oe_order_lines_all b
1212: WHERE
1213: a.header_id = b.header_id AND
1214: b.line_id = v_source_line_id AND
1215: a.header_id = v_source_header_id ;
1216:
1217: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
1218: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
1219: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
1220: v_conv_rate NUMBER;
1221: v_conv_date DATE;
1222:
1223: v_curr_conv_rate NUMBER;
1755:
1756: 17.24/09/2003 Aiyer Bug #3139718 File Version : 616.4
1757:
1758: Added the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the
1759: conversion_date from oe_order_headers_all.
1760: As a sales order shipment date can be different from its creation date, hence the conversion rate
1761: applicable on the date of shipment should be considerd for all processing rather than the creation
1762: date of the Sales order.
1763: Added the procedure call jai_cmn_utils_pkg.currency_conversion to calculated the currency conversion rate.