[Home] [Help]
74: CHANGE HISTORY:
75: S.No Date Author and Details
76:
77: 1 29-Nov-2004 Sanjikum for 4035297. Version 115.1
78: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
79:
80: 2 08-Jun-2005 This Object is Modified to refer to New DB Entry names in place of Old
81: DB as required for CASE COMPLAINCE. Version 116.1
82:
83: 3. 13-Jun-2005 File Version: 116.2
84: Ramananda for bug#4428980. Removal of SQL LITERALs is done
85:
86: Dependency Due to this Bug:-
87: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
88:
89:
90: Future Dependencies For the release Of this Object:-
91: (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/
114: CLOSE Fetch_Book_Id_Cur;
115: */
116:
117:
118: --IF jai_cmn_utils_pkg.check_jai_exists(p_calling_object => 'JA_IN_PO_TAX_DELETE_TRG' ,
119: -- p_set_of_books_id => v_gl_set_of_bks_id) = FALSE THEN
120: -- RETURN;
121: -- END IF;
122:
332: FileVersion: 618.2 is obsoleted with this Version
333: This is a DEPENDANCY for later versions of the file
334:
335: 5 29-Nov-2004 Sanjikum for 4035297. Version 115.1
336: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
337:
338: Dependency Due to this Bug:-
339: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
340:
335: 5 29-Nov-2004 Sanjikum for 4035297. Version 115.1
336: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
337:
338: Dependency Due to this Bug:-
339: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
340:
341: 6. 19-Mar-05 rallamse for bug#4227171 Version#115.2
342: Remove automatic GSCC errors
343:
353: 10 06-Jul-2005 rallamse for bug# PADDR Elimination
354: 1. Commented rel_found and call to jai_po_cmn_pkg.query_locator_for_release
355:
356: 11. 08-Jul-2005 Sanjikum for Bug#4483042
357: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
358: IL functionality should work or not.
359:
360: 11. 08-Jul-2005 Sanjikum for Bug#4483042, File Version 117.2
361: 1) Added a new column style_id in cursor - Check_Rfq_Quot_Cur
436: FETCH Fetch_Book_Id_Cur INTO v_gl_set_of_bks_id;
437: CLOSE Fetch_Book_Id_Cur;
438: */
439:
440: --IF jai_cmn_utils_pkg.check_jai_exists( p_calling_object => 'JA_IN_PO_TAX_INSERT_TRG',
441: -- p_set_of_books_id => v_gl_set_of_bks_id) = FALSE THEN
442: -- RETURN;
443: -- END IF;
444:
556: v_style_id; --Added by Sanjikum for Bug#4483042
557: CLOSE Check_Rfq_Quot_Cur;
558:
559: --code added by Sanjikum for Bug#4483042
560: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
561: return;
562: END IF;
563:
564: open c_get_po_line_loc_details(v_orig_ship_id);
1149: Adhoc taxes are not apportioned when quantity is changed which is handled with this bug.
1150: Code is added to update JAI_PO_TAXES tables based on old and new quantity for adhoc taxes
1151:
1152: 3 29-Nov-2004 Sanjikum for 4035297. Version 115.1
1153: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
1154:
1155: Dependency Due to this Bug:-
1156: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
1157:
1152: 3 29-Nov-2004 Sanjikum for 4035297. Version 115.1
1153: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
1154:
1155: Dependency Due to this Bug:-
1156: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
1157:
1158: 4. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.2
1159: The Assessable Value is calculated for the transaction. For this, a call is
1160: made to the function ja_in_vat_assessable_value_f.sql with the parameters
1168: 6. 13-Jun-2005 File Version: 116.2
1169: Ramananda for bug#4428980. Removal of SQL LITERALs is done
1170:
1171: 7. 08-Jul-2005 Sanjikum for Bug#4483042 File Version: 116.3
1172: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
1173: IL functionality should work or not.
1174:
1175: 8. 8-Jul-2005 File Version: 116.3
1176: rchandan for bug#4479131
1275: END IF;
1276:
1277: --Commented the above and added the below by Sanjikum for Bug#4035297
1278:
1279: -- IF jai_cmn_utils_pkg.check_jai_exists( p_calling_object => 'JA_IN_PO_TAX_UPDATE_TRG',
1280: -- p_set_of_books_id => v_gl_set_of_bks_id) = FALSE THEN
1281: -- RETURN;
1282: -- END IF;
1283:
1403: v_style_id; --Added by Sanjikum for Bug#4483042
1404: CLOSE check_rfq_quot_cur;
1405:
1406: --code added by Sanjikum for Bug#4483042
1407: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
1408: return;
1409: END IF;
1410:
1411: OPEN item_id_cur;
1762: WHERE line_location_id = v_line_loc_id
1763: AND EXISTS (select 1 from JAI_CMN_TAXES_ALL b where b.tax_id = a.tax_id and b.adhoc_flag = 'Y');
1764:
1765: IF v_curr <> v_currency_code THEN
1766: v_currency_conv_rate := jai_cmn_utils_pkg.currency_conversion(v_gl_set_of_bks_id,
1767: v_curr, v_po_rate_date, v_po_rate_type, v_po_rate);
1768: ELSE
1769: v_currency_conv_rate := 1;
1770: END IF;