1480:
1481: /*
1482: In cXML the deliverto information is provided as
1483:
1484: QUANTITY: PO_cXML_DELIVERTO_ARCH_V.QUANTITY ||
1485: NAME: || PO_cXML_DELIVERTO_ARCH_V.REQUESTOR ||
1486: ADDRESS: || PO_cXML_DELIVERTO_ARCH_V.all the address tags
1487:
1488: This is a helper function to concatinate all these values.
1481: /*
1482: In cXML the deliverto information is provided as
1483:
1484: QUANTITY: PO_cXML_DELIVERTO_ARCH_V.QUANTITY ||
1485: NAME: || PO_cXML_DELIVERTO_ARCH_V.REQUESTOR ||
1486: ADDRESS: || PO_cXML_DELIVERTO_ARCH_V.all the address tags
1487:
1488: This is a helper function to concatinate all these values.
1489: */
1482: In cXML the deliverto information is provided as
1483:
1484: QUANTITY: PO_cXML_DELIVERTO_ARCH_V.QUANTITY ||
1485: NAME: || PO_cXML_DELIVERTO_ARCH_V.REQUESTOR ||
1486: ADDRESS: || PO_cXML_DELIVERTO_ARCH_V.all the address tags
1487:
1488: This is a helper function to concatinate all these values.
1489: */
1490: Procedure get_cxml_deliverto_info(p_QUANTITY in number, p_REQUESTOR in varchar2,
1911: l_flag number;
1912:
1913: CURSOR deliverto_cur (headerid number, releaseid number) IS
1914: SELECT REQUESTOR
1915: FROM PO_CXML_DELIVERTO_ARCH_V
1916: WHERE PO_HEADER_ID = headerid
1917: AND ((PO_RELEASE_ID is null AND releaseid is null)
1918: OR PO_RELEASE_ID = releaseid
1919: );