[Home] [Help]
54: v_created_by NUMBER ;--File.Sql.35 Cbabu := pr_new.Created_By;
55: v_last_update_date DATE ;--File.Sql.35 Cbabu := pr_new.Last_Update_Date;
56: v_last_updated_by NUMBER;--File.Sql.35 Cbabu := pr_new.Last_Updated_By;
57: v_last_update_login NUMBER ;--File.Sql.35 Cbabu := pr_new.Last_Update_Login;
58: v_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type := pr_new.modified_by_agent_flag; /*Added for Bug 8241905*/
59: v_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type := pr_new.parent_req_line_id; /*Added for Bug 8241905*/
60: conv_rate NUMBER;
61: p_tax_amount NUMBER;
62: v_assessable_value NUMBER;
55: v_last_update_date DATE ;--File.Sql.35 Cbabu := pr_new.Last_Update_Date;
56: v_last_updated_by NUMBER;--File.Sql.35 Cbabu := pr_new.Last_Updated_By;
57: v_last_update_login NUMBER ;--File.Sql.35 Cbabu := pr_new.Last_Update_Login;
58: v_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type := pr_new.modified_by_agent_flag; /*Added for Bug 8241905*/
59: v_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type := pr_new.parent_req_line_id; /*Added for Bug 8241905*/
60: conv_rate NUMBER;
61: p_tax_amount NUMBER;
62: v_assessable_value NUMBER;
63: ln_vat_assess_value NUMBER; -- Ravi for VAT
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
266: Forward porting the change in 11i bug 5365523 (Additional CVD Enhancement, Tax precedence, BOE).
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: (
364: pr_new.REQUISITION_LINE_ID,
365: pr_new.REQUISITION_HEADER_ID,
366: pr_new.LINE_NUM,
528: /* Bug4540709. Added by Lakshmig Gopalsami
529: * Reverting the fix for bug 4535701 */
530: /* pr_new.EVENT_ID,
531: pr_new.LINE_NUMBER*/ -- the above two lines commented by ssumaith - bug#4616729
532: 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 */
533: NULL
534: ) ;
535:
536: --This change is done By Nagaraj.s for Bug#2381124
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.
2054: These will be uncommented once PO team's po_requisition_lines_all table has these columns
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.
2054: These will be uncommented once PO team's po_requisition_lines_all table has these columns
2055: 10 17-sep-05 p1 bug 4616729 - ssumaith - file version 120.3
2056: event_id and line_number columns have been commented and null is passes instead in calls to various hook packages
2057:
2058: 02/11/2006 for Bug 5228046, File version 120.2
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: (
2130: pr_new.REQUISITION_LINE_ID,
2131: pr_new.REQUISITION_HEADER_ID,
2132: pr_new.LINE_NUM,
2289: pr_new.BASE_UNIT_PRICE,
2290: pr_new.AT_SOURCING_FLAG,
2291: /*
2292: || Commented the columns for P1 bug# 4535701.
2293: || These will be uncommented once PO teams po_requisition_lines_all table has these columns
2294: */
2295: /* Bug4540709. Added by Lakshmig Gopalsami
2296: * Reverting the fix for bug 4535701 */
2297: /* pr_new.EVENT_ID, /*following 2 cols commented by ssumaith - bug# 4616729 and added the two null towards the end /*
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.
2822: These will be uncommented once PO team's po_requisition_lines_all table has these columns
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.
2822: These will be uncommented once PO team's po_requisition_lines_all table has these columns
2823: 7. 07-Nov-2008 JMEENA for bug#5394234
2824: Increased the length of variables v_sugg_vendor_name and v_sugg_vendor_loc from 80 to 360
2825:
2826: Dependency:
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: (
2883: pr_new.REQUISITION_LINE_ID,
2884: pr_new.REQUISITION_HEADER_ID,
2885: pr_new.LINE_NUM,
3042: pr_new.BASE_UNIT_PRICE,
3043: pr_new.AT_SOURCING_FLAG,
3044: /*
3045: || Commented the columns for P1 bug# 4535701.
3046: || These will be uncommented once PO teams po_requisition_lines_all table has these columns
3047: */
3048: /* Bug4540709. Added by Lakshmig Gopalsami
3049: * Reverting the fix for bug 4535701 */
3050: /* pr_new.EVENT_ID,/*following 2 cols commented by ssumaith - bug# 4616729 and added the two null towards the end /*