APPS.PO_MASS_UPDATE_PO_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_PO_GRP';

Line: 47

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_supplier_id      IN NUMBER,
                         p_include_close_po IN VARCHAR2,
			 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: 63

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

Line: 72

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

Line: 85

SAVEPOINT Update_Persons_SP;

Line: 87

PO_Mass_Update_PO_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_supplier_id,
                                p_include_close_po,
				p_commit_interval,
				p_msg_data,
                                p_msg_count,
                                p_return_status);

Line: 107

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

Line: 121

ROLLBACK TO Update_Persons_SP;

Line: 133

END Update_Persons;