The following lines contain the word 'select', 'insert', 'update' or 'delete':
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) := '';
-- dbms_output.put_line('Exception occurred in insert_into_po_notif');
PO_MESSAGE_S.SQL_ERROR('insert_into_po_notif', x_progress, sqlcode);
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) := '';
-- dbms_output.put_line('Exception occurred in update_fnd_notif');
PO_MESSAGE_S.SQL_ERROR('UPDATE_FND_NOTIF', x_progress, sqlcode);
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');
-- dbms_output.put_line('Exception occurred in update_po_notif');
PO_MESSAGE_S.SQL_ERROR('UPDATE_PO_NOTIF', x_progress, sqlcode);
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) := '';
po_message_s.sql_error('delete_from_po_notif', x_progress, sqlcode);
SELECT type_lookup_code
INTO x_fnd_type_code
FROM po_requisition_headers
WHERE requisition_header_id = x_object_id;
SELECT release_type
INTO x_fnd_type_code
FROM po_releases
WHERE po_release_id = x_object_id;
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) := '';
-- dbms_output.put_line('Exception occurred in insert_into_fnd_notif');
PO_MESSAGE_S.SQL_ERROR('INSERT_INTO_FND_NOTIF', x_progress, sqlcode);
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
SELECT ORG_ID
FROM FINANCIALS_SYSTEM_PARAMS_ALL;