APPS.PO_RELEASES_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

  PROCEDURE NAME:	lock_row_for_status_update

===========================================================================*/

PROCEDURE lock_row_for_status_update (x_po_release_id  IN  NUMBER)
IS
    CURSOR C IS
        SELECT 	*
        FROM   	po_releases
        WHERE   po_release_id = x_po_release_id
        FOR UPDATE of po_release_id NOWAIT;

Line: 29

        FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 40

	PO_MESSAGE_S.SQL_ERROR('LOCK_ROW_FOR_STATUS_UPDATE', x_progress, sqlcode);

Line: 47

  PROCEDURE NAME:	delete_release


===========================================================================*/
   PROCEDURE delete_release
		      (X_po_release_id IN NUMBER,
	               X_row_id        IN VARCHAR2) IS

      X_progress                VARCHAR2(3)  := '';

Line: 63

         ** Call the table handler to delete the release shipment row.
         */
   /* Bug 2904413 */
      X_progress := '010';

Line: 68

      SELECT wf_item_key, wf_item_type, release_type
      INTO   x_item_key, x_item_type, X_release_type
      FROM   po_releases
      WHERE  po_release_id = X_po_release_id;

Line: 84

       Delete From po_action_history
       Where OBJECT_TYPE_CODE = 'RELEASE' and
             OBJECT_SUB_TYPE_CODE = X_release_type and
             OBJECT_ID = X_po_release_id;

Line: 91

       fnd_attached_documents2_pkg.delete_attachments('PO_RELEASES', X_po_release_id,'', '', '', '', 'Y');

Line: 96

         po_releases_pkg_s2.delete_row(X_row_id);

Line: 100

	 ** Call the cover routine to delete all of the children
         */
         po_releases_sv.delete_children(X_po_release_id);

Line: 103

	 -- dbms_output.put_line('after delete children');

Line: 108

	  po_message_s.sql_error('delete_release', X_progress, sqlcode);

Line: 110

      END delete_release;

Line: 115

  PROCEDURE NAME:	delete_children


===========================================================================*/
   PROCEDURE delete_children
		      (X_po_release_id IN NUMBER) IS

      X_progress                VARCHAR2(3)  := '';

Line: 129

         SELECT line_location_id
         FROM   po_line_locations
         WHERE  po_release_id = X_po_release_id;

Line: 137

         ** Call the routine to delete all of the release shipments.
         */
         po_shipments_sv4.delete_all_shipments(X_po_release_id,
				  	       X_entity_level,
					       'NOT RFQ/QUOTE');

Line: 144

	 ** Call the routine to delete all of the release distributions.
	 */
	 po_distributions_sv.delete_distributions(X_po_release_id,
						  'RELEASE');

Line: 150

         ** Call the routine to delete all attachements.
	 */
	 fnd_attached_documents2_pkg.delete_attachments('PO_RELEASE',
				     X_po_release_id,
				     '', '', '', '', 'Y');

Line: 163

            fnd_attached_documents2_pkg.delete_attachments('PO_SHIPMENT',
                                     x_line_location_id,
                                     '', '', '', '', 'Y');

Line: 171

	 ** Call the routine to delete all notifications.
	 */

         /*hvadlamu : commenting out the delete and adding the workflow call*/

	 /*po_notifications_sv1.delete_po_notif ('RELEASE',
		           			X_po_release_id); */

Line: 178

	   SELECT wf_item_type,wf_item_key
       	   INTO   x_item_type,x_item_key
       	   FROM   PO_RELEASES
       	   WHERE  po_release_id = x_po_release_id;

Line: 198

	  po_message_s.sql_error('delete_children', X_progress, sqlcode);

Line: 199

      END delete_children;