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