8: --------------------------------------------------------------
9: PROCEDURE Create_Category_Assignment
10: (
11: p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_errorcode OUT NOCOPY NUMBER,
16: x_msg_count OUT NOCOPY NUMBER,
9: PROCEDURE Create_Category_Assignment
10: (
11: p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_errorcode OUT NOCOPY NUMBER,
16: x_msg_count OUT NOCOPY NUMBER,
17: x_msg_data OUT NOCOPY VARCHAR2,
33: -- IN : p_api_version IN NUMBER (required)
34: -- API Version of this procedure
35: --
36: -- p_init_msg_level IN VARCHAR2 (optional)
37: -- DEFAULT = FND_API.G_FALSE,
38: --
39: -- p_commit IN VARCHAR2 (optional)
40: -- DEFAULT = FND_API.G_FALSE,
41: --
36: -- p_init_msg_level IN VARCHAR2 (optional)
37: -- DEFAULT = FND_API.G_FALSE,
38: --
39: -- p_commit IN VARCHAR2 (optional)
40: -- DEFAULT = FND_API.G_FALSE,
41: --
42: -- p_category_id IN NUMBER (required)
43: -- category for assigning item
44: --
59: -- contains the message itself
60: --
61: -- X_return_status OUT NUMBER
62: -- Result of all the operations
63: -- FND_API.G_RET_STS_SUCCESS if success
64: -- FND_API.G_RET_STS_ERROR if error
65: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
66: --
67: -- X_ErrorCode OUT NUMBER
60: --
61: -- X_return_status OUT NUMBER
62: -- Result of all the operations
63: -- FND_API.G_RET_STS_SUCCESS if success
64: -- FND_API.G_RET_STS_ERROR if error
65: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
66: --
67: -- X_ErrorCode OUT NUMBER
68: -- RETURN value OF the x_errorcode
61: -- X_return_status OUT NUMBER
62: -- Result of all the operations
63: -- FND_API.G_RET_STS_SUCCESS if success
64: -- FND_API.G_RET_STS_ERROR if error
65: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
66: --
67: -- X_ErrorCode OUT NUMBER
68: -- RETURN value OF the x_errorcode
69: -- check only if x_return_status <> fnd_api.g_ret_sts_success
65: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
66: --
67: -- X_ErrorCode OUT NUMBER
68: -- RETURN value OF the x_errorcode
69: -- check only if x_return_status <> fnd_api.g_ret_sts_success
70: -- These errors are unrecoverable and the API failed as a result of this
71: -- XXX - Error reason/message (will be updated after implementation)
72: -- -1 - unexpected error - all operations have been rollbacked
73: --
82: ----------------------------------------------------------------------------
83: PROCEDURE Delete_Category_Assignment
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_errorcode OUT NOCOPY NUMBER,
90: x_msg_count OUT NOCOPY NUMBER,
83: PROCEDURE Delete_Category_Assignment
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_errorcode OUT NOCOPY NUMBER,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
106: -- IN : p_api_version IN NUMBER (required)
107: -- API Version of this procedure
108: --
109: -- p_init_msg_level IN VARCHAR2 (optional)
110: -- DEFAULT = FND_API.G_FALSE,
111: --
112: -- p_commit IN VARCHAR2 (optional)
113: -- DEFAULT = FND_API.G_FALSE,
114: --
109: -- p_init_msg_level IN VARCHAR2 (optional)
110: -- DEFAULT = FND_API.G_FALSE,
111: --
112: -- p_commit IN VARCHAR2 (optional)
113: -- DEFAULT = FND_API.G_FALSE,
114: --
115: -- p_category_id IN NUMBER (required)
116: -- category of the assginement
117: --
130: -- contains the message itself
131: --
132: -- X_return_status OUT NUMBER
133: -- Result of all the operations
134: -- FND_API.G_RET_STS_SUCCESS if success
135: -- FND_API.G_RET_STS_ERROR if error
136: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
137: --
138: -- X_ErrorCode OUT NUMBER
131: --
132: -- X_return_status OUT NUMBER
133: -- Result of all the operations
134: -- FND_API.G_RET_STS_SUCCESS if success
135: -- FND_API.G_RET_STS_ERROR if error
136: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
137: --
138: -- X_ErrorCode OUT NUMBER
139: -- RETURN value OF the x_errorcode
132: -- X_return_status OUT NUMBER
133: -- Result of all the operations
134: -- FND_API.G_RET_STS_SUCCESS if success
135: -- FND_API.G_RET_STS_ERROR if error
136: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
137: --
138: -- X_ErrorCode OUT NUMBER
139: -- RETURN value OF the x_errorcode
140: -- check only if x_return_status <> fnd_api.g_ret_sts_success
136: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
137: --
138: -- X_ErrorCode OUT NUMBER
139: -- RETURN value OF the x_errorcode
140: -- check only if x_return_status <> fnd_api.g_ret_sts_success
141: -- These errors are unrecoverable and the API failed as a result of this
142: -- XXX - Error reason/message (will be updated after implementation)
143: -- -1 - unexpected error - all operations have been rollbacked
144: --