APPS.PO_NOTIFICATIONS_SV3 SQL Statements

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

Line: 19

	-- Cursor C will select all approval-required notifications
	-- whose recipient id is x_old_employee_id.

    /* Commenting out since no longe rused in R11
	CURSOR C is
	    SELECT notification_id, doc_type, object_id
	    FROM   fnd_notifications
	    WHERE  employee_id = x_old_employee_id
	    AND    message_name = 'AWAITING_YOUR_APPROVAL'; */

Line: 42

	PO_NOTIFICATIONS_SV2.update_po_notif (x_new_employee_id,
				   x_doc_type,
				   x_object_id);

Line: 70

	-- Cursor C will select the approval-required notification
	-- for this document.

   /*  Commenting out since no longe rused in R11
	CURSOR C is
	    SELECT notification_id
	    FROM   fnd_notifications
	    WHERE  doc_type = x_doc_type
	    AND	   object_id = x_object_id
	    AND    message_name = 'AWAITING_YOUR_APPROVAL'; */

Line: 94

	PO_NOTIFICATIONS_SV2.update_po_notif (x_new_employee_id,
		    		   x_doc_type,
		  		   x_object_id);

Line: 111

  PROCEDURE NAME:       delete_from_fnd_notif

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

PROCEDURE delete_from_fnd_notif (n_object_type_lookup_code  IN VARCHAR2,
			   	 n_object_id	            IN NUMBER)
IS
	x_doc_type	VARCHAR2(30) := '';

Line: 134

	SELECT    doc_type
    	INTO      x_doc_type
    	FROM      fnd_notifications_v
    	WHERE     object_id = n_object_id
    	AND       doc_type IN ('PURCHASE', 'INTERNAL');

Line: 142

	SELECT    doc_type
    	INTO      x_doc_type
    	FROM      fnd_notifications_v
    	WHERE     object_id = n_object_id
    	AND       doc_type IN ('RELEASE', 'SCHEDULED');

Line: 150

	SELECT    doc_type
    	INTO      x_doc_type
    	FROM      fnd_notifications_v
    	WHERE     object_id = n_object_id
    	AND       doc_type = n_object_type_lookup_code;

Line: 163

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

Line: 172

    po_notifications_sv1.delete_notif_by_id_type(n_object_id, x_doc_type);

Line: 180

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

Line: 229

	 SELECT BLANKET_TOTAL_AMOUNT
	 INTO x_amount
	 FROM PO_HEADERS ph
	 WHERE ph.po_header_id = x_object_id;

Line: 270

    SELECT   FULL_NAME
      INTO   v_full_name
      FROM   HR_EMPLOYEES
     WHERE   EMPLOYEE_ID = x_emp_id;

Line: 289

    select orig_system_id
    from wf_users
    where name = x_role_name
    and orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');

Line: 295

    select orig_system_id
    from wf_users
    where orig_system = substr(x_role_name, 1, colon-1)
    and orig_system_id = substr(x_role_name, colon+1)
    and name = x_role_name
    and orig_system not in ('POS', 'ENG_LIST', 'CUST_CONT');