APPS.PO_WF_DEBUG_PKG SQL Statements

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

Line: 15

procedure insert_debug (itemtype varchar2,
                        itemkey  varchar2,
                        x_progress  varchar2) is

/* Bug# 1632741: kagarwal
** Desc: Making procedure insert_debug an autonomous transaction as
** there should never be a commit in any code that is called by the
** workflow engine that will be executed in the same transaction.
*/

  pragma AUTONOMOUS_TRANSACTION;

Line: 94

      insert into PO_WF_DEBUG
                        (EXECUTION_SEQUENCE,
                         EXECUTION_DATE,
                         ITEMTYPE,
                         ITEMKEY,
                         DOCUMENT_ID,
                         DOCUMENT_NUMBER,
                         PREPARER_ID,
                         APPROVER_EMPID,
                         FORWARD_TO_ID,
                         FORWARD_TO_USERNAME,
                         FORWARD_FROM_ID,
                         FORWARD_FROM_USERNAME,
                         AUTHORIZATION_STATUS,
                         DEBUG_MESSAGE)
                        values(po_wf_debug_s.nextval,
                                sysdate,
                                itemtype,
                                itemkey,
                                l_document_id,
                                l_document_number,
                                l_preparer_id,
                                l_approver_empid,
                                l_Forward_to_id,
                                l_Forward_to_username,
                                l_Forward_from_id,
                                l_Forward_from_username,
                                l_Authorization_status,
                                x_progress);

Line: 147

END insert_debug;

Line: 167

    INSERT INTO po_wf_debug (  execution_sequence
                             , execution_date
                             , debug_message
                            )
    VALUES                  (  po_wf_debug_s.NEXTVAL
                             , SYSDATE
                             , SUBSTRB(p_log_head || '.' || p_token || ':' || p_message, 1, 1000));