28: -- Version Initial version number = 1.0
29: -- History Current version number = 1.0
30: --=======================================================
31: procedure CREATE_FLOW (
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: p_api_version_number IN NUMBER,
34: p_init_msg_tbl IN BOOLEAN := FALSE,
35: p_msg_count OUT NOCOPY NUMBER,
36: p_msg_data OUT NOCOPY VARCHAR2,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_flow_application_id IN NUMBER,
39: p_flow_code IN VARCHAR2,
40: p_name IN VARCHAR2,
41: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
43: p_creation_date IN DATE := FND_API.G_MISS_DATE,
44: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
38: p_flow_application_id IN NUMBER,
39: p_flow_code IN VARCHAR2,
40: p_name IN VARCHAR2,
41: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
43: p_creation_date IN DATE := FND_API.G_MISS_DATE,
44: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
39: p_flow_code IN VARCHAR2,
40: p_name IN VARCHAR2,
41: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
43: p_creation_date IN DATE := FND_API.G_MISS_DATE,
44: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
47: );
40: p_name IN VARCHAR2,
41: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
43: p_creation_date IN DATE := FND_API.G_MISS_DATE,
44: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
47: );
48:
41: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
43: p_creation_date IN DATE := FND_API.G_MISS_DATE,
44: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
47: );
48:
49:
42: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
43: p_creation_date IN DATE := FND_API.G_MISS_DATE,
44: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
45: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
46: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
47: );
48:
49:
50: --=======================================================
70: -- Version Initial version number = 1.0
71: -- History Current version number = 1.0
72: --=======================================================
73: procedure CREATE_PAGE (
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: p_api_version_number IN NUMBER,
76: p_init_msg_tbl IN BOOLEAN := FALSE,
77: p_msg_count OUT NOCOPY NUMBER,
78: p_msg_data OUT NOCOPY VARCHAR2,
81: p_flow_code IN VARCHAR2,
82: p_page_application_id IN NUMBER,
83: p_page_code IN VARCHAR2,
84: p_name IN VARCHAR2,
85: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
88: p_creation_date IN DATE := FND_API.G_MISS_DATE,
89: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
82: p_page_application_id IN NUMBER,
83: p_page_code IN VARCHAR2,
84: p_name IN VARCHAR2,
85: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
88: p_creation_date IN DATE := FND_API.G_MISS_DATE,
89: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
90: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
83: p_page_code IN VARCHAR2,
84: p_name IN VARCHAR2,
85: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
88: p_creation_date IN DATE := FND_API.G_MISS_DATE,
89: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
90: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
91: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
84: p_name IN VARCHAR2,
85: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
88: p_creation_date IN DATE := FND_API.G_MISS_DATE,
89: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
90: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
91: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
92: );
85: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
88: p_creation_date IN DATE := FND_API.G_MISS_DATE,
89: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
90: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
91: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
92: );
93:
86: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
88: p_creation_date IN DATE := FND_API.G_MISS_DATE,
89: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
90: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
91: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
92: );
93:
94: --=======================================================
87: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
88: p_creation_date IN DATE := FND_API.G_MISS_DATE,
89: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
90: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
91: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
92: );
93:
94: --=======================================================
95: -- Procedure CREATE_PAGE_REGION
121: -- Version Initial version number = 1.0
122: -- History Current version number = 1.0
123: --=======================================================
124: procedure CREATE_PAGE_REGION (
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: p_api_version_number IN NUMBER,
127: p_init_msg_tbl IN BOOLEAN := FALSE,
128: p_msg_count OUT NOCOPY NUMBER,
129: p_msg_data OUT NOCOPY VARCHAR2,
133: p_page_application_id IN NUMBER,
134: p_page_code IN VARCHAR2,
135: p_region_application_id IN NUMBER,
136: p_region_code IN VARCHAR2,
137: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
138: p_region_style IN VARCHAR2,
139: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
140: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
135: p_region_application_id IN NUMBER,
136: p_region_code IN VARCHAR2,
137: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
138: p_region_style IN VARCHAR2,
139: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
140: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_region_code IN VARCHAR2,
137: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
138: p_region_style IN VARCHAR2,
139: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
140: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
138: p_region_style IN VARCHAR2,
139: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
140: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
138: p_region_style IN VARCHAR2,
139: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
140: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
139: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
140: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
140: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
141: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
142: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
142: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
150: );
143: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
150: );
151:
144: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
150: );
151:
152: --=======================================================
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
150: );
151:
152: --=======================================================
153: -- Procedure CREATE_PAGE_REGION_ITEM
167: -- Version Initial version number = 1.0
168: -- History Current version number = 1.0
169: --=======================================================
170: procedure CREATE_PAGE_REGION_ITEM (
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_api_version_number IN NUMBER,
173: p_init_msg_tbl IN BOOLEAN := FALSE,
174: p_msg_count OUT NOCOPY NUMBER,
175: p_msg_data OUT NOCOPY VARCHAR2,
181: p_region_application_id IN NUMBER,
182: p_region_code IN VARCHAR2,
183: p_attribute_application_id IN NUMBER,
184: p_attribute_code IN VARCHAR2,
185: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
186: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
182: p_region_code IN VARCHAR2,
183: p_attribute_application_id IN NUMBER,
184: p_attribute_code IN VARCHAR2,
185: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
186: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190: p_creation_date IN DATE := FND_API.G_MISS_DATE,
183: p_attribute_application_id IN NUMBER,
184: p_attribute_code IN VARCHAR2,
185: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
186: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190: p_creation_date IN DATE := FND_API.G_MISS_DATE,
191: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
184: p_attribute_code IN VARCHAR2,
185: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
186: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190: p_creation_date IN DATE := FND_API.G_MISS_DATE,
191: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
185: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
186: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190: p_creation_date IN DATE := FND_API.G_MISS_DATE,
191: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
186: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190: p_creation_date IN DATE := FND_API.G_MISS_DATE,
191: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
194: );
187: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
188: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190: p_creation_date IN DATE := FND_API.G_MISS_DATE,
191: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
194: );
195:
188: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190: p_creation_date IN DATE := FND_API.G_MISS_DATE,
191: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
194: );
195:
196: --=======================================================
189: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190: p_creation_date IN DATE := FND_API.G_MISS_DATE,
191: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
192: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
193: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
194: );
195:
196: --=======================================================
197: -- Procedure CREATE_REGION_RELATION
211: -- Version Initial version number = 1.0
212: -- History Current version number = 1.0
213: --=======================================================
214: procedure CREATE_REGION_RELATION (
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: p_api_version_number IN NUMBER,
217: p_init_msg_tbl IN BOOLEAN := FALSE,
218: p_msg_count OUT NOCOPY NUMBER,
219: p_msg_data OUT NOCOPY VARCHAR2,
229: p_to_page_code IN VARCHAR2,
230: p_to_region_appl_id IN NUMBER,
231: p_to_region_code IN VARCHAR2,
232: p_application_id IN NUMBER,
233: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
234: p_creation_date IN DATE := FND_API.G_MISS_DATE,
235: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
236: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
237: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
230: p_to_region_appl_id IN NUMBER,
231: p_to_region_code IN VARCHAR2,
232: p_application_id IN NUMBER,
233: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
234: p_creation_date IN DATE := FND_API.G_MISS_DATE,
235: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
236: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
237: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
238: );
231: p_to_region_code IN VARCHAR2,
232: p_application_id IN NUMBER,
233: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
234: p_creation_date IN DATE := FND_API.G_MISS_DATE,
235: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
236: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
237: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
238: );
239:
232: p_application_id IN NUMBER,
233: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
234: p_creation_date IN DATE := FND_API.G_MISS_DATE,
235: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
236: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
237: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
238: );
239:
240: --=======================================================
233: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
234: p_creation_date IN DATE := FND_API.G_MISS_DATE,
235: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
236: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
237: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
238: );
239:
240: --=======================================================
241: -- Procedure DELETE_FLOW
262: -- Version Initial version number = 1.0
263: -- History Current version number = 1.0
264: --=======================================================
265: procedure DELETE_FLOW (
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: p_api_version_number IN NUMBER,
268: p_init_msg_tbl IN BOOLEAN := FALSE,
269: p_msg_count OUT NOCOPY NUMBER,
270: p_msg_data OUT NOCOPY VARCHAR2,
301: -- Version Initial version number = 1.0
302: -- History Current version number = 1.0
303: --=======================================================
304: procedure DELETE_PAGE (
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_api_version_number IN NUMBER,
307: p_init_msg_tbl IN BOOLEAN := FALSE,
308: p_msg_count OUT NOCOPY NUMBER,
309: p_msg_data OUT NOCOPY VARCHAR2,
344: -- Version Initial version number = 1.0
345: -- History Current version number = 1.0
346: --=======================================================
347: procedure DELETE_PAGE_REGION (
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349: p_api_version_number IN NUMBER,
350: p_init_msg_tbl IN BOOLEAN := FALSE,
351: p_msg_count OUT NOCOPY NUMBER,
352: p_msg_data OUT NOCOPY VARCHAR2,
391: -- Version Initial version number = 1.0
392: -- History Current version number = 1.0
393: --=======================================================
394: procedure DELETE_PAGE_REGION_ITEM (
395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
396: p_api_version_number IN NUMBER,
397: p_init_msg_tbl IN BOOLEAN := FALSE,
398: p_msg_count OUT NOCOPY NUMBER,
399: p_msg_data OUT NOCOPY VARCHAR2,
443: -- Version Initial version number = 1.0
444: -- History Current version number = 1.0
445: --=======================================================
446: procedure DELETE_REGION_RELATION (
447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: p_api_version_number IN NUMBER,
449: p_init_msg_tbl IN BOOLEAN := FALSE,
450: p_msg_count OUT NOCOPY NUMBER,
451: p_msg_data OUT NOCOPY VARCHAR2,
508: -- Version Initial version number = 1.0
509: -- History Current version number = 1.0
510: --===========================================================
511: procedure DOWNLOAD_FLOW (
512: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
513: p_api_version_number IN NUMBER,
514: p_init_msg_tbl IN BOOLEAN := FALSE,
515: p_msg_count OUT NOCOPY NUMBER,
516: p_msg_data OUT NOCOPY VARCHAR2,
514: p_init_msg_tbl IN BOOLEAN := FALSE,
515: p_msg_count OUT NOCOPY NUMBER,
516: p_msg_data OUT NOCOPY VARCHAR2,
517: p_return_status OUT NOCOPY VARCHAR2,
518: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
520: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
522: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL
515: p_msg_count OUT NOCOPY NUMBER,
516: p_msg_data OUT NOCOPY VARCHAR2,
517: p_return_status OUT NOCOPY VARCHAR2,
518: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
520: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
522: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL
523: );
516: p_msg_data OUT NOCOPY VARCHAR2,
517: p_return_status OUT NOCOPY VARCHAR2,
518: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
520: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
522: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL
523: );
524:
540: -- Version Initial version number = 1.0
541: -- History Current version number = 1.0
542: --=======================================================
543: procedure UPDATE_FLOW (
544: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
545: p_api_version_number IN NUMBER,
546: p_init_msg_tbl IN BOOLEAN := FALSE,
547: p_msg_count OUT NOCOPY NUMBER,
548: p_msg_data OUT NOCOPY VARCHAR2,
548: p_msg_data OUT NOCOPY VARCHAR2,
549: p_return_status OUT NOCOPY VARCHAR2,
550: p_flow_application_id IN NUMBER,
551: p_flow_code IN VARCHAR2,
552: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
553: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
549: p_return_status OUT NOCOPY VARCHAR2,
550: p_flow_application_id IN NUMBER,
551: p_flow_code IN VARCHAR2,
552: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
553: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557: p_creation_date IN DATE := FND_API.G_MISS_DATE,
550: p_flow_application_id IN NUMBER,
551: p_flow_code IN VARCHAR2,
552: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
553: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557: p_creation_date IN DATE := FND_API.G_MISS_DATE,
558: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
551: p_flow_code IN VARCHAR2,
552: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
553: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557: p_creation_date IN DATE := FND_API.G_MISS_DATE,
558: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
559: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
552: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
553: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557: p_creation_date IN DATE := FND_API.G_MISS_DATE,
558: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
559: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
560: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
553: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
554: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557: p_creation_date IN DATE := FND_API.G_MISS_DATE,
558: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
559: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
560: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
561: );
554: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557: p_creation_date IN DATE := FND_API.G_MISS_DATE,
558: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
559: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
560: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
561: );
562:
555: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557: p_creation_date IN DATE := FND_API.G_MISS_DATE,
558: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
559: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
560: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
561: );
562:
563: --=======================================================
556: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557: p_creation_date IN DATE := FND_API.G_MISS_DATE,
558: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
559: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
560: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
561: );
562:
563: --=======================================================
564: -- Procedure UPDATE_PAGE
581: -- Version Initial version number = 1.0
582: -- History Current version number = 1.0
583: --=======================================================
584: procedure UPDATE_PAGE (
585: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
586: p_api_version_number IN NUMBER,
587: p_init_msg_tbl IN BOOLEAN := FALSE,
588: p_msg_count OUT NOCOPY NUMBER,
589: p_msg_data OUT NOCOPY VARCHAR2,
591: p_flow_application_id IN NUMBER,
592: p_flow_code IN VARCHAR2,
593: p_page_application_id IN NUMBER,
594: p_page_code IN VARCHAR2,
595: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
596: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
598: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
592: p_flow_code IN VARCHAR2,
593: p_page_application_id IN NUMBER,
594: p_page_code IN VARCHAR2,
595: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
596: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
598: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
593: p_page_application_id IN NUMBER,
594: p_page_code IN VARCHAR2,
595: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
596: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
598: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601: p_creation_date IN DATE := FND_API.G_MISS_DATE,
594: p_page_code IN VARCHAR2,
595: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
596: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
598: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601: p_creation_date IN DATE := FND_API.G_MISS_DATE,
602: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
595: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
596: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
598: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601: p_creation_date IN DATE := FND_API.G_MISS_DATE,
602: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
603: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
596: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
598: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601: p_creation_date IN DATE := FND_API.G_MISS_DATE,
602: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
603: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
604: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
597: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
598: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601: p_creation_date IN DATE := FND_API.G_MISS_DATE,
602: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
603: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
604: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
605: );
598: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601: p_creation_date IN DATE := FND_API.G_MISS_DATE,
602: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
603: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
604: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
605: );
606:
599: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601: p_creation_date IN DATE := FND_API.G_MISS_DATE,
602: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
603: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
604: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
605: );
606:
607: --=======================================================
600: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601: p_creation_date IN DATE := FND_API.G_MISS_DATE,
602: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
603: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
604: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
605: );
606:
607: --=======================================================
608: -- Procedure UPDATE_PAGE_REGION
634: -- Version Initial version number = 1.0
635: -- History Current version number = 1.0
636: --=======================================================
637: procedure UPDATE_PAGE_REGION (
638: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
639: p_api_version_number IN NUMBER,
640: p_init_msg_tbl IN BOOLEAN := FALSE,
641: p_msg_count OUT NOCOPY NUMBER,
642: p_msg_data OUT NOCOPY VARCHAR2,
646: p_page_application_id IN NUMBER,
647: p_page_code IN VARCHAR2,
648: p_region_application_id IN NUMBER,
649: p_region_code IN VARCHAR2,
650: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
651: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
652: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
653: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_page_code IN VARCHAR2,
648: p_region_application_id IN NUMBER,
649: p_region_code IN VARCHAR2,
650: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
651: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
652: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
653: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
648: p_region_application_id IN NUMBER,
649: p_region_code IN VARCHAR2,
650: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
651: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
652: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
653: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
649: p_region_code IN VARCHAR2,
650: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
651: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
652: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
653: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
650: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
651: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
652: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
653: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
651: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
652: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
653: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659: p_creation_date IN DATE := FND_API.G_MISS_DATE,
652: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
653: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659: p_creation_date IN DATE := FND_API.G_MISS_DATE,
660: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
653: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659: p_creation_date IN DATE := FND_API.G_MISS_DATE,
660: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
661: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
654: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659: p_creation_date IN DATE := FND_API.G_MISS_DATE,
660: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
661: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
662: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
655: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659: p_creation_date IN DATE := FND_API.G_MISS_DATE,
660: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
661: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
662: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
663: );
656: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659: p_creation_date IN DATE := FND_API.G_MISS_DATE,
660: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
661: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
662: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
663: );
664:
657: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659: p_creation_date IN DATE := FND_API.G_MISS_DATE,
660: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
661: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
662: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
663: );
664:
665: --=======================================================
658: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659: p_creation_date IN DATE := FND_API.G_MISS_DATE,
660: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
661: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
662: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
663: );
664:
665: --=======================================================
666: -- Procedure UPDATE_PAGE_REGION_ITEM
680: -- Version Initial version number = 1.0
681: -- History Current version number = 1.0
682: --=======================================================
683: procedure UPDATE_PAGE_REGION_ITEM (
684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
685: p_api_version_number IN NUMBER,
686: p_init_msg_tbl IN BOOLEAN := FALSE,
687: p_msg_count OUT NOCOPY NUMBER,
688: p_msg_data OUT NOCOPY VARCHAR2,
694: p_region_application_id IN NUMBER,
695: p_region_code IN VARCHAR2,
696: p_attribute_application_id IN NUMBER,
697: p_attribute_code IN VARCHAR2,
698: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
699: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
701: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
695: p_region_code IN VARCHAR2,
696: p_attribute_application_id IN NUMBER,
697: p_attribute_code IN VARCHAR2,
698: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
699: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
701: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703: p_creation_date IN DATE := FND_API.G_MISS_DATE,
696: p_attribute_application_id IN NUMBER,
697: p_attribute_code IN VARCHAR2,
698: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
699: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
701: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703: p_creation_date IN DATE := FND_API.G_MISS_DATE,
704: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
697: p_attribute_code IN VARCHAR2,
698: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
699: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
701: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703: p_creation_date IN DATE := FND_API.G_MISS_DATE,
704: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
705: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
698: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
699: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
701: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703: p_creation_date IN DATE := FND_API.G_MISS_DATE,
704: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
705: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
706: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
699: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
700: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
701: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703: p_creation_date IN DATE := FND_API.G_MISS_DATE,
704: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
705: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
706: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
707: );
700: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
701: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703: p_creation_date IN DATE := FND_API.G_MISS_DATE,
704: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
705: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
706: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
707: );
708:
701: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703: p_creation_date IN DATE := FND_API.G_MISS_DATE,
704: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
705: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
706: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
707: );
708:
709: --=======================================================
702: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703: p_creation_date IN DATE := FND_API.G_MISS_DATE,
704: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
705: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
706: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
707: );
708:
709: --=======================================================
710: -- Procedure UPDATE_REGION_RELATION
724: -- Version Initial version number = 1.0
725: -- History Current version number = 1.0
726: --=======================================================
727: procedure UPDATE_REGION_RELATION (
728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729: p_api_version_number IN NUMBER,
730: p_init_msg_tbl IN BOOLEAN := FALSE,
731: p_msg_count OUT NOCOPY NUMBER,
732: p_msg_data OUT NOCOPY VARCHAR2,
741: p_to_page_appl_id IN NUMBER,
742: p_to_page_code IN VARCHAR2,
743: p_to_region_appl_id IN NUMBER,
744: p_to_region_code IN VARCHAR2,
745: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
746: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
747: p_creation_date IN DATE := FND_API.G_MISS_DATE,
748: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
749: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
742: p_to_page_code IN VARCHAR2,
743: p_to_region_appl_id IN NUMBER,
744: p_to_region_code IN VARCHAR2,
745: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
746: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
747: p_creation_date IN DATE := FND_API.G_MISS_DATE,
748: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
749: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
750: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
743: p_to_region_appl_id IN NUMBER,
744: p_to_region_code IN VARCHAR2,
745: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
746: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
747: p_creation_date IN DATE := FND_API.G_MISS_DATE,
748: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
749: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
750: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
751: );
744: p_to_region_code IN VARCHAR2,
745: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
746: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
747: p_creation_date IN DATE := FND_API.G_MISS_DATE,
748: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
749: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
750: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
751: );
752:
745: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
746: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
747: p_creation_date IN DATE := FND_API.G_MISS_DATE,
748: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
749: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
750: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
751: );
752:
753: end AK_FLOW_GRP;
746: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
747: p_creation_date IN DATE := FND_API.G_MISS_DATE,
748: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
749: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
750: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
751: );
752:
753: end AK_FLOW_GRP;