APPS.PO_UDA_DATA_UTIL dependencies on PO_UDA_AG_TEMPLATES

Line 101: po_uda_AG_templates t

97: -- Checking if there exists a page with specific template
98: SELECT 1
99: INTO l_count
100: FROM EGO_PAGE_ENTRIES_B P,
101: po_uda_AG_templates t
102: WHERE P.PAGE_ID = p_attr_grp_or_page_id
103: AND t.TEMPLATE_ID = p_template_id
104: AND p.CLASSIFICATION_CODE = p_template_id || ''
105: AND ROWNUM < 2;

Line 459: FROM PO_UDA_AG_TEMPLATES

455: d_progress := 10;
456: -- Fetching the internal name and entity code for the template
457: SELECT ENTITY_CODE
458: INTO v_entity_type
459: FROM PO_UDA_AG_TEMPLATES
460: WHERE TEMPLATE_ID = p_template_id
461: AND ROWNUM = 1;
462:
463: IF PO_LOG.d_stmt THEN

Line 556: FROM PO_UDA_AG_TEMPLATES

552: d_progress := 10;
553: -- Fetching the internal name and entity code for the template
554: SELECT ENTITY_CODE
555: INTO v_entity_type
556: FROM PO_UDA_AG_TEMPLATES
557: WHERE TEMPLATE_ID = p_template_id
558: AND ROWNUM = 1;
559:
560: IF PO_LOG.d_stmt THEN

Line 623: FROM po_uda_AG_templates b, po_uda_ag_template_usages u

619: d_progress := 10;
620:
621: SELECT 1
622: INTO l_count
623: FROM po_uda_AG_templates b, po_uda_ag_template_usages u
624: WHERE u.template_id = b.template_id
625: AND b.template_id = p_template_id
626: AND u.ATTRIBUTE_CATEGORY = p_usage_code
627: AND ROWNUM < 2;

Line 970: FROM PO_UDA_AG_TEMPLATES

966: END IF;
967:
968: SELECT ENTITY_CODE
969: INTO from_attr_group_Type
970: FROM PO_UDA_AG_TEMPLATES
971: WHERE TEMPLATE_ID = from_template_id;
972:
973: SELECT ENTITY_CODE
974: INTO to_attr_group_type

Line 975: FROM PO_UDA_AG_TEMPLATES

971: WHERE TEMPLATE_ID = from_template_id;
972:
973: SELECT ENTITY_CODE
974: INTO to_attr_group_type
975: FROM PO_UDA_AG_TEMPLATES
976: WHERE TEMPLATE_ID = to_template_id;
977:
978: IF PO_LOG.d_stmt THEN
979: PO_LOG.stmt(d_module,d_progress,'from_attr_group_Type',from_attr_group_Type);

Line 1654: FROM PO_UDA_AG_TEMPLATES

1650: d_progress := 010;
1651:
1652: SELECT ENTITY_CODE
1653: INTO l_attr_group_Type
1654: FROM PO_UDA_AG_TEMPLATES
1655: WHERE TEMPLATE_ID = x_template_id;
1656:
1657: IF PO_LOG.d_stmt THEN
1658: PO_LOG.stmt(d_module,d_progress,'l_attr_group_Type',l_attr_group_Type);

Line 1889: FROM PO_UDA_AG_TEMPLATES

1885: END IF;
1886:
1887: SELECT ENTITY_CODE
1888: INTO l_attr_group_Type
1889: FROM PO_UDA_AG_TEMPLATES
1890: WHERE TEMPLATE_ID = x_template_id;
1891:
1892: IF PO_LOG.d_stmt THEN
1893: PO_LOG.stmt(d_module,d_progress,'l_attr_group_Type',l_attr_group_Type);

Line 2388: FROM po_uda_ag_templates

2384: END IF;
2385:
2386: SELECT template_id
2387: INTO l_template_id
2388: FROM po_uda_ag_templates
2389: WHERE functional_area = p_functional_area
2390: AND document_level = p_document_level
2391: AND Nvl(document_type, '@@@') = Nvl(p_document_type, '@@@')
2392: AND Nvl(document_style_id , -1) = Nvl(p_document_style_id, -1)

Line 2583: FROM PO_UDA_AG_TEMPLATES

2579: END IF;
2580:
2581: SELECT ENTITY_CODE
2582: INTO l_attr_group_Type
2583: FROM PO_UDA_AG_TEMPLATES
2584: WHERE TEMPLATE_ID = p_template_id;
2585:
2586: IF PO_LOG.d_stmt THEN
2587: PO_LOG.stmt(d_module,d_progress,'l_attr_group_Type',l_attr_group_Type);