[Home] [Help]
13: --
14: -- TEMPORARY
15: --=======================================================
16: procedure WRITE_CUSTOM_TO_BUFFER (
17: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: p_return_status OUT NOCOPY VARCHAR2,
19: p_region_application_id IN NUMBER,
20: p_region_code IN VARCHAR2,
21: p_custom_application_id IN NUMBER,
28: --
29: -- TEMPORARY
30: --=======================================================
31: procedure WRITE_CUST_REGION_TO_BUFFER (
32: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33: p_return_status OUT NOCOPY VARCHAR2,
34: p_region_application_id IN NUMBER,
35: p_region_code IN VARCHAR2,
36: p_custom_application_id IN NUMBER,
43: --
44: -- TEMPORARY
45: --=======================================================
46: procedure WRITE_CUST_REG_ITEM_TO_BUFFER (
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_return_status OUT NOCOPY VARCHAR2,
49: p_region_application_id IN NUMBER,
50: p_region_code IN VARCHAR2,
51: p_custom_application_id IN NUMBER,
58: --
59: -- TEMPORARY
60: --=======================================================
61: procedure WRITE_CRITERIA_TO_BUFFER (
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_return_status OUT NOCOPY VARCHAR2,
64: p_region_application_id IN NUMBER,
65: p_region_code IN VARCHAR2,
66: p_custom_application_id IN NUMBER,
93: -- Version Initial version number = 1.0
94: -- History Current version number = 1.0
95: --=======================================================
96: procedure CREATE_CUSTOM (
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: p_api_version_number IN NUMBER,
99: p_init_msg_tbl IN BOOLEAN := FALSE,
100: p_msg_count OUT NOCOPY NUMBER,
101: p_msg_data OUT NOCOPY VARCHAR2,
103: p_custom_appl_id IN NUMBER,
104: p_custom_code IN VARCHAR2,
105: p_region_appl_id IN NUMBER,
106: p_region_code IN VARCHAR2,
107: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
104: p_custom_code IN VARCHAR2,
105: p_region_appl_id IN NUMBER,
106: p_region_code IN VARCHAR2,
107: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_region_appl_id IN NUMBER,
106: p_region_code IN VARCHAR2,
107: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_region_code IN VARCHAR2,
107: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
107: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
111: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
112: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
115: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
116: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
124: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
117: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
124: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
125: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
118: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
124: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
125: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
126: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
119: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
124: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
125: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
126: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
127: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
120: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
124: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
125: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
126: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
127: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
128: p_pass IN NUMBER,
121: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
124: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
125: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
126: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
127: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
128: p_pass IN NUMBER,
129: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
122: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
124: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
125: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
126: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
127: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
128: p_pass IN NUMBER,
129: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
130: );
123: p_creation_date IN DATE := FND_API.G_MISS_DATE,
124: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
125: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
126: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
127: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
128: p_pass IN NUMBER,
129: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
130: );
131:
154: -- Version Initial version number = 1.0
155: -- History Current version number = 1.0
156: --=======================================================
157: procedure CREATE_CUST_REGION (
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: p_api_version_number IN NUMBER,
160: p_init_msg_tbl IN BOOLEAN := FALSE,
161: p_msg_count OUT NOCOPY NUMBER,
162: p_msg_data OUT NOCOPY VARCHAR2,
165: p_custom_code IN VARCHAR2,
166: p_region_appl_id IN NUMBER,
167: p_region_code IN VARCHAR2,
168: p_property_name IN VARCHAR2,
169: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
171: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
166: p_region_appl_id IN NUMBER,
167: p_region_code IN VARCHAR2,
168: p_property_name IN VARCHAR2,
169: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
171: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
167: p_region_code IN VARCHAR2,
168: p_property_name IN VARCHAR2,
169: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
171: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
175: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
168: p_property_name IN VARCHAR2,
169: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
171: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
175: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
176: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
171: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
175: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
176: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
177: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
170: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
171: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
175: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
176: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
177: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
178: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
171: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
172: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
175: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
176: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
177: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
178: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
179: p_pass IN NUMBER,
172: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
175: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
176: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
177: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
178: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
179: p_pass IN NUMBER,
180: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
173: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
175: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
176: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
177: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
178: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
179: p_pass IN NUMBER,
180: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
181: );
174: p_creation_date IN DATE := FND_API.G_MISS_DATE,
175: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
176: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
177: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
178: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
179: p_pass IN NUMBER,
180: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
181: );
182:
205: -- Version Initial version number = 1.0
206: -- History Current version number = 1.0
207: --=======================================================
208: procedure CREATE_CUST_REG_ITEM (
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: p_api_version_number IN NUMBER,
211: p_init_msg_tbl IN BOOLEAN := FALSE,
212: p_msg_count OUT NOCOPY NUMBER,
213: p_msg_data OUT NOCOPY VARCHAR2,
218: p_region_code IN VARCHAR2,
219: p_attr_appl_id IN NUMBER,
220: p_attr_code IN VARCHAR2,
221: p_property_name IN VARCHAR2,
222: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
224: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
219: p_attr_appl_id IN NUMBER,
220: p_attr_code IN VARCHAR2,
221: p_property_name IN VARCHAR2,
222: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
224: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
220: p_attr_code IN VARCHAR2,
221: p_property_name IN VARCHAR2,
222: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
224: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
228: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_property_name IN VARCHAR2,
222: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
224: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
228: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
229: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
222: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
224: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
228: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
229: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
230: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
223: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
224: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
228: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
229: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
230: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
231: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
224: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
228: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
229: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
230: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
231: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
232: p_pass IN NUMBER,
225: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
228: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
229: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
230: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
231: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
232: p_pass IN NUMBER,
233: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
226: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
228: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
229: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
230: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
231: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
232: p_pass IN NUMBER,
233: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
234: );
227: p_creation_date IN DATE := FND_API.G_MISS_DATE,
228: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
229: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
230: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
231: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
232: p_pass IN NUMBER,
233: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
234: );
235:
258: -- Version Initial version number = 1.0
259: -- History Current version number = 1.0
260: --=======================================================
261: procedure CREATE_CRITERIA (
262: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
263: p_api_version_number IN NUMBER,
264: p_init_msg_tbl IN BOOLEAN := FALSE,
265: p_msg_count OUT NOCOPY NUMBER,
266: p_msg_data OUT NOCOPY VARCHAR2,
271: p_region_code IN VARCHAR2,
272: p_attr_appl_id IN NUMBER,
273: p_attr_code IN VARCHAR2,
274: p_sequence_number IN NUMBER,
275: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
278: p_value_date IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
272: p_attr_appl_id IN NUMBER,
273: p_attr_code IN VARCHAR2,
274: p_sequence_number IN NUMBER,
275: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
278: p_value_date IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
273: p_attr_code IN VARCHAR2,
274: p_sequence_number IN NUMBER,
275: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
278: p_value_date IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
274: p_sequence_number IN NUMBER,
275: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
278: p_value_date IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
275: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
278: p_value_date IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
283: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
276: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
278: p_value_date IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
283: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
284: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
277: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
278: p_value_date IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
283: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
284: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
285: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
278: p_value_date IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
283: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
284: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
285: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
286: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
279: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
283: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
284: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
285: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
286: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
287: p_pass IN NUMBER,
280: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
283: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
284: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
285: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
286: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
287: p_pass IN NUMBER,
288: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
281: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
283: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
284: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
285: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
286: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
287: p_pass IN NUMBER,
288: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
289: );
282: p_creation_date IN DATE := FND_API.G_MISS_DATE,
283: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
284: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
285: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
286: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
287: p_pass IN NUMBER,
288: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
289: );
290:
446: -- Version Initial version number = 1.0
447: -- History Current version number = 1.0
448: --=======================================================
449: procedure UPDATE_CUSTOM (
450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: p_api_version_number IN NUMBER,
452: p_init_msg_tbl IN BOOLEAN := FALSE,
453: p_msg_count OUT NOCOPY NUMBER,
454: p_msg_data OUT NOCOPY VARCHAR2,
456: p_custom_appl_id IN NUMBER,
457: p_custom_code IN VARCHAR2,
458: p_region_application_id IN NUMBER,
459: p_region_code IN VARCHAR2,
460: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_custom_code IN VARCHAR2,
458: p_region_application_id IN NUMBER,
459: p_region_code IN VARCHAR2,
460: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_region_application_id IN NUMBER,
459: p_region_code IN VARCHAR2,
460: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_region_code IN VARCHAR2,
460: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
464: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
465: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
468: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
469: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
477: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
470: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
477: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
478: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
471: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
477: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
478: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
479: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
472: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
477: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
478: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
479: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
480: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
473: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
477: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
478: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
479: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
480: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
481: p_pass IN NUMBER,
474: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
477: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
478: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
479: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
480: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
481: p_pass IN NUMBER,
482: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
475: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
477: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
478: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
479: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
480: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
481: p_pass IN NUMBER,
482: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
483: );
476: p_creation_date IN DATE := FND_API.G_MISS_DATE,
477: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
478: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
479: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
480: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
481: p_pass IN NUMBER,
482: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
483: );
484:
505: -- Version Initial version number = 1.0
506: -- History Current version number = 1.0
507: --=======================================================
508: procedure UPDATE_CUST_REGION (
509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
510: p_api_version_number IN NUMBER,
511: p_init_msg_tbl IN BOOLEAN := FALSE,
512: p_msg_count OUT NOCOPY NUMBER,
513: p_msg_data OUT NOCOPY VARCHAR2,
516: p_custom_code IN VARCHAR2,
517: p_region_application_id IN NUMBER,
518: p_region_code IN VARCHAR2,
519: p_property_name IN VARCHAR2,
520: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
522: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
517: p_region_application_id IN NUMBER,
518: p_region_code IN VARCHAR2,
519: p_property_name IN VARCHAR2,
520: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
522: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
518: p_region_code IN VARCHAR2,
519: p_property_name IN VARCHAR2,
520: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
522: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
526: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
519: p_property_name IN VARCHAR2,
520: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
522: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
526: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
527: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
520: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
522: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
526: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
527: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
528: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
521: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
522: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
526: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
527: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
528: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
529: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
522: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
526: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
527: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
528: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
529: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
530: p_pass IN NUMBER,
523: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
526: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
527: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
528: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
529: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
530: p_pass IN NUMBER,
531: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
524: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
526: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
527: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
528: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
529: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
530: p_pass IN NUMBER,
531: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
532: );
525: p_creation_date IN DATE := FND_API.G_MISS_DATE,
526: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
527: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
528: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
529: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
530: p_pass IN NUMBER,
531: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
532: );
533:
554: -- Version Initial version number = 1.0
555: -- History Current version number = 1.0
556: --=======================================================
557: procedure UPDATE_CUST_REG_ITEM (
558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559: p_api_version_number IN NUMBER,
560: p_init_msg_tbl IN BOOLEAN := FALSE,
561: p_msg_count OUT NOCOPY NUMBER,
562: p_msg_data OUT NOCOPY VARCHAR2,
567: p_region_code IN VARCHAR2,
568: p_attribute_appl_id IN NUMBER,
569: p_attribute_code IN VARCHAR2,
570: p_property_name IN VARCHAR2,
571: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
573: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
568: p_attribute_appl_id IN NUMBER,
569: p_attribute_code IN VARCHAR2,
570: p_property_name IN VARCHAR2,
571: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
573: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
569: p_attribute_code IN VARCHAR2,
570: p_property_name IN VARCHAR2,
571: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
573: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
577: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
570: p_property_name IN VARCHAR2,
571: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
573: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
577: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
578: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
571: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
572: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
573: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
577: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
578: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
579: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
572: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
573: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
577: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
578: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
579: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
580: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
573: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
577: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
578: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
579: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
580: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
581: p_pass IN NUMBER,
574: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
577: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
578: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
579: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
580: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
581: p_pass IN NUMBER,
582: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
575: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
577: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
578: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
579: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
580: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
581: p_pass IN NUMBER,
582: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
583: );
576: p_creation_date IN DATE := FND_API.G_MISS_DATE,
577: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
578: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
579: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
580: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
581: p_pass IN NUMBER,
582: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
583: );
584:
605: -- Version Initial version number = 1.0
606: -- History Current version number = 1.0
607: --=======================================================
608: procedure UPDATE_CRITERIA (
609: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
610: p_api_version_number IN NUMBER,
611: p_init_msg_tbl IN BOOLEAN := FALSE,
612: p_msg_count OUT NOCOPY NUMBER,
613: p_msg_data OUT NOCOPY VARCHAR2,
618: p_region_code IN VARCHAR2,
619: p_attribute_appl_id IN NUMBER,
620: p_attribute_code IN VARCHAR2,
621: p_sequence_number IN NUMBER,
622: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
623: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
625: p_value_date IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
619: p_attribute_appl_id IN NUMBER,
620: p_attribute_code IN VARCHAR2,
621: p_sequence_number IN NUMBER,
622: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
623: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
625: p_value_date IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
620: p_attribute_code IN VARCHAR2,
621: p_sequence_number IN NUMBER,
622: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
623: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
625: p_value_date IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
621: p_sequence_number IN NUMBER,
622: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
623: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
625: p_value_date IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
622: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
623: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
625: p_value_date IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
630: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
623: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
624: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
625: p_value_date IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
630: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
631: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
624: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
625: p_value_date IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
630: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
631: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
632: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
625: p_value_date IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
630: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
631: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
632: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
633: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
626: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
630: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
631: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
632: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
633: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
634: p_pass IN NUMBER,
627: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
630: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
631: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
632: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
633: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
634: p_pass IN NUMBER,
635: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
628: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
630: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
631: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
632: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
633: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
634: p_pass IN NUMBER,
635: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
636: );
629: p_creation_date IN DATE := FND_API.G_MISS_DATE,
630: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
631: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
632: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
633: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
634: p_pass IN NUMBER,
635: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
636: );
637:
679: -- Version Initial version number = 1.0
680: -- History Current version number = 1.0
681: --=======================================================
682: procedure DOWNLOAD_CUSTOM (
683: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
684: p_api_version_number IN NUMBER,
685: p_return_status OUT NOCOPY VARCHAR2,
686: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
682: procedure DOWNLOAD_CUSTOM (
683: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
684: p_api_version_number IN NUMBER,
685: p_return_status OUT NOCOPY VARCHAR2,
686: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
688: p_nls_language IN VARCHAR2,
689: p_get_object_flag IN VARCHAR2,
690: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
686: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
687: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
688: p_nls_language IN VARCHAR2,
689: p_get_object_flag IN VARCHAR2,
690: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
691: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR
692: );
693:
694: --=======================================================
687: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
688: p_nls_language IN VARCHAR2,
689: p_get_object_flag IN VARCHAR2,
690: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
691: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR
692: );
693:
694: --=======================================================
695: -- Procedure INSERT_CUSTOM_PK_TABLE
760: -- Version Initial version number = 1.0
761: -- History Current version number = 1.0
762: --=======================================================
763: function VALIDATE_CUSTOM (
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_api_version_number IN NUMBER,
766: p_return_status OUT NOCOPY VARCHAR2,
767: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: function VALIDATE_CUSTOM (
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_api_version_number IN NUMBER,
766: p_return_status OUT NOCOPY VARCHAR2,
767: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_custom_application_id IN NUMBER := FND_API.G_MISS_NUM,
770: p_custom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_api_version_number IN NUMBER,
766: p_return_status OUT NOCOPY VARCHAR2,
767: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_custom_application_id IN NUMBER := FND_API.G_MISS_NUM,
770: p_custom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_api_version_number IN NUMBER,
766: p_return_status OUT NOCOPY VARCHAR2,
767: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_custom_application_id IN NUMBER := FND_API.G_MISS_NUM,
770: p_custom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
766: p_return_status OUT NOCOPY VARCHAR2,
767: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_custom_application_id IN NUMBER := FND_API.G_MISS_NUM,
770: p_custom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
767: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_custom_application_id IN NUMBER := FND_API.G_MISS_NUM,
770: p_custom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_custom_application_id IN NUMBER := FND_API.G_MISS_NUM,
770: p_custom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
769: p_custom_application_id IN NUMBER := FND_API.G_MISS_NUM,
770: p_custom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_custom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
782: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
775: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
782: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
783: p_end_date_Active IN DATE := FND_API.G_MISS_DATE,
776: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
782: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
783: p_end_date_Active IN DATE := FND_API.G_MISS_DATE,
784: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
777: p_default_custom_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
782: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
783: p_end_date_Active IN DATE := FND_API.G_MISS_DATE,
784: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
778: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
782: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
783: p_end_date_Active IN DATE := FND_API.G_MISS_DATE,
784: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_caller IN VARCHAR2,
779: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
782: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
783: p_end_date_Active IN DATE := FND_API.G_MISS_DATE,
784: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_caller IN VARCHAR2,
787: p_pass IN NUMBER := 2
780: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
782: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
783: p_end_date_Active IN DATE := FND_API.G_MISS_DATE,
784: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_caller IN VARCHAR2,
787: p_pass IN NUMBER := 2
788: ) return boolean;
781: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
782: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
783: p_end_date_Active IN DATE := FND_API.G_MISS_DATE,
784: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_caller IN VARCHAR2,
787: p_pass IN NUMBER := 2
788: ) return boolean;
789:
818: -- Version Initial version number = 1.0
819: -- History Current version number = 1.0
820: --=======================================================
821: function VALIDATE_CUST_REGION (
822: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
823: p_api_version_number IN NUMBER,
824: p_return_status OUT NOCOPY VARCHAR2,
825: p_region_application_id IN NUMBER,
826: p_region_code IN VARCHAR2,
825: p_region_application_id IN NUMBER,
826: p_region_code IN VARCHAR2,
827: p_custom_application_id IN NUMBER,
828: p_custom_code IN VARCHAR2,
829: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
830: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
831: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
832: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
833: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
826: p_region_code IN VARCHAR2,
827: p_custom_application_id IN NUMBER,
828: p_custom_code IN VARCHAR2,
829: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
830: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
831: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
832: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
833: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
834: p_caller IN VARCHAR2,
827: p_custom_application_id IN NUMBER,
828: p_custom_code IN VARCHAR2,
829: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
830: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
831: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
832: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
833: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
834: p_caller IN VARCHAR2,
835: p_pass IN NUMBER := 2
828: p_custom_code IN VARCHAR2,
829: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
830: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
831: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
832: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
833: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
834: p_caller IN VARCHAR2,
835: p_pass IN NUMBER := 2
836: ) return BOOLEAN;
829: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
830: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
831: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
832: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
833: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
834: p_caller IN VARCHAR2,
835: p_pass IN NUMBER := 2
836: ) return BOOLEAN;
837:
866: -- Version Initial version number = 1.0
867: -- History Current version number = 1.0
868: --=======================================================
869: function VALIDATE_CUST_REGION_ITEM (
870: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
871: p_api_version_number IN NUMBER,
872: p_return_status OUT NOCOPY VARCHAR2,
873: p_region_application_id IN NUMBER,
874: p_region_code IN VARCHAR2,
873: p_region_application_id IN NUMBER,
874: p_region_code IN VARCHAR2,
875: p_custom_application_id IN NUMBER,
876: p_custom_code IN VARCHAR2,
877: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
878: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
874: p_region_code IN VARCHAR2,
875: p_custom_application_id IN NUMBER,
876: p_custom_code IN VARCHAR2,
877: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
878: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
882: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_custom_application_id IN NUMBER,
876: p_custom_code IN VARCHAR2,
877: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
878: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
882: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_custom_code IN VARCHAR2,
877: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
878: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
882: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_caller IN VARCHAR2,
877: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
878: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
882: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_caller IN VARCHAR2,
885: p_pass IN NUMBER := 2
878: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
882: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_caller IN VARCHAR2,
885: p_pass IN NUMBER := 2
886: ) return BOOLEAN;
879: p_property_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
882: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_caller IN VARCHAR2,
885: p_pass IN NUMBER := 2
886: ) return BOOLEAN;
887:
916: -- Version Initial version number = 1.0
917: -- History Current version number = 1.0
918: --=======================================================
919: function VALIDATE_CRITERIA (
920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921: p_api_version_number IN NUMBER,
922: p_return_status OUT NOCOPY VARCHAR2,
923: p_region_application_id IN NUMBER,
924: p_region_code IN VARCHAR2,
923: p_region_application_id IN NUMBER,
924: p_region_code IN VARCHAR2,
925: p_custom_application_id IN NUMBER,
926: p_custom_code IN VARCHAR2,
927: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM,
930: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_region_code IN VARCHAR2,
925: p_custom_application_id IN NUMBER,
926: p_custom_code IN VARCHAR2,
927: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM,
930: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
925: p_custom_application_id IN NUMBER,
926: p_custom_code IN VARCHAR2,
927: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM,
930: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
933: p_value_date IN DATE := FND_API.G_MISS_DATE,
926: p_custom_code IN VARCHAR2,
927: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM,
930: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
933: p_value_date IN DATE := FND_API.G_MISS_DATE,
934: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
927: p_attr_appl_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM,
930: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
933: p_value_date IN DATE := FND_API.G_MISS_DATE,
934: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
935: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
928: p_attr_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM,
930: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
933: p_value_date IN DATE := FND_API.G_MISS_DATE,
934: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
935: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
936: p_caller IN VARCHAR2,
929: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM,
930: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
933: p_value_date IN DATE := FND_API.G_MISS_DATE,
934: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
935: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
936: p_caller IN VARCHAR2,
937: p_pass IN NUMBER := 2
930: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
933: p_value_date IN DATE := FND_API.G_MISS_DATE,
934: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
935: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
936: p_caller IN VARCHAR2,
937: p_pass IN NUMBER := 2
938: ) return BOOLEAN;
931: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
933: p_value_date IN DATE := FND_API.G_MISS_DATE,
934: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
935: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
936: p_caller IN VARCHAR2,
937: p_pass IN NUMBER := 2
938: ) return BOOLEAN;
939: end AK_CUSTOM_PVT;