APPS.OKL_AM_WF SQL Statements

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

Line: 29

    SELECT   IT.display_name
    ,        RP.display_name
    FROM     WF_EVENTS             WFEV,
             WF_EVENT_SUBSCRIPTIONS   WFES,
             wf_runnable_processes_v  RP,
             wf_item_types_vl         IT
    WHERE WFEV.guid = WFES.event_filter_guid
    AND   WFES.WF_PROCESS_TYPE = RP.ITEM_TYPE
    AND   WFES.WF_PROCESS_NAME = RP.PROCESS_NAME
    AND   RP.ITEM_TYPE = IT.NAME
    AND   WFEV.NAME  = c_event_name;

Line: 104

 SELECT okl_wf_item_s.nextval
 FROM   dual;

Line: 111

select khr.authoring_org_id
 from okc_k_headers_all_b khr,
      OKL_ASSET_CNDTNS acd,
      okc_k_lines_b kln
where acd.id = p_acd_id
and  acd.kle_id = kln.id
and kln.dnz_chr_id = khr.id;

Line: 218

           l_parameter_list.DELETE;

Line: 278

 SELECT okl_wf_item_s.nextval
 FROM   dual;

Line: 359

       l_parameter_list.DELETE;

Line: 632

 SELECT okl_wf_item_s.nextval
 FROM   dual;

Line: 646

        SELECT name
        FROM   wf_item_attributes
        WHERE  item_type = c_item_type
        AND name IN ('APP_REQUEST_SUB' ,'APP_REMINDER_SUB' ,'APP_APPROVED_SUB',
                   'APP_REJECTED_SUB','APP_REMINDER_HEAD','APP_APPROVED_HEAD',
                   'APP_REJECTED_HEAD') ;

Line: 934

        update ame_temp_old_approver_lists
        set approval_status = null
        where transaction_id = l_transaction_id;

Line: 997

     SELECT APPLICATION_ID
     FROM   FND_APPLICATION
     WHERE  APPLICATION_SHORT_NAME = 'OKL';

Line: 1004

     SELECT count(*)
     FROM   AME_CALLING_APPS
     WHERE  TRANSACTION_TYPE_ID = c_trx_type;

Line: 1011

     SELECT PARENT_ITEM_TYPE, PARENT_ITEM_KEY
     FROM   WF_ITEMS
     WHERE  ITEM_TYPE = c_itemtype
     AND    ITEM_KEY = c_itemkey;

Line: 1213

                    aname               => 'API_INSERTION',
                              avalue              => l_approver_rec.api_insertion);

Line: 1370

            l_approver_rec.api_insertion  := wf_engine.GetItemAttrText (
                                itemtype            => itemtype,
                    itemkey             => itemkey,
                    aname               => 'API_INSERTION');

Line: 1380

            ame_api.updateApprovalStatus(applicationIdIn    => l_app_id,
                                     transactionIdIn    => l_transaction_id,
                                     approverIn         => l_approver_rec,
                                     transactionTypeIn  => l_trx_type);

Line: 1561

            fnd_msg_pub.delete_msg();

Line: 1630

    SELECT NAME, DISPLAY_NAME
    FROM   WF_ROLES
    WHERE  orig_system_id = c_emp_id
    AND    orig_system = c_system;

Line: 1637

    SELECT USER_NAME, DESCRIPTION, EMPLOYEE_ID
    FROM   FND_USER
    WHERE  user_id = c_user_id;

Line: 2227

       SELECT --PT.PTM_CODE REPORT_CODE,
             -- FND.MEANING REPORT_NAME,
              PT.XML_TMPLT_CODE TEMPLATE_CODE,
              --XDOTL.TEMPLATE_NAME,
             -- XDOB.APPLICATION_SHORT_NAME TMPLT_APPS_SHORT_NAME,
             -- XDOB.DS_APP_SHORT_NAME DATA_SRC_APPS_SHORT_NAME,
              XDOB.DATA_SOURCE_CODE,
              PTTL.EMAIL_SUBJECT_LINE
              FROM OKL_PROCESS_TMPLTS_B PT,
              OKL_PROCESS_TMPLTS_TL PTTL,
              FND_LOOKUPS FND,
              XDO_TEMPLATES_B XDOB,
              XDO_TEMPLATES_TL XDOTL
            WHERE PT.PTM_CODE = FND.LOOKUP_CODE
           AND XDOB.TEMPLATE_CODE = XDOTL.TEMPLATE_CODE
           AND XDOB.APPLICATION_SHORT_NAME = 'OKL'
           AND PT.START_DATE <= SYSDATE
           AND NVL(PT.END_DATE,SYSDATE) >= SYSDATE
           AND PT.XML_TMPLT_CODE = XDOB.TEMPLATE_CODE
           AND XDOTL.LANGUAGE = USERENV('LANG')
           AND PT.PTM_CODE = process_code
           AND PT.RECIPIENT_TYPE_CODE = recipient_type
           AND PTTL.ID=PT.ID;