61: p_actual_end_date_from IN VARCHAR2 ,
62: p_actual_end_date_to IN VARCHAR2 ,
63: p_task_type_id IN NUMBER DEFAULT NULL ,
64: p_task_status_id IN NUMBER DEFAULT NULL ,
65: p_delete_closed_task_only IN VARCHAR2 DEFAULT fnd_api.g_false ,
66: p_delete_deleted_task_only IN VARCHAR2 DEFAULT fnd_api.g_false ,
67: p_no_of_worker IN NUMBER DEFAULT 4 );
68:
69:
62: p_actual_end_date_to IN VARCHAR2 ,
63: p_task_type_id IN NUMBER DEFAULT NULL ,
64: p_task_status_id IN NUMBER DEFAULT NULL ,
65: p_delete_closed_task_only IN VARCHAR2 DEFAULT fnd_api.g_false ,
66: p_delete_deleted_task_only IN VARCHAR2 DEFAULT fnd_api.g_false ,
67: p_no_of_worker IN NUMBER DEFAULT 4 );
68:
69:
70: /**
87: Procedure POPULATE_PURGE_TMP (
88: errbuf OUT NOCOPY VARCHAR2,
89: retcode OUT NOCOPY VARCHAR2,
90: p_api_version IN NUMBER ,
91: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
92: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
93: p_worker_id IN NUMBER ,
94: p_concurrent_request_id IN NUMBER );
95:
88: errbuf OUT NOCOPY VARCHAR2,
89: retcode OUT NOCOPY VARCHAR2,
90: p_api_version IN NUMBER ,
91: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
92: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
93: p_worker_id IN NUMBER ,
94: p_concurrent_request_id IN NUMBER );
95:
96:
FND_API.G_RET_STS_SUCCESS
106: * By default, the commit will not be performed.
107: * @param p_processing_set_id ID for identifying parent of the TASK.
108: * @param x_return_status returns the result of all the operations performed
109: * by the API and must have one of the following values:
110: * 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
107: * @param p_processing_set_id ID for identifying parent of the TASK.
108: * @param x_return_status returns the result of all the operations performed
109: * by the API and must have one of the following values:
110: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.FND_API.G_RET_STS_UNEXP_ERROR
108: * @param x_return_status returns the result of all the operations performed
109: * by the API and must have one of the following values:
110: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.
119: **/
120:
121: Procedure PURGE_TASK_ENTITIES (
122: p_api_version IN NUMBER ,
123: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
124: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
125: p_processing_set_id IN NUMBER ,
126: x_return_status OUT NOCOPY VARCHAR2 ,
127: x_msg_data OUT NOCOPY VARCHAR2 ,
120:
121: Procedure PURGE_TASK_ENTITIES (
122: p_api_version IN NUMBER ,
123: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
124: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
125: p_processing_set_id IN NUMBER ,
126: x_return_status OUT NOCOPY VARCHAR2 ,
127: x_msg_data OUT NOCOPY VARCHAR2 ,
128: x_msg_count OUT NOCOPY NUMBER ,