DBA Data[Home] [Help]

APPS.IGW_BUDGET_PERSONS_PVT SQL Statements

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

Line: 31

procedure UPDATE_SALARY
       (p_init_msg_list                 IN  VARCHAR2   := FND_API.G_TRUE
        ,p_commit                       IN  VARCHAR2   := FND_API.G_FALSE
        ,p_validate_only                IN  VARCHAR2   := FND_API.G_TRUE
	,p_proposal_id		            NUMBER
	,p_version_id		            NUMBER
  	,p_person_id		            NUMBER
        ,p_party_id			    NUMBER
        ,p_person_name                      VARCHAR2
  	,p_appointment_type_code	    VARCHAR2
        ,p_appointment_type                 VARCHAR2
  	,p_effective_date		    DATE
  	,p_calculation_base  	            NUMBER
        ,p_record_version_number        IN  NUMBER
        ,p_rowid                        IN  ROWID
        ,x_return_status                OUT NOCOPY VARCHAR2
        ,x_msg_count                    OUT NOCOPY NUMBER
        ,x_msg_data                     OUT NOCOPY VARCHAR2) IS


BEGIN
   null;
Line: 54

END; --UPDATE SALARY
Line: 57

procedure DELETE_SALARY
       (p_init_msg_list                 IN  VARCHAR2   := FND_API.G_TRUE
        ,p_commit                       IN  VARCHAR2   := FND_API.G_FALSE
        ,p_validate_only                IN  VARCHAR2   := FND_API.G_TRUE
        ,p_proposal_id                  IN  NUMBER
        ,p_version_id                   IN  NUMBER
        ,p_person_id                    IN  NUMBER
        ,p_party_id			    NUMBER
  	,p_appointment_type_code	IN  VARCHAR2
        ,p_record_version_number        IN  NUMBER
        ,p_rowid                        IN  ROWID
        ,x_return_status                OUT NOCOPY VARCHAR2
        ,x_msg_count                    OUT NOCOPY NUMBER
        ,x_msg_data                     OUT NOCOPY VARCHAR2) is


BEGIN
 null;
Line: 75

END; --DELETE BUDGET VERSION