APPS.PO_UDA_DATA_UTIL dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 46: FROM po_uda_ag_template_usages

42:
43: -- Checking if there exists a template usage for the specific template and attribute group id
44: SELECT 1
45: INTO l_count
46: FROM po_uda_ag_template_usages
47: WHERE TEMPLATE_ID = p_template_id
48: AND ATTRIBUTE_GROUP_ID = p_attr_grp_or_page_id
49: AND ROWNUM < 2;
50:

Line 62: FROM po_uda_ag_template_usages

58:
59: -- Collecting the usage code if there exists a template usage for the specific template and attribute group id
60: SELECT DISTINCT ATTRIBUTE_CATEGORY
61: INTO x_usage_code
62: FROM po_uda_ag_template_usages
63: WHERE TEMPLATE_ID = p_template_id
64: AND ATTRIBUTE_GROUP_ID = p_attr_grp_or_page_id;
65: x_found_status := 'true';
66:

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 1380: ' AND EXISTS (SELECT 1 from PO_UDA_AG_TEMPLATE_USAGES where template_id = ' || to_template_id ||

1376: l_dynamic_sql := ' SELECT EXTENSION_ID, EGO_EXTFWK_S.NEXTVAL '||
1377: ' FROM '||l_from_object_cr.l_object_ext_b_table||
1378: ' WHERE '||l_from_where_pk_sql ||
1379: ' DATA_LEVEL_ID = ' || l_from_data_level_id ||
1380: ' AND EXISTS (SELECT 1 from PO_UDA_AG_TEMPLATE_USAGES where template_id = ' || to_template_id ||
1381: ' AND attribute_group_id = ' ||
1382: '(SELECT ' || l_to_object_cr.l_ag_mapping_column || ' FROM po_uda_mappings WHERE ' || l_from_object_cr.l_ag_mapping_column || ' = ATTR_GROUP_ID)) ';
1383:
1384: IF PO_LOG.d_stmt THEN

Line 2784: select distinct(attribute_category) from po_uda_ag_template_usages

2780: l_attr_grp_ids PO_TBL_NUMBER;
2781: t_count NUMBER;
2782:
2783: cursor c_get_usages(p_template_id number) is
2784: select distinct(attribute_category) from po_uda_ag_template_usages
2785: where template_id = p_template_id;
2786:
2787: BEGIN
2788: IF (PO_LOG.d_proc) THEN

Line 2862: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

2858: t_count NUMBER;
2859: l_count NUMBER;
2860:
2861: CURSOR c_get_usages(p_template_id NUMBER) IS
2862: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
2863: WHERE template_id = p_template_id;
2864:
2865: BEGIN
2866:

Line 2949: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

2945: l_attr_grp_ids PO_TBL_NUMBER;
2946: t_count NUMBER;
2947:
2948: CURSOR c_get_usages(p_template_id NUMBER) IS
2949: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
2950: WHERE template_id = p_template_id;
2951:
2952: BEGIN
2953: IF (PO_LOG.d_proc) THEN

Line 4715: -- SQL Join: po_uda_ag_template_usages

4711:
4712: -- SQL What: Querying for attribute_group_id for a specific attribute category
4713: -- SQL Why: Need to attribute_group_id to copy specific attr grp uda data
4714: -- from base doc to mod
4715: -- SQL Join: po_uda_ag_template_usages
4716: SELECT attribute_group_id
4717: INTO l_attr_group_id
4718: FROM po_uda_ag_template_usages
4719: WHERE attribute2 = p_contract_type

Line 4718: FROM po_uda_ag_template_usages

4714: -- from base doc to mod
4715: -- SQL Join: po_uda_ag_template_usages
4716: SELECT attribute_group_id
4717: INTO l_attr_group_id
4718: FROM po_uda_ag_template_usages
4719: WHERE attribute2 = p_contract_type
4720: AND attribute1 = p_idc_type
4721: AND template_id = p_template_id
4722: AND attribute_category = p_attr_category;