[Home] [Help]
87:
88: 4. 29-nov-2004 ssumaith - bug# 4037690 - File version 115.3
89: Check whether india localization is being used was done using a INR check in every trigger.
90: This check has now been moved into a new package and calls made to this package from this trigger
91: If the function jai_cmn_utils_pkg.check_jai_exists returns true it means INR is the set of books currency ,
92: Hence if this function returns FALSE , control should return.
93:
94: 5. 08-dec-2004 ssumaith - bug# 4037690 - File version 115.4
95:
127: open c_set_of_books;
128: fetch c_set_of_books into ln_sob_id;
129: close c_set_of_books;
130:
131: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_CREATE_57F4', P_SET_OF_BOOKS_ID => ln_sob_id) = false then
132: -- return;
133: --end if;
134:
135: /*The following code has been commented and added the above code instead - ssumaith - bug# 4037690*/
214: The trigger should not get fired when the non-INR based set of books is attached to the current operating unit
215: where transaction is being done.
216:
217: Fix:-
218: 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
219: NON-INR
220: Removed the cursors Fetch_Book_Id_Cur and Sob_Cur and the variables v_operating_id and v_gl_set_of_bks_id
221:
222: Dependency Due to this Bug:-
219: NON-INR
220: Removed the cursors Fetch_Book_Id_Cur and Sob_Cur and the variables v_operating_id and v_gl_set_of_bks_id
221:
222: Dependency Due to this Bug:-
223: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0 introduced through the bug 4033992
224:
225: 2. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
226: DB Entity as required for CASE COMPLAINCE. Version 116.1
227:
248: v_last_upd_by := pr_new.Last_Updated_By;
249: v_last_upd_login := pr_new.Last_Update_Login;
250: /*
251: || Code added by aiyer for the bug 4035566
252: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
253: */
254:
255: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_PO_HDR_CURR_UPD_TRG' ,
256: -- p_org_id => pr_new.org_id
251: || Code added by aiyer for the bug 4035566
252: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
253: */
254:
255: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_PO_HDR_CURR_UPD_TRG' ,
256: -- p_org_id => pr_new.org_id
257: -- ) = FALSE
258: --THEN
259: /*
438: The trigger should not get fires when the non-INR based set of books is attached to the current operating unit
439: where transaction is being done.
440:
441: Fix:-
442: 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
443: NON-INR
444:
445: Dependency Due to this Bug:-
446: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
442: 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
443: NON-INR
444:
445: Dependency Due to this Bug:-
446: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
447:
448: 4. 23/Jan/2005 brathod for bug#4030192 Version#115.2
449: Issue:- Trigger is not updating the vendor_id field in JAI_PO_TAXES
450: when a PO having no vendor is updated with the new vendor.
478: 8. 13-Jun-2005 File Version: 116.2
479: Ramananda for bug#4428980. Removal of SQL LITERALs is done
480:
481: 9. 08-Jul-2005 Sanjikum for Bug#4483042
482: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
483: IL functionality should work or not.
484:
485: 10. 12-Jul-2005 Sanjikum for Bug#4483042
486: 1) Changed the parameter being passed to jai_cmn_utils_pkg.validate_po_type
482: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
483: IL functionality should work or not.
484:
485: 10. 12-Jul-2005 Sanjikum for Bug#4483042
486: 1) Changed the parameter being passed to jai_cmn_utils_pkg.validate_po_type
487:
488: 11. 10-Sep-2010 Jia for GST Bug#10091373
489:
490: 12. 06-06-2012 amandali for bug 14085523
528:
529:
530: /*
531: || Code added by aiyer for the bug 4035566
532: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
533: */
534: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_PO_HDR_VENDOR_UPD_TRG' ,
535: -- p_org_id => pr_new.org_id
536: -- ) = FALSE
530: /*
531: || Code added by aiyer for the bug 4035566
532: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
533: */
534: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_PO_HDR_VENDOR_UPD_TRG' ,
535: -- p_org_id => pr_new.org_id
536: -- ) = FALSE
537: --THEN
538: /*
541: -- RETURN;
542: -- END IF;
543:
544: --code added by Sanjikum for Bug#4483042
545: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => pr_new.style_id) = FALSE THEN
546: return;
547: END IF;
548:
549: -- Start added for bug#3030483