APPS.POR_UDA_PKG dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 28: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

24: t_count NUMBER;
25: l_count NUMBER;
26:
27: CURSOR c_get_usages(p_template_id NUMBER) IS
28: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
29: WHERE template_id = p_template_id;
30:
31: CURSOR c_get_usage_context(p_req_line_id NUMBER) IS
32: SELECT CONTRACT_TYPE FROM po_requisition_lines_all

Line 596: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

592: l_attr_grp_ids PO_TBL_NUMBER;
593: t_count NUMBER;
594:
595: CURSOR c_get_usages(p_template_id NUMBER) IS
596: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
597: WHERE template_id = p_template_id;
598:
599: BEGIN
600: IF (PO_LOG.d_proc) THEN

Line 671: FROM po_uda_ag_template_usages WHERE template_id = l_template_id

667: AND revision_num = p_revision_num;
668:
669: CURSOR c_get_add_agids_tbl(l_template_id NUMBER) IS
670: SELECT ATTRIBUTE_GROUP_ID
671: FROM po_uda_ag_template_usages WHERE template_id = l_template_id
672: AND ATTRIBUTE_CATEGORY = 'ADDRESS';
673:
674: BEGIN
675:

Line 1025: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

1021: l_msg_data VARCHAR2(4000);
1022: t_count NUMBER;
1023:
1024: CURSOR c_get_usages(p_template_id NUMBER) IS
1025: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
1026: WHERE template_id = p_template_id
1027: AND ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING';
1028:
1029: CURSOR c_get_lines(p_req_header_id NUMBER) IS

Line 1034: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

1030: SELECT requisition_line_id FROM po_requisition_lines_all
1031: WHERE requisition_header_id = p_req_header_id;
1032:
1033: CURSOR c_get_line_usages(p_template_id NUMBER) IS
1034: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
1035: WHERE template_id = p_template_id;
1036:
1037: CURSOR c_get_usage_context(p_req_line_id NUMBER) IS
1038: SELECT CONTRACT_TYPE FROM po_requisition_lines_all

Line 1186: PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

1182: SELECT extension_id, EGO_EXTFWK_S.NEXTVAL
1183: FROM PO_REQ_HEADERS_EXT_B
1184: WHERE REQUISITION_HEADER_ID = p_old_header_id
1185: AND ATTR_GROUP_ID in ( SELECT ATTR_GROUP_ID FROM
1186: PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
1187: WHERE usages.template_id = p_template_id
1188: AND usages.ATTRIBUTE1='Base Document'
1189: AND usages.ATTRIBUTE2='NA'
1190: AND usages.ATTRIBUTE_CATEGORY='DOCUMENT_NUMBERING'