[Home] [Help]
PACKAGE: APPS.PA_PAGE_LAYOUT_PVT
Source
1 PACKAGE PA_PAGE_LAYOUT_PVT AUTHID CURRENT_USER AS
2 --$Header: PAPRPLVS.pls 120.1 2005/08/19 16:44:54 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,
22
23 p_end_date IN date,
24 p_shortcut_menu_id IN number,
25 p_shortcut_menu_name IN VARCHAR2,
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,
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,
51
52 p_end_date IN date,
53 p_shortcut_menu_id IN number,
54 p_shortcut_menu_name IN VARCHAR2,
55 p_record_version_number IN NUMBER ,
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
63
64 PROCEDURE Delete_Page_Layout
65 (
66 p_api_version IN NUMBER := 1.0,
67 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
68 p_commit IN VARCHAR2 := FND_API.g_false,
69 p_validate_only IN VARCHAR2 := FND_API.g_true,
70 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
71
72 p_page_id IN number,
73 p_record_version_number IN NUMBER ,
74
75 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
76 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
77 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
78 ) ;
79
80
81 procedure ADD_PAGE_REGION (
82 p_api_version IN NUMBER := 1.0,
83 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
84 p_commit IN VARCHAR2 := FND_API.g_false,
85 p_validate_only IN VARCHAR2 := FND_API.g_true,
86 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
87 P_PAGE_ID in NUMBER,
88 P_REGION_SOURCE_TYPE in VARCHAR2,
89 P_REGION_SOURCE_CODE in VARCHAR2,
90 P_VIEW_REGION_CODE in VARCHAR2,
91 P_EDIT_REGION_CODE in VARCHAR2,
92 P_REGION_STYLE in VARCHAR2 default 'PA_UDS_SINGLE_COL',
93 P_DISPLAY_ORDER in NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
95 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
96 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
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,
108 P_REGION_SOURCE_TYPE in VARCHAR2,
109 P_REGION_SOURCE_CODE in VARCHAR2,
110 p_record_version_number IN NUMBER,
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 PROCEDURE Delete_All_Page_Region
118 (
119 p_api_version IN NUMBER := 1.0,
120 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
121 p_commit IN VARCHAR2 := FND_API.g_false,
122 p_validate_only IN VARCHAR2 := FND_API.g_true,
123 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
124
125 p_page_id IN NUMBER := null,
126 p_region_position IN VARCHAR2 := null,
127
128 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
129 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
130 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131 ) ;
132
133 PROCEDURE Delete_All_Link_Page_Region
134 (
135 p_api_version IN NUMBER := 1.0,
136 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
137 p_commit IN VARCHAR2 := FND_API.g_false,
138 p_validate_only IN VARCHAR2 := FND_API.g_true,
139 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
140
141 p_page_id IN NUMBER := null,
142 p_region_position IN VARCHAR2 := null,
143
144 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
145 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
146 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
147 ) ;
148
149 FUNCTION IS_REGION_DELETE_OK(p_region_source_type in varchar2,
150 p_region_source_code in varchar2) return varchar2;
151
152 END PA_PAGE_LAYOUT_PVT;