DBA Data[Home] [Help]

PACKAGE: APPS.PA_PAGE_LAYOUT_PUB

Source


1 package PA_PAGE_LAYOUT_PUB AUTHID CURRENT_USER AS
2 --$Header: PAPRPLPS.pls 120.1 2005/08/19 16:44:45 mwasowic noship $
3 
4 --History
5 --    16-Feb-2004    svenketa - Modified, Added a parameter p_function_name for create and update.
6 
7 PROCEDURE Create_Page_Layout
8 (
9  p_api_version                 IN     NUMBER :=  1.0,
10  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
11  p_commit                      IN     VARCHAR2 := FND_API.g_false,
12  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
13  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
14 
15  p_page_name                   IN     VARCHAR2 := FND_API.g_miss_char,
16 
17  p_page_type                   IN     VARCHAR2 := FND_API.g_miss_char,
18 
19  p_description                 IN     VARCHAR2 := FND_API.g_miss_char,
20 
21  p_start_date                  IN     DATE := sysdate,
22 
23  p_end_date                    IN     DATE := null,
24  p_shortcut_menu_id            IN     NUMBER := FND_API.g_miss_num,
25  p_shortcut_menu_name          IN     VARCHAR2 := NULL,
26  P_FUNCTION_NAME	       IN     VARCHAR2 := NULL,
27  x_page_id                     OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
28  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
30  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
31    );
32 
33 
34  PROCEDURE Update_Page_Layout
35 (
36  p_api_version                 IN     NUMBER :=  1.0,
37  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
38  p_commit                      IN     VARCHAR2 := FND_API.g_false,
39  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
40  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
41 
42  p_page_id                     IN     NUMBER := null,
43 
44  p_page_name                   IN     VARCHAR2  := FND_API.g_miss_char,
45 
46 -- p_page_type                   IN     VARCHAR2 := FND_API.g_miss_char,
47 
48  p_description                 IN     VARCHAR2 := FND_API.g_miss_char,
49 
50  p_start_date                  IN     DATE := null,
51 
52  p_end_date                    IN     DATE := null,
53  p_shortcut_menu_id            IN     NUMBER := FND_API.g_miss_num,
54  p_shortcut_menu_name          IN     VARCHAR2 := NULL,
55  p_record_version_number       IN     NUMBER := null,
56  p_function_name	       IN     VARCHAR2 := NULL,
57  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
59  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60    ) ;
61 
62 PROCEDURE Delete_Page_Layout
63 (
64  p_api_version                 IN     NUMBER :=  1.0,
65  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
66  p_commit                      IN     VARCHAR2 := FND_API.g_false,
67  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
68  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
69 
70  p_page_id                     IN     NUMBER := null,
71  p_record_version_number       IN     NUMBER := null,
72 
73  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
75  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76  ) ;
77 
78 
79 procedure ADD_PAGE_REGION (
80  p_api_version                 IN     NUMBER :=  1.0,
81  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
82  p_commit                      IN     VARCHAR2 := FND_API.g_false,
83  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
84  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
85 
86   P_PAGE_ID in NUMBER := null,
87   P_REGION_SOURCE_TYPE in VARCHAR2 default 'STD',
88   P_REGION_SOURCE_CODE in VARCHAR2,
89   P_VIEW_REGION_CODE in VARCHAR2:= null,
90   P_EDIT_REGION_CODE in VARCHAR2:= null,
91   P_REGION_STYLE     in VARCHAR2:= null,
92   P_DISPLAY_ORDER in NUMBER := null,
93   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
94   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
95   x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96 );
97 
98 
99 PROCEDURE Delete_Page_Region
100 (
101  p_api_version                 IN     NUMBER :=  1.0,
102  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
103  p_commit                      IN     VARCHAR2 := FND_API.g_false,
104  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
105  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
106 
107  p_page_id                     IN     NUMBER := null,
108  P_REGION_SOURCE_TYPE          in     VARCHAR2 := 'STD',
109  P_REGION_SOURCE_CODE          in     VARCHAR2,
110  p_record_version_number       IN     NUMBER := null,
111 
112  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
113  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
114  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115   );
116 
117 
118 PROCEDURE Delete_All_Page_Region
119 (
120  p_api_version                 IN     NUMBER :=  1.0,
121  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
122  p_commit                      IN     VARCHAR2 := FND_API.g_false,
123  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
124  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
125 
126  p_page_id                     IN     NUMBER := null,
127  p_region_position             IN     VARCHAR2 := null,
128 
129  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
130  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
131  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132   ) ;
133 
134 PROCEDURE Delete_All_Link_Page_Region
135 (
136  p_api_version                 IN     NUMBER :=  1.0,
137  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
138  p_commit                      IN     VARCHAR2 := FND_API.g_false,
139  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
140  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
141 
142  p_page_id                     IN     NUMBER := null,
143  p_region_position             IN     VARCHAR2 := null,
144 
145  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
146  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
147  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
148  ) ;
149 
150 END  PA_PAGE_LAYOUT_PUB;