APPS.PO_DATATEMPLATE_PKG dependencies on PO_UDA_PUB

Line 783: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,

779:
780: FUNCTION get_vendor_address_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB AS
781: v_clob_addr CLOB;
782: BEGIN
783: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
784: 'SUPPLIER_DTLS', NULL, 'HIDD_ADDRS_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;
785:
786: RETURN v_clob_addr;
787: END get_vendor_address_details;

Line 792: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,

788:
789: FUNCTION get_vendor_contact_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB AS
790: v_clob_addr CLOB;
791: BEGIN
792: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
793: 'SUPPLIER_DTLS', NULL, 'HIDD_CNTCT_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;
794:
795: RETURN v_clob_addr;
796: END get_vendor_contact_details;

Line 804: inv_office := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,

800: inv_office VARCHAR2 (1000);
801: pay_office VARCHAR2 (1000);
802: Begin
803:
804: inv_office := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
805: 'addresses', NULL, 'addresscode', 'INV_OFFICE', 'INTERNAL_VALUE');
806: pay_office := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
807: 'addresses', NULL, 'addresscode', 'PAY_OFFICE', 'INTERNAL_VALUE');
808:

Line 806: pay_office := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,

802: Begin
803:
804: inv_office := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
805: 'addresses', NULL, 'addresscode', 'INV_OFFICE', 'INTERNAL_VALUE');
806: pay_office := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
807: 'addresses', NULL, 'addresscode', 'PAY_OFFICE', 'INTERNAL_VALUE');
808:
809: IF (inv_office = pay_office)
810: then p_result := 'Y';

Line 929: l_supp_size := PO_UDA_PUB.get_single_attr_value(l_uda_template_id,

925: from po_headers_merge_v
926: where po_header_id = headerId
927: and draft_id = nvl(draftId, -1);
928:
929: l_supp_size := PO_UDA_PUB.get_single_attr_value(l_uda_template_id,
930: NULL, headerId, l_draft_id , NULL, NULL, NULL, NULL,
931: 'SUPPLIER_DTLS', NULL, 'SUPLR_SIZE', 'INTERNAL_VALUE');
932:
933: if l_supp_size is not null then