1 PACKAGE CS_UWQ_DISTRIBUTE_ITEMS AS
2 /* $Header: csvsrwds.pls 120.2 2006/08/22 00:01:16 nveerara noship $ */
3
4 /*****************************************
5 This procdeure is going to be called by UWQ's distribute_function()
6 to update owner of Service Request in CS when the WI is assigned
7 to an individual owner
8 *******************************************/
9
10 PROCEDURE Distribute_ServiceRequests
11 (P_RESOURCE_ID IN NUMBER,
12 P_LANGUAGE IN VARCHAR2,
13 P_SOURCE_LANG IN VARCHAR2,
14 P_NUM_OF_ITEMS IN NUMBER,
15 P_DIST_BUS_RULES IN SYSTEM.DIST_BUS_RULES_NST,
16 P_WS_INPUT_DATA IN OUT NOCOPY SYSTEM.WR_ITEM_DATA_NST,
17 X_MSG_COUNT OUT NOCOPY NUMBER,
18 X_MSG_DATA OUT NOCOPY VARCHAR2,
19 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
20
21 PROCEDURE SYNC_SR_TASKS(
22 P_TASKS_DATA IN SYSTEM.WR_TASKS_DATA_NST,
23 P_DEF_WR_DATA IN SYSTEM.DEF_WR_DATA_NST,
24 X_MSG_COUNT OUT NOCOPY NUMBER,
25 X_MSG_DATA OUT NOCOPY VARCHAR2,
26 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
27
28
29 PROCEDURE SYNC_SR_TASKS(
30 P_PROCESSING_SET_ID IN NUMBER DEFAULT NULL,
31 X_MSG_COUNT OUT NOCOPY NUMBER,
32 X_MSG_DATA OUT NOCOPY VARCHAR2,
33 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
34
35
36 PROCEDURE DISTRIBUTE_SRTASKS
37 (P_RESOURCE_ID IN NUMBER,
38 P_LANGUAGE IN VARCHAR2,
39 P_SOURCE_LANG IN VARCHAR2,
40 P_NUM_OF_ITEMS IN NUMBER,
41 P_DIST_BUS_RULES IN SYSTEM.DIST_BUS_RULES_NST,
42 P_WS_INPUT_DATA IN OUT NOCOPY SYSTEM.WR_ITEM_DATA_NST,
43 X_MSG_COUNT OUT NOCOPY NUMBER,
44 X_MSG_DATA OUT NOCOPY VARCHAR2,
45 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
46
47
48 END CS_UWQ_DISTRIBUTE_ITEMS;