DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PO_ADDRESS_DETAILS_GT

Line 6545: context := dbms_xmlgen.newContext(''select * from po_address_details_gt '');

6541: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
6542: PO_HR_LOCATION.populate_gt();
6543:
6544: BEGIN
6545: context := dbms_xmlgen.newContext(''select * from po_address_details_gt '');
6546: dbms_xmlgen.setRowsetTag(context,''ADDRESS_DETAILS'');
6547: dbms_xmlgen.setRowTag(context,''ADDRESS_DETAILS_ROW'');
6548: :xaddrDetails := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
6549: dbms_xmlgen.closeContext(context);

Line 6569: DELETE po_address_details_gt;

6565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'End of executing queries', l_time);
6566: END IF;
6567:
6568: /*Delete the records from global temp table*/
6569: DELETE po_address_details_gt;
6570: DELETE po_communication_gt ; -- Added this line for bug:3698674
6571:
6572:
6573: