2: /* $Header: ARHEXTCS.pls 120.2 2005/08/30 19:07:52 geliu noship $ */
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTCS.pls';
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9:
10: -- Define the package global constants to substitute FND_API global variables for missing values
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTCS.pls';
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9:
10: -- Define the package global constants to substitute FND_API global variables for missing values
11: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTCS.pls';
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9:
10: -- Define the package global constants to substitute FND_API global variables for missing values
11: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
12: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9:
10: -- Define the package global constants to substitute FND_API global variables for missing values
11: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
12: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
13: G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
14:
30: ,p_entity_id IN NUMBER DEFAULT NULL
31: ,p_entity_index IN NUMBER DEFAULT NULL
32: ,p_entity_code IN VARCHAR2 DEFAULT NULL
33: ,p_debug_level IN NUMBER DEFAULT 0
34: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
35: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
36: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
37: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
38: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
31: ,p_entity_index IN NUMBER DEFAULT NULL
32: ,p_entity_code IN VARCHAR2 DEFAULT NULL
33: ,p_debug_level IN NUMBER DEFAULT 0
34: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
35: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
36: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
37: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
38: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
39: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
32: ,p_entity_code IN VARCHAR2 DEFAULT NULL
33: ,p_debug_level IN NUMBER DEFAULT 0
34: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
35: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
36: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
37: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
38: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
39: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
40: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
33: ,p_debug_level IN NUMBER DEFAULT 0
34: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
35: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
36: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
37: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
38: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
39: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
40: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
41: ,x_return_status OUT NOCOPY VARCHAR2
34: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
35: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
36: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
37: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
38: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
39: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
40: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_errorcode OUT NOCOPY NUMBER
35: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
36: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
37: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
38: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
39: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
40: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_errorcode OUT NOCOPY NUMBER
43: ,x_msg_count OUT NOCOPY NUMBER
58: ,p_entity_id IN NUMBER DEFAULT NULL
59: ,p_entity_index IN NUMBER DEFAULT NULL
60: ,p_entity_code IN VARCHAR2 DEFAULT NULL
61: ,p_debug_level IN NUMBER DEFAULT 0
62: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
63: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
64: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
65: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
59: ,p_entity_index IN NUMBER DEFAULT NULL
60: ,p_entity_code IN VARCHAR2 DEFAULT NULL
61: ,p_debug_level IN NUMBER DEFAULT 0
62: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
63: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
64: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
65: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
67: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
60: ,p_entity_code IN VARCHAR2 DEFAULT NULL
61: ,p_debug_level IN NUMBER DEFAULT 0
62: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
63: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
64: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
65: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
67: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
68: ,x_return_status OUT NOCOPY VARCHAR2
61: ,p_debug_level IN NUMBER DEFAULT 0
62: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
63: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
64: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
65: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
67: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
68: ,x_return_status OUT NOCOPY VARCHAR2
69: ,x_errorcode OUT NOCOPY NUMBER
87: * p_new_profile_id New profile Id.
88: * IN/OUT:
89: * OUT:
90: * x_return_status Return status after the call. The status can
91: * be FND_API.G_RET_STS_SUCCESS (success),
92: * FND_API.G_RET_STS_ERROR (error),
93: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
94: *
95: * NOTES
88: * IN/OUT:
89: * OUT:
90: * x_return_status Return status after the call. The status can
91: * be FND_API.G_RET_STS_SUCCESS (success),
92: * FND_API.G_RET_STS_ERROR (error),
93: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
94: *
95: * NOTES
96: *
89: * OUT:
90: * x_return_status Return status after the call. The status can
91: * be FND_API.G_RET_STS_SUCCESS (success),
92: * FND_API.G_RET_STS_ERROR (error),
93: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
94: *
95: * NOTES
96: *
97: * MODIFICATION HISTORY
122: * p_new_profile_id New profile Id.
123: * IN/OUT:
124: * OUT:
125: * x_return_status Return status after the call. The status can
126: * be FND_API.G_RET_STS_SUCCESS (success),
127: * FND_API.G_RET_STS_ERROR (error),
128: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
129: *
130: * NOTES
123: * IN/OUT:
124: * OUT:
125: * x_return_status Return status after the call. The status can
126: * be FND_API.G_RET_STS_SUCCESS (success),
127: * FND_API.G_RET_STS_ERROR (error),
128: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
129: *
130: * NOTES
131: *
124: * OUT:
125: * x_return_status Return status after the call. The status can
126: * be FND_API.G_RET_STS_SUCCESS (success),
127: * FND_API.G_RET_STS_ERROR (error),
128: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
129: *
130: * NOTES
131: *
132: * MODIFICATION HISTORY