APPS.IGI_AP_CANCEL_PKG SQL Statements

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

Line: 8

  PROCEDURE Insert_Hold(P_invoice_id	   IN  VARCHAR2,
		        P_message_name	   IN  VARCHAR2,
		        P_last_updated_by  IN  NUMBER,
		        P_calling_sequence IN  VARCHAR2)
  IS
  BEGIN
   NULL;

Line: 15

  END Insert_Hold;

Line: 44

			            P_last_updated_by        IN  NUMBER,
				    P_last_update_login      IN  NUMBER,
			            P_set_of_books_id        IN  NUMBER,
			            P_accounting_date        IN  DATE,
			            P_period_name            IN  VARCHAR2,
				    P_message_name	     OUT NOCOPY VARCHAR2,
				    P_invoice_amount	     OUT NOCOPY NUMBER,
				    P_base_amount	     OUT NOCOPY NUMBER,
				    P_tax_amount	     OUT NOCOPY NUMBER,
				    P_temp_cancelled_amount  OUT NOCOPY NUMBER,
				    P_cancelled_by	     OUT NOCOPY NUMBER,
				    P_cancelled_amount	     OUT NOCOPY NUMBER,
				    P_cancelled_date         OUT NOCOPY DATE,
				    P_last_update_date       OUT NOCOPY DATE,
				    P_original_prepayment_amount OUT NOCOPY NUMBER,
				    P_calling_sequence       IN  VARCHAR2)
    RETURN BOOLEAN
  IS
  BEGIN
   NULL;

Line: 89

			       P_last_updated_by   IN  NUMBER,
			       P_last_update_login IN  NUMBER,
			       P_set_of_books_id   IN  NUMBER,
			       P_accounting_date   IN  DATE,
			       P_period_name       IN  VARCHAR2,
			       P_num_cancelled	   OUT NOCOPY NUMBER,
			       P_num_not_cancelled OUT NOCOPY NUMBER,
			       P_calling_sequence  IN  VARCHAR2)
  IS
  BEGIN
   NULL;