1 PACKAGE BODY JAI_JPO_LLT_TRIGGER_PKG AS
2 /* $Header: jai_jpo_llt_t.plb 120.0 2005/09/01 12:35:58 rallamse noship $ */
3
4 /*
5 REM +======================================================================+
6 REM NAME BRU_T1
7 REM
8 REM DESCRIPTION Called from trigger JAI_JPO_LLT_BRIUD_T1
9 REM
10 REM NOTES Refers to old trigger JAI_JPO_LLT_BRU_T1
11 REM
12 REM +======================================================================+
13 */
14 PROCEDURE BRU_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15 BEGIN
16 pv_return_code := jai_constants.successful ;
17 /*--------------------------------------------------------------------------------------------------------------------------
18 CHANGE HISTORY for FILENAME - ja_in_pllt_bu_trg.sql
19 S.No Date Author and Details
20 -------------------------------------------------
21 1. 30/12/2002 cbabu for Enhancement Porting from 11.0.3 Bug# 2427465, FileVersion# 615.1
22 Created for the enhancement. When user changes the tax name of the defaulated tax, then defaulted tax should
23 be treated as manual tax. If tax_category_id is NULL then the tax is identified as Manual tax.
24 This trigger makes defaulted tax to be converted into a manual tax if user changed the tax name attached
25 to the tax line.
26 2. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
27 DB Entity as required for CASE COMPLAINCE. Version 116.1
28 --------------------------------------------------------------------------------------------------------------------------*/
29
30 pr_new.tax_category_id := null;
31 END BRU_T1 ;
32
33 END JAI_JPO_LLT_TRIGGER_PKG ;