APPS.PO_NOTIFICATIONS_SV2 SQL Statements

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

Line: 9

  PROCEDURE NAME:       insert_into_po_notif

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

PROCEDURE insert_into_po_notif (x_employee_id  	IN 	NUMBER,
			x_message_name		IN	VARCHAR2,
			x_doc_type		IN 	VARCHAR2,
			x_object_id		IN 	NUMBER,
			x_doc_creation_date	IN      DATE,
			x_start_effective_date  IN	DATE,
			x_end_effective_date	IN	DATE) IS

    x_approved_flag	VARCHAR2(255) := '';

Line: 38

	-- dbms_output.put_line('Exception occurred in insert_into_po_notif');

Line: 39

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

Line: 45

  PROCEDURE NAME:       update_fnd_notif

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

PROCEDURE update_fnd_notif (x_object_type_lookup_code	IN  VARCHAR2,
			    x_object_id			IN  NUMBER,
			    x_old_employee_id		IN  NUMBER,
			    x_new_employee_id		IN  NUMBER) IS
	x_type		  VARCHAR2(30) := '';

Line: 67

	-- dbms_output.put_line('Exception occurred in update_fnd_notif');

Line: 68

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

Line: 74

  PROCEDURE NAME:       update_po_notif

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

PROCEDURE update_po_notif (x_new_employee_id		NUMBER,
		           x_doc_type			VARCHAR2,
		           x_object_id		NUMBER)  IS
    x_user_id  		NUMBER  := FND_PROFILE.Value('USER_ID');

Line: 92

	-- dbms_output.put_line('Exception occurred in update_po_notif');

Line: 93

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

Line: 99

  PROCEDURE NAME:       delete_from_po_notif

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

PROCEDURE delete_from_po_notif (x_doc_type	IN	VARCHAR2,
			        x_object_id	IN	NUMBER) IS

	x_progress	VARCHAR2(3) := '';

Line: 115

       po_message_s.sql_error('delete_from_po_notif', x_progress, sqlcode);

Line: 196

	    SELECT  type_lookup_code
	    INTO    x_fnd_type_code
	    FROM    po_requisition_headers
	    WHERE   requisition_header_id = x_object_id;

Line: 208

	    SELECT  release_type
	    INTO    x_fnd_type_code
	    FROM    po_releases
	    WHERE   po_release_id = x_object_id;

Line: 290

  PROCEDURE NAME:       insert_into_fnd_notif

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

PROCEDURE insert_into_fnd_notif(n_object_type_lookup_code  IN  VARCHAR2,
			   n_object_id		      IN  NUMBER,
			   n_employee_id	      IN  NUMBER,
			   n_start_date_active	      IN  DATE,
			   n_end_date_active	      IN  DATE,
			   n_notification_id	      OUT NOCOPY NUMBER) IS
	x_dummy_str             VARCHAR2(30) := '';

Line: 325

	-- dbms_output.put_line('Exception occurred in insert_into_fnd_notif');

Line: 326

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

Line: 341

	x_last_update_date		DATE;

Line: 342

	x_last_updated_by		NUMBER;

Line: 343

	x_last_update_login		NUMBER;

Line: 362

            SELECT ORG_ID
            FROM   FINANCIALS_SYSTEM_PARAMS_ALL;