[Home] [Help]
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
260: Forward porting the change in 11i bug 5365523 (Additional CVD Enhancement, Tax precedence, BOE).
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: (
348: pr_new.REQUISITION_LINE_ID,
349: pr_new.REQUISITION_HEADER_ID,
350: pr_new.LINE_NUM,
512: /* Bug4540709. Added by Lakshmig Gopalsami
513: * Reverting the fix for bug 4535701 */
514: /* pr_new.EVENT_ID,
515: pr_new.LINE_NUMBER*/ -- the above two lines commented by ssumaith - bug#4616729
516: NULL, /* the following two nulls are added by ssumaith because these two columns are not present in the table po_requisition_lines_all at this time */
517: NULL
518: ) ;
519:
520: --This change is done By Nagaraj.s for Bug#2381124
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.
1923: These will be uncommented once PO team's po_requisition_lines_all table has these columns
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.
1923: These will be uncommented once PO team's po_requisition_lines_all table has these columns
1924: 10 17-sep-05 p1 bug 4616729 - ssumaith - file version 120.3
1925: event_id and line_number columns have been commented and null is passes instead in calls to various hook packages
1926:
1927: 02/11/2006 for Bug 5228046, File version 120.2
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: (
1996: pr_new.REQUISITION_LINE_ID,
1997: pr_new.REQUISITION_HEADER_ID,
1998: pr_new.LINE_NUM,
2155: pr_new.BASE_UNIT_PRICE,
2156: pr_new.AT_SOURCING_FLAG,
2157: /*
2158: || Commented the columns for P1 bug# 4535701.
2159: || These will be uncommented once PO teams po_requisition_lines_all table has these columns
2160: */
2161: /* Bug4540709. Added by Lakshmig Gopalsami
2162: * Reverting the fix for bug 4535701 */
2163: /* pr_new.EVENT_ID, /*following 2 cols commented by ssumaith - bug# 4616729 and added the two null towards the end /*
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.
2599: These will be uncommented once PO team's po_requisition_lines_all table has these columns
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.
2599: These will be uncommented once PO team's po_requisition_lines_all table has these columns
2600: 7. 07-Nov-2008 JMEENA for bug#5394234
2601: Increased the length of variables v_sugg_vendor_name and v_sugg_vendor_loc from 80 to 360
2602:
2603: Dependency:
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: (
2659: pr_new.REQUISITION_LINE_ID,
2660: pr_new.REQUISITION_HEADER_ID,
2661: pr_new.LINE_NUM,
2818: pr_new.BASE_UNIT_PRICE,
2819: pr_new.AT_SOURCING_FLAG,
2820: /*
2821: || Commented the columns for P1 bug# 4535701.
2822: || These will be uncommented once PO teams po_requisition_lines_all table has these columns
2823: */
2824: /* Bug4540709. Added by Lakshmig Gopalsami
2825: * Reverting the fix for bug 4535701 */
2826: /* pr_new.EVENT_ID,/*following 2 cols commented by ssumaith - bug# 4616729 and added the two null towards the end /*