APPS.POS_ANON_PKG SQL Statements

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

Line: 37

        icx_sec.updateSessionContext(
                            p_application_id    =>178,
                            p_responsibility_id =>20873,
                            p_security_group_id => 0,
                            p_session_id        => x_session_id,
                            p_transaction_id    => x_transaction_id);

Line: 47

        SELECT  max(transaction_id)
        INTO    x_transaction_id
        FROM    icx_transactions
        WHERE   session_id = icx_sec.g_session_id
        AND     responsibility_id = icx_sec.g_responsibility_id
        AND     security_group_id = icx_sec.g_security_group_id
        AND     function_id = icx_sec.g_function_id
        GROUP BY transaction_id;

Line: 59

            SELECT  icx_transactions_s.nextval
            INTO    x_transaction_id
            FROM    dual;

Line: 88

      SELECT resp_enabled_flag,
	hierarchy_type
        FROM fnd_profile_options
        WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT'
        AND Nvl(start_date_active, Sysdate) <= Sysdate
        AND Nvl(end_date_active, sysdate) >= sysdate;

Line: 98

      SELECT responsibility_id, application_id
	FROM fnd_responsibility
	WHERE responsibility_key = 'POS_SUPPLIER_GUEST_USER'
	AND application_id =
	(SELECT application_id FROM fnd_application WHERE application_short_name = 'POS');

Line: 176

	 SELECT user_name
	   FROM   FND_USER
	   WHERE  user_id = 6
	   AND    start_date < sysdate
	   AND    (end_date IS NULL OR end_date > sysdate);

Line: 184

	 SELECT application_id, responsibility_id
	   FROM   FND_RESPONSIBILITY
	   WHERE  responsibility_key = p_responsibility_key
	   AND    start_date < sysdate
	   AND    (end_date IS NULL OR end_date > sysdate);

Line: 192

	 SELECT end_date, start_date
	   FROM   FND_USER_RESP_GROUPS_DIRECT
	   WHERE  user_id = 6
	   AND    responsibility_id = l_resp_id;

Line: 235

      FND_USER_RESP_GROUPS_API.insert_assignment
	( user_id => 6,
	  responsibility_id => l_resp_id,
	  responsibility_application_id => l_app_id,
	  security_group_id => 0,
	  start_date => sysdate,
	  end_date => NULL,
	  description => p_responsibility_key);

Line: 261

       fnd_user_resp_groups_api.update_assignment
         ( user_id            	     => 6,
           responsibility_id  	     => l_resp_id,
           responsibility_application_id => l_app_id,
           security_group_id             => 0,
           start_date                    => l_start_date,
           end_date                      => NULL,
           description                   => p_responsibility_key);

Line: 300

    SELECT application_id, responsibility_id
    INTO   x_application_id, x_responsibility_id
    FROM   FND_RESPONSIBILITY
    WHERE  responsibility_key = p_responsibility_key;

Line: 315

  SELECT session_cookie_name, session_cookie_domain
  INTO   l_cookie_name, l_cookie_domain
  FROM   icx_parameters;