40: -- NOTES
41: ---------------------------------------------------------------------
42: PROCEDURE Update_User_Action(
43: p_api_version IN NUMBER
44: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
46:
47: ,x_return_status OUT NOCOPY VARCHAR2
48: ,x_msg_data OUT NOCOPY VARCHAR2
41: ---------------------------------------------------------------------
42: PROCEDURE Update_User_Action(
43: p_api_version IN NUMBER
44: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
46:
47: ,x_return_status OUT NOCOPY VARCHAR2
48: ,x_msg_data OUT NOCOPY VARCHAR2
49: ,x_msg_count OUT NOCOPY NUMBER
59: -- NOTES
60: ---------------------------------------------------------------------
61: PROCEDURE Get_Approvers(
62: p_api_version IN NUMBER
63: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
64: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
65:
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_data OUT NOCOPY VARCHAR2
60: ---------------------------------------------------------------------
61: PROCEDURE Get_Approvers(
62: p_api_version IN NUMBER
63: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
64: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
65:
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_data OUT NOCOPY VARCHAR2
68: ,x_msg_count OUT NOCOPY NUMBER
82: -- NOTES
83: ---------------------------------------------------------------------
84: PROCEDURE Add_Access(
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: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
89:
90: ,x_msg_data OUT NOCOPY VARCHAR2
83: ---------------------------------------------------------------------
84: PROCEDURE Add_Access(
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: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
89:
90: ,x_msg_data OUT NOCOPY VARCHAR2
91: ,x_msg_count OUT NOCOPY NUMBER
84: PROCEDURE Add_Access(
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: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
89:
90: ,x_msg_data OUT NOCOPY VARCHAR2
91: ,x_msg_count OUT NOCOPY NUMBER
92: ,x_return_status OUT NOCOPY VARCHAR2
105: -- NOTES
106: ---------------------------------------------------------------------
107: PROCEDURE Revoke_Access (
108: p_api_version IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112:
113: ,x_return_status OUT NOCOPY VARCHAR2
106: ---------------------------------------------------------------------
107: PROCEDURE Revoke_Access (
108: p_api_version IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112:
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_data OUT NOCOPY VARCHAR2
107: PROCEDURE Revoke_Access (
108: p_api_version IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112:
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_data OUT NOCOPY VARCHAR2
115: ,x_msg_count OUT NOCOPY NUMBER
148: -- NOTES
149: ---------------------------------------------------------------------
150: PROCEDURE Send_Notification (
151: p_api_version IN NUMBER
152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155:
156: ,x_return_status OUT NOCOPY VARCHAR2
149: ---------------------------------------------------------------------
150: PROCEDURE Send_Notification (
151: p_api_version IN NUMBER
152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155:
156: ,x_return_status OUT NOCOPY VARCHAR2
157: ,x_msg_data OUT NOCOPY VARCHAR2
150: PROCEDURE Send_Notification (
151: p_api_version IN NUMBER
152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155:
156: ,x_return_status OUT NOCOPY VARCHAR2
157: ,x_msg_data OUT NOCOPY VARCHAR2
158: ,x_msg_count OUT NOCOPY NUMBER
177: -- 1. object_version_number will be set to 1.
178: ---------------------------------------------------------------------
179: PROCEDURE Process_User_Action (
180: p_api_version IN NUMBER
181: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
182: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
183: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184:
185: ,x_return_status OUT NOCOPY VARCHAR2
178: ---------------------------------------------------------------------
179: PROCEDURE Process_User_Action (
180: p_api_version IN NUMBER
181: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
182: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
183: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184:
185: ,x_return_status OUT NOCOPY VARCHAR2
186: ,x_msg_data OUT NOCOPY VARCHAR2
179: PROCEDURE Process_User_Action (
180: p_api_version IN NUMBER
181: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
182: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
183: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184:
185: ,x_return_status OUT NOCOPY VARCHAR2
186: ,x_msg_data OUT NOCOPY VARCHAR2
187: ,x_msg_count OUT NOCOPY NUMBER
205: -- NOTES
206: ---------------------------------------------------------------------
207: PROCEDURE Process_SD_Approval (
208: p_api_version IN NUMBER
209: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
210: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
211: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
212: ,p_object_id IN NUMBER
213: ,p_action_code IN VARCHAR2
206: ---------------------------------------------------------------------
207: PROCEDURE Process_SD_Approval (
208: p_api_version IN NUMBER
209: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
210: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
211: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
212: ,p_object_id IN NUMBER
213: ,p_action_code IN VARCHAR2
214: ,x_return_status OUT NOCOPY VARCHAR2
207: PROCEDURE Process_SD_Approval (
208: p_api_version IN NUMBER
209: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
210: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
211: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
212: ,p_object_id IN NUMBER
213: ,p_action_code IN VARCHAR2
214: ,x_return_status OUT NOCOPY VARCHAR2
215: ,x_msg_count OUT NOCOPY NUMBER
230: -- NOTES
231: ---------------------------------------------------------------------
232: PROCEDURE Get_All_Approvers(
233: p_api_version IN NUMBER
234: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
235: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
236: ,p_transaction_id IN VARCHAR2
237: ,p_transaction_type_key IN VARCHAR2
238: ,x_approvers OUT NOCOPY ame_util.approversTable2
231: ---------------------------------------------------------------------
232: PROCEDURE Get_All_Approvers(
233: p_api_version IN NUMBER
234: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
235: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
236: ,p_transaction_id IN VARCHAR2
237: ,p_transaction_type_key IN VARCHAR2
238: ,x_approvers OUT NOCOPY ame_util.approversTable2
239: ,x_approval_flag OUT NOCOPY VARCHAR2
256: -- NOTES
257: ---------------------------------------------------------------------
258: PROCEDURE Add_SD_Access(
259: p_api_version IN NUMBER
260: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
262: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
263: ,p_request_header_id IN NUMBER
264: ,p_user_id IN NUMBER
257: ---------------------------------------------------------------------
258: PROCEDURE Add_SD_Access(
259: p_api_version IN NUMBER
260: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
262: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
263: ,p_request_header_id IN NUMBER
264: ,p_user_id IN NUMBER
265: ,p_resource_id IN NUMBER
258: PROCEDURE Add_SD_Access(
259: p_api_version IN NUMBER
260: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
261: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
262: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
263: ,p_request_header_id IN NUMBER
264: ,p_user_id IN NUMBER
265: ,p_resource_id IN NUMBER
266: ,p_person_id IN NUMBER DEFAULT NULL
285: -- NOTES
286: ---------------------------------------------------------------------
287: PROCEDURE Add_SD_Access(
288: p_api_version IN NUMBER
289: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
290: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
291: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
292: ,p_access_rec IN sd_access_rec_type
293: ,x_return_status OUT NOCOPY VARCHAR2
286: ---------------------------------------------------------------------
287: PROCEDURE Add_SD_Access(
288: p_api_version IN NUMBER
289: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
290: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
291: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
292: ,p_access_rec IN sd_access_rec_type
293: ,x_return_status OUT NOCOPY VARCHAR2
294: ,x_msg_count OUT NOCOPY NUMBER
287: PROCEDURE Add_SD_Access(
288: p_api_version IN NUMBER
289: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
290: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
291: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
292: ,p_access_rec IN sd_access_rec_type
293: ,x_return_status OUT NOCOPY VARCHAR2
294: ,x_msg_count OUT NOCOPY NUMBER
295: ,x_msg_data OUT NOCOPY VARCHAR2);
328: -- NOTES
329: ---------------------------------------------------------------------
330: PROCEDURE Send_SD_Notification (
331: p_api_version IN NUMBER
332: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
333: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
334: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
335: ,p_object_id IN NUMBER
336: ,p_action_code IN VARCHAR2
329: ---------------------------------------------------------------------
330: PROCEDURE Send_SD_Notification (
331: p_api_version IN NUMBER
332: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
333: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
334: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
335: ,p_object_id IN NUMBER
336: ,p_action_code IN VARCHAR2
337: ,x_return_status OUT NOCOPY VARCHAR2
330: PROCEDURE Send_SD_Notification (
331: p_api_version IN NUMBER
332: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
333: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
334: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
335: ,p_object_id IN NUMBER
336: ,p_action_code IN VARCHAR2
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_data OUT NOCOPY VARCHAR2