DBA Data[Home] [Help]

APPS.IGW_BUDGET_DETAILS_PVT SQL Statements

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

Line: 84

  procedure update_budget_line
       (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     := NULL
	,p_version_id		            NUMBER     := NULL
        ,p_budget_period_id                 NUMBER     := NULL
        ,p_line_item_id                     NUMBER
        ,p_expenditure_type                 VARCHAR2
        ,p_expenditure_category_flag        VARCHAR2
        ,p_budget_category_code             VARCHAR2
        ,p_budget_category                  VARCHAR2
        ,p_line_item_description            VARCHAR2
        ,p_based_on_line_item               NUMBER     := NULL
        ,p_line_item_cost                   NUMBER
	,p_cost_sharing_amount	            NUMBER
	,p_underrecovery_amount	            NUMBER     := 0
        ,p_apply_inflation_flag             VARCHAR2
        ,p_budget_justification             LONG
        ,p_location_code                    VARCHAR2
        ,p_location                         VARCHAR2
        ,p_project_id                       NUMBER
	,p_project_number                   VARCHAR2
        ,p_task_id                          NUMBER
	,p_task_number                      VARCHAR2
        ,p_award_id                         NUMBER
	,p_award_number                     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: 120

END; --UPDATE BUDGET LINE
Line: 124

procedure delete_budget_line
       (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     := NULL
        ,p_version_id                   IN  NUMBER     := NULL
        ,p_budget_period_id                 NUMBER     := NULL
        ,p_line_item_id                     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: 141

END; --DELETE BUDGET LINE