1 package IEU_UWQM_ITEMS_PKG AUTHID CURRENT_USER as
2 /* $Header: IEUUWQMS.pls 120.0 2005/06/02 15:48:28 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_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 x_work_item_id OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 x_return_status OUT NOCOPY VARCHAR2
29 ) ;
30
31 procedure UPDATE_ROW
32 ( p_WORKITEM_OBJ_CODE IN VARCHAR2,
33 p_workitem_pk_id IN NUMBER,
34 p_title IN VARCHAR2,
35 p_party_id IN NUMBER,
36 p_priority_id IN NUMBER,
37 p_priority_level IN NUMBER,
38 p_due_date IN DATE,
39 p_owner_id IN NUMBER,
40 p_owner_type IN VARCHAR2,
41 p_assignee_id IN NUMBER,
42 p_assignee_type IN VARCHAR2,
43 p_owner_type_actual IN VARCHAR2,
44 p_assignee_type_actual IN VARCHAR2,
45 p_source_object_id IN NUMBER,
46 p_source_object_type_code IN VARCHAR2,
47 p_application_id IN NUMBER,
48 p_user_id IN NUMBER,
49 p_login_id IN NUMBER,
50 -- p_ieu_enum_type_uuid IN VARCHAR2,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2
53
54 );
55
56 PROCEDURE LOAD_ROW
57 ( p_workitem_obj_code IN VARCHAR2,
58 p_workitem_pk_id IN NUMBER,
59 p_work_item_number IN VARCHAR2,
60 p_title IN VARCHAR2,
61 p_party_id IN NUMBER,
62 p_priority_id IN NUMBER,
63 p_priority_level IN NUMBER,
64 p_due_date IN DATE,
65 p_owner_id IN NUMBER,
66 p_owner_type IN VARCHAR2,
67 p_assignee_id IN NUMBER,
68 p_assignee_type IN VARCHAR2,
69 p_owner_type_actual IN VARCHAR2,
70 p_assignee_type_actual IN VARCHAR2,
71 p_source_object_id IN NUMBER,
72 p_source_object_type_code IN VARCHAR2,
73 p_application_id IN NUMBER,
74 p_ieu_enum_type_uuid IN NUMBER,
75 p_user_id IN NUMBER,
76 p_login_id IN NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 x_return_status OUT NOCOPY VARCHAR2
79
80 );
81
82 procedure DELETE_ROW
83 ( p_work_item_id IN NUMBER,
84 p_workitem_obj_code IN VARCHAR2,
85 p_workitem_pk_id IN NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 x_return_status OUT NOCOPY VARCHAR2
88 );
89
90 procedure UPDATE_STATUS_FLAG
91 ( p_workitem_obj_code IN VARCHAR2,
92 p_workitem_pk_id IN NUMBER,
93 p_work_item_id IN NUMBER DEFAULT NULL,
94 p_status_update_user_id IN NUMBER,
95 p_status_id IN NUMBER,
96 -- p_start_time IN DATE DEFAULT NULL,
97 x_return_status OUT NOCOPY VARCHAR2
98 );
99
100
101 end IEU_UWQM_ITEMS_PKG;
102