DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PO_ADDRESS_DETAILS_GT

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

5500: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
5501: PO_HR_LOCATION.populate_gt();
5502:
5503: BEGIN
5504: context := dbms_xmlgen.newContext(''select * from po_address_details_gt '');
5505: dbms_xmlgen.setRowsetTag(context,''ADDRESS_DETAILS'');
5506: dbms_xmlgen.setRowTag(context,''ADDRESS_DETAILS_ROW'');
5507: :xaddrDetails := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
5508: dbms_xmlgen.closeContext(context);

Line 5528: DELETE po_address_details_gt;

5524: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'End of executing queries', l_time);
5525: END IF;
5526:
5527: /*Delete the records from global temp table*/
5528: DELETE po_address_details_gt;
5529: DELETE po_communication_gt ; -- Added this line for bug:3698674
5530:
5531:
5532: