[Home] [Help]
PACKAGE: APPS.CUG_GENERIC_WF_PKG
Source
1 Package CUG_GENERIC_WF_PKG AUTHID CURRENT_USER AS
2 /* $Header: CUGGNWFS.pls 115.17 2003/02/20 22:31:51 rhungund noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- Enter package declarations as shown below
13
14
15
16 PROCEDURE GET_OTHER_SR_ATTRIBUTES(
17 itemtype VARCHAR2,
18 itemkey VARCHAR2,
19 actid NUMBER,
20 funmode VARCHAR2,
21 result OUT NOCOPY VARCHAR2 );
22
23 PROCEDURE REPLACE_SR_OWNER(
24 itemtype VARCHAR2,
25 itemkey VARCHAR2,
26 actid NUMBER,
27 funmode VARCHAR2,
28 result OUT NOCOPY VARCHAR2 );
29
30 PROCEDURE ALLOW_ADDRESS_OVERWRITE(
31 itemtype VARCHAR2,
32 itemkey VARCHAR2,
33 actid NUMBER,
34 funmode VARCHAR2,
35 result OUT NOCOPY VARCHAR2 );
36
37 PROCEDURE DUPLICATE_CHECKING_REQUIRED(
38 itemtype VARCHAR2,
39 itemkey VARCHAR2,
40 actid NUMBER,
41 funmode VARCHAR2,
42 result OUT NOCOPY VARCHAR2 );
43
44 PROCEDURE SR_A_DUPLICATE(
45 itemtype VARCHAR2,
46 itemkey VARCHAR2,
47 actid NUMBER,
48 funmode VARCHAR2,
49 result OUT NOCOPY VARCHAR2 );
50
51 PROCEDURE UPDATE_DUPLICATE_INFO(
52 itemtype VARCHAR2,
53 itemkey VARCHAR2,
54 actid NUMBER,
55 funmode VARCHAR2,
56 result OUT NOCOPY VARCHAR2 );
57
58 PROCEDURE CREATE_ALL_SR_TASKS(
59 itemtype VARCHAR2,
60 itemkey VARCHAR2,
61 actid NUMBER,
62 funmode VARCHAR2,
63 result OUT NOCOPY VARCHAR2 );
64
65 PROCEDURE CHECK_ON_TASK_STATUS(
66 itemtype VARCHAR2,
67 itemkey VARCHAR2,
68 actid NUMBER,
69 funmode VARCHAR2,
70 result OUT NOCOPY VARCHAR2 );
71
72
73 PROCEDURE CALCULATE_DUPLICATE_TIME_FRAME(p_service_request_id NUMBER,
74 p_request_type_id NUMBER,
75 p_duplicate_time_frame OUT NOCOPY DATE);
76
77
78 PROCEDURE CALCULATE_DATE(p_uom IN VARCHAR2,
79 p_offset IN NUMBER,
80 x_date OUT NOCOPY DATE);
81
82 PROCEDURE start_task_workflow (
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
85 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
86 p_task_id IN NUMBER,
87 p_old_assignee_code IN VARCHAR2 DEFAULT NULL,
88 p_old_assignee_id IN NUMBER DEFAULT NULL,
89 p_new_assignee_code IN VARCHAR2 DEFAULT NULL,
90 p_new_assignee_id IN NUMBER DEFAULT NULL,
91 p_old_owner_code IN VARCHAR2 DEFAULT NULL,
92 p_old_owner_id IN NUMBER DEFAULT NULL,
93 p_new_owner_code IN VARCHAR2 DEFAULT NULL,
94 p_new_owner_id IN NUMBER DEFAULT NULL,
95 p_wf_display_name IN VARCHAR2 DEFAULT NULL,
96 p_tsk_typ_attr_dep_id IN NUMBER,
97 p_wf_process IN VARCHAR2 DEFAULT 'TASK_WORKFLOW',
98 p_wf_item_type IN VARCHAR2 DEFAULT 'JTFTASK',
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104
105 PROCEDURE VALIDATE_TASK_DETAILS(p_task_type_id NUMBER,
106 p_task_status_id NUMBER,
107 p_task_priority_id NUMBER,
108 p_itemkey VARCHAR2,
109 p_return_status OUT NOCOPY VARCHAR2);
110
111
112
113 PROCEDURE Update_CIC_Request_Info ( itemtype VARCHAR2,
114 itemkey VARCHAR2,
115 actid NUMBER,
116 funmode VARCHAR2,
117 result OUT NOCOPY VARCHAR2 );
118
119 PROCEDURE CIC_Initialize_Request(itemtype VARCHAR2,
120 itemkey VARCHAR2,
121 actid NUMBER,
122 funmode VARCHAR2,
123 result OUT NOCOPY VARCHAR2 );
124 END; -- Package spec