[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
70: --------------------------------------------------------------------------------------------*/
71:
72: /* following code added by ssumaith - bug# 4037690 */
73: -- if pr_new.org_id is not null then
74: -- 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
75: -- return;
76: -- end if;
77: -- end if;
78:
120:
121: 2. 29/11/2005 Aparajita for bug#4036241. Version#115.1
122:
123: Introduced the call to centralized packaged procedure,
124: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
125:
126: 3. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
127: DB Entity as required for CASE COMPLAINCE. Version 116.1
128:
133:
134: Sl No. Bug Dependent on
135: Bug/Patch set Details
136: -------------------------------------------------------------------------------------------------
137: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug
138: 4033992.
139: ja_in_util_pkg_s.sql 115.0
140: ja_in_util_pkg_b.sql 115.0
141:
140: ja_in_util_pkg_b.sql 115.0
141:
142: --------------------------------------------------------------------------------------------------*/
143: --if
144: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_WSH_BACKORDER_AU_TRG', p_inventory_orgn_id => pr_new.organization_id)
145: -- =
146: -- FALSE
147: --then
148: /* India Localization funtionality is not required */
580:
581: 10. Aparajita 30/11/2004. Bug#4036241. Version#115.3
582:
583: Introduced the call to centralized packaged procedure,
584: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
585:
586:
587: 11. Brathod 21/03/2005. Bug#4245073. Version# 115.4, 115.5
588: Trigger modified to check whether vat type of tax exists or not.
670: v_line_tax_amount :=0;
671: v_sum_tax_amount :=0;
672:
673: --if
674: -- 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)
675: -- =
676: -- FALSE
677: --then
678: -- /* India Localization funtionality is not required */
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.
1764: Also changed the population logic of v_func_tax_amt variable, such that
1765: during shipping the functional tax amount gets recalculated from the tax_amount column in JAI_OM_OE_SO_TAXES
1766: and hence logic is ->
1767: v_func_tax_amt = v_tax_amt * nvl((v_curr_conv_rate ,1)
1836: The trigger should not get fired when the non-INR based set of books is attached to the current operating unit
1837: where transaction is being done.
1838:
1839: Fix:-
1840: 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
1841: NON-INR
1842:
1843: Dependency Due to this Bug:-
1844: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0 introduced through the bug 4033992
1840: 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
1841: NON-INR
1842:
1843: Dependency Due to this Bug:-
1844: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0 introduced through the bug 4033992
1845:
1846:
1847: 23. 2005/02/11 ssumaith - bug# 4171272 - File version 115.3
1848:
2026: END IF;
2027:
2028: /*
2029: || Code added by aiyer for the bug 4035566
2030: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
2031: */
2032: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_WSH_DLRY_DTLS_AU_TRG' ,
2033: -- p_org_id => pr_new.org_id
2034: -- ) = FALSE
2028: /*
2029: || Code added by aiyer for the bug 4035566
2030: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
2031: */
2032: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_WSH_DLRY_DTLS_AU_TRG' ,
2033: -- p_org_id => pr_new.org_id
2034: -- ) = FALSE
2035: --THEN
2036: /*
2197: FETCH get_conv_detail_cur INTO v_currency_code, v_conv_type_code,v_conv_rate, v_conv_date;
2198:
2199: IF get_conv_detail_cur%FOUND THEN
2200:
2201: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion (
2202: v_set_of_books_id ,
2203: v_currency_code ,
2204: v_conv_date ,
2205: v_conv_type_code ,