eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE BODY: APPS.PO_LINES_ALL_EXT_PKG

Source


1 PACKAGE BODY PO_LINES_ALL_EXT_PKG AS
2   /* $Header: PO_LINES_ALL_EXT_PKG.plb 120.1 2011/12/09 13:52:28 snelloru noship $ */
3 
4 procedure ADD_LANGUAGE
5 IS
6 
7 begin
8 
9 delete from po_lines_all_ext_tl T
10   where not exists
11     (select NULL
12     from po_lines_all_ext_b B
13     where B.EXTENSION_ID = T.EXTENSION_ID);
14 
15 
16 INSERT INTO PO_LINES_ALL_EXT_TL
17   (EXTENSION_ID
18   ,ATTR_GROUP_ID
19   ,PO_LINE_ID
20   ,DATA_LEVEL_ID
21   ,PK1_VALUE
22   ,PK2_VALUE
23   ,PK3_VALUE
24   ,PK4_VALUE
25   ,PK5_VALUE
26   ,LANGUAGE
27   ,SOURCE_LANG
28   ,LAST_UPDATE_DATE
29   ,LAST_UPDATED_BY
30   ,LAST_UPDATE_LOGIN
31   ,CREATED_BY
32   ,CREATION_DATE
33   ,TL_EXT_ATTR1
34   ,TL_EXT_ATTR2
35   ,TL_EXT_ATTR3
36   ,TL_EXT_ATTR4
37   ,TL_EXT_ATTR5
38   ,TL_EXT_ATTR6
39   ,TL_EXT_ATTR7
40   ,TL_EXT_ATTR8
41   ,TL_EXT_ATTR9
42   ,TL_EXT_ATTR10
43   ,TL_EXT_ATTR11
44   ,TL_EXT_ATTR12
45   ,TL_EXT_ATTR13
46   ,TL_EXT_ATTR14
47   ,TL_EXT_ATTR15
48   ,TL_EXT_ATTR16
49   ,TL_EXT_ATTR17
50   ,TL_EXT_ATTR18
51   ,TL_EXT_ATTR19
52   ,TL_EXT_ATTR20
53   ,TL_EXT_ATTR21
54   ,TL_EXT_ATTR22
55   ,TL_EXT_ATTR23
56   ,TL_EXT_ATTR24
57   ,TL_EXT_ATTR25
58   ,TL_EXT_ATTR26
59   ,TL_EXT_ATTR27
60   ,TL_EXT_ATTR28
61   ,TL_EXT_ATTR29
62   ,TL_EXT_ATTR30
63   ,TL_EXT_ATTR31
64   ,TL_EXT_ATTR32
65   ,TL_EXT_ATTR33
66   ,TL_EXT_ATTR34
67   ,TL_EXT_ATTR35
68   ,TL_EXT_ATTR36
69   ,TL_EXT_ATTR37
70   ,TL_EXT_ATTR38
71   ,TL_EXT_ATTR39
72   ,TL_EXT_ATTR40
73   ,UDA_TEMPLATE_ID
74   ,DRAFT_ID
75     )
76 	select
77    B.EXTENSION_ID
78   ,B.ATTR_GROUP_ID
79   ,B.PO_LINE_ID
80   ,B.DATA_LEVEL_ID
81   ,B.PK1_VALUE
82   ,B.PK2_VALUE
83   ,B.PK3_VALUE
84   ,B.PK4_VALUE
85   ,B.PK5_VALUE
86   ,l.language_code
87   ,B.SOURCE_LANG
88   ,B.LAST_UPDATE_DATE
89   ,B.LAST_UPDATED_BY
90   ,B.LAST_UPDATE_LOGIN
91   ,B.CREATED_BY
92   ,B.CREATION_DATE
93   ,B.TL_EXT_ATTR1
94   ,B.TL_EXT_ATTR2
95   ,B.TL_EXT_ATTR3
96   ,B.TL_EXT_ATTR4
97   ,B.TL_EXT_ATTR5
98   ,B.TL_EXT_ATTR6
99   ,B.TL_EXT_ATTR7
100   ,B.TL_EXT_ATTR8
101   ,B.TL_EXT_ATTR9
102   ,B.TL_EXT_ATTR10
103   ,B.TL_EXT_ATTR11
104   ,B.TL_EXT_ATTR12
105   ,B.TL_EXT_ATTR13
106   ,B.TL_EXT_ATTR14
107   ,B.TL_EXT_ATTR15
108   ,B.TL_EXT_ATTR16
109   ,B.TL_EXT_ATTR17
110   ,B.TL_EXT_ATTR18
111   ,B.TL_EXT_ATTR19
112   ,B.TL_EXT_ATTR20
113   ,B.TL_EXT_ATTR21
114   ,B.TL_EXT_ATTR22
115   ,B.TL_EXT_ATTR23
116   ,B.TL_EXT_ATTR24
117   ,B.TL_EXT_ATTR25
118   ,B.TL_EXT_ATTR26
119   ,B.TL_EXT_ATTR27
120   ,B.TL_EXT_ATTR28
121   ,B.TL_EXT_ATTR29
122   ,B.TL_EXT_ATTR30
123   ,B.TL_EXT_ATTR31
124   ,B.TL_EXT_ATTR32
125   ,B.TL_EXT_ATTR33
126   ,B.TL_EXT_ATTR34
127   ,B.TL_EXT_ATTR35
128   ,B.TL_EXT_ATTR36
129   ,B.TL_EXT_ATTR37
130   ,B.TL_EXT_ATTR38
131   ,B.TL_EXT_ATTR39
132   ,B.TL_EXT_ATTR40
133   ,B.UDA_TEMPLATE_ID
134   ,B.DRAFT_ID
135   from fnd_languages l, po_lines_all_ext_tl B
136   where l.installed_flag in ('I', 'B')
137   and  B.LANGUAGE = userenv('LANG')
138   and not exists
139       (select null
140        from   po_lines_all_ext_tl t
141        where  t.language = l.language_code
142        and    t.extension_id = B.extension_id);
143 
144 end ADD_LANGUAGE;
145 
146 
147 END PO_LINES_ALL_EXT_PKG;