APPS.PO_XML_FPDSNG_PKG dependencies on PO_UDA_PUB

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

372:
373: FUNCTION get_vendor_address_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB AS
374: v_clob_addr CLOB;
375: BEGIN
376: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
377: 'SUPPLIER_DTLS', NULL, 'HIDD_ADDRS_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;
378:
379: RETURN v_clob_addr;
380: END get_vendor_address_details;

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

381:
382: FUNCTION get_vendor_contact_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB AS
383: v_clob_addr CLOB;
384: BEGIN
385: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
386: 'SUPPLIER_DTLS', NULL, 'HIDD_CNTCT_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;
387:
388: RETURN v_clob_addr;
389: END get_vendor_contact_details;

Line 396: l_addr_dodac := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(NULL, 'PO_HEADER_EXT_ATTRS', p_header_id, -1, NULL, NULL, NULL, NULL,

392: l_addr_dodac VARCHAR2 (1000);
393:
394: BEGIN
395: IF (p_draft_id = -1) then
396: l_addr_dodac := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(NULL, 'PO_HEADER_EXT_ATTRS', p_header_id, -1, NULL, NULL, NULL, NULL,
397: 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE');
398: ELSE
399: l_addr_dodac := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(NULL, 'PO_HEADER_EXT_ATTRS', p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
400: 'addresses', NULL, 'addresscode', 'MOD_ISSUING_OFFICE', 'DISPLAY_VALUE');

Line 399: l_addr_dodac := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(NULL, 'PO_HEADER_EXT_ATTRS', p_header_id, p_draft_id, NULL, NULL, NULL, NULL,

395: IF (p_draft_id = -1) then
396: l_addr_dodac := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(NULL, 'PO_HEADER_EXT_ATTRS', p_header_id, -1, NULL, NULL, NULL, NULL,
397: 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE');
398: ELSE
399: l_addr_dodac := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(NULL, 'PO_HEADER_EXT_ATTRS', p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
400: 'addresses', NULL, 'addresscode', 'MOD_ISSUING_OFFICE', 'DISPLAY_VALUE');
401: END IF;
402:
403: return(l_addr_dodac);