2: /* $Header: EGOVITMS.pls 120.8 2007/09/12 13:23:25 srajapar ship $ */
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOVITMS.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) := 'EGOVITMS.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:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOVITMS.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:
12: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
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:
12: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
13: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
14: G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
45: -- -----------------------------------------------------------------------------
46:
47: PROCEDURE Process_Items
48: (
49: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
50: , x_return_status OUT NOCOPY VARCHAR2
51: , x_msg_count OUT NOCOPY NUMBER
52: );
53:
61: -- -----------------------------------------------------------------------------
62:
63: PROCEDURE Process_Item
64: (
65: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
66: , x_return_status OUT NOCOPY VARCHAR2
67: , x_msg_count OUT NOCOPY NUMBER
68: );
69: */
76: -- -----------------------------------------------------------------------------
77:
78: PROCEDURE Process_Item_Org_Assignments
79: (
80: p_commit IN VARCHAR2 DEFAULT FND_API.g_FALSE
81: , x_return_status OUT NOCOPY VARCHAR2
82: , x_msg_count OUT NOCOPY NUMBER
83: );
84:
132: ,p_entity_id IN NUMBER DEFAULT NULL
133: ,p_entity_index IN NUMBER DEFAULT NULL
134: ,p_entity_code IN VARCHAR2 DEFAULT NULL
135: ,p_debug_level IN NUMBER DEFAULT 0
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
133: ,p_entity_index IN NUMBER DEFAULT NULL
134: ,p_entity_code IN VARCHAR2 DEFAULT NULL
135: ,p_debug_level IN NUMBER DEFAULT 0
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
134: ,p_entity_code IN VARCHAR2 DEFAULT NULL
135: ,p_debug_level IN NUMBER DEFAULT 0
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
135: ,p_debug_level IN NUMBER DEFAULT 0
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
136: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
144: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
137: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
144: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
145: ,x_return_status OUT NOCOPY VARCHAR2
138: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
144: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
145: ,x_return_status OUT NOCOPY VARCHAR2
146: ,x_errorcode OUT NOCOPY NUMBER
139: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
140: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142: ,p_do_policy_check IN VARCHAR2 DEFAULT FND_API.G_TRUE
143: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
144: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
145: ,x_return_status OUT NOCOPY VARCHAR2
146: ,x_errorcode OUT NOCOPY NUMBER
147: ,x_msg_count OUT NOCOPY NUMBER
163: ,p_entity_id IN NUMBER DEFAULT NULL
164: ,p_entity_index IN NUMBER DEFAULT NULL
165: ,p_entity_code IN VARCHAR2 DEFAULT NULL
166: ,p_debug_level IN NUMBER DEFAULT 0
167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
171: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
164: ,p_entity_index IN NUMBER DEFAULT NULL
165: ,p_entity_code IN VARCHAR2 DEFAULT NULL
166: ,p_debug_level IN NUMBER DEFAULT 0
167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
171: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
172: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
165: ,p_entity_code IN VARCHAR2 DEFAULT NULL
166: ,p_debug_level IN NUMBER DEFAULT 0
167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
171: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
172: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
173: ,x_return_status OUT NOCOPY VARCHAR2
166: ,p_debug_level IN NUMBER DEFAULT 0
167: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
168: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
169: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
170: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
171: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
172: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_errorcode OUT NOCOPY NUMBER