1 PACKAGE EDR_PSIG_MSCA_PAGE_FLOW AS
2 /* $Header: EDRVMPFS.pls 120.1.12000000.1 2007/01/18 05:56:29 appldev ship $ */
3
4
5 --This procedeure would process the signature process of the approvers in
6 --MSCA page flow and update the ERES tables accordingly.
7 --This is a PRIVATE procedure
8
9 -- Start of comments
10 -- API name : PROCESS_RESPONSE
11 -- Type : Private
12 -- Function : Processes the signature response.
13 -- Pre-reqs : None.
14 -- Parameters :
15 -- IN : p_event_id IN NUMBER - The event Id value.
16 -- : p_erecord_id IN NUMBER - The e-record ID value
17 -- : p_user_name IN VARCHAR2 - The approver's user name
18 -- : p_action_code IN VARCHAR2 - The action code
19 -- : p_action_meaning IN VARCHAR2 - The action meaning
20 -- : p_sign_sequence IN NUMBER - The approver sequence number
21 -- : p_signature_param_names IN FND_TABLE_OF_VARCHAR2_255 - List of signature parameter names
22 -- : p_signature_param_values IN FND_TABLE_OF_VARCHAR2_255 - List of signature parameter values
23 -- : p_sig_param_display_names IN FND_TABLE_OF_VARCHAR2_255 - List of signature parameter display values
24
25 -- OUT : x_error_code OUT NOCOPY NUMBER - The status code
26 -- : x_error_msg OUT NOCOPY VARCHAR2 - The return message indicating success/error.
27
28 PROCEDURE PROCESS_RESPONSE( p_event_id IN NUMBER,
29 p_erecord_id IN NUMBER,
30 p_user_name IN VARCHAR2,
31 p_action_code IN VARCHAR2,
32 p_action_meaning IN VARCHAR2,
33 p_sign_sequence IN NUMBER,
34 p_signature_param_names IN FND_TABLE_OF_VARCHAR2_255,
35 p_signature_param_values IN FND_TABLE_OF_VARCHAR2_255,
36 p_sig_param_display_names IN FND_TABLE_OF_VARCHAR2_255,
37 x_error_code OUT NOCOPY NUMBER,
38 x_error_msg OUT NOCOPY VARCHAR2);
39
40
41 --This procedeure would process pageflow for the CANCEL response.
42 --This is a PRIVATE procedure
43
44 -- Start of comments
45 -- API name : PROCESS_CANCEL
46 -- Type : Private
47 -- Function : Processes the CANCEL RESPONSE
48 -- Pre-reqs : None.
49 -- Parameters :
50 -- IN : p_erecord_id IN NUMBER - The e-record ID value
51 -- : p_itemtype IN VARCHAR2 - The pageflow item type
52 -- : p_itemkey IN VARCHAR2 - The pageflow item key value
53
54 -- OUT : x_error_code OUT NOCOPY NUMBER - The status code
55 -- : x_error_msg OUT NOCOPY VARCHAR2 - The return message indicating success/error.
56
57 PROCEDURE PROCESS_CANCEL(p_erecord_id IN NUMBER,
58 p_itemtype IN VARCHAR2,
59 p_itemkey IN VARCHAR2,
60 x_error_code OUT NOCOPY NUMBER,
61 x_error_msg OUT NOCOPY VARCHAR2);
62
63
64 --This procedeure would process pageflow for the CANCEL response.
65 --This is a PRIVATE procedure
66
67 -- Start of comments
68 -- API name : PROCESS_MSCA_BLOCKED_ACTIVITY
69 -- Type : Private
70 -- Function : This API would perform the actual pageflow block activities
71 -- : based on the action parameter.
72 -- Pre-reqs : None.
73 -- Parameters :
74 -- IN : p_itemtype IN VARCHAR2 - The pageflow item type
75 -- : p_itemkey IN VARCHAR2 - The pageflow item key value
76 -- : p_action IN VARCHAR2 - The action required
77 -- - The possible are "DONE","DEFER"
78
79 -- OUT : x_error_code OUT NOCOPY NUMBER - The status code
80 -- : x_error_msg OUT NOCOPY VARCHAR2 - The return message indicating success/error.
81
82 PROCEDURE PROCESS_MSCA_BLOCKED_ACTIVITY(p_itemtype IN VARCHAR2,
83 p_itemkey IN VARCHAR2,
84 p_action IN VARCHAR2,
85 x_error_code OUT NOCOPY NUMBER,
86 x_error_msg OUT NOCOPY VARCHAR2);
87
88
89
90 --This procedeure would process pageflow for the DEFER response.
91 --This is a PRIVATE procedure
92
93 -- Start of comments
94 -- API name : PROCESS_DEFER
95 -- Type : Private
96 -- Function : Processes the DEFER RESPONSE
97 -- Pre-reqs : None.
98 -- Parameters :
99 -- IN : p_erecord_id IN NUMBER - The e-record ID value
100 -- : p_itemtype IN VARCHAR2 - The pageflow item type
101 -- : p_itemkey IN VARCHAR2 - The pageflow item key value
102
103 -- OUT : x_error_code OUT NOCOPY NUMBER - The status code
104 -- : x_error_msg OUT NOCOPY VARCHAR2 - The return message indicating success/error.
105
106 PROCEDURE PROCESS_DEFER(p_erecord_id IN NUMBER,
107 p_itemtype IN VARCHAR2,
108 p_itemkey IN VARCHAR2,
109 x_error_code OUT NOCOPY NUMBER,
110 x_error_msg OUT NOCOPY VARCHAR2);
111
112
113
114 --This procedeure provides a wrapper over the API EDR_PSIG.CLOSEDOCUMENT
115 --This procedure has been defined to perform the closeDocument operation
116 --in an autonomous transaction.
117 --This is a PRIVATE procedure
118
119 -- Start of comments
120 -- API name : CLOSE_DOCUMENT
121 -- Type : Private
122 -- Function : Closes the specified document in evidence store.
123 -- Pre-reqs : None.
124 -- Parameters :
125 -- IN : P_DOCUMENT_ID IN NUMBER - The ID of the document to be closed.
126
127 -- OUT : x_error_code OUT NOCOPY NUMBER - The status code
128 -- : x_error_msg OUT NOCOPY VARCHAR2 - The return message indicating success/error.
129
130 PROCEDURE CLOSE_DOCUMENT(P_DOCUMENT_ID IN NUMBER,
131 X_ERROR OUT NOCOPY NUMBER,
132 X_ERROR_MSG OUT NOCOPY VARCHAR2
133 );
134
135 END EDR_PSIG_MSCA_PAGE_FLOW;