[Home] [Help]
257: 7. 13-Jun-2005 File Version: 116.2
258: Ramananda for bug#4428980. Removal of SQL LITERALs is done
259:
260: 8 06-Jul-2005 rallamse for bug#4479131 PADDR Elimination
261: 1. Replaced call to jai_po_cmn_pkg.query_locator_for_line with
262: jai_cmn_hook_pkg.Po_Requisition_Lines_All
263:
264:
265: 9. 03/11/2006 SACSETHI for Bug 5228046, File version 120.4
355: || ssumaith - eliminated code to stop iprocurement Requisitions from being created.
356: */
357: /* added by rchandan for bug#4627239 end*/
358:
359: -- jai_po_cmn_pkg.query_locator_for_line( v_requisition_header_id, 'JAINREQN', FOUND );
360: v_hook_value := 'TRUE';
361: /* If v_hook_value is TRUE, then it means taxes should be defaulted. IF FALSE then return */
362: v_hook_value := jai_cmn_hook_pkg.Po_Requisition_Lines_All
363: (
689: END IF;
690: --pramasub end FP
691: IF v_blanket_hdr IS NOT NULL AND v_blanket_line IS NOT NULL THEN
692:
693: jai_po_cmn_pkg.locate_source_line( v_blanket_hdr, v_blanket_line, v_line_quantity, v_po_line_id, v_line_location_id );
694:
695: /*IF v_line_location_id = -999 THEN --pramasub commented FP
696: -- code added by sriram to ensure that we do not have a duplicate requisition line_id
697: -- checking if the requisition line id is already created or not
1184:
1185: 4 22/07/2003 cbabu for Bug# 3051278, FileVersion# 616.1
1186: This fix is done to default the taxes onto PO Shipment line which got created through AutoCreate of
1187: Blanket Release from Purchase Requisition. If there is any change in UOM between
1188: requisition line and BPO Line, then PO Shipment quantity has to be given as input to jai_po_cmn_pkg.process_release_shipment
1189: procedure. But requisition quantity is going as input and this is causing the problem.
1190: Code is modified to pick PO Shipment quantity and give it as input to jai_po_cmn_pkg.process_release_shipment procedure
1191:
1192: 5 18/11/2003 Vijay Shankar for Bug# 3193592, FileVersion# 617.1
1186: This fix is done to default the taxes onto PO Shipment line which got created through AutoCreate of
1187: Blanket Release from Purchase Requisition. If there is any change in UOM between
1188: requisition line and BPO Line, then PO Shipment quantity has to be given as input to jai_po_cmn_pkg.process_release_shipment
1189: procedure. But requisition quantity is going as input and this is causing the problem.
1190: Code is modified to pick PO Shipment quantity and give it as input to jai_po_cmn_pkg.process_release_shipment procedure
1191:
1192: 5 18/11/2003 Vijay Shankar for Bug# 3193592, FileVersion# 617.1
1193: when multiple requisitions are merged to form a single PO Shipment during Autocreation process, then this trigger
1194: is erroring out as taxes from multiple requisition lines are getting populated into the same line_location_id.
1195: This is resolved by defaulting taxes from setup with an API call to jai_po_tax_pkg.ja_in_po_case2 procedure
1196: instead of carrying taxes from requisition lines to PO Shipment
1197:
1198: 6.02/08/2004 ssumaith - bug# 3729015 file version 115.1
1199: commented call to jai_po_cmn_pkg.process_release_shipment because in the ja_in_po_tax_insert_trg
1200: a hook has been implemented which defaults the taxes from a requisition to the release.
1201: and JAINPOCR concurrent is anyway called from ja_in_po_tax_insert_trg , hence the presense
1202: of the call is superfluous.
1203:
1446: */
1447: -- End of addition by Gsri on 07-MAR-2001
1448:
1449: if v_debug THEN
1450: UTL_FILE.PUT_LINE(v_myfilehandle,'777 jai_po_cmn_pkg.process_release_shipment ('''||'BLANKET'||''''
1451: ||','||v_src_ship_id || v_line_loc_id||',' ||v_po_line_id||',' ||v_po_hdr_id
1452: ||','||v_quantity||',' ||v_po_rel_id
1453: ||',' ||''''||TO_CHAR(v_cre_dt,'DD/MM/RRRR HH24:MI:SS')||''''||',' ||v_cre_by
1454: ||',' ||''''||TO_CHAR(v_last_upd_dt,'DD/MM/RRRR HH24:MI:SS')||''''||',' ||v_last_upd_by
1462: because in the ja_in_po_tax_insert_trg, because of a hook ,
1463: the taxes JAINPOCR concurrent is anyway called from ja_in_po_tax_insert_trg
1464:
1465:
1466: jai_po_cmn_pkg.process_release_shipment ( 'BLANKET',
1467: v_src_ship_id,
1468: v_line_loc_id,
1469: v_po_line_id,
1470: v_po_hdr_id,
1575: ||Po lines does not exists .
1576: ||Insert the line locations from requisition into po using the procedure below
1577: */
1578:
1579: jai_po_cmn_pkg.insert_line( 'STANDARD',
1580: v_line_loc_id, -- Bug 4513549
1581: v_po_hdr_id,
1582: v_po_line_id,
1583: v_cre_dt,
1742:
1743: IF NVL( v_assessable_value, 0 ) > 0 THEN
1744: -- Bug 4513549. Added by LGOPALSA
1745: v_assessable_value := v_assessable_value * v_quantity;
1746: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, v_assessable_value, v_po_curr, v_curr_conv_factor );
1747: ELSE
1748: v_assessable_value := Line_Tot;
1749: END IF;
1750:
1764: ELSE
1765: -- Bug 4513549.
1766: -- Added by LGOPALSA. Fix
1767: ln_vat_assess_value := ln_vat_assess_value * v_quantity;
1768: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, ln_vat_assess_value, v_po_curr, v_curr_conv_factor );
1769: END IF ;
1770: /* end rallamse bug#4250072 for VAT */
1771: /*
1772: -- Added by Jia for GST Bug#10091373 on 2010/09/10, Begin
1785: THEN
1786: ln_gst_assessable_value := Line_tot ;
1787: ELSE
1788: ln_gst_assessable_value := ln_gst_assessable_value * v_quantity;
1789: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, ln_gst_assessable_value, v_po_curr, v_curr_conv_factor );
1790: END IF ;
1791: */
1792: ------------------------------------------------------------------------------------------------
1793: -- Added by Jia for GST Bug#10091373 on 2010/09/10, End
1791: */
1792: ------------------------------------------------------------------------------------------------
1793: -- Added by Jia for GST Bug#10091373 on 2010/09/10, End
1794:
1795: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, DUMMY, v_po_curr, v_curr_conv_factor); -- TO get the conversion rate .
1796:
1797: /* Added ln_vat_assess_value for bug# for VAT */
1798: jai_po_tax_pkg.calculate_tax( 'STANDARDPO',
1799: v_po_hdr_id ,
2045: 7. 13-Jun-2005 File Version: 116.2
2046: Ramananda for bug#4428980. Removal of SQL LITERALs is done
2047:
2048: 8 06-Jul-2005 rallamse for bug# PADDR Elimination
2049: 1. Replaced call to jai_po_cmn_pkg.query_locator_for_line with
2050: jai_cmn_hook_pkg.Po_Requisition_Lines_All
2051:
2052: 9 04-Aug-2005 P1 Build Issue bug# 4535701 by Ramananda. File Version 120.2
2053: Commented the columns Event_Id and Line_Number.
2121: FETCH Bind_cur INTO v_seg_id, v_type_lookup_code , lv_apps_source_code;
2122: CLOSE bind_cur;
2123: --pramasub FP end
2124:
2125: --jai_po_cmn_pkg.query_locator_for_line( v_header_id, 'JAINREQN', found );
2126: v_hook_value := 'TRUE'; /* rallamse bug#4479131 PADDR Elimination */
2127: /* If v_hook_value is TRUE, then it means taxes should be defaulted. IF FALSE then return */
2128: v_hook_value := jai_cmn_hook_pkg.Po_Requisition_Lines_All
2129: (
2511: Delete From JAI_PO_REQ_LINE_TAXES --Ja_In_Reqn_Tax_Lines pramasub FP
2512: Where Requisition_Line_Id = v_line_id;
2513: IF v_blanket_hdr IS NOT NULL AND v_blanket_line IS NOT NULL THEN
2514: --Ja_In_Locate_Line( v_blanket_hdr, v_blanket_line, v_quantity, v_po_line_id, v_line_location_id );
2515: jai_po_cmn_pkg.locate_source_line( v_blanket_hdr, v_blanket_line, v_quantity, v_po_line_id,
2516: v_line_location_id );
2517: open c_reqn_line_id(v_line_id);
2518: fetch c_reqn_line_id into v_reqn_ctr;
2519: close c_reqn_line_id;
2813: 4. 13-Jun-2005 File Version: 116.2
2814: Ramananda for bug#4428980. Removal of SQL LITERALs is done
2815:
2816: 5 06-Jul-2005 rallamse for bug# PADDR Elimination
2817: 1. Replaced call to jai_po_cmn_pkg.query_locator_for_line with
2818: jai_cmn_hook_pkg.Po_Requisition_Lines_All
2819:
2820: 6 04-Aug-2005 P1 Build Issue bug# 4535701 by Ramananda. File Version 120.2
2821: Commented the columns Event_Id and Line_Number.
2874: -- return;
2875: --end if;
2876:
2877:
2878: --jai_po_cmn_pkg.query_locator_for_line( v_header_id, 'JAINREQN', found );
2879: v_hook_value := 'TRUE'; /* rallamse bug#4479131 PADDR Elimination */
2880: /* If v_hook_value is TRUE, then it means taxes should be defaulted. IF FALSE then return */
2881: v_hook_value := jai_cmn_hook_pkg.Po_Requisition_Lines_All
2882: (