71: -- Version Initial version number = 1.0
72: -- History Current version number = 1.0
73: --=======================================================
74: procedure CREATE_ATTRIBUTE (
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_api_version_number IN NUMBER,
77: p_init_msg_tbl IN BOOLEAN := FALSE,
78: p_msg_count OUT NOCOPY NUMBER,
79: p_msg_data OUT NOCOPY VARCHAR2,
79: p_msg_data OUT NOCOPY VARCHAR2,
80: p_return_status OUT NOCOPY VARCHAR2,
81: p_attribute_application_id IN NUMBER,
82: p_attribute_code IN VARCHAR2,
83: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
84: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
85: p_bold IN VARCHAR2,
86: p_italic IN VARCHAR2,
87: p_vertical_alignment IN VARCHAR2,
80: p_return_status OUT NOCOPY VARCHAR2,
81: p_attribute_application_id IN NUMBER,
82: p_attribute_code IN VARCHAR2,
83: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
84: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
85: p_bold IN VARCHAR2,
86: p_italic IN VARCHAR2,
87: p_vertical_alignment IN VARCHAR2,
88: p_horizontal_alignment IN VARCHAR2,
85: p_bold IN VARCHAR2,
86: p_italic IN VARCHAR2,
87: p_vertical_alignment IN VARCHAR2,
88: p_horizontal_alignment IN VARCHAR2,
89: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
86: p_italic IN VARCHAR2,
87: p_vertical_alignment IN VARCHAR2,
88: p_horizontal_alignment IN VARCHAR2,
89: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
87: p_vertical_alignment IN VARCHAR2,
88: p_horizontal_alignment IN VARCHAR2,
89: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_horizontal_alignment IN VARCHAR2,
89: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
90: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
96: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
97: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
98: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_precision IN NUMBER := FND_API.G_MISS_NUM,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_name IN VARCHAR2,
115: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_name IN VARCHAR2,
123: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_name IN VARCHAR2,
123: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_name IN VARCHAR2,
123: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_name IN VARCHAR2,
123: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
120: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_name IN VARCHAR2,
123: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
128: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
121: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_name IN VARCHAR2,
123: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
128: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
129: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
122: p_name IN VARCHAR2,
123: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
128: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
129: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
130: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
123: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
128: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
129: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
130: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
131: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
124: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
128: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
129: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
130: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
131: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
132: p_pass IN NUMBER,
125: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
128: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
129: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
130: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
131: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
132: p_pass IN NUMBER,
133: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
126: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
128: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
129: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
130: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
131: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
132: p_pass IN NUMBER,
133: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
134: );
127: p_creation_date IN DATE := FND_API.G_MISS_DATE,
128: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
129: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
130: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
131: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
132: p_pass IN NUMBER,
133: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
134: );
135:
159: -- Version Initial version number = 1.0
160: -- History Current version number = 1.0
161: --=======================================================
162: procedure DELETE_ATTRIBUTE (
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164: p_api_version_number IN NUMBER,
165: p_init_msg_tbl IN BOOLEAN := FALSE,
166: p_msg_count OUT NOCOPY NUMBER,
167: p_msg_data OUT NOCOPY VARCHAR2,
209: -- Version Initial version number = 1.0
210: -- History Current version number = 1.0
211: --=======================================================
212: procedure DOWNLOAD_ATTRIBUTE (
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: p_api_version_number IN NUMBER,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
212: procedure DOWNLOAD_ATTRIBUTE (
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: p_api_version_number IN NUMBER,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
218: := AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL,
219: p_nls_language IN VARCHAR2
220: );
275: -- Version Initial version number = 1.0
276: -- History Current version number = 1.0
277: --=======================================================
278: procedure UPDATE_ATTRIBUTE (
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_api_version_number IN NUMBER,
281: p_init_msg_tbl IN BOOLEAN := FALSE,
282: p_msg_count OUT NOCOPY NUMBER,
283: p_msg_data OUT NOCOPY VARCHAR2,
283: p_msg_data OUT NOCOPY VARCHAR2,
284: p_return_status OUT NOCOPY VARCHAR2,
285: p_attribute_application_id IN NUMBER,
286: p_attribute_code IN VARCHAR2,
287: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
288: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
289: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_return_status OUT NOCOPY VARCHAR2,
285: p_attribute_application_id IN NUMBER,
286: p_attribute_code IN VARCHAR2,
287: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
288: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
289: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_attribute_application_id IN NUMBER,
286: p_attribute_code IN VARCHAR2,
287: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
288: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
289: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_attribute_code IN VARCHAR2,
287: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
288: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
289: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
288: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
289: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
289: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
289: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
290: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
291: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
294: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
300: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
301: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
302: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_precision IN NUMBER := FND_API.G_MISS_NUM,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
319: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
321: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
323: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
324: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
332: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
325: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
332: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
333: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
326: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
332: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
333: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
334: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
327: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
332: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
333: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
334: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
335: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
328: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
332: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
333: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
334: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
335: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
336: p_pass IN NUMBER,
329: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
332: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
333: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
334: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
335: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
336: p_pass IN NUMBER,
337: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
330: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
332: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
333: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
334: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
335: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
336: p_pass IN NUMBER,
337: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
338: );
331: p_creation_date IN DATE := FND_API.G_MISS_DATE,
332: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
333: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
334: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
335: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
336: p_pass IN NUMBER,
337: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
338: );
339:
385: -- Version Initial version number = 1.0
386: -- History Current version number = 1.0
387: --=======================================================
388: procedure UPLOAD_ATTRIBUTE (
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_api_version_number IN NUMBER,
391: p_return_status OUT NOCOPY VARCHAR2,
392: p_index IN OUT NOCOPY NUMBER,
393: p_loader_timestamp IN DATE,
390: p_api_version_number IN NUMBER,
391: p_return_status OUT NOCOPY VARCHAR2,
392: p_index IN OUT NOCOPY NUMBER,
393: p_loader_timestamp IN DATE,
394: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
395: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
396: p_line_num_out OUT NOCOPY NUMBER,
397: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
398: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
430: -- Version Initial version number = 1.0
431: -- History Current version number = 1.0
432: --=======================================================
433: function VALIDATE_ATTRIBUTE (
434: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
435: p_api_version_number IN NUMBER,
436: p_return_status OUT NOCOPY VARCHAR2,
437: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
438: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
433: function VALIDATE_ATTRIBUTE (
434: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
435: p_api_version_number IN NUMBER,
436: p_return_status OUT NOCOPY VARCHAR2,
437: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
438: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
440: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
435: p_api_version_number IN NUMBER,
436: p_return_status OUT NOCOPY VARCHAR2,
437: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
438: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
440: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_api_version_number IN NUMBER,
436: p_return_status OUT NOCOPY VARCHAR2,
437: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
438: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
440: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_return_status OUT NOCOPY VARCHAR2,
437: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
438: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
440: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
438: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
440: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
440: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
440: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_attribute_value_length IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
441: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
442: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
445: p_data_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
446: p_upper_case_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_caller IN VARCHAR2,
449: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_caller IN VARCHAR2,
457: p_pass IN NUMBER := 2
450: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_caller IN VARCHAR2,
457: p_pass IN NUMBER := 2
458: ) return BOOLEAN;
451: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_caller IN VARCHAR2,
457: p_pass IN NUMBER := 2
458: ) return BOOLEAN;
459:
484: -- Version Initial version number = 1.0
485: -- History Current version number = 1.0
486: --=======================================================
487: procedure UPLOAD_ATTRIBUTE_SECOND (
488: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
489: p_return_status OUT NOCOPY VARCHAR2,
490: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
491: p_pass IN NUMBER := 2
492: );
486: --=======================================================
487: procedure UPLOAD_ATTRIBUTE_SECOND (
488: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
489: p_return_status OUT NOCOPY VARCHAR2,
490: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
491: p_pass IN NUMBER := 2
492: );
493:
494: end AK_Attribute_pvt;