DBA Data[Home] [Help]

PACKAGE: APPS.OKS_WF_K_APPROVE

Source


1 PACKAGE OKS_WF_K_APPROVE AUTHID CURRENT_USER AS
2 /* $Header: OKSWCAPS.pls 120.7 2011/07/29 09:32:40 vgujarat ship $ */
3 
4 procedure Selector  ( 	item_type	in varchar2,
5 			item_key  	in varchar2,
6 			activity_id	in number,
7 			command		in varchar2,
8 			resultout	out NOCOPY varchar2	);
9 procedure Post_Approval(	itemtype	in varchar2,
10 				itemkey  	in varchar2,
11 				actid		in number,
12 				funcmode	in varchar2,
13 				resultout	out NOCOPY varchar2	);
14 procedure Post_Sign(	itemtype	in varchar2,
15 				itemkey  	in varchar2,
16 				actid		in number,
17 				funcmode	in varchar2,
18 				resultout	out NOCOPY varchar2	);
19 procedure note_filled(	itemtype	in varchar2,
20 				itemkey  	in varchar2,
21 				actid		in number,
22 				funcmode	in varchar2,
23 				resultout	out NOCOPY varchar2	);
24 procedure IS_related(	itemtype	in varchar2,
25 				itemkey  	in varchar2,
26 				actid		in number,
27 				funcmode	in varchar2,
28 				resultout	out NOCOPY varchar2	);
29 procedure IS_K_TEMPLATE(itemtype	in varchar2,
30 				itemkey  in varchar2,
31 				actid		in number,
32 				funcmode	in varchar2,
33 				resultout	out NOCOPY varchar2	);
34 procedure MAKE_ACTIVE(itemtype	in varchar2,
35 				itemkey  in varchar2,
36 				actid		in number,
37 				funcmode	in varchar2,
38 				resultout	out NOCOPY varchar2	);
39 procedure Initialize ( 		itemtype	in varchar2,
40 				itemkey  	in varchar2,
41 				actid		in number,
42 				funcmode	in varchar2,
43 				resultout	out NOCOPY varchar2	);
44 procedure Select_Approver(	itemtype	in varchar2,
45 				itemkey  	in varchar2,
46 				actid		in number,
47 				funcmode	in varchar2,
48 				resultout	out NOCOPY varchar2	);
49 
50 procedure Update_AME(	        itemtype	in varchar2,
51 				itemkey  	in varchar2,
52 				actid		in number,
53 				funcmode	in varchar2,
54 				resultout	out NOCOPY varchar2	);
55 procedure Select_Informed(	itemtype	in varchar2,
56 				itemkey  	in varchar2,
57 				actid		in number,
58 				funcmode	in varchar2,
59 				resultout	out NOCOPY varchar2	);
60 procedure Select_Informed_A(	itemtype	in varchar2,
61 				itemkey  	in varchar2,
62 				actid		in number,
63 				funcmode	in varchar2,
64 				resultout	out NOCOPY varchar2	);
65 procedure Select_Informed_AR(	itemtype	in varchar2,
66 				itemkey  	in varchar2,
67 				actid		in number,
68 				funcmode	in varchar2,
69 				resultout	out NOCOPY varchar2	);
70 procedure Select_Informed_S(	itemtype	in varchar2,
71 				itemkey  	in varchar2,
72 				actid		in number,
73 				funcmode	in varchar2,
74 				resultout	out NOCOPY varchar2	);
75 procedure Select_Informed_SR(	itemtype	in varchar2,
76 				itemkey  	in varchar2,
77 				actid		in number,
78 				funcmode	in varchar2,
79 				resultout	out NOCOPY varchar2	);
80 procedure Record_Approved(	itemtype	in varchar2,
81 				itemkey  	in varchar2,
82 				actid		in number,
83 				funcmode	in varchar2,
84 				resultout	out NOCOPY varchar2	);
85 procedure Erase_Approved(	itemtype	in varchar2,
86 				itemkey  	in varchar2,
87 				actid		in number,
88 				funcmode	in varchar2,
89 				resultout	out NOCOPY varchar2	);
90 procedure Record_Signed(	itemtype	in varchar2,
91 				itemkey  	in varchar2,
92 				actid		in number,
93 				funcmode	in varchar2,
94 				resultout	out NOCOPY varchar2	);
95 procedure Record_Rejected(
96                                 itemtype  in         varchar2,
97                                 itemkey   in         varchar2,
98                                	actid	  in         number,
99                                 funcmode  in         varchar2,
100                                 resultout out nocopy VARCHAR2          );
101 procedure was_approver(	itemtype	in varchar2,
102 				itemkey  	in varchar2,
103 				actid		in number,
104 				funcmode	in varchar2,
105 				resultout	out NOCOPY varchar2	);
106 procedure valid_approver(itemtype	in varchar2,
107 				itemkey  	in varchar2,
108 				actid		in number,
109 				funcmode	in varchar2,
110 				resultout	out NOCOPY varchar2	);
111 procedure notify_sales_rep_w (itemtype	in varchar2,
112 				itemkey  	in varchar2,
113 				actid		in number,
114 				funcmode	in varchar2,
115 				resultout	out NOCOPY varchar2	);
116 procedure updt_quote_from_k   (itemtype	in varchar2,
117 				itemkey  	in varchar2,
118 				actid		in number,
119 				funcmode	in varchar2,
120 				resultout	out NOCOPY varchar2	);
121 
122 PROCEDURE invalid_approver(itemtype	IN VARCHAR2,
123 				itemkey  	IN VARCHAR2,
124 				actid		IN NUMBER,
125 				funcmode	IN VARCHAR2,
126 				resultout	OUT NOCOPY VARCHAR2	);
127 
128 PROCEDURE update_invalid_approver(itemtype	IN VARCHAR2,
129 				itemkey  	IN VARCHAR2,
130 				actid		IN NUMBER,
131 				funcmode	IN VARCHAR2,
132 				resultout	OUT NOCOPY VARCHAR2	);
133 
134 
135 --Global variables
136 --
137 G_TERMSFORQUOTE			CONSTANT OKC_K_REL_OBJS.RTY_CODE%TYPE := 'CONTRACTISTERMSFORQUOTE';
138 
139 --added
140 G_NEGOTIATESQUOTE               CONSTANT OKC_K_REL_OBJS.RTY_CODE%TYPE := 'CONTRACTNEGOTIATESQUOTE';
141 
142 G_OBJECT_CODE                   CONSTANT VARCHAR2(30) := 'OKX_QUOTEHEAD';
143 
144 G_APPROVER_EXISTS                 VARCHAR2(10) :='F'; ---Added for bug 8558419
145 
146 end OKS_WF_K_APPROVE;
147