[Home] [Help]
37:
38: 2. 29-nov-2004 ssumaith - bug# 4037690 - File version 115.1
39: Check whether india localization is being used was done using a INR check in every trigger.
40: This check has now been moved into a new package and calls made to this package from this trigger
41: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,
42: Hence if this function returns FALSE , control should return.
43:
44: 3. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
45: DB Entity as required for CASE COMPLAINCE. Version 116.1
80: --------------------------------------------------------------------------------------------*/
81:
82: /* following code added by ssumaith - bug# 4037690 */
83: -- if pr_new.org_id is not null then
84: -- If jai_cmn_utils_pkg.check_jai_exists( P_CALLING_OBJECT => 'JA_IN_WSH_DLRY_DTLS_AD_TRG', P_ORG_ID => pr_new.org_id) = false then
85: -- return;
86: -- end if;
87: -- end if;
88:
130:
131: 2. 29/11/2005 Aparajita for bug#4036241. Version#115.1
132:
133: Introduced the call to centralized packaged procedure,
134: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
135:
136: 3. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
137: DB Entity as required for CASE COMPLAINCE. Version 116.1
138:
143:
144: Sl No. Bug Dependent on
145: Bug/Patch set Details
146: -------------------------------------------------------------------------------------------------
147: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug
148: 4033992.
149: ja_in_util_pkg_s.sql 115.0
150: ja_in_util_pkg_b.sql 115.0
151:
150: ja_in_util_pkg_b.sql 115.0
151:
152: --------------------------------------------------------------------------------------------------*/
153: --if
154: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_WSH_BACKORDER_AU_TRG', p_inventory_orgn_id => pr_new.organization_id)
155: -- =
156: -- FALSE
157: --then
158: /* India Localization funtionality is not required */
658:
659: 10. Aparajita 30/11/2004. Bug#4036241. Version#115.3
660:
661: Introduced the call to centralized packaged procedure,
662: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
663:
664:
665: 11. Brathod 21/03/2005. Bug#4245073. Version# 115.4, 115.5
666: Trigger modified to check whether vat type of tax exists or not.
778: v_sum_tax_amount :=0;
779:
780:
781: --if
782: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_WSH_DLRY_AU_REL_STAT_TRG', p_org_id => pr_new.org_id)
783: -- =
784: -- FALSE
785: --then
786: -- /* India Localization funtionality is not required */
1999: conversion_date from oe_order_headers_all.
2000: As a sales order shipment date can be different from its creation date, hence the conversion rate
2001: applicable on the date of shipment should be considerd for all processing rather than the creation
2002: date of the Sales order.
2003: Added the procedure call jai_cmn_utils_pkg.currency_conversion to calculated the currency conversion rate.
2004: Also changed the population logic of v_func_tax_amt variable, such that
2005: during shipping the functional tax amount gets recalculated from the tax_amount column in JAI_OM_OE_SO_TAXES
2006: and hence logic is ->
2007: v_func_tax_amt = v_tax_amt * nvl((v_curr_conv_rate ,1)
2076: The trigger should not get fired when the non-INR based set of books is attached to the current operating unit
2077: where transaction is being done.
2078:
2079: Fix:-
2080: Function jai_cmn_utils_pkg.check_jai_exists is being called which returns the TRUE if the currency is INR and FALSE if the currency is
2081: NON-INR
2082:
2083: Dependency Due to this Bug:-
2084: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0 introduced through the bug 4033992
2080: Function jai_cmn_utils_pkg.check_jai_exists is being called which returns the TRUE if the currency is INR and FALSE if the currency is
2081: NON-INR
2082:
2083: Dependency Due to this Bug:-
2084: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0 introduced through the bug 4033992
2085:
2086:
2087: 23. 2005/02/11 ssumaith - bug# 4171272 - File version 115.3
2088:
2323: END IF;
2324:
2325: /*
2326: || Code added by aiyer for the bug 4035566
2327: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
2328: */
2329: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_WSH_DLRY_DTLS_AU_TRG' ,
2330: -- p_org_id => pr_new.org_id
2331: -- ) = FALSE
2325: /*
2326: || Code added by aiyer for the bug 4035566
2327: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
2328: */
2329: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_WSH_DLRY_DTLS_AU_TRG' ,
2330: -- p_org_id => pr_new.org_id
2331: -- ) = FALSE
2332: --THEN
2333: /*
2509: FETCH get_conv_detail_cur INTO v_currency_code, v_conv_type_code,v_conv_rate, v_conv_date;
2510:
2511: IF get_conv_detail_cur%FOUND THEN
2512:
2513: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion (
2514: v_set_of_books_id ,
2515: v_currency_code ,
2516: v_conv_date ,
2517: v_conv_type_code ,