23: */
24: --
25:
26: TYPE custom_region_items_type IS RECORD
27: ( customization_application_id ak_custom_region_items.customization_application_id%TYPE
28: , customization_code ak_custom_region_items.customization_code%TYPE
29: , region_application_id ak_custom_region_items.region_application_id%TYPE
30: , region_code ak_custom_region_items.region_code%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
24: --
25:
26: TYPE custom_region_items_type IS RECORD
27: ( customization_application_id ak_custom_region_items.customization_application_id%TYPE
28: , customization_code ak_custom_region_items.customization_code%TYPE
29: , region_application_id ak_custom_region_items.region_application_id%TYPE
30: , region_code ak_custom_region_items.region_code%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
25:
26: TYPE custom_region_items_type IS RECORD
27: ( customization_application_id ak_custom_region_items.customization_application_id%TYPE
28: , customization_code ak_custom_region_items.customization_code%TYPE
29: , region_application_id ak_custom_region_items.region_application_id%TYPE
30: , region_code ak_custom_region_items.region_code%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
26: TYPE custom_region_items_type IS RECORD
27: ( customization_application_id ak_custom_region_items.customization_application_id%TYPE
28: , customization_code ak_custom_region_items.customization_code%TYPE
29: , region_application_id ak_custom_region_items.region_application_id%TYPE
30: , region_code ak_custom_region_items.region_code%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
27: ( customization_application_id ak_custom_region_items.customization_application_id%TYPE
28: , customization_code ak_custom_region_items.customization_code%TYPE
29: , region_application_id ak_custom_region_items.region_application_id%TYPE
30: , region_code ak_custom_region_items.region_code%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
28: , customization_code ak_custom_region_items.customization_code%TYPE
29: , region_application_id ak_custom_region_items.region_application_id%TYPE
30: , region_code ak_custom_region_items.region_code%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
29: , region_application_id ak_custom_region_items.region_application_id%TYPE
30: , region_code ak_custom_region_items.region_code%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
37: , language ak_custom_region_items_tl.language%TYPE
30: , region_code ak_custom_region_items.region_code%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
37: , language ak_custom_region_items_tl.language%TYPE
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
31: , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
37: , language ak_custom_region_items_tl.language%TYPE
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
39: , created_by ak_custom_region_items_tl.created_by%TYPE
32: , attribute_code ak_custom_region_items.attribute_code%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
37: , language ak_custom_region_items_tl.language%TYPE
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
39: , created_by ak_custom_region_items_tl.created_by%TYPE
40: , creation_date ak_custom_region_items_tl.creation_date%TYPE
33: , property_name ak_custom_region_items.property_name%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
37: , language ak_custom_region_items_tl.language%TYPE
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
39: , created_by ak_custom_region_items_tl.created_by%TYPE
40: , creation_date ak_custom_region_items_tl.creation_date%TYPE
41: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
34: , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
37: , language ak_custom_region_items_tl.language%TYPE
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
39: , created_by ak_custom_region_items_tl.created_by%TYPE
40: , creation_date ak_custom_region_items_tl.creation_date%TYPE
41: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
42: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
35: , property_number_value ak_custom_region_items.property_number_value%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
37: , language ak_custom_region_items_tl.language%TYPE
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
39: , created_by ak_custom_region_items_tl.created_by%TYPE
40: , creation_date ak_custom_region_items_tl.creation_date%TYPE
41: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
42: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
43: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
36: , property_date_value ak_custom_region_items.property_date_value%TYPE
37: , language ak_custom_region_items_tl.language%TYPE
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
39: , created_by ak_custom_region_items_tl.created_by%TYPE
40: , creation_date ak_custom_region_items_tl.creation_date%TYPE
41: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
42: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
43: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
44: );
37: , language ak_custom_region_items_tl.language%TYPE
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
39: , created_by ak_custom_region_items_tl.created_by%TYPE
40: , creation_date ak_custom_region_items_tl.creation_date%TYPE
41: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
42: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
43: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
44: );
45:
38: , source_lang ak_custom_region_items_tl.source_lang%TYPE
39: , created_by ak_custom_region_items_tl.created_by%TYPE
40: , creation_date ak_custom_region_items_tl.creation_date%TYPE
41: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
42: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
43: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
44: );
45:
46: TYPE customizations_type IS RECORD
39: , created_by ak_custom_region_items_tl.created_by%TYPE
40: , creation_date ak_custom_region_items_tl.creation_date%TYPE
41: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
42: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
43: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
44: );
45:
46: TYPE customizations_type IS RECORD
47: ( customization_application_id ak_customizations.customization_application_id%TYPE
62: , function_name ak_customizations.function_name%TYPE
63: , developer_mode ak_customizations.developer_mode%TYPE
64: , name ak_customizations_tl.name%TYPE
65: , description ak_customizations_tl.description%TYPE
66: , language ak_custom_region_items_tl.language%TYPE
67: , source_lang ak_custom_region_items_tl.source_lang%TYPE
68: , created_by ak_custom_region_items_tl.created_by%TYPE
69: , creation_date ak_custom_region_items_tl.creation_date%TYPE
70: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
63: , developer_mode ak_customizations.developer_mode%TYPE
64: , name ak_customizations_tl.name%TYPE
65: , description ak_customizations_tl.description%TYPE
66: , language ak_custom_region_items_tl.language%TYPE
67: , source_lang ak_custom_region_items_tl.source_lang%TYPE
68: , created_by ak_custom_region_items_tl.created_by%TYPE
69: , creation_date ak_custom_region_items_tl.creation_date%TYPE
70: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
71: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
64: , name ak_customizations_tl.name%TYPE
65: , description ak_customizations_tl.description%TYPE
66: , language ak_custom_region_items_tl.language%TYPE
67: , source_lang ak_custom_region_items_tl.source_lang%TYPE
68: , created_by ak_custom_region_items_tl.created_by%TYPE
69: , creation_date ak_custom_region_items_tl.creation_date%TYPE
70: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
71: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
72: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
65: , description ak_customizations_tl.description%TYPE
66: , language ak_custom_region_items_tl.language%TYPE
67: , source_lang ak_custom_region_items_tl.source_lang%TYPE
68: , created_by ak_custom_region_items_tl.created_by%TYPE
69: , creation_date ak_custom_region_items_tl.creation_date%TYPE
70: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
71: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
72: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
73: );
66: , language ak_custom_region_items_tl.language%TYPE
67: , source_lang ak_custom_region_items_tl.source_lang%TYPE
68: , created_by ak_custom_region_items_tl.created_by%TYPE
69: , creation_date ak_custom_region_items_tl.creation_date%TYPE
70: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
71: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
72: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
73: );
74:
67: , source_lang ak_custom_region_items_tl.source_lang%TYPE
68: , created_by ak_custom_region_items_tl.created_by%TYPE
69: , creation_date ak_custom_region_items_tl.creation_date%TYPE
70: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
71: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
72: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
73: );
74:
75:
68: , created_by ak_custom_region_items_tl.created_by%TYPE
69: , creation_date ak_custom_region_items_tl.creation_date%TYPE
70: , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
71: , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
72: , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
73: );
74:
75:
76: -- PROCEDUREs
74:
75:
76: -- PROCEDUREs
77: --
78: -- creates rows into ak_custom_region_items and tl tables
79: --
80: PROCEDURE Create_Custom_Region_Items
81: ( p_api_version IN NUMBER
82: , p_commit IN VARCHAR2 := FND_API.G_FALSE
86: , x_msg_data OUT NOCOPY VARCHAR2
87: );
88: --
89: --
90: -- updates rows into ak_custom_region_items and tl tables
91: --
92: PROCEDURE Update_Custom_Region_Items
93: ( p_api_version IN NUMBER
94: , p_commit IN VARCHAR2 := FND_API.G_FALSE
98: , x_msg_data OUT NOCOPY VARCHAR2
99: );
100: --
101: --
102: -- delete row in ak_custom_region_items and tl tables
103: --
104: PROCEDURE Delete_Custom_Region_Items
105: ( p_api_version IN NUMBER
106: , p_commit IN VARCHAR2 := FND_API.G_FALSE
205: , x_msg_data OUT NOCOPY VARCHAR2
206: );
207: --
208: --
209: -- updates rows into ak_custom_region_items and tl tables
210: --
211: PROCEDURE Update_Custom_Region_Items_UI
212: ( p_api_version IN NUMBER
213: , p_commit IN VARCHAR2 := FND_API.G_FALSE
225: , x_msg_count OUT NOCOPY NUMBER
226: , x_msg_data OUT NOCOPY VARCHAR2
227: );
228: --
229: -- delete rows from ak_custom_region_items and tl tables
230: --
231: PROCEDURE Delete_Custom_Region_Items_UI
232: ( p_api_version IN NUMBER
233: , p_commit IN VARCHAR2 := FND_API.G_FALSE