1 package IEU_WR_ITEMS_PKG as
2 /* $Header: IEUVUWRS.pls 120.0 2005/06/02 15:44:39 appldev noship $ */
3
4 procedure INSERT_ROW
5 ( p_workitem_obj_code IN VARCHAR2,
6 p_workitem_pk_id IN NUMBER,
7 p_work_item_number IN VARCHAR2,
8 p_title IN VARCHAR2,
9 p_party_id IN NUMBER,
10 p_priority_id IN NUMBER,
11 p_priority_level IN NUMBER,
12 p_due_date IN DATE,
13 p_work_item_status_id IN NUMBER,
14 p_owner_id IN NUMBER,
15 p_owner_type IN VARCHAR2,
16 p_assignee_id IN NUMBER,
17 p_assignee_type IN VARCHAR2,
18 p_owner_type_actual IN VARCHAR2,
19 p_assignee_type_actual IN VARCHAR2,
20 p_source_object_id IN NUMBER,
21 p_source_object_type_code IN VARCHAR2,
22 p_application_id IN NUMBER,
23 p_ieu_enum_type_uuid IN VARCHAR2,
24 p_user_id IN NUMBER,
25 p_login_id IN NUMBER,
26 p_work_source_id IN NUMBER,
27 p_distribution_status_id IN NUMBER,
28 x_work_item_id OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 x_return_status OUT NOCOPY VARCHAR2
31 ) ;
32
33 procedure UPDATE_ROW
34 ( p_WORKITEM_OBJ_CODE IN VARCHAR2,
35 p_workitem_pk_id IN NUMBER,
36 p_title IN VARCHAR2,
37 p_party_id IN NUMBER,
38 p_priority_id IN NUMBER,
39 p_priority_level IN NUMBER,
40 p_due_date IN DATE,
41 p_owner_id IN NUMBER,
42 p_owner_type IN VARCHAR2,
43 p_assignee_id IN NUMBER,
44 p_assignee_type IN VARCHAR2,
45 p_owner_type_actual IN VARCHAR2,
46 p_assignee_type_actual IN VARCHAR2,
47 p_source_object_id IN NUMBER,
48 p_source_object_type_code IN VARCHAR2,
49 p_application_id IN NUMBER,
50 p_work_item_status_id IN NUMBER,
51 p_user_id IN NUMBER,
52 p_login_id IN NUMBER,
53 p_work_source_id IN NUMBER,
54 p_distribution_status_id IN NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2
57
58 );
59
60 PROCEDURE LOAD_ROW
61 ( p_workitem_obj_code IN VARCHAR2,
62 p_workitem_pk_id IN NUMBER,
63 p_work_item_number IN VARCHAR2,
64 p_title IN VARCHAR2,
65 p_party_id IN NUMBER,
66 p_priority_id IN NUMBER,
67 p_priority_level IN NUMBER,
68 p_due_date IN DATE,
69 p_owner_id IN NUMBER,
70 p_owner_type IN VARCHAR2,
71 p_assignee_id IN NUMBER,
72 p_assignee_type IN VARCHAR2,
73 p_owner_type_actual IN VARCHAR2,
74 p_assignee_type_actual IN VARCHAR2,
75 p_source_object_id IN NUMBER,
76 p_source_object_type_code IN VARCHAR2,
77 p_application_id IN NUMBER,
78 p_work_item_status_id IN NUMBER,
79 p_ieu_enum_type_uuid IN NUMBER,
80 p_user_id IN NUMBER,
81 p_login_id IN NUMBER,
82 p_work_source_id IN NUMBER,
83 p_distribution_status_id IN NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 x_return_status OUT NOCOPY VARCHAR2
86
87 );
88
89 procedure DELETE_ROW
90 ( p_workitem_obj_code IN VARCHAR2,
91 p_workitem_pk_id IN NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 x_return_status OUT NOCOPY VARCHAR2
94 );
95
96 end IEU_WR_ITEMS_PKG;
97
[Home] [Help]