44: -- NOTES
45: ---------------------------------------------------------------------
46: PROCEDURE Update_User_Action(
47: p_api_version IN NUMBER
48: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
49: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
50:
51: ,x_return_status OUT NOCOPY VARCHAR2
52: ,x_msg_data OUT NOCOPY VARCHAR2
45: ---------------------------------------------------------------------
46: PROCEDURE Update_User_Action(
47: p_api_version IN NUMBER
48: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
49: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
50:
51: ,x_return_status OUT NOCOPY VARCHAR2
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER
63: -- NOTES
64: ---------------------------------------------------------------------
65: PROCEDURE Get_Approvers(
66: p_api_version IN NUMBER
67: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
69:
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,x_msg_data OUT NOCOPY VARCHAR2
64: ---------------------------------------------------------------------
65: PROCEDURE Get_Approvers(
66: p_api_version IN NUMBER
67: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
69:
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,x_msg_data OUT NOCOPY VARCHAR2
72: ,x_msg_count OUT NOCOPY NUMBER
84: -- NOTES
85: ---------------------------------------------------------------------
86: PROCEDURE Get_AllApprovers(
87: p_api_version IN NUMBER
88: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
89: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
90:
91: ,x_return_status OUT NOCOPY VARCHAR2
92: ,x_msg_data OUT NOCOPY VARCHAR2
85: ---------------------------------------------------------------------
86: PROCEDURE Get_AllApprovers(
87: p_api_version IN NUMBER
88: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
89: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
90:
91: ,x_return_status OUT NOCOPY VARCHAR2
92: ,x_msg_data OUT NOCOPY VARCHAR2
93: ,x_msg_count OUT NOCOPY NUMBER
107: -- NOTES
108: ---------------------------------------------------------------------
109: PROCEDURE Clear_All_Approvals (
110: p_api_version IN NUMBER
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
114:
115: ,x_return_status OUT NOCOPY VARCHAR2
108: ---------------------------------------------------------------------
109: PROCEDURE Clear_All_Approvals (
110: p_api_version IN NUMBER
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
114:
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
109: PROCEDURE Clear_All_Approvals (
110: p_api_version IN NUMBER
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
114:
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
117: ,x_msg_data OUT NOCOPY VARCHAR2
130: -- NOTES
131: ---------------------------------------------------------------------
132: PROCEDURE Add_Access(
133: p_api_version IN NUMBER
134: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
135: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
136: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
137:
138: ,x_msg_data OUT NOCOPY VARCHAR2
131: ---------------------------------------------------------------------
132: PROCEDURE Add_Access(
133: p_api_version IN NUMBER
134: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
135: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
136: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
137:
138: ,x_msg_data OUT NOCOPY VARCHAR2
139: ,x_msg_count OUT NOCOPY NUMBER
132: PROCEDURE Add_Access(
133: p_api_version IN NUMBER
134: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
135: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
136: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
137:
138: ,x_msg_data OUT NOCOPY VARCHAR2
139: ,x_msg_count OUT NOCOPY NUMBER
140: ,x_return_status OUT NOCOPY VARCHAR2
153: -- NOTES
154: ---------------------------------------------------------------------
155: PROCEDURE Revoke_Access (
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
154: ---------------------------------------------------------------------
155: PROCEDURE Revoke_Access (
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_data OUT NOCOPY VARCHAR2
155: PROCEDURE Revoke_Access (
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_data OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER
195: -- NOTES
196: ---------------------------------------------------------------------
197: PROCEDURE Send_Notification (
198: p_api_version IN NUMBER
199: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
201: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
202:
203: ,x_return_status OUT NOCOPY VARCHAR2
196: ---------------------------------------------------------------------
197: PROCEDURE Send_Notification (
198: p_api_version IN NUMBER
199: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
201: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
202:
203: ,x_return_status OUT NOCOPY VARCHAR2
204: ,x_msg_data OUT NOCOPY VARCHAR2
197: PROCEDURE Send_Notification (
198: p_api_version IN NUMBER
199: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
201: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
202:
203: ,x_return_status OUT NOCOPY VARCHAR2
204: ,x_msg_data OUT NOCOPY VARCHAR2
205: ,x_msg_count OUT NOCOPY NUMBER
222: -- 1. object_version_number will be set to 1.
223: ---------------------------------------------------------------------
224: PROCEDURE Process_User_Action (
225: p_api_version IN NUMBER
226: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
227: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
228: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
229:
230: ,x_return_status OUT NOCOPY VARCHAR2
223: ---------------------------------------------------------------------
224: PROCEDURE Process_User_Action (
225: p_api_version IN NUMBER
226: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
227: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
228: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
229:
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_data OUT NOCOPY VARCHAR2
224: PROCEDURE Process_User_Action (
225: p_api_version IN NUMBER
226: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
227: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
228: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
229:
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_data OUT NOCOPY VARCHAR2
232: ,x_msg_count OUT NOCOPY NUMBER