eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE: APPS.PA_FP_EXCLUDED_ELEMENTS_PKG

Source


1 PACKAGE pa_fp_excluded_elements_pkg AUTHID CURRENT_USER as
2 /* $Header: PAFPXELS.pls 120.1 2005/08/19 16:32:11 mwasowic noship $ */
3 
4 G_PKG_NAME  CONSTANT VARCHAR2(30) := 'PA_FP_EXCLUDED_ELEMENTS_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPEXLS.pls';
6 
7 PROCEDURE Insert_Row
8 (
9  p_proj_fp_options_id           IN pa_fp_excluded_elements.proj_fp_options_id%TYPE    := Null
10 ,p_project_id                   IN pa_fp_excluded_elements.project_id%TYPE            := Null
11 ,p_fin_plan_type_id             IN pa_fp_excluded_elements.fin_plan_type_id%TYPE      := Null
12 ,p_element_type                 IN pa_fp_excluded_elements.element_type%TYPE          := Null
13 ,p_fin_plan_version_id          IN pa_fp_excluded_elements.fin_plan_version_id%TYPE   := Null
14 ,p_task_id                      IN pa_fp_excluded_elements.task_id%TYPE               := Null
15 ,x_row_id                       OUT NOCOPY ROWID --File.Sql.39 bug 4440895
16 ,x_return_status                OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
17 
18 PROCEDURE Update_Row
19 (
20  p_proj_fp_options_id           IN pa_fp_excluded_elements.proj_fp_options_id%TYPE    := Null
21 ,p_project_id                   IN pa_fp_excluded_elements.project_id%TYPE            := Null
22 ,p_fin_plan_type_id             IN pa_fp_excluded_elements.fin_plan_type_id%TYPE      := Null
23 ,p_element_type                 IN pa_fp_excluded_elements.element_type%TYPE          := Null
24 ,p_fin_plan_version_id          IN pa_fp_excluded_elements.fin_plan_version_id%TYPE   := Null
25 ,p_task_id                      IN pa_fp_excluded_elements.task_id%TYPE               := Null
26 ,p_record_version_number        IN pa_fp_excluded_elements.record_version_number%TYPE := Null
27 ,p_row_id                       IN ROWID                                              := Null
28 ,x_return_status                OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
29 
30 PROCEDURE Delete_Row
31 ( p_proj_fp_options_id          IN pa_fp_excluded_elements.proj_fp_options_id%TYPE    := Null
32  ,p_element_type                IN pa_fp_excluded_elements.element_type%TYPE          := Null
33  ,p_task_id                     IN pa_fp_excluded_elements.task_id%TYPE               := Null
34  ,p_row_id                      IN ROWID
35  ,p_record_version_number       IN NUMBER                                             := Null
36  ,x_return_status               OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
37 
38 PROCEDURE Lock_Row
39 ( p_row_id                         IN ROWID
40  ,p_record_version_number          IN NUMBER                                          := Null
41  ,x_return_status                  OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
42 
43 END pa_fp_excluded_elements_pkg;