APPS.EDR_ADHOC_USER_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

procedure UPDATE_SIGNERLIST (
        p_event_id             IN number,
        p_event_name           IN VARCHAR2 ,
        p_document_id          IN number,
        p_originalrecipient    IN FND_TABLE_OF_VARCHAR2_255,
        p_finalrecipient       IN FND_TABLE_OF_VARCHAR2_255,
        p_overridingdetails    IN FND_TABLE_OF_VARCHAR2_255,
        p_signaturesequence    IN FND_TABLE_OF_VARCHAR2_255,
        p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
        p_originating_system   IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
        p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
        x_error                OUT NOCOPY NUMBER,
        x_error_msg            OUT NOCOPY VARCHAR2
) IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 39

l_updatestatus FND_TABLE_OF_VARCHAR2_255 := FND_TABLE_OF_VARCHAR2_255();

Line: 42

	   select user_name, original_recipient, to_number(signature_sequence,'999999999999.999999')
           --Bug 4272262: End
	   from edr_esignatures
	   where event_id = p_event_id
           --Bug 4272262: Start
	   order by to_number(signature_sequence,'999999999999.999999');

Line: 53

      l_updatestatus.extend;

Line: 54

      l_updatestatus(i):= G_ACTION_REQD;

Line: 96

                    UPDATE EDR_ESIGNATURES
                        SET SIGNATURE_SEQUENCE = p_signaturesequence(i)
                        WHERE EVENT_ID = p_event_id
		        AND USER_NAME =l_final_recipient
		        AND ORIGINAL_RECIPIENT = l_original_recipient;

Line: 102

                    edr_psig.update_signature_sequence (
                                          P_SIGNATURE_ID => l_psig_signature_id,
                                          P_SIGNATURE_SEQUENCE =>
p_signaturesequence(i),
                                          X_ERROR => l_error,
                                          X_ERROR_MSG => l_error_msg);

Line: 114

                l_updatestatus(i) := G_NO_ACTION_REQD;

Line: 123

          DELETE FROM EDR_ESIGNATURES
            WHERE EVENT_ID = p_event_id
            AND USER_NAME = l_final_recipient
            AND ORIGINAL_RECIPIENT = l_original_recipient;

Line: 142

             edr_psig.delete_adhoc_user (P_SIGNATURE_ID =>  l_psig_signature_id,
                                         X_ERROR => l_error,
                                         X_ERROR_MSG => l_error_msg);

Line: 157

             edr_psig.update_adhoc_status ( P_SIGNATURE_ID =>
l_psig_signature_id,
                                            P_ADHOC_STATUS => 'DELETED',
                                            X_ERROR => l_error,
                                            X_ERROR_MSG => l_error_msg);

Line: 172

            l_status :=  l_updatestatus(i);

Line: 183

               SELECT EDR_ESIGNATURES_S.NEXTVAL into l_temp_signature_id from
DUAL;

Line: 187

               INSERT into EDR_ESIGNATURES
		(
			 SIGNATURE_ID,
			 EVENT_ID,
			 EVENT_NAME,
			 USER_NAME,
			 SIGNATURE_SEQUENCE,
			 SIGNATURE_STATUS,
			 ADHOC_STATUS,
			 ORIGINAL_RECIPIENT,
			 SIGNATURE_OVERRIDING_COMMENTS
		)
	        values
		(
			 l_temp_signature_id,
			 p_event_id,
			 p_event_name,
			 l_overriding_approver,
			 p_signaturesequence(i),
			 'PENDING',
			 'ADDED',
			 l_original_recipient,
			 l_overriding_comments
	         );

Line: 246

END UPDATE_SIGNERLIST;