1 PACKAGE TASK_MGR AS
2 /* $Header: JTFATSKS.pls 120.2 2005/10/31 05:28:52 snellepa ship $ */
3
4 PROCEDURE create_task(
5 API_VERSION IN NUMBER,
6 TASK_NAME IN VARCHAR2,
7 TASK_TYPE_ID IN NUMBER,
8 TASK_STATUS_ID IN NUMBER,
9 OWNER_TYPE_CODE IN VARCHAR2,
10 OWNER_ID IN NUMBER,
11 SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
12 PARTY_ID IN NUMBER,
13 X_MSG_DATA OUT NOCOPY VARCHAR2,
14 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
15 X_MSG_COUNT OUT NOCOPY NUMBER);
16
17 FUNCTION query_task(API_VERSION IN NUMBER DEFAULT 1.0,
18 START_POINTER IN NUMBER DEFAULT 1,
19 REC_WANTED IN NUMBER DEFAULT 1,
20 TASK_STATUS_ID IN NUMBER DEFAULT 10,
21 SHOW_ALL IN VARCHAR2 DEFAULT 'YES',
22 SORT_ORDER IN VARCHAR2 DEFAULT 'sortByAscendingDate') RETURN CLOB;
23
24 PROCEDURE query_test(API_VERSION IN NUMBER DEFAULT 1.0,
25 START_POINTER IN NUMBER DEFAULT 1,
26 REC_WANTED IN NUMBER DEFAULT 1,
27 SHOW_ALL IN VARCHAR2 DEFAULT 'YES',
28 SORT_ORDER IN VARCHAR2 DEFAULT 'sortByAscendingDate');
29
30 PROCEDURE update_task(API_VERSION IN NUMBER DEFAULT 1.0,
31 OBJECT_VERSION_NUMBER IN NUMBER DEFAULT 1,
32 P_TASK_ID IN NUMBER,
33 COMMENTS IN VARCHAR2 DEFAULT NULL,
34 COMPLETION_STATUS IN VARCHAR2 DEFAULT 'COMPLETED',
35 X_MSG_DATA OUT NOCOPY VARCHAR2,
36 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
37 X_MSG_COUNT OUT NOCOPY NUMBER);
38
39
40 PROCEDURE update_task_without_note(API_VERSION IN NUMBER DEFAULT 1.0,
41 OBJECT_VERSION_NUMBER IN NUMBER DEFAULT 1,
42 P_TASK_ID IN NUMBER,
43 COMMENTS IN VARCHAR2 DEFAULT NULL,
44 COMPLETION_STATUS IN VARCHAR2 DEFAULT 'COMPLETED');
45
46 PROCEDURE update_party_note(API_VERSION IN NUMBER DEFAULT 1.0,
47 OBJECT_VERSION_NUMBER IN NUMBER DEFAULT 1,
48 PARTY_ID IN NUMBER,
49 COMMENTS IN VARCHAR2);
50
51 END TASK_MGR;