APPS.IGI_APPROVAL_PKG SQL Statements

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

Line: 26

PROCEDURE Update_Inv_Dists_To_Approved(p_invoice_id	 IN NUMBER,
			     	      p_user_id          IN NUMBER,
			     	      p_calling_sequence IN VARCHAR2);

Line: 30

PROCEDURE Update_Inv_Dists_To_Selected(p_invoice_id		IN NUMBER,
			     	       p_run_option		IN VARCHAR2,
			     	       p_calling_sequence	IN VARCHAR2);

Line: 85

			  p_last_updated_by		IN NUMBER,
			  p_last_update_login		IN NUMBER,
			  p_program_application_id	IN NUMBER,
			  p_program_id			IN NUMBER,
			  p_request_id			IN NUMBER,
			  p_system_user			IN NUMBER,
		   	  p_holds			IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
			  p_holds_count			IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
			  p_release_count		IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
			  p_calling_sequence		IN VARCHAR2);

Line: 97

			p_last_updated_by		IN NUMBER,
			p_last_update_login		IN NUMBER,
			p_calling_sequence		IN VARCHAR2);

Line: 329

PROCEDURE Update_Inv_Dists_To_Selected(p_invoice_id	IN NUMBER,
			     	     p_run_option	IN VARCHAR2,
			     	     p_calling_sequence	IN VARCHAR2) IS
BEGIN
NULL;

Line: 334

END Update_Inv_Dists_To_Selected;

Line: 773

			p_last_updated_by		IN NUMBER,
			p_last_update_login		IN NUMBER,
			p_calling_sequence		IN VARCHAR2) IS
BEGIN
NULL;

Line: 828

			  p_last_updated_by		IN NUMBER,
			  p_last_update_login		IN NUMBER,
			  p_program_application_id	IN NUMBER,
			  p_program_id			IN NUMBER,
			  p_request_id			IN NUMBER,
			  p_system_user			IN NUMBER,
		   	  p_holds			IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
			  p_holds_count			IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
			  p_release_count		IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
			  p_calling_sequence		IN VARCHAR2) IS
BEGIN
NULL;

Line: 850

PROCEDURE Update_Inv_Dists_To_Approved(p_invoice_id	  IN NUMBER,
			     	       p_user_id          IN NUMBER,
			     	       p_calling_sequence IN VARCHAR2) IS
BEGIN
NULL;

Line: 855

END  Update_Inv_Dists_To_Approved;