20: -- Parameters :
21: -- name direction type required?
22: -- ---- --------- ---- ---------
23: -- p_api_version IN NUMBER required
24: -- p_init_msg_list IN VARCHAR2 optional DEFAULT fnd_api.g_false
25: -- p_commit IN VARCHAR2 optional DEFAULT fnd_api.g_false
26: -- x_return_status OUT VARCHAR2 required
27: -- x_msg_count OUT NUMBER required
28: -- x_msg_data OUT VARCHAR2 required
21: -- name direction type required?
22: -- ---- --------- ---- ---------
23: -- p_api_version IN NUMBER required
24: -- p_init_msg_list IN VARCHAR2 optional DEFAULT fnd_api.g_false
25: -- p_commit IN VARCHAR2 optional DEFAULT fnd_api.g_false
26: -- x_return_status OUT VARCHAR2 required
27: -- x_msg_count OUT NUMBER required
28: -- x_msg_data OUT VARCHAR2 required
29: -- p_task_id IN NUMBER required
79: );
80:
81:
82: TYPE nlist_rec_type is RECORD (
83: name wf_users.name%TYPE := FND_API.G_MISS_CHAR,
84: display_name wf_users.display_name%TYPE := FND_API.G_MISS_CHAR,
85: email_address wf_users.email_address%TYPE := FND_API.G_MISS_CHAR);
86:
87:
80:
81:
82: TYPE nlist_rec_type is RECORD (
83: name wf_users.name%TYPE := FND_API.G_MISS_CHAR,
84: display_name wf_users.display_name%TYPE := FND_API.G_MISS_CHAR,
85: email_address wf_users.email_address%TYPE := FND_API.G_MISS_CHAR);
86:
87:
88: TYPE task_details_rec_type is RECORD(
81:
82: TYPE nlist_rec_type is RECORD (
83: name wf_users.name%TYPE := FND_API.G_MISS_CHAR,
84: display_name wf_users.display_name%TYPE := FND_API.G_MISS_CHAR,
85: email_address wf_users.email_address%TYPE := FND_API.G_MISS_CHAR);
86:
87:
88: TYPE task_details_rec_type is RECORD(
89: task_name jtf_tasks_vl.task_name%TYPE,
FND_API.G_RET_STS_SUCCESS
120: * the API to commit on their behalf after performing its function
121: * By default, the commit will not be performed.
122: * @param x_return_status the parameter that returns the result of all the operations performed.
123: * by the API and must have one of the following values:
124: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
121: * By default, the commit will not be performed.
122: * @param x_return_status the parameter that returns the result of all the operations performed.
123: * by the API and must have one of the following values:
124: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
122: * @param x_return_status the parameter that returns the result of all the operations performed.
123: * by the API and must have one of the following values:
124: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
148: * @rep:compatibility S
149: */
150: PROCEDURE Start_Resc_Workflow(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
153: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
149: */
150: PROCEDURE Start_Resc_Workflow(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
153: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_task_id IN NUMBER,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_task_id IN NUMBER,
158: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_task_id IN NUMBER,
158: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_task_id IN NUMBER,
158: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
157: p_task_id IN NUMBER,
158: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_doc_created IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_owner_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
160: p_owner_type_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
161: p_level_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
169: p_wf_process_name IN VARCHAR2 DEFAULT 'ESC_NOTIF_PROCESS',
162: p_status_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
169: p_wf_process_name IN VARCHAR2 DEFAULT 'ESC_NOTIF_PROCESS',
170: p_wf_item_type_name IN VARCHAR2 DEFAULT 'JTFEC',
163: p_target_date_changed IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
169: p_wf_process_name IN VARCHAR2 DEFAULT 'ESC_NOTIF_PROCESS',
170: p_wf_item_type_name IN VARCHAR2 DEFAULT 'JTFEC',
171: x_notif_not_sent OUT NOCOPY VARCHAR2,
164: p_old_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_old_owner_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_old_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
167: p_old_status_id IN NUMBER := FND_API.G_MISS_NUM,
168: p_old_target_date IN DATE := FND_API.G_MISS_DATE,
169: p_wf_process_name IN VARCHAR2 DEFAULT 'ESC_NOTIF_PROCESS',
170: p_wf_item_type_name IN VARCHAR2 DEFAULT 'JTFEC',
171: x_notif_not_sent OUT NOCOPY VARCHAR2,
172: x_wf_process_id OUT NOCOPY NUMBER
FND_API.G_RET_STS_SUCCESS
246: * @param x_doc_details_t the parameter that returns the document details in text format
247: * @param x_doc_details_h the paramter that returns the document details in html format
248: * @param x_return_status the parameter that returns the result of all the operations performed.
249: * by the API and must have one of the following values:
250: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
247: * @param x_doc_details_h the paramter that returns the document details in html format
248: * @param x_return_status the parameter that returns the result of all the operations performed.
249: * by the API and must have one of the following values:
250: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
248: * @param x_return_status the parameter that returns the result of all the operations performed.
249: * by the API and must have one of the following values:
250: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR