[Home] [Help]
251: 7. 13-Jun-2005 File Version: 116.2
252: Ramananda for bug#4428980. Removal of SQL LITERALs is done
253:
254: 8 06-Jul-2005 rallamse for bug#4479131 PADDR Elimination
255: 1. Replaced call to jai_po_cmn_pkg.query_locator_for_line with
256: jai_cmn_hook_pkg.Po_Requisition_Lines_All
257:
258:
259: 9. 03/11/2006 SACSETHI for Bug 5228046, File version 120.4
339: || ssumaith - eliminated code to stop iprocurement Requisitions from being created.
340: */
341: /* added by rchandan for bug#4627239 end*/
342:
343: -- jai_po_cmn_pkg.query_locator_for_line( v_requisition_header_id, 'JAINREQN', FOUND );
344: v_hook_value := 'TRUE';
345: /* If v_hook_value is TRUE, then it means taxes should be defaulted. IF FALSE then return */
346: v_hook_value := jai_cmn_hook_pkg.Po_Requisition_Lines_All
347: (
643: END IF;
644: --pramasub end FP
645: IF v_blanket_hdr IS NOT NULL AND v_blanket_line IS NOT NULL THEN
646:
647: jai_po_cmn_pkg.locate_source_line( v_blanket_hdr, v_blanket_line, v_line_quantity, v_po_line_id, v_line_location_id );
648:
649: /*IF v_line_location_id = -999 THEN --pramasub commented FP
650: -- code added by sriram to ensure that we do not have a duplicate requisition line_id
651: -- checking if the requisition line id is already created or not
1096:
1097: 4 22/07/2003 cbabu for Bug# 3051278, FileVersion# 616.1
1098: This fix is done to default the taxes onto PO Shipment line which got created through AutoCreate of
1099: Blanket Release from Purchase Requisition. If there is any change in UOM between
1100: requisition line and BPO Line, then PO Shipment quantity has to be given as input to jai_po_cmn_pkg.process_release_shipment
1101: procedure. But requisition quantity is going as input and this is causing the problem.
1102: Code is modified to pick PO Shipment quantity and give it as input to jai_po_cmn_pkg.process_release_shipment procedure
1103:
1104: 5 18/11/2003 Vijay Shankar for Bug# 3193592, FileVersion# 617.1
1098: This fix is done to default the taxes onto PO Shipment line which got created through AutoCreate of
1099: Blanket Release from Purchase Requisition. If there is any change in UOM between
1100: requisition line and BPO Line, then PO Shipment quantity has to be given as input to jai_po_cmn_pkg.process_release_shipment
1101: procedure. But requisition quantity is going as input and this is causing the problem.
1102: Code is modified to pick PO Shipment quantity and give it as input to jai_po_cmn_pkg.process_release_shipment procedure
1103:
1104: 5 18/11/2003 Vijay Shankar for Bug# 3193592, FileVersion# 617.1
1105: when multiple requisitions are merged to form a single PO Shipment during Autocreation process, then this trigger
1106: is erroring out as taxes from multiple requisition lines are getting populated into the same line_location_id.
1107: This is resolved by defaulting taxes from setup with an API call to jai_po_tax_pkg.ja_in_po_case2 procedure
1108: instead of carrying taxes from requisition lines to PO Shipment
1109:
1110: 6.02/08/2004 ssumaith - bug# 3729015 file version 115.1
1111: commented call to jai_po_cmn_pkg.process_release_shipment because in the ja_in_po_tax_insert_trg
1112: a hook has been implemented which defaults the taxes from a requisition to the release.
1113: and JAINPOCR concurrent is anyway called from ja_in_po_tax_insert_trg , hence the presense
1114: of the call is superfluous.
1115:
1345: */
1346: -- End of addition by Gsri on 07-MAR-2001
1347:
1348: if v_debug THEN
1349: UTL_FILE.PUT_LINE(v_myfilehandle,'777 jai_po_cmn_pkg.process_release_shipment ('''||'BLANKET'||''''
1350: ||','||v_src_ship_id || v_line_loc_id||',' ||v_po_line_id||',' ||v_po_hdr_id
1351: ||','||v_quantity||',' ||v_po_rel_id
1352: ||',' ||''''||TO_CHAR(v_cre_dt,'DD/MM/RRRR HH24:MI:SS')||''''||',' ||v_cre_by
1353: ||',' ||''''||TO_CHAR(v_last_upd_dt,'DD/MM/RRRR HH24:MI:SS')||''''||',' ||v_last_upd_by
1361: because in the ja_in_po_tax_insert_trg, because of a hook ,
1362: the taxes JAINPOCR concurrent is anyway called from ja_in_po_tax_insert_trg
1363:
1364:
1365: jai_po_cmn_pkg.process_release_shipment ( 'BLANKET',
1366: v_src_ship_id,
1367: v_line_loc_id,
1368: v_po_line_id,
1369: v_po_hdr_id,
1473: ||Po lines does not exists .
1474: ||Insert the line locations from requisition into po using the procedure below
1475: */
1476:
1477: jai_po_cmn_pkg.insert_line( 'STANDARD',
1478: v_line_loc_id, -- Bug 4513549
1479: v_po_hdr_id,
1480: v_po_line_id,
1481: v_cre_dt,
1639:
1640: IF NVL( v_assessable_value, 0 ) > 0 THEN
1641: -- Bug 4513549. Added by LGOPALSA
1642: v_assessable_value := v_assessable_value * v_quantity;
1643: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, v_assessable_value, v_po_curr, v_curr_conv_factor );
1644: ELSE
1645: v_assessable_value := Line_Tot;
1646: END IF;
1647:
1661: ELSE
1662: -- Bug 4513549.
1663: -- Added by LGOPALSA. Fix
1664: ln_vat_assess_value := ln_vat_assess_value * v_quantity;
1665: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, ln_vat_assess_value, v_po_curr, v_curr_conv_factor );
1666: END IF ;
1667: /* end rallamse bug#4250072 for VAT */
1668:
1669:
1666: END IF ;
1667: /* end rallamse bug#4250072 for VAT */
1668:
1669:
1670: 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 .
1671:
1672: /* Added ln_vat_assess_value for bug# for VAT */
1673: jai_po_tax_pkg.calculate_tax( 'STANDARDPO',
1674: v_po_hdr_id ,
1914: 7. 13-Jun-2005 File Version: 116.2
1915: Ramananda for bug#4428980. Removal of SQL LITERALs is done
1916:
1917: 8 06-Jul-2005 rallamse for bug# PADDR Elimination
1918: 1. Replaced call to jai_po_cmn_pkg.query_locator_for_line with
1919: jai_cmn_hook_pkg.Po_Requisition_Lines_All
1920:
1921: 9 04-Aug-2005 P1 Build Issue bug# 4535701 by Ramananda. File Version 120.2
1922: Commented the columns Event_Id and Line_Number.
1987: FETCH Bind_cur INTO v_seg_id, v_type_lookup_code , lv_apps_source_code;
1988: CLOSE bind_cur;
1989: --pramasub FP end
1990:
1991: --jai_po_cmn_pkg.query_locator_for_line( v_header_id, 'JAINREQN', found );
1992: v_hook_value := 'TRUE'; /* rallamse bug#4479131 PADDR Elimination */
1993: /* If v_hook_value is TRUE, then it means taxes should be defaulted. IF FALSE then return */
1994: v_hook_value := jai_cmn_hook_pkg.Po_Requisition_Lines_All
1995: (
2333: Delete From JAI_PO_REQ_LINE_TAXES --Ja_In_Reqn_Tax_Lines pramasub FP
2334: Where Requisition_Line_Id = v_line_id;
2335: IF v_blanket_hdr IS NOT NULL AND v_blanket_line IS NOT NULL THEN
2336: --Ja_In_Locate_Line( v_blanket_hdr, v_blanket_line, v_quantity, v_po_line_id, v_line_location_id );
2337: jai_po_cmn_pkg.locate_source_line( v_blanket_hdr, v_blanket_line, v_quantity, v_po_line_id,
2338: v_line_location_id );
2339: open c_reqn_line_id(v_line_id);
2340: fetch c_reqn_line_id into v_reqn_ctr;
2341: close c_reqn_line_id;
2590: 4. 13-Jun-2005 File Version: 116.2
2591: Ramananda for bug#4428980. Removal of SQL LITERALs is done
2592:
2593: 5 06-Jul-2005 rallamse for bug# PADDR Elimination
2594: 1. Replaced call to jai_po_cmn_pkg.query_locator_for_line with
2595: jai_cmn_hook_pkg.Po_Requisition_Lines_All
2596:
2597: 6 04-Aug-2005 P1 Build Issue bug# 4535701 by Ramananda. File Version 120.2
2598: Commented the columns Event_Id and Line_Number.
2650: -- return;
2651: --end if;
2652:
2653:
2654: --jai_po_cmn_pkg.query_locator_for_line( v_header_id, 'JAINREQN', found );
2655: v_hook_value := 'TRUE'; /* rallamse bug#4479131 PADDR Elimination */
2656: /* If v_hook_value is TRUE, then it means taxes should be defaulted. IF FALSE then return */
2657: v_hook_value := jai_cmn_hook_pkg.Po_Requisition_Lines_All
2658: (