APPS.PO_UDA_TEMPLATES_UTIL dependencies on UDA_SETUP_METADATA_V

Line 4677: FROM po_uda_ag_template_usages ptu, uda_setup_metadata_v umv

4673: l_errorcode VARCHAR2(30);
4674:
4675: CURSOR c_get_association_id(p_usage_id NUMBER) IS
4676: SELECT ptu.association_id, ptu.attribute_group_id, ptu.template_id, umv.object_id
4677: FROM po_uda_ag_template_usages ptu, uda_setup_metadata_v umv
4678: WHERE ptu.usage_id = p_usage_id
4679: AND ptu.template_id = umv.template_id;
4680:
4681: CURSOR c_get_action_id(p_object_id NUMBER, p_template_id NUMBER, p_attribute_group_id NUMBER) IS

Line 4852: FROM uda_setup_metadata_v

4848: WHERE template_id = p_src_template_id;
4849:
4850: CURSOR c_get_temp_details(p_src_template_id NUMBER) IS
4851: SELECT object_id, DATA_LEVEL_NAME
4852: FROM uda_setup_metadata_v
4853: WHERE template_id = p_src_template_id;
4854:
4855: CURSOR c_gen_association_id IS
4856: SELECT EGO_ASSOCS_S.NEXTVAL

Line 5055: FROM uda_setup_metadata_v

5051: AND ATTRIBUTE_CATEGORY = p_usage_name ;
5052:
5053: CURSOR c_get_temp_details(p_src_template_id NUMBER) IS
5054: SELECT object_id, DATA_LEVEL_NAME
5055: FROM uda_setup_metadata_v
5056: WHERE template_id = p_src_template_id;
5057:
5058: CURSOR c_gen_association_id IS
5059: SELECT EGO_ASSOCS_S.NEXTVAL