[Home] [Help]
57: CHANGE HISTORY:
58: S.No Date Author and Details
59:
60: 1 29-Nov-2004 Sanjikum for 4035297. Version 115.1
61: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
62:
63: 2 08-Jun-2005 This Object is Modified to refer to New DB Entry names in place of Old
64: DB as required for CASE COMPLAINCE. Version 116.1
65:
66: 3. 13-Jun-2005 File Version: 116.2
67: Ramananda for bug#4428980. Removal of SQL LITERALs is done
68:
69: Dependency Due to this Bug:-
70: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
71:
72:
73: Future Dependencies For the release Of this Object:-
74: (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/
97: CLOSE Fetch_Book_Id_Cur;
98: */
99:
100:
101: --IF jai_cmn_utils_pkg.check_jai_exists(p_calling_object => 'JA_IN_PO_TAX_DELETE_TRG' ,
102: -- p_set_of_books_id => v_gl_set_of_bks_id) = FALSE THEN
103: -- RETURN;
104: -- END IF;
105:
295: FileVersion: 618.2 is obsoleted with this Version
296: This is a DEPENDANCY for later versions of the file
297:
298: 5 29-Nov-2004 Sanjikum for 4035297. Version 115.1
299: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
300:
301: Dependency Due to this Bug:-
302: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
303:
298: 5 29-Nov-2004 Sanjikum for 4035297. Version 115.1
299: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
300:
301: Dependency Due to this Bug:-
302: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
303:
304: 6. 19-Mar-05 rallamse for bug#4227171 Version#115.2
305: Remove automatic GSCC errors
306:
316: 10 06-Jul-2005 rallamse for bug# PADDR Elimination
317: 1. Commented rel_found and call to jai_po_cmn_pkg.query_locator_for_release
318:
319: 11. 08-Jul-2005 Sanjikum for Bug#4483042
320: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
321: IL functionality should work or not.
322:
323: 11. 08-Jul-2005 Sanjikum for Bug#4483042, File Version 117.2
324: 1) Added a new column style_id in cursor - Check_Rfq_Quot_Cur
385: FETCH Fetch_Book_Id_Cur INTO v_gl_set_of_bks_id;
386: CLOSE Fetch_Book_Id_Cur;
387: */
388:
389: --IF jai_cmn_utils_pkg.check_jai_exists( p_calling_object => 'JA_IN_PO_TAX_INSERT_TRG',
390: -- p_set_of_books_id => v_gl_set_of_bks_id) = FALSE THEN
391: -- RETURN;
392: -- END IF;
393:
505: v_style_id; --Added by Sanjikum for Bug#4483042
506: CLOSE Check_Rfq_Quot_Cur;
507:
508: --code added by Sanjikum for Bug#4483042
509: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
510: return;
511: END IF;
512:
513:
998: Adhoc taxes are not apportioned when quantity is changed which is handled with this bug.
999: Code is added to update JAI_PO_TAXES tables based on old and new quantity for adhoc taxes
1000:
1001: 3 29-Nov-2004 Sanjikum for 4035297. Version 115.1
1002: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
1003:
1004: Dependency Due to this Bug:-
1005: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
1006:
1001: 3 29-Nov-2004 Sanjikum for 4035297. Version 115.1
1002: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
1003:
1004: Dependency Due to this Bug:-
1005: The current trigger becomes dependent on the function jai_cmn_utils_pkg.check_jai_exists version 115.0.
1006:
1007: 4. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.2
1008: The Assessable Value is calculated for the transaction. For this, a call is
1009: made to the function ja_in_vat_assessable_value_f.sql with the parameters
1017: 6. 13-Jun-2005 File Version: 116.2
1018: Ramananda for bug#4428980. Removal of SQL LITERALs is done
1019:
1020: 7. 08-Jul-2005 Sanjikum for Bug#4483042 File Version: 116.3
1021: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
1022: IL functionality should work or not.
1023:
1024: 8. 8-Jul-2005 File Version: 116.3
1025: rchandan for bug#4479131
1113: END IF;
1114:
1115: --Commented the above and added the below by Sanjikum for Bug#4035297
1116:
1117: -- IF jai_cmn_utils_pkg.check_jai_exists( p_calling_object => 'JA_IN_PO_TAX_UPDATE_TRG',
1118: -- p_set_of_books_id => v_gl_set_of_bks_id) = FALSE THEN
1119: -- RETURN;
1120: -- END IF;
1121:
1241: v_style_id; --Added by Sanjikum for Bug#4483042
1242: CLOSE check_rfq_quot_cur;
1243:
1244: --code added by Sanjikum for Bug#4483042
1245: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
1246: return;
1247: END IF;
1248:
1249: OPEN item_id_cur;
1578: WHERE line_location_id = v_line_loc_id
1579: AND EXISTS (select 1 from JAI_CMN_TAXES_ALL b where b.tax_id = a.tax_id and b.adhoc_flag = 'Y');
1580:
1581: IF v_curr <> v_currency_code THEN
1582: v_currency_conv_rate := jai_cmn_utils_pkg.currency_conversion(v_gl_set_of_bks_id,
1583: v_curr, v_po_rate_date, v_po_rate_type, v_po_rate);
1584: ELSE
1585: v_currency_conv_rate := 1;
1586: END IF;