16: */
17:
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTSS.pls';
19:
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
23:
24: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
17:
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTSS.pls';
19:
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
23:
24: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
25: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTSS.pls';
19:
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
23:
24: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
25: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
26: G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
23:
24: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
25: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
26: G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
27: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE; -- 'F'
28: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE; -- 'T'
29:
30: /*#
31: * Creates or updates information in extensions tables for organization profiles.
24: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
25: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
26: G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
27: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE; -- 'F'
28: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE; -- 'T'
29:
30: /*#
31: * Creates or updates information in extensions tables for organization profiles.
32: * The HZ_ORG_PROFILES_EXT_B and HZ_ORG_PROFILES_EXT_TL tables hold extended, custom
48: ,p_entity_id IN NUMBER DEFAULT NULL
49: ,p_entity_index IN NUMBER DEFAULT NULL
50: ,p_entity_code IN VARCHAR2 DEFAULT NULL
51: ,p_debug_level IN NUMBER DEFAULT 0
52: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
53: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
55: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
56: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
49: ,p_entity_index IN NUMBER DEFAULT NULL
50: ,p_entity_code IN VARCHAR2 DEFAULT NULL
51: ,p_debug_level IN NUMBER DEFAULT 0
52: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
53: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
55: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
56: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
57: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
50: ,p_entity_code IN VARCHAR2 DEFAULT NULL
51: ,p_debug_level IN NUMBER DEFAULT 0
52: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
53: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
55: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
56: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
57: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
58: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
51: ,p_debug_level IN NUMBER DEFAULT 0
52: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
53: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
55: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
56: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
57: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
58: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
59: ,x_return_status OUT NOCOPY VARCHAR2
52: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
53: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
55: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
56: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
57: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
58: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
59: ,x_return_status OUT NOCOPY VARCHAR2
60: ,x_errorcode OUT NOCOPY NUMBER
53: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
55: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
56: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
57: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
58: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
59: ,x_return_status OUT NOCOPY VARCHAR2
60: ,x_errorcode OUT NOCOPY NUMBER
61: ,x_msg_count OUT NOCOPY NUMBER
81: ,p_entity_id IN NUMBER DEFAULT NULL
82: ,p_entity_index IN NUMBER DEFAULT NULL
83: ,p_entity_code IN VARCHAR2 DEFAULT NULL
84: ,p_debug_level IN NUMBER DEFAULT 0
85: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
87: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
88: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
89: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
82: ,p_entity_index IN NUMBER DEFAULT NULL
83: ,p_entity_code IN VARCHAR2 DEFAULT NULL
84: ,p_debug_level IN NUMBER DEFAULT 0
85: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
87: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
88: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
89: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
83: ,p_entity_code IN VARCHAR2 DEFAULT NULL
84: ,p_debug_level IN NUMBER DEFAULT 0
85: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
87: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
88: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
89: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
91: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
84: ,p_debug_level IN NUMBER DEFAULT 0
85: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
87: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
88: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
89: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
91: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
92: ,x_return_status OUT NOCOPY VARCHAR2
85: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
87: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
88: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
89: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
91: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
92: ,x_return_status OUT NOCOPY VARCHAR2
93: ,x_errorcode OUT NOCOPY NUMBER
86: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
87: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
88: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
89: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
91: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
92: ,x_return_status OUT NOCOPY VARCHAR2
93: ,x_errorcode OUT NOCOPY NUMBER
94: ,x_msg_count OUT NOCOPY NUMBER
114: ,p_entity_id IN NUMBER DEFAULT NULL
115: ,p_entity_index IN NUMBER DEFAULT NULL
116: ,p_entity_code IN VARCHAR2 DEFAULT NULL
117: ,p_debug_level IN NUMBER DEFAULT 0
118: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
122: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
115: ,p_entity_index IN NUMBER DEFAULT NULL
116: ,p_entity_code IN VARCHAR2 DEFAULT NULL
117: ,p_debug_level IN NUMBER DEFAULT 0
118: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
122: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
123: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
116: ,p_entity_code IN VARCHAR2 DEFAULT NULL
117: ,p_debug_level IN NUMBER DEFAULT 0
118: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
122: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
123: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
124: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
117: ,p_debug_level IN NUMBER DEFAULT 0
118: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
122: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
123: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
124: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
125: ,x_return_status OUT NOCOPY VARCHAR2
118: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
122: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
123: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
124: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
125: ,x_return_status OUT NOCOPY VARCHAR2
126: ,x_errorcode OUT NOCOPY NUMBER
119: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
122: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
123: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
124: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
125: ,x_return_status OUT NOCOPY VARCHAR2
126: ,x_errorcode OUT NOCOPY NUMBER
127: ,x_msg_count OUT NOCOPY NUMBER
147: ,p_entity_id IN NUMBER DEFAULT NULL
148: ,p_entity_index IN NUMBER DEFAULT NULL
149: ,p_entity_code IN VARCHAR2 DEFAULT NULL
150: ,p_debug_level IN NUMBER DEFAULT 0
151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
152: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
153: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
155: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
148: ,p_entity_index IN NUMBER DEFAULT NULL
149: ,p_entity_code IN VARCHAR2 DEFAULT NULL
150: ,p_debug_level IN NUMBER DEFAULT 0
151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
152: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
153: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
155: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
156: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
149: ,p_entity_code IN VARCHAR2 DEFAULT NULL
150: ,p_debug_level IN NUMBER DEFAULT 0
151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
152: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
153: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
155: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
156: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
157: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
150: ,p_debug_level IN NUMBER DEFAULT 0
151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
152: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
153: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
155: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
156: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
157: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
158: ,x_return_status OUT NOCOPY VARCHAR2
151: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
152: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
153: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
155: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
156: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
157: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
158: ,x_return_status OUT NOCOPY VARCHAR2
159: ,x_errorcode OUT NOCOPY NUMBER
152: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
153: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
155: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
156: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
157: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
158: ,x_return_status OUT NOCOPY VARCHAR2
159: ,x_errorcode OUT NOCOPY NUMBER
160: ,x_msg_count OUT NOCOPY NUMBER
167: ,p_entity_id IN NUMBER DEFAULT NULL
168: ,p_entity_index IN NUMBER DEFAULT NULL
169: ,p_entity_code IN VARCHAR2 DEFAULT NULL
170: ,p_debug_level IN NUMBER DEFAULT 0
171: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
172: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
173: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
174: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
175: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
168: ,p_entity_index IN NUMBER DEFAULT NULL
169: ,p_entity_code IN VARCHAR2 DEFAULT NULL
170: ,p_debug_level IN NUMBER DEFAULT 0
171: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
172: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
173: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
174: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
175: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
176: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
169: ,p_entity_code IN VARCHAR2 DEFAULT NULL
170: ,p_debug_level IN NUMBER DEFAULT 0
171: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
172: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
173: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
174: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
175: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
176: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
177: ,x_return_status OUT NOCOPY VARCHAR2
170: ,p_debug_level IN NUMBER DEFAULT 0
171: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
172: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
173: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
174: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
175: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
176: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
177: ,x_return_status OUT NOCOPY VARCHAR2
178: ,x_errorcode OUT NOCOPY NUMBER