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.

[Home] [Help]

APPS.PO_UDA_LOAD_TEMPLATES dependencies on PO_UDA_AG_TEMPLATES

Line 52: FROM PO_UDA_AG_TEMPLATES

48:
49:
50: SELECT COUNT(*)
51: INTO v_count
52: FROM PO_UDA_AG_TEMPLATES
53: WHERE NVL(FUNCTIONAL_AREA, '-1') = NVL(p_functional_area, '-1')
54: AND NVL(DOCUMENT_LEVEL, '-1') = NVL(p_document_level, '-1')
55: AND NVL(DOCUMENT_TYPE, '-1') = NVL(p_document_type, '-1')
56: AND NVL(DOCUMENT_STYLE_ID, -1) = DECODE(p_document_style, null, -1, 1);

Line 63: SELECT PO_UDA_AG_TEMPLATES_S.nextval

59: load_msg('load_templates: v_count ' || v_count);
60:
61: IF (v_count = 0) THEN
62:
63: SELECT PO_UDA_AG_TEMPLATES_S.nextval
64: INTO l_template_id
65: FROM DUAL
66: WHERE ROWNUM = 1;
67:

Line 70: INSERT INTO PO_UDA_AG_TEMPLATES

66: WHERE ROWNUM = 1;
67:
68: load_msg('load_templates: l_template_id '||l_template_id);
69:
70: INSERT INTO PO_UDA_AG_TEMPLATES
71: (
72: TEMPLATE_ID,
73: ENTITY_CODE,
74: LAST_UPDATE_DATE,

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 144: FROM PO_UDA_AG_TEMPLATES TB

140: load_msg('load_templates: in update mode');
141:
142: SELECT TB.TEMPLATE_ID, TB.REVISION, TB.ENTITY_CODE
143: INTO l_template_id, l_revision, l_entity_code
144: FROM PO_UDA_AG_TEMPLATES TB
145: WHERE NVL(TB.FUNCTIONAL_AREA, '-1') = NVL(p_functional_area, '-1')
146: AND NVL(TB.DOCUMENT_LEVEL, '-1') = NVL(p_document_level, '-1')
147: AND NVL(TB.DOCUMENT_TYPE, '-1') = NVL(p_document_type, '-1')
148: AND NVL(TB.DOCUMENT_STYLE_ID, -1) = decode (p_document_style, null, -1, 1)

Line 151: FROM PO_UDA_AG_TEMPLATES T

147: AND NVL(TB.DOCUMENT_TYPE, '-1') = NVL(p_document_type, '-1')
148: AND NVL(TB.DOCUMENT_STYLE_ID, -1) = decode (p_document_style, null, -1, 1)
149: AND TB.REVISION = (
150: SELECT MAX(T.REVISION)
151: FROM PO_UDA_AG_TEMPLATES T
152: WHERE NVL(T.FUNCTIONAL_AREA, '-1') = NVL(p_functional_area, '-1')
153: AND NVL(T.DOCUMENT_LEVEL, '-1') = NVL(p_document_level, '-1')
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)

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 206: UPDATE PO_UDA_AG_TEMPLATES

202: AND LANGUAGE = USERENV('LANG');
203:
204: load_msg('load_templates: updated comments ');
205:
206: UPDATE PO_UDA_AG_TEMPLATES
207: SET COMPILED_FLAG ='N'
208: WHERE TEMPLATE_ID = l_template_id;
209:
210: load_msg('load_templates: compile flag reset ');

Line 305: FROM PO_UDA_AG_TEMPLATES TB

301: load_msg('load_templates_nls: in update mode');
302:
303: SELECT TB.TEMPLATE_ID, TB.REVISION, TB.ENTITY_CODE
304: INTO l_template_id, l_revision, l_entity_code
305: FROM PO_UDA_AG_TEMPLATES TB
306: WHERE NVL(TB.FUNCTIONAL_AREA, '-1') = NVL(p_functional_area, '-1')
307: AND NVL(TB.DOCUMENT_LEVEL, '-1') = NVL(p_document_level, '-1')
308: AND NVL(TB.DOCUMENT_TYPE, '-1') = NVL(p_document_type, '-1')
309: AND NVL(TB.DOCUMENT_STYLE_ID, -1) = decode (p_document_style, null, -1, 1)

Line 312: FROM PO_UDA_AG_TEMPLATES T

308: AND NVL(TB.DOCUMENT_TYPE, '-1') = NVL(p_document_type, '-1')
309: AND NVL(TB.DOCUMENT_STYLE_ID, -1) = decode (p_document_style, null, -1, 1)
310: AND TB.REVISION = (
311: SELECT MAX(T.REVISION)
312: FROM PO_UDA_AG_TEMPLATES T
313: WHERE NVL(T.FUNCTIONAL_AREA, '-1') = NVL(p_functional_area, '-1')
314: AND NVL(T.DOCUMENT_LEVEL, '-1') = NVL(p_document_level, '-1')
315: AND NVL(T.DOCUMENT_TYPE, '-1') = NVL(p_document_type, '-1')
316: AND NVL(T.DOCUMENT_STYLE_ID, -1) = decode (p_document_style, null, -1, 1)

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,

Line 388: FROM PO_UDA_AG_TEMPLATES

384:
385:
386: SELECT ENTITY_CODE
387: INTO l_entity_code
388: FROM PO_UDA_AG_TEMPLATES
389: WHERE TEMPLATE_ID = g_pkg_template_id;
390:
391: BEGIN
392:

Line 568: FROM PO_UDA_AG_TEMPLATES

564: BEGIN
565:
566: SELECT ENTITY_CODE
567: INTO l_entity_code
568: FROM PO_UDA_AG_TEMPLATES
569: WHERE TEMPLATE_ID = g_pkg_template_id;
570:
571: SELECT OBJECT_ID
572: INTO l_object_id

Line 774: FROM PO_UDA_AG_TEMPLATES

770: load_msg ('LOAD_ACTIONS_NLS : g_pkg_template_id ' || g_pkg_template_id || ' p_object_name ' ||p_object_name || ' p_function_name ' || p_function_name);
771:
772: SELECT ENTITY_CODE
773: INTO l_entity_code
774: FROM PO_UDA_AG_TEMPLATES
775: WHERE TEMPLATE_ID = g_pkg_template_id;
776:
777: SELECT OBJECT_ID
778: INTO l_object_id

Line 862: FROM PO_UDA_AG_TEMPLATES

858: BEGIN
859:
860: SELECT ENTITY_CODE
861: INTO l_entity_code
862: FROM PO_UDA_AG_TEMPLATES
863: WHERE TEMPLATE_ID = g_pkg_template_id;
864:
865: SELECT DATA_LEVEL_ID
866: INTO l_data_level_id

Line 986: FROM PO_UDA_AG_TEMPLATES

982: BEGIN
983:
984: SELECT ENTITY_CODE
985: INTO l_entity_code
986: FROM PO_UDA_AG_TEMPLATES
987: WHERE TEMPLATE_ID = g_pkg_template_id;
988:
989: SELECT APPLICATION_ID
990: INTO l_app_id

Line 1125: FROM PO_UDA_AG_TEMPLATES

1121: BEGIN
1122:
1123: SELECT ENTITY_CODE
1124: INTO l_entity_code
1125: FROM PO_UDA_AG_TEMPLATES
1126: WHERE TEMPLATE_ID = g_pkg_template_id;
1127:
1128: BEGIN
1129: