APPS.PO_MASS_UPDATE_REQ_GRP SQL Statements

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

Line: 14

g_pkg_name CONSTANT VARCHAR2(100) := 'PO_Mass_Update_Req_GRP';

Line: 45

PROCEDURE Update_Persons(p_update_person    IN VARCHAR2,
                         p_old_personid     IN NUMBER,
                         p_new_personid     IN NUMBER,
                         p_document_type    IN VARCHAR2,
                         p_document_no_from IN VARCHAR2,
                         p_document_no_to   IN VARCHAR2,
                         p_date_from        IN DATE,
                         p_date_to          IN DATE,
                         p_commit_interval  IN NUMBER,
			 p_msg_data         OUT NOCOPY  VARCHAR2,
                         p_msg_count        OUT NOCOPY  NUMBER,
                         p_return_status    OUT NOCOPY  VARCHAR2) IS

l_progress                 VARCHAR2(3);

Line: 59

l_log_head                 CONSTANT VARCHAR2(1000) := g_log_head||'Update_Persons';

Line: 68

	PO_DEBUG.debug_var(l_log_head,l_progress,'p_update_person',p_update_person );

Line: 79

SAVEPOINT Update_Persons_SP;

Line: 81

PO_Mass_Update_Req_PVT.DO_Update(p_update_person,
                                 p_old_personid,
                                 p_new_personid,
                                 p_document_type,
                                 p_document_no_from,
                                 p_document_no_to,
                                 p_date_from,
                                 p_date_to,
                                 p_commit_interval,
				 p_msg_data,
                                 p_msg_count,
                                 p_return_status);

Line: 97

	PO_DEBUG.debug_var(l_log_head,l_progress,'After Calling Do_Update', 'After Calling Do_Update');

Line: 111

ROLLBACK TO Update_Persons_SP;

Line: 123

END Update_Persons;