DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_PUB SQL Statements

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

Line: 109

PROCEDURE SELECT_ADHOC_PARTY(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_action_id           NUMBER ;
Line: 127

        SELECT  party_id_list adhoc_party_list
              , TRUNC(response_by_date)            response_by_date
              , sysdate
        FROM    ENG_CHANGE_ACTIONS
        WHERE  action_id = p_action_id ;
Line: 242

    wf_core.context('Eng_Workflow_Pub', 'SELECT_ADHOC_PARTY',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 250

    wf_core.context('Eng_Workflow_Pub', 'SELECT_ADHOC_PARTY',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 254

END SELECT_ADHOC_PARTY ;
Line: 258

PROCEDURE SELECT_ASSIGNEE (
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 272

    l_debug_filename  VARCHAR2(30) ;  -- 'SelectAssignee.log' ;
Line: 370

    wf_core.context('Eng_Workflow_Pub', 'SELECT_ASSIGNEE',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 383

    wf_core.context('Eng_Workflow_Pub', 'SELECT_ASSIGNEE',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 387

END SELECT_ASSIGNEE ;
Line: 391

PROCEDURE SELECT_STD_REVIEWERS(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 475

    wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_REVIEWERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 483

    wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_REVIEWERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 487

END SELECT_STD_REVIEWERS;
Line: 491

PROCEDURE SELECT_REVIEWERS(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 574

    wf_core.context('Eng_Workflow_Pub', 'SELECT_REVIEWERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 582

    wf_core.context('Eng_Workflow_Pub', 'SELECT_REVIEWERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 586

END SELECT_REVIEWERS;
Line: 589

PROCEDURE SELECT_LINE_ASSIGNEE (
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 603

    l_debug_filename  VARCHAR2(30) ;  -- 'SelectLineAssignee.log' ;
Line: 698

    wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_ASSIGNEE',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 711

    wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_ASSIGNEE',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 715

END SELECT_LINE_ASSIGNEE ;
Line: 719

PROCEDURE SELECT_STD_LINE_REVIEWERS(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 831

    wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_LINE_REVIEWERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 843

    wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_LINE_REVIEWERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 847

END SELECT_STD_LINE_REVIEWERS;
Line: 851

PROCEDURE SELECT_LINE_REVIEWERS(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 934

    wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_REVIEWERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 941

    wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_REVIEWERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 945

END SELECT_LINE_REVIEWERS;
Line: 1071

PROCEDURE SELECT_ROUTE_PEOPLE(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 1154

    wf_core.context('Eng_Workflow_Pub', 'SELECT_ROUTE_PEOPLE',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 1162

    wf_core.context('Eng_Workflow_Pub', 'SELECT_ROUTE_PEOPLE',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 1166

END SELECT_ROUTE_PEOPLE ;
Line: 1170

PROCEDURE SELECT_STEP_PEOPLE(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 1253

    wf_core.context('Eng_Workflow_Pub', 'SELECT_STEP_PEOPLE',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 1261

    wf_core.context('Eng_Workflow_Pub', 'SELECT_STEP_PEOPLE',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 1265

END SELECT_STEP_PEOPLE;
Line: 1269

PROCEDURE DELETE_ADHOC_ROLES_AND_USERS(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    result    in out NOCOPY varchar2)
IS

    l_return_status       VARCHAR2(1);
Line: 1290

    Eng_Workflow_Util.DeleteAdhocRolesAndUsers
    (  x_return_status     => l_return_status
    ,  x_msg_count         => l_msg_count
    ,  x_msg_data          => l_msg_data
    ,  p_item_type         => itemtype
    ,  p_item_key          => itemkey
    ) ;
Line: 1346

    wf_core.context('Eng_Workflow_Pub', 'DELETE_ADHOC_ROLES_AND_USERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 1354

    wf_core.context('Eng_Workflow_Pub', 'DELETE_ADHOC_ROLES_AND_USERS',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 1358

END DELETE_ADHOC_ROLES_AND_USERS ;
Line: 1375

        SELECT TRUNC(response_by_date)            response_by_date
        FROM    ENG_CHANGE_ACTIONS
        WHERE   action_id = p_action_id ;
Line: 1489

        SELECT  TRUNC(required_date)   response_by_date
              , condition_type_code
              , required_relative_days required_relative_days
        FROM    ENG_CHANGE_ROUTE_STEPS
        WHERE   step_id = p_step_id ;
Line: 1639

        SELECT TRUNC(response_by_date)            response_by_date
              , sysdate
        FROM    ENG_CHANGE_ACTIONS
        WHERE   action_id = p_action_id ;
Line: 5172

        SELECT  approval_status_type
        FROM    ENG_ENGINEERING_CHANGES
        WHERE  change_id = c_change_id ;