APPS.ASG_BASE SQL Statements

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

Line: 119

    SELECT user_name
    FROM asg_user
    WHERE resource_id = p_resource_id;

Line: 136

    SELECT resource_id
    FROM asg_user
    WHERE user_name = p_user_name;

Line: 153

    SELECT user_id
    FROM asg_user
    WHERE user_name = p_user_name;

Line: 170

    SELECT responsibility_id
    FROM asg_user
    WHERE user_name = p_user_name;

Line: 187

    SELECT language
    FROM asg_user
    WHERE user_name = p_user_name;

Line: 204

    SELECT app_id
    FROM asg_user
    WHERE user_name = p_user_name;

Line: 222

    SELECT last_synch_date_end into l_last_synch_date
    FROM asg_user
    WHERE user_name = p_user_name;

Line: 328

  /* get dml type based on creation_date, update_date and */
  /* last_synch_date. Will return either G_INS or G_UPD */
  FUNCTION get_dml_type(p_creation_date IN DATE)
    return VARCHAR2 IS
  BEGIN
    -- g_last_synch_date IS NULL means no synch completed successfully
    -- or the user has never synched.
    IF ((g_last_synch_date IS NULL) OR
        (p_creation_date > g_last_synch_date)) THEN
      return G_INS;

Line: 343

  /* get dml type based on update date and publication name */
  /* For publications that will be completely refreshed the */
  /* DML type will be insert (G_INS)                        */
  FUNCTION get_dml_type(p_pub_item_name IN VARCHAR2,
                        p_creation_date IN DATE)
    return VARCHAR2 IS
  BEGIN
    -- g_last_synch_date IS NULL means no synch completed successfully
    -- or the user has never synched.
    -- Skip check for complete_refresh if p_creation_date is
    -- greater than last_synch_date

    IF (p_pub_item_name = g_last_pub_item_name_gdt) THEN
      RETURN g_dml_type_gdt;

Line: 517

    SELECT last_synch_date_end  INTO l_date
    FROM asg_user WHERE user_id = p_user_id;

Line: 586

    l_str := 'select '||G_OLITE_SCHEMA||'.CONS_EXT.GET_CURR_DEVICE from dual';

Line: 603

    l_str := 'select '||G_OLITE_SCHEMA||'.CONS_EXT.GET_CURR_DEVICE from dual';

Line: 621

    select current_device from asg_user where user_name = l_user_name;

Line: 626

      l_qry_string := 'SELECT value ' ||
                      'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$all_config ' ||
                      'WHERE param = :1';

Line: 651

        update asg_user set current_device = l_curr_dev_type
        where user_name = p_user_name;

Line: 655

        l_qry_string := 'update '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q '
                        ||'set comp_ref = ''Y'' '||' where name IN '
                        ||' ( select item_id from asg_pub_item)' ;

Line: 659

        update asg_user set current_device = l_curr_dev_type
        where user_name = p_user_name;

Line: 680

    SELECT count(*) into l_cnt
    FROM asg_user
    WHERE user_id = p_user_id AND enabled = 'Y';

Line: 694

  SELECT user_id
  FROM asg_user
  WHERE enabled = 'Y';

Line: 723

    SELECT app_id, responsibility_id into p_app_id, p_resp_id
    FROM asg_user
    WHERE user_id = p_user_id and enabled = 'Y';