APPS.WIP_COMMON_WF_PKG SQL Statements

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

Line: 18

PROCEDURE SelectBuyer( itemtype  in varchar2,
                       itemkey   in varchar2,
                       actid     in number,
                       funcmode  in varchar2,
                       resultout out NOCOPY varchar2) is

  l_po_header_id number :=
    wf_engine.GetItemAttrText( itemtype => itemtype,
                               itemkey  => itemkey,
                               aname    => 'PO_HEADER_ID');

Line: 62

    wf_core.context('WIP_COMMON_WF_PKG',  'SelectBuyer',
        itemtype, itemkey, actid, funcmode);

Line: 66

END SelectBuyer;

Line: 68

PROCEDURE SelectSupplierCNT( itemtype  in varchar2,
                       itemkey   in varchar2,
                       actid     in number,
                       funcmode  in varchar2,
                       resultout out NOCOPY varchar2) is

  l_po_header_id number :=
    wf_engine.GetItemAttrText( itemtype => itemtype,
                               itemkey  => itemkey,
                               aname    => 'PO_HEADER_ID');

Line: 112

    wf_core.context('WIP_COMMON_WF_PKG',  'SelectSupplierCN',
        itemtype, itemkey, actid, funcmode);

Line: 116

END SelectSupplierCNT;

Line: 118

PROCEDURE SelectProdScheduler( itemtype  in varchar2,
                       itemkey   in varchar2,
                       actid     in number,
                       funcmode  in varchar2,
                       resultout out NOCOPY varchar2) is

  l_organization_id number :=
    wf_engine.GetItemAttrText( itemtype => itemtype,
                               itemkey  => itemkey,
                               aname    => 'ORGANIZATION_ID');

Line: 163

    wf_core.context('WIP_COMMON_WF_PKG',  'SelectProdScheduler',
        itemtype, itemkey, actid, funcmode);

Line: 167

END SelectProdScheduler;

Line: 169

PROCEDURE SelectShippingManager( itemtype  in varchar2,
                       itemkey   in varchar2,
                       actid     in number,
                       funcmode  in varchar2,
                       resultout out NOCOPY varchar2) is

  l_organization_id number :=
    wf_engine.GetItemAttrNumber( itemtype => itemtype,
                               itemkey  => itemkey,
                               aname    => 'ORGANIZATION_ID');

Line: 214

    wf_core.context('WIP_COMMON_WF_PKG',  'SelectShippingManager',
        itemtype, itemkey, actid, funcmode);

Line: 218

END SelectShippingManager;

Line: 221

PROCEDURE SelectDefaultBuyer( itemtype  in varchar2,
                       itemkey   in varchar2,
                       actid     in number,
                       funcmode  in varchar2,
                       resultout out NOCOPY varchar2) is

  l_organization_id number :=
    wf_engine.GetItemAttrNumber( itemtype => itemtype,
                               itemkey  => itemkey,
                               aname    => 'ORGANIZATION_ID');

Line: 271

    wf_core.context('WIP_COMMON_WF_PKG',  'SelectDefaultBuyer',
        itemtype, itemkey, actid, funcmode);

Line: 275

END SelectDefaultBuyer;