1 PACKAGE EDR_EINITIALS_PVT AS
2 /*$Header: EDRVINTS.pls 120.3.12000000.1 2007/01/18 05:56:18 appldev ship $ */
3
4 -- Start of comments
5 -- API name : GET_WF_ATTRIBUTES
6 -- Type : Private.
7 -- Function : This procedure is primarily used to fetch the values of the specified
8 -- workflow attributes.
9 -- Pre-reqs : None
10 --
11 -- IN : P_ITEMTYPE - The workflow item type.
12 -- : P_ITEMKEY - The workflow item key.
13 -- : P_PARAM_NAMES - The parameter names whose values are required.
14 --
15 -- OUT : X_PARAM_VALUES - The corresponding parameter values.
16 PROCEDURE GET_WF_ATTRIBUTES(P_ITEMTYPE IN VARCHAR2,
17 P_ITEMKEY IN VARCHAR2,
18 P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
19 X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255);
20
21
22
23 -- Start of comments
24 -- API name : GET_ERECORD_DETAILS
25 -- Type : Private.
26 -- Function : This procedure would return the values of the specified workflow attributes and also
27 -- the e-record text associated with the workflow item type and item key.
28 -- Pre-reqs : None
29 --
30 -- IN : P_ITEMTYPE - The workflow item type.
31 -- : P_ITEMKEY - The workflow item key.
32 -- : P_PARAM_NAMES - The parameter names whose values are required.
33 --
34 -- OUT : X_PARAM_VALUES - The corresponding parameter values.
35 -- : X_ERECORD_TEXT - The e-record text.
36 PROCEDURE GET_ERECORD_DETAILS(P_ITEMTYPE IN VARCHAR2,
37 P_ITEMKEY IN VARCHAR2,
38 P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
39 X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
40 X_ERECORD_TEXT OUT NOCOPY CLOB);
41
42 -- Start of comments
43 -- API name : GET_ERECORD_DETAILS
44 -- Type : Private.
45 -- Function : This procedure would return the values of the specified workflow attributes and also
46 -- the e-record text associated with the ERES process ID.
47 -- Pre-reqs : None
48 --
49 -- IN : P_PROCESS_ID - The ERES process ID.
50 -- : P_PARAM_NAMES - The parameter names whose values are required.
51 --
52 -- OUT : X_ITEMTYPE - The workflow item type associated with the process ID.
53 -- : X_ITEMKEY - The workflow item key associated with the process ID.
54 -- : X_PARAM_VALUES - The workflow attribute values.
55 -- : X_ERECORD_COUNT - The number of e-records associated with the process ID.
56 -- : X_ESIGN_COMPLETED - A flag indicating if e-signature is already completed for the e-record
57 -- associated with the process ID.
58 -- : X_ERECORD_TEXT - The e-record text.
59
60 PROCEDURE GET_ERECORD_DETAILS(P_PROCESS_ID IN VARCHAR2,
61 P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
62 X_ITEMTYPE OUT NOCOPY VARCHAR2,
63 X_ITEMKEY OUT NOCOPY VARCHAR2,
64 X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
65 X_ERECORD_COUNT OUT NOCOPY NUMBER,
66 X_ESIGN_COMPLETED OUT NOCOPY VARCHAR2,
67 X_ERECORD_TEXT OUT NOCOPY CLOB);
68
69
70 -- Start of comments
71 -- API name : POST_SIGNATURE_DETAILS
72 -- Type : Private.
73 -- Function : This procedure posts the signature details as specified in the API parameters.
74 -- A return flag would indicate if the signature process was successful for the approver
75 -- specified in the API parameters.
76
77 -- Pre-reqs : None
78 --
79 -- IN : P_ERECORD_ID - The ERES process ID.
80 -- : P_ITEMTYPE - The workflow item type.
81 -- : P_ITEMKEY - The workflow item key.
82 -- : P_SIGNATURE_ID - The signature ID.
83 -- : P_ROLE_NAME - The role names associated with the approver.
84 -- : P_SIGNER_NAME - The signer name.
85 -- : P_SIGNER_PASSWORD - The password used to sign the transaction.
86 -- : P_SIGNATURE_SEQUENCE - The signature sequence.
87 -- : P_SIGNER_RESPONSE - The signer response value.
88 -- : P_SIGNER_TYPE - The signer type value.
89 -- : P_SIGNER_COMMENTS - The signer comments value.
90 -- : P_SIGNING_REASON - The signing reason value.
91
92 -- OUT : X_IS_APPROVER_VALID - A flag indicating if the approver details are valid.
93 PROCEDURE POST_SIGNATURE_DETAILS(P_ERECORD_ID IN VARCHAR2,
94 P_ITEMTYPE IN VARCHAR2,
95 P_ITEMKEY IN VARCHAR2,
96 P_SIGNATURE_ID IN NUMBER,
97 P_ROLE_NAME IN VARCHAR2,
98 P_SIGNER_NAME IN VARCHAR2,
99 P_SIGNER_PASSWORD IN VARCHAR2,
100 P_SIGNATURE_SEQUENCE IN NUMBER,
101 P_SIGNER_RESPONSE IN VARCHAR2,
102 P_SIGNER_TYPE IN VARCHAR2,
103 P_SIGNER_COMMENTS IN VARCHAR2,
104 P_SIGNING_REASON IN VARCHAR2,
105 X_IS_APPROVER_VALID OUT NOCOPY VARCHAR2,
106 X_SIGNER_DISPLAY_NAME OUT NOCOPY VARCHAR2);
107
108
109 -- Start of comments
110 -- API name : COMPLETE_SIGNATURE
111 -- Type : Private.
112 -- Function : This procedure completes the signature process for the specified on the workflow item type and item key.
113 -- It returns the final e-record status for the specified e-record ID.
114
115 -- Pre-reqs : None
116 --
117 -- IN : P_ITEMTYPE - The workflow item type.
118 -- : P_ITEMKEY - The workflow item key.
119 -- : P_ERECORD_ID - The e-record ID whose signature is to be canceled.
120 -- : P_UPDATE_ORES_TEMP_TABLES - A flag indicating if the ORES temp tables should be updated.
121 -- : X_ERECORD_STATUS - The final e-record status for the specified e-record ID.
122
123 PROCEDURE COMPLETE_SIGNATURE(P_ITEMTYPE IN VARCHAR2,
124 P_ITEMKEY IN VARCHAR2,
125 P_ERECORD_ID IN VARCHAR2,
126 P_UPDATE_ORES_TEMP_TABLES IN VARCHAR2,
127 X_ERECORD_STATUS OUT NOCOPY VARCHAR2);
128
129
130
131
132
133
134 -- Start of comments
135 -- API name : CANCEL_SIGNATURE
136 -- Type : Private.
137 -- Function : This procedure cancels the signature process based on the workflow item type and item key.
138 -- Pre-reqs : None
139 --
140 -- IN : P_ITEMTYPE - The workflow item type.
141 -- : P_ITEMKEY - The workflow item key.
142 -- : P_ERECORD_ID - The e-record ID whose signature is to be canceled.
143 -- : P_UPDATE_ORES_TEMP_TABLES - A flag indicating if the ORES temp tables should be updated.
144 PROCEDURE CANCEL_SIGNATURE(P_ITEMTYPE IN VARCHAR2,
145 P_ITEMKEY IN VARCHAR2,
146 P_ERECORD_ID IN VARCHAR2,
147 P_UPDATE_ORES_TEMP_TABLES IN VARCHAR2);
148
149
150 END EDR_EINITIALS_PVT;