[Home] [Help]
40: cursor GET_SIGNERS_FOR_EVENT is
41: --Bug 4272262: Start
42: select user_name, original_recipient, to_number(signature_sequence,'999999999999.999999')
43: --Bug 4272262: End
44: from edr_esignatures
45: where event_id = p_event_id
46: --Bug 4272262: Start
47: order by to_number(signature_sequence,'999999999999.999999');
48: --Bug 4272262: Start
92:
93: --Bug 2674799: start
94: -- Use the signature sequence passed to this API.
95:
96: UPDATE EDR_ESIGNATURES
97: SET SIGNATURE_SEQUENCE = p_signaturesequence(i)
98: WHERE EVENT_ID = p_event_id
99: AND USER_NAME =l_final_recipient
100: AND ORIGINAL_RECIPIENT = l_original_recipient;
119:
120: -- if the original recipeint and final recipeint is not found in the row
121: -- set, delete the row
122: if (l_actiondone = G_ACTION_REQD) then
123: DELETE FROM EDR_ESIGNATURES
124: WHERE EVENT_ID = p_event_id
125: AND USER_NAME = l_final_recipient
126: AND ORIGINAL_RECIPIENT = l_original_recipient;
127:
179: if ((l_status is null) or (l_status = G_ACTION_REQD)) then
180: -- you already have the final recipient and overriding details
181: l_overriding_approver := p_finalrecipient(i);
182: l_overriding_comments := p_overridingdetails(i);
183: SELECT EDR_ESIGNATURES_S.NEXTVAL into l_temp_signature_id from
184: DUAL;
185: --Bug 2674799 : start
186:
187: INSERT into EDR_ESIGNATURES
183: SELECT EDR_ESIGNATURES_S.NEXTVAL into l_temp_signature_id from
184: DUAL;
185: --Bug 2674799 : start
186:
187: INSERT into EDR_ESIGNATURES
188: (
189: SIGNATURE_ID,
190: EVENT_ID,
191: EVENT_NAME,