APPS.EDR_PSIG_MSCA_PAGE_FLOW dependencies on EDR_ESIGNATURES

Line 39: FROM edr_esignatures

35: BEGIN
36:
37: --Validate the signature sequence
38: SELECT min(signature_sequence) into l_sign_sequence
39: FROM edr_esignatures
40: WHERE EVENT_ID = p_event_id
41: and SIGNATURE_STATUS = 'PENDING';
42:
43: --If the sequence is out of order, then raise an error.

Line 74: --Update EDR_ESIGNATURES table with the signature details.

70:
71: l_param_table(i).Param_displayname := p_sig_param_display_names(i);
72: END LOOP;
73:
74: --Update EDR_ESIGNATURES table with the signature details.
75: --As this table is associated with workflow, the signer code and signer reason
76: --code is passed.
77: UPDATE EDR_ESIGNATURES
78: SET SIGNATURE_STATUS = p_action_code ,

Line 77: UPDATE EDR_ESIGNATURES

73:
74: --Update EDR_ESIGNATURES table with the signature details.
75: --As this table is associated with workflow, the signer code and signer reason
76: --code is passed.
77: UPDATE EDR_ESIGNATURES
78: SET SIGNATURE_STATUS = p_action_code ,
79: SIGNATURE_TYPE = l_SIGNER_code,
80: SIGNATURE_REASON_CODE = l_signing_reason_code,
81: SIGNATURE_TIMESTAMP = SYSDATE,