1 PACKAGE IEU_UWQM_PUB AUTHID CURRENT_USER AS
2 /* $Header: IEUPUMTS.pls 115.11 2003/11/13 22:34:46 ckurian ship $ */
3
4 /* PROGRAM OBSOLETED */
5
6 -- Status_id : 0 - open , 1 - Locked, 2 - WIP , 4 - Closed, 5 - Delete
7
8 g_pkg_name CONSTANT VARCHAR2(30) := 'IEU_UWQM_PUB';
9
10
11 PROCEDURE CREATE_UWQM_ITEM
12 ( p_api_version IN NUMBER,
13 p_init_msg_list IN VARCHAR2,
14 p_commit IN VARCHAR2,
15 p_workitem_obj_code IN VARCHAR2,
16 p_workitem_pk_id IN NUMBER ,
17 p_work_item_number IN VARCHAR2,
18 p_title IN VARCHAR2 ,
19 p_party_id IN NUMBER,
20 p_priority_code IN VARCHAR2,
21 p_due_date IN DATE,
22 p_owner_id IN NUMBER,
23 p_owner_type IN VARCHAR2,
24 p_assignee_id IN NUMBER,
25 p_assignee_type IN VARCHAR2,
26 p_source_object_id IN NUMBER,
27 p_source_object_type_code IN VARCHAR2,
28 p_application_id IN NUMBER,
29 p_ieu_enum_type_uuid IN VARCHAR2,
30 p_work_status_flag IN VARCHAR2,
31 p_user_id IN NUMBER,
32 p_login_id IN NUMBER,
33 x_work_item_id OUT NOCOPY NUMBER,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2);
37
38 PROCEDURE UPDATE_UWQM_ITEM
39 ( p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2,
41 p_commit IN VARCHAR2,
42 p_workitem_obj_code IN VARCHAR2,
43 p_workitem_pk_id IN NUMBER,
44 p_title IN VARCHAR2,
45 p_party_id IN NUMBER,
46 p_priority_code IN VARCHAR2,
47 p_due_date IN DATE,
48 p_owner_id IN NUMBER,
49 p_owner_type IN VARCHAR2,
50 p_assignee_id IN NUMBER,
51 p_assignee_type IN VARCHAR2,
52 p_source_object_id IN NUMBER,
53 p_source_object_type_code IN VARCHAR2,
54 p_application_id IN NUMBER,
55 p_user_id IN NUMBER,
56 p_login_id IN NUMBER,
57 -- p_ieu_enum_type_uuid IN NOCOPY VARCHAR2 DEFAULT fnd_api.g_miss_char,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2);
61
62 PROCEDURE OPEN_UWQM_ITEM
63 ( p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2,
65 p_commit IN VARCHAR2,
66 p_workitem_obj_code IN VARCHAR2,
67 p_workitem_pk_id IN NUMBER,
68 p_user_id IN NUMBER,
69 p_login_id IN NUMBER,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 x_return_status OUT NOCOPY VARCHAR2);
73
74 PROCEDURE USE_UWQM_ITEM
75 ( p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2,
77 p_commit IN VARCHAR2,
78 p_workitem_obj_code IN VARCHAR2,
79 p_workitem_pk_id IN NUMBER,
80 p_user_id IN NUMBER,
81 p_login_id IN NUMBER,
82 x_work_item_id OUT NOCOPY NUMBER,
83 x_work_item_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2);
87
88 PROCEDURE RELEASE_UWQM_ITEM
89 ( p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2,
91 p_commit IN VARCHAR2,
92 p_workitem_obj_code IN VARCHAR2,
93 p_workitem_pk_id IN NUMBER,
94 p_work_item_id IN NUMBER,
95 p_user_id IN NUMBER,
96 p_login_id IN NUMBER,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 x_return_status OUT NOCOPY VARCHAR2);
100
101 PROCEDURE CLOSE_UWQM_ITEM
102 ( p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2,
104 p_commit IN VARCHAR2,
105 p_workitem_obj_code IN VARCHAR2,
106 p_workitem_pk_id IN NUMBER,
107 p_user_id IN NUMBER,
108 p_login_id IN NUMBER,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2);
112
113 PROCEDURE DELETE_UWQM_ITEM
114 ( p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2,
116 p_commit IN VARCHAR2,
117 p_workitem_obj_code IN VARCHAR2,
118 p_workitem_pk_id IN NUMBER,
119 p_user_id IN NUMBER,
120 p_login_id IN NUMBER,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 x_return_status OUT NOCOPY VARCHAR2);
124
125 PROCEDURE RESCHEDULE_UWQM_ITEM
126 ( p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2,
128 p_commit IN VARCHAR2,
129 p_workitem_obj_code IN VARCHAR2,
130 p_workitem_pk_id IN NUMBER,
131 p_work_item_id IN NUMBER,
132 p_reschedule_time IN DATE,
133 p_user_id IN NUMBER,
134 p_login_id IN NUMBER,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2) ;
138
139 PROCEDURE GET_UWQM_ITEM_WORK_STATUS
140 ( p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2,
142 p_commit IN VARCHAR2,
143 p_workitem_obj_code IN VARCHAR2,
144 p_workitem_pk_id IN NUMBER,
145 p_work_item_id IN NUMBER,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 x_work_item_status OUT NOCOPY VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2);
150
151
152 END IEU_UWQM_PUB;