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_TEMPLATES_UTIL dependencies on PO_UDA_AG_TEMPLATES

Line 308: FROM PO_UDA_AG_TEMPLATES

304: d_progress := 330;
305:
306: SELECT entity_code
307: INTO l_entity_type
308: FROM PO_UDA_AG_TEMPLATES
309: WHERE TEMPLATE_ID = p_template_id;
310:
311: d_progress := 335;
312:

Line 326: FROM PO_UDA_AG_TEMPLATES

322: FROM EGO_DATA_LEVEL_B
323: WHERE ATTR_GROUP_TYPE IN
324: (
325: SELECT ENTITY_CODE
326: FROM PO_UDA_AG_TEMPLATES
327: WHERE TEMPLATE_ID = p_template_id
328: )
329: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
330:

Line 499: FROM PO_UDA_AG_TEMPLATES temp

495: ,p_revision NUMBER
496: )
497: IS
498: SELECT temp.TEMPLATE_ID
499: FROM PO_UDA_AG_TEMPLATES temp
500: WHERE temp.FUNCTIONAL_AREA = NVL(p_functional_area_code, temp.FUNCTIONAL_AREA)
501: AND temp.DOCUMENT_TYPE = NVL(p_document_type_code, temp.DOCUMENT_TYPE)
502: AND temp.DOCUMENT_STYLE_ID = NVL(p_document_style_id, temp.DOCUMENT_STYLE_ID)
503: AND temp.DOCUMENT_LEVEL = NVL(p_level_code, temp.DOCUMENT_LEVEL)

Line 757: UPDATE PO_UDA_AG_TEMPLATES

753:
754: fnd_file.put(fnd_file.log, 'Before updating the flag');
755:
756:
757: UPDATE PO_UDA_AG_TEMPLATES
758: SET COMPILED_FLAG = 'Y'
759: WHERE TEMPLATE_ID = p_template_id;
760:
761: x_return_status := 'S';

Line 1055: FROM PO_UDA_AG_TEMPLATES

1051: ELSE
1052:
1053: SELECT ENTITY_CODE
1054: INTO l_entity_code
1055: FROM PO_UDA_AG_TEMPLATES
1056: WHERE TEMPLATE_ID = l_template_id;
1057:
1058: IF l_entity_code = 'PO_HEADER_EXT_ATTRS' THEN
1059: SELECT count(*)

Line 1159: FROM EGO_OBJECT_EXT_TABLES_B eb, fnd_objects fo, EGO_FND_DESC_FLEXS_EXT et, po_uda_ag_templates pt

1155: c_document_exists ref_cursor;
1156:
1157: CURSOR c_prod_table(p_template_id NUMBER) IS
1158: SELECT fo.DATABASE_OBJECT_NAME
1159: FROM EGO_OBJECT_EXT_TABLES_B eb, fnd_objects fo, EGO_FND_DESC_FLEXS_EXT et, po_uda_ag_templates pt
1160: WHERE eb.OBJECT_ID = fo.object_id
1161: AND eb.EXT_TABLE_NAME = et.APPLICATION_TL_TABLE_NAME
1162: AND et.DESCRIPTIVE_FLEXFIELD_NAME = pt.entity_code
1163: AND pt.template_id = p_template_id;

Line 3222: FROM po_uda_ag_templates

3218:
3219:
3220: CURSOR get_entity_code(p_template_id NUMBER) IS
3221: SELECT entity_code
3222: FROM po_uda_ag_templates
3223: WHERE template_id = p_template_id;
3224:
3225: BEGIN
3226:

Line 3279: UPDATE po_uda_ag_templates SET database_view_name = l_view_name

3275: -- EXECUTE IMMEDIATE (l_create_view);
3276: END IF;
3277:
3278: /*update database_view_name in po_ag_templates table*/
3279: UPDATE po_uda_ag_templates SET database_view_name = l_view_name
3280: WHERE template_id = p_template_id;
3281:
3282: x_template_view_name := l_view_name;
3283:

Line 3463: FROM po_uda_ag_templates

3459: l_functional_area VARCHAR2(25);
3460:
3461: CURSOR c_get_templ_dtls(p_template_id NUMBER) IS
3462: SELECT document_level, document_type, document_style_id, revision, functional_area
3463: FROM po_uda_ag_templates
3464: WHERE template_id = p_template_id;
3465:
3466:
3467: BEGIN

Line 3607: FROM po_uda_ag_templates pt, EGO_FND_DESC_FLEXS_EXT et

3603: j NUMBER ;
3604:
3605: CURSOR c_table_name(p_template_id NUMBER) IS
3606: SELECT pt.entity_code, et.APPLICATION_VL_NAME, et.APPLICATION_TL_TABLE_NAME
3607: FROM po_uda_ag_templates pt, EGO_FND_DESC_FLEXS_EXT et
3608: WHERE pt.template_id = p_template_id
3609: AND et.DESCRIPTIVE_FLEXFIELD_NAME = pt.entity_code;
3610:
3611: CURSOR c_attr_group_ids(p_template_id NUMBER) IS

Line 3788: FROM po_uda_ag_template_usages u, po_uda_ag_templates b

3784: WHERE et.DESCRIPTIVE_FLEXFIELD_NAME = p_entity_code;
3785:
3786: CURSOR c_attr_group_ids(p_entity_code VARCHAR2) IS
3787: SELECT DISTINCT(u.attribute_group_id)
3788: FROM po_uda_ag_template_usages u, po_uda_ag_templates b
3789: WHERE b.entity_code = p_entity_code
3790: AND b.template_id = u.template_id;
3791:
3792: CURSOR l_uda_attr_col_name(p_attr_grp_id NUMBER, p_entity_code VARCHAR2) IS

Line 4128: FROM po_uda_ag_templates

4124: l_functional_area VARCHAR2(25);
4125:
4126: CURSOR c_get_templ_dtls(p_template_id NUMBER) IS
4127: SELECT document_level, document_type, document_style_id, revision, functional_area
4128: FROM po_uda_ag_templates
4129: WHERE template_id = p_template_id;
4130:
4131: BEGIN
4132:

Line 4469: SELECT template_id, effective_from, revision FROM po_uda_ag_templates

4465: l_action_type VARCHAR2(50);
4466:
4467: CURSOR c_get_template_ids(p_functional_area VARCHAR2, p_document_type VARCHAR2,
4468: p_document_style_id NUMBER, p_document_level VARCHAR2) is
4469: SELECT template_id, effective_from, revision FROM po_uda_ag_templates
4470: WHERE functional_area = p_functional_area
4471: AND Nvl(document_type,'null') = Nvl(p_document_type, 'null')
4472: AND Nvl(document_style_id, -1) = Nvl(p_document_style_id,-1)
4473: AND document_level = p_document_level

Line 4476: FROM po_uda_ag_templates

4472: AND Nvl(document_style_id, -1) = Nvl(p_document_style_id,-1)
4473: AND document_level = p_document_level
4474: AND revision = (
4475: SELECT max(revision)
4476: FROM po_uda_ag_templates
4477: WHERE functional_area = p_functional_area
4478: AND Nvl(document_type,'null') = Nvl(p_document_type, 'null')
4479: AND Nvl(document_style_id, -1) = Nvl(p_document_style_id,-1)
4480: AND document_level = p_document_level);

Line 4500: SELECT revision INTO l_current_revision FROM po_uda_ag_templates WHERE template_id = p_template_id;

4496: CLOSE c_get_template_ids;
4497:
4498: d_progress := 10;
4499: IF p_template_id IS NOT NULL THEN
4500: SELECT revision INTO l_current_revision FROM po_uda_ag_templates WHERE template_id = p_template_id;
4501: IF l_current_revision < l_max_revision THEN
4502: RETURN NULL;
4503: END IF;
4504: END IF ;

Line 4554: FROM po_uda_ag_templates

4550:
4551: CURSOR c_get_template_ids(p_functional_area VARCHAR2, p_document_type VARCHAR2,
4552: p_document_style_id NUMBER, p_document_level VARCHAR2) is
4553: SELECT template_id
4554: FROM po_uda_ag_templates
4555: WHERE functional_area = p_functional_area
4556: AND Nvl(document_type, 'null') = Nvl(p_document_type, 'null')
4557: AND Nvl(document_style_id, -1) = Nvl(p_document_style_id, -1)
4558: AND document_level = p_document_level

Line 5271: FROM po_uda_ag_templates b

5267:
5268: CURSOR c_src_template_details(p_src_template_id NUMBER) IS
5269: SELECT b.template_id, b.ENTITY_CODE, b.FUNCTIONAL_AREA, b.DOCUMENT_LEVEL, b.DOCUMENT_TYPE, b.DOCUMENT_STYLE_ID, b.REVISION,
5270: b.SRC_TEMPLATE_ID
5271: FROM po_uda_ag_templates b
5272: WHERE b.template_id = p_src_template_id;
5273:
5274: CURSOR c_src_template_tl_details(p_src_template_id NUMBER) IS
5275: SELECT tl.display_name, tl.comments, tl.LANGUAGE, tl.SOURCE_LANG

Line 5276: FROM po_uda_ag_templates_tl tl

5272: WHERE b.template_id = p_src_template_id;
5273:
5274: CURSOR c_src_template_tl_details(p_src_template_id NUMBER) IS
5275: SELECT tl.display_name, tl.comments, tl.LANGUAGE, tl.SOURCE_LANG
5276: FROM po_uda_ag_templates_tl tl
5277: WHERE tl.template_id = p_src_template_id;
5278:
5279: CURSOR c_gen_template_seq IS
5280: SELECT PO_UDA_AG_TEMPLATES_S.NEXTVAL FROM dual;

Line 5280: SELECT PO_UDA_AG_TEMPLATES_S.NEXTVAL FROM dual;

5276: FROM po_uda_ag_templates_tl tl
5277: WHERE tl.template_id = p_src_template_id;
5278:
5279: CURSOR c_gen_template_seq IS
5280: SELECT PO_UDA_AG_TEMPLATES_S.NEXTVAL FROM dual;
5281:
5282: BEGIN
5283: IF (PO_LOG.d_proc) THEN
5284: PO_LOG.proc_begin(d_module);

Line 5297: INSERT INTO po_uda_ag_templates (TEMPLATE_ID,

5293: CLOSE c_gen_template_seq;
5294:
5295: FOR c_src_template_details_rec IN c_src_template_details(p_src_template_id) LOOP
5296:
5297: INSERT INTO po_uda_ag_templates (TEMPLATE_ID,
5298: ENTITY_CODE,
5299: FUNCTIONAL_AREA,
5300: DOCUMENT_LEVEL,
5301: DOCUMENT_TYPE,

Line 5327: INSERT INTO po_uda_ag_templates_tl(template_id,

5323: END LOOP;
5324:
5325: FOR c_src_template_tl_details_rec IN c_src_template_tl_details(p_src_template_id) LOOP
5326:
5327: INSERT INTO po_uda_ag_templates_tl(template_id,
5328: display_name,
5329: comments,
5330: LANGUAGE,
5331: source_lang,

Line 5751: FROM po_uda_ag_templates_tl ptl,po_uda_ag_templates pt

5747:
5748: --Get the dummy classfication code,Revision -to display in the attribute group page
5749: SELECT ptl.display_name || ', Rev ' || pt.revision
5750: INTO l_dummy_classfication_code
5751: FROM po_uda_ag_templates_tl ptl,po_uda_ag_templates pt
5752: WHERE ptl.template_id = pt.template_id
5753: AND ptl.template_id = p_classification_code
5754: AND language = USERENV('LANG');
5755:

Line 5863: FROM po_uda_ag_templates_tl ptl,po_uda_ag_templates pt

5859:
5860: --Get the dummy classification code
5861: SELECT ptl.display_name || ', Rev ' || pt.revision
5862: INTO l_template_name
5863: FROM po_uda_ag_templates_tl ptl,po_uda_ag_templates pt
5864: WHERE ptl.template_id = pt.template_id
5865: AND ptl.template_id = l_template_id
5866: AND language = USERENV('LANG');
5867: