DBA Data[Home] [Help]

APPS.PO_LINES_ALL_EXT_PKG dependencies on PO_LINES_ALL_EXT_TL

Line 9: delete from po_lines_all_ext_tl T

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);

Line 16: INSERT INTO PO_LINES_ALL_EXT_TL

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

Line 135: from fnd_languages l, po_lines_all_ext_tl B

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

Line 140: from po_lines_all_ext_tl t

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;