APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_UDA_AG_TEMPLATES

Line 98: FROM po_uda_ag_templates

94: */
95:
96: SELECT DISTINCT document_level
97: BULK COLLECT INTO x_doc_level_tbl
98: FROM po_uda_ag_templates
99: WHERE functional_area = p_func_area
100: AND ( p_doc_type IS NULL
101: OR document_type = p_doc_type
102: )

Line 490: FROM po_uda_ag_templates

486:
487: -- Determine the Attribute group type
488: SELECT entity_code
489: INTO l_ag_type
490: FROM po_uda_ag_templates
491: WHERE 1=1
492: AND functional_area = p_func_area
493: AND Nvl(document_type,'@@@') = Nvl(p_doc_type,'@@@')
494: AND Nvl(document_style_id,-99) = Nvl(p_doc_style,-99)

Line 2463: ,p_object_name => l_src_object_name --Get it from PO_UDA_AG_TEMPLATES

2459:
2460: l_progress := '080';
2461: ego_user_attrs_data_pvt.get_user_attrs_data(
2462: p_api_version => 1.0
2463: ,p_object_name => l_src_object_name --Get it from PO_UDA_AG_TEMPLATES
2464: ,p_pk_column_name_value_pairs => p_src_pk_col_name_val_pairs--Source Primary Keys
2465: ,p_attr_group_request_table => l_attr_group_request_table --Construct the Attribute Group Table
2466: ,x_attributes_row_table => x_attributes_row_table
2467: ,x_attributes_data_table => x_attributes_data_table

Line 2916: FROM po_uda_ag_templates

2912: );
2913: l_progress := '040';
2914: SELECT entity_code
2915: INTO l_entity_code
2916: FROM po_uda_ag_templates
2917: WHERE template_id = p_template_id;
2918:
2919: IF g_debug_stmt THEN
2920: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name

Line 3442: FROM PO_UDA_AG_TEMPLATES

3438: BEGIN
3439:
3440: SELECT ENTITY_CODE
3441: INTO l_attr_group_Type
3442: FROM PO_UDA_AG_TEMPLATES
3443: WHERE TEMPLATE_ID = x_src_template_id;
3444:
3445: IF g_debug_stmt THEN
3446: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name