APPS.MRP_REL_WF SQL Statements

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

Line: 22

    select responsibility_id
    from   fnd_responsibility_vl
    where  application_id = l_application_id
    and    responsibility_name = l_resp_name;

Line: 28

     select user_id
       into l_user_id
       from fnd_user
      where user_name = p_user_name;

Line: 34

      SELECT APPLICATION_ID
        INTO l_application_id
        FROM FND_APPLICATION_VL
      WHERE APPLICATION_SHORT_NAME = 'MSC'
      and   rownum = 1;

Line: 59

      SELECT responsibility_id
        INTO l_resp_id
        FROM FND_responsibility_vl
        where application_Id = l_application_id
          and rownum =1 ;

Line: 69

     SELECT APPLICATION_ID
     INTO l_application_id
     FROM FND_APPLICATION_VL
     WHERE APPLICATION_SHORT_NAME = 'MRP'
     and rownum = 1;

Line: 75

      SELECT responsibility_id
        INTO l_resp_id
        FROM FND_responsibility_vl
        where application_Id = l_application_id
          and rownum =1 ;

Line: 154

PROCEDURE validate_pjm_selectAll(p_server_dblink IN varchar2,
                                 p_user_name     IN varchar2,
                                 p_plan_id       IN number,
                                 p_query_id      IN number) IS
sql_stmt varchar2(500);

Line: 174

  ' SELECT  number1, -- trx_id
            number2, -- organization_id,
            date1,   -- new_schedule_date,
            number3, -- project_id,
            number4  -- task_id
     FROM   mrp_form_query '||p_server_dblink||
  '  WHERE query_id = :p_query_id ';

Line: 201

        select user_id
        INTO  l_user_id
        FROM fnd_user
        where user_name= p_user_name; -- here I can  pass any userid

Line: 206

        SELECT APPLICATION_ID
        INTO l_application_id
        FROM FND_APPLICATION_VL
        WHERE APPLICATION_SHORT_NAME ='PJM'
        and rownum = 1;

Line: 212

        SELECT responsibility_id
        INTO l_resp_id
        FROM FND_responsibility_vl
        where application_Id = l_application_id
        and rownum = 1;

Line: 218

        select operating_unit
        INTO l_operating_unit_id
        FROM org_organization_definitions
        WHERE organization_id=p_org ; --3983540

Line: 242

        sql_stmt:= 'update msc_supplies ' ||p_server_dblink ||
             '  SET implement_as = NULL,
                implement_quantity = NULL,
                implement_date = NULL,
                release_status = 2,
                release_errors = :p_error
          where transaction_id = :p_transaction_id
            and plan_id = :plan_id';

Line: 281

END  validate_pjm_selectAll;

Line: 306

        select user_id
        INTO  l_user_id
        FROM fnd_user
        where user_name= p_user_name; -- here I can  pass any userid

Line: 311

        SELECT APPLICATION_ID
        INTO l_application_id
        FROM FND_APPLICATION_VL
        WHERE APPLICATION_SHORT_NAME ='PJM'
        and rownum = 1;

Line: 317

        SELECT responsibility_id
        INTO l_resp_id
        FROM FND_responsibility_vl
        where application_Id = l_application_id
        and rownum = 1;

Line: 323

        select operating_unit
        INTO l_operating_unit_id
        FROM org_organization_definitions
        WHERE organization_id=p_org ; --3983540

Line: 375

        select user_id
        into   l_user_id
        from   fnd_user
        where  user_name = p_user_name;

Line: 380

        select application_id
        into   l_appl_id
        from   fnd_application_vl
        where  application_short_name = p_appl_name;

Line: 385

        select responsibility_id
        into   l_resp_id
        from   fnd_responsibility_vl
        where  responsibility_name = p_resp_name
        and    application_Id = l_appl_id;

Line: 397

  select fnd_profile.value_specific ( p_prof_name
                                    , l_user_id
                                    , l_resp_id
                                    , l_appl_id
                                    )
         into rc from dual;