APPS.PO_UDA_LOAD_TEMPLATES dependencies on PO_UDA_AG_TEMPLATES_TL

Line 103: INSERT INTO PO_UDA_AG_TEMPLATES_TL

99: );
100:
101: load_msg('load_templates: after intering base table');
102:
103: INSERT INTO PO_UDA_AG_TEMPLATES_TL
104: (
105: TEMPLATE_ID,
106: DISPLAY_NAME,
107: LANGUAGE,

Line 131: FROM PO_UDA_AG_TEMPLATES_TL T

127: FROM FND_LANGUAGES L
128: WHERE L.INSTALLED_FLAG in ('I', 'B')
129: AND NOT EXISTS
130: ( SELECT NULL
131: FROM PO_UDA_AG_TEMPLATES_TL T
132: WHERE T.TEMPLATE_ID = l_template_id
133: AND T.LANGUAGE = L.LANGUAGE_CODE);
134:
135:

Line 158: INSERT INTO PO_UDA_AG_TEMPLATES_TL

154: AND NVL(T.DOCUMENT_TYPE, '-1') = NVL(p_document_type, '-1')
155: AND NVL(T.DOCUMENT_STYLE_ID, -1) = decode (p_document_style, null, -1, 1)
156: );
157:
158: INSERT INTO PO_UDA_AG_TEMPLATES_TL
159: (
160: TEMPLATE_ID,
161: DISPLAY_NAME,
162: LANGUAGE,

Line 186: from PO_UDA_AG_TEMPLATES_TL T

182: FROM fnd_languages L
183: where L.INSTALLED_FLAG in ('I', 'B')
184: AND NOT EXISTS
185: ( select NULL
186: from PO_UDA_AG_TEMPLATES_TL T
187: where T.TEMPLATE_ID = l_template_id
188: and T.LANGUAGE = L.LANGUAGE_CODE);
189:
190: load_msg('load_templates: update mode : l_template_id ' ||l_template_id ||' l_revision '||l_revision ||' l_entity_code '|| l_entity_code || ' l_display_name ' || l_display_name );

Line 198: UPDATE PO_UDA_AG_TEMPLATES_TL

194: load_msg('load_templates: l_can_update'|| l_can_update);
195:
196: IF l_can_update = 'true' THEN
197:
198: UPDATE PO_UDA_AG_TEMPLATES_TL
199: SET COMMENTS = p_comments,
200: source_lang = USERENV('LANG')
201: WHERE TEMPLATE_ID = l_template_id
202: AND LANGUAGE = USERENV('LANG');

Line 327: UPDATE PO_UDA_AG_TEMPLATES_TL

323: load_msg('load_templates_nls: l_can_update'|| l_can_update);
324:
325: IF l_can_update = 'true' THEN
326:
327: UPDATE PO_UDA_AG_TEMPLATES_TL
328: SET DISPLAY_NAME = p_display_name,
329: COMMENTS = p_comments,
330: SOURCE_LANG = USERENV('LANG'),
331: LAST_UPDATE_DATE = SYSDATE,