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:
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,
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:
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,
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,
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,
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,
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
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:
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,
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:
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,
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,
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,
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,
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
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:
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,
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,
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:
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:
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,
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',
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,
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:
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,
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',
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,
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:
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,
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,
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:
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:
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,
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,
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: