[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:
124: open c_set_of_books;
125: fetch c_set_of_books into ln_sob_id;
126: close c_set_of_books;
127:
128: --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
129: -- return;
130: --end if;
131:
132: /*The following code has been commented and added the above code instead - ssumaith - bug# 4037690*/
211: The trigger should not get fired when the non-INR based set of books is attached to the current operating unit
212: where transaction is being done.
213:
214: Fix:-
215: 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
216: NON-INR
217: Removed the cursors Fetch_Book_Id_Cur and Sob_Cur and the variables v_operating_id and v_gl_set_of_bks_id
218:
219: Dependency Due to this Bug:-
216: NON-INR
217: Removed the cursors Fetch_Book_Id_Cur and Sob_Cur and the variables v_operating_id and v_gl_set_of_bks_id
218:
219: Dependency Due to this Bug:-
220: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0 introduced through the bug 4033992
221:
222: 2. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
223: DB Entity as required for CASE COMPLAINCE. Version 116.1
224:
245: v_last_upd_by := pr_new.Last_Updated_By;
246: v_last_upd_login := pr_new.Last_Update_Login;
247: /*
248: || Code added by aiyer for the bug 4035566
249: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
250: */
251:
252: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_PO_HDR_CURR_UPD_TRG' ,
253: -- p_org_id => pr_new.org_id
248: || Code added by aiyer for the bug 4035566
249: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
250: */
251:
252: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_PO_HDR_CURR_UPD_TRG' ,
253: -- p_org_id => pr_new.org_id
254: -- ) = FALSE
255: --THEN
256: /*
432: The trigger should not get fires when the non-INR based set of books is attached to the current operating unit
433: where transaction is being done.
434:
435: Fix:-
436: 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
437: NON-INR
438:
439: Dependency Due to this Bug:-
440: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
436: 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
437: NON-INR
438:
439: Dependency Due to this Bug:-
440: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0. introduced through the bug 4033992
441:
442: 4. 23/Jan/2005 brathod for bug#4030192 Version#115.2
443: Issue:- Trigger is not updating the vendor_id field in JAI_PO_TAXES
444: when a PO having no vendor is updated with the new vendor.
472: 8. 13-Jun-2005 File Version: 116.2
473: Ramananda for bug#4428980. Removal of SQL LITERALs is done
474:
475: 9. 08-Jul-2005 Sanjikum for Bug#4483042
476: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
477: IL functionality should work or not.
478:
479: 10. 12-Jul-2005 Sanjikum for Bug#4483042
480: 1) Changed the parameter being passed to jai_cmn_utils_pkg.validate_po_type
476: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
477: IL functionality should work or not.
478:
479: 10. 12-Jul-2005 Sanjikum for Bug#4483042
480: 1) Changed the parameter being passed to jai_cmn_utils_pkg.validate_po_type
481:
482:
483: Future Dependencies For the release Of this Object:-
484: (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
517:
518:
519: /*
520: || Code added by aiyer for the bug 4035566
521: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
522: */
523: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_PO_HDR_VENDOR_UPD_TRG' ,
524: -- p_org_id => pr_new.org_id
525: -- ) = FALSE
519: /*
520: || Code added by aiyer for the bug 4035566
521: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
522: */
523: --IF jai_cmn_utils_pkg.check_jai_exists ( p_calling_object => 'JA_IN_PO_HDR_VENDOR_UPD_TRG' ,
524: -- p_org_id => pr_new.org_id
525: -- ) = FALSE
526: --THEN
527: /*
530: -- RETURN;
531: -- END IF;
532:
533: --code added by Sanjikum for Bug#4483042
534: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => pr_new.style_id) = FALSE THEN
535: return;
536: END IF;
537:
538: -- Start added for bug#3030483