39: -- Version Initial version number = 1.0
40: -- History Current version number = 1.0
41: --=======================================================
42: function VALIDATE_FLOW (
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_api_version_number IN NUMBER,
45: p_return_status OUT NOCOPY VARCHAR2,
46: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: function VALIDATE_FLOW (
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_api_version_number IN NUMBER,
45: p_return_status OUT NOCOPY VARCHAR2,
46: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
49: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_api_version_number IN NUMBER,
45: p_return_status OUT NOCOPY VARCHAR2,
46: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
49: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_api_version_number IN NUMBER,
45: p_return_status OUT NOCOPY VARCHAR2,
46: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
49: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_caller IN VARCHAR2,
45: p_return_status OUT NOCOPY VARCHAR2,
46: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
49: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_caller IN VARCHAR2,
53: p_pass IN NUMBER := 2
46: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
47: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
49: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_caller IN VARCHAR2,
53: p_pass IN NUMBER := 2
54: ) return BOOLEAN;
47: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
49: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_caller IN VARCHAR2,
53: p_pass IN NUMBER := 2
54: ) return BOOLEAN;
55:
84: -- Version Initial version number = 1.0
85: -- History Current version number = 1.0
86: --=======================================================
87: function VALIDATE_PAGE (
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: p_api_version_number IN NUMBER,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: function VALIDATE_PAGE (
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: p_api_version_number IN NUMBER,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: p_api_version_number IN NUMBER,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_api_version_number IN NUMBER,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_caller IN VARCHAR2,
92: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_caller IN VARCHAR2,
100: p_pass IN NUMBER := 2
93: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_caller IN VARCHAR2,
100: p_pass IN NUMBER := 2
101: ) return BOOLEAN;
94: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_caller IN VARCHAR2,
100: p_pass IN NUMBER := 2
101: ) return BOOLEAN;
102:
135: -- Version Initial version number = 1.0
136: -- History Current version number = 1.0
137: --=======================================================
138: function VALIDATE_PAGE_REGION (
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_api_version_number IN NUMBER,
141: p_return_status OUT NOCOPY VARCHAR2,
142: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: function VALIDATE_PAGE_REGION (
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_api_version_number IN NUMBER,
141: p_return_status OUT NOCOPY VARCHAR2,
142: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_api_version_number IN NUMBER,
141: p_return_status OUT NOCOPY VARCHAR2,
142: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_api_version_number IN NUMBER,
141: p_return_status OUT NOCOPY VARCHAR2,
142: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
141: p_return_status OUT NOCOPY VARCHAR2,
142: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
143: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
143: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_caller IN VARCHAR2,
149: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_caller IN VARCHAR2,
157: p_pass IN NUMBER := 2
150: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_caller IN VARCHAR2,
157: p_pass IN NUMBER := 2
158: ) return BOOLEAN;
151: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
153: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_caller IN VARCHAR2,
157: p_pass IN NUMBER := 2
158: ) return BOOLEAN;
159:
188: -- Version Initial version number = 1.0
189: -- History Current version number = 1.0
190: --=======================================================
191: function VALIDATE_PAGE_REGION_ITEM (
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: p_api_version_number IN NUMBER,
194: p_return_status OUT NOCOPY VARCHAR2,
195: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: function VALIDATE_PAGE_REGION_ITEM (
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: p_api_version_number IN NUMBER,
194: p_return_status OUT NOCOPY VARCHAR2,
195: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: p_api_version_number IN NUMBER,
194: p_return_status OUT NOCOPY VARCHAR2,
195: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_api_version_number IN NUMBER,
194: p_return_status OUT NOCOPY VARCHAR2,
195: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_return_status OUT NOCOPY VARCHAR2,
195: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
204: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
204: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
204: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
204: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_caller IN VARCHAR2,
200: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
204: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_caller IN VARCHAR2,
208: p_pass IN NUMBER := 2
201: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
204: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_caller IN VARCHAR2,
208: p_pass IN NUMBER := 2
209: ) return BOOLEAN;
202: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
204: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_caller IN VARCHAR2,
208: p_pass IN NUMBER := 2
209: ) return BOOLEAN;
210:
239: -- Version Initial version number = 1.0
240: -- History Current version number = 1.0
241: --=======================================================
242: function VALIDATE_REGION_RELATION (
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: p_api_version_number IN NUMBER,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: function VALIDATE_REGION_RELATION (
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: p_api_version_number IN NUMBER,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: p_api_version_number IN NUMBER,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_api_version_number IN NUMBER,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_caller IN VARCHAR2,
251: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_caller IN VARCHAR2,
259: p_pass IN NUMBER := 2
252: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_caller IN VARCHAR2,
259: p_pass IN NUMBER := 2
260: ) return BOOLEAN;
253: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_caller IN VARCHAR2,
259: p_pass IN NUMBER := 2
260: ) return BOOLEAN;
261: