APPS.EDR_EINITIALS_PVT dependencies on EDR_ESIGNATURES

Line 239: FROM EDR_ESIGNATURES

235:
236: CURSOR FETCH_OVERRIDING_DETAILS IS
237: SELECT ORIGINAL_RECIPIENT,
238: SIGNATURE_OVERRIDING_COMMENTS
239: FROM EDR_ESIGNATURES
240: WHERE EVENT_ID = L_EVENT_ID
241: AND SIGNATURE_ID = P_SIGNATURE_ID;
242:
243: BEGIN

Line 271: --Update the signer details in the EDR_ESIGNATURES table.

267:
268: --Check if the role name is null or if it contains a responsibility.
269: IF P_ROLE_NAME IS NULL OR INSTR(P_ROLE_NAME,'#') = 1 THEN
270:
271: --Update the signer details in the EDR_ESIGNATURES table.
272: UPDATE EDR_ESIGNATURES
273: SET USER_NAME = P_SIGNER_NAME,
274: SIGNATURE_TYPE = P_SIGNER_TYPE,
275: SIGNATURE_TIMESTAMP = SYSDATE,

Line 272: UPDATE EDR_ESIGNATURES

268: --Check if the role name is null or if it contains a responsibility.
269: IF P_ROLE_NAME IS NULL OR INSTR(P_ROLE_NAME,'#') = 1 THEN
270:
271: --Update the signer details in the EDR_ESIGNATURES table.
272: UPDATE EDR_ESIGNATURES
273: SET USER_NAME = P_SIGNER_NAME,
274: SIGNATURE_TYPE = P_SIGNER_TYPE,
275: SIGNATURE_TIMESTAMP = SYSDATE,
276: SIGNATURE_STATUS = P_SIGNER_RESPONSE,

Line 325: --Update the signer response in EDR_ESIGNATURES table.

321: END IF;
322:
323: ELSE
324:
325: --Update the signer response in EDR_ESIGNATURES table.
326: UPDATE EDR_ESIGNATURES
327: SET SIGNATURE_TYPE = P_SIGNER_TYPE,
328: SIGNATURE_TIMESTAMP = SYSDATE,
329: SIGNATURE_STATUS = P_SIGNER_RESPONSE,

Line 326: UPDATE EDR_ESIGNATURES

322:
323: ELSE
324:
325: --Update the signer response in EDR_ESIGNATURES table.
326: UPDATE EDR_ESIGNATURES
327: SET SIGNATURE_TYPE = P_SIGNER_TYPE,
328: SIGNATURE_TIMESTAMP = SYSDATE,
329: SIGNATURE_STATUS = P_SIGNER_RESPONSE,
330: SIGNER_COMMENTS = P_SIGNER_COMMENTS,

Line 339: --Fetch the overring details from edr_esignatures table.

335:
336: --Fetch the signer response meaning from FND LOOKUPS.
337: EDR_STANDARD.GET_MEANING('EDR_SIGN_RESPONSE_TYPE', P_SIGNER_RESPONSE,L_RESPONSE_MEANING);
338:
339: --Fetch the overring details from edr_esignatures table.
340: OPEN FETCH_OVERRIDING_DETAILS;
341: FETCH FETCH_OVERRIDING_DETAILS INTO L_ORIGINAL_RECIPIENT,L_OVERRIDING_COMMENTS;
342: CLOSE FETCH_OVERRIDING_DETAILS;
343: