APPS.JTF_RESOURCE_UTL SQL Statements

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

Line: 18

    SELECT fnd_global.user_id
    INTO l_created_by
    FROM dual;

Line: 27

  /* Function to get the updated_by who column. */

  FUNCTION updated_by
    RETURN NUMBER
  IS
    l_updated_by    NUMBER;

Line: 35

    SELECT fnd_global.user_id
    INTO l_updated_by
    FROM dual;

Line: 39

    RETURN l_updated_by;

Line: 52

    SELECT fnd_global.login_id
    INTO l_login_id
    FROM dual;

Line: 72

         SELECT hook_PACKAGE, hook_api
           FROM jtf_hooks_data
          WHERE PACKAGE_NAME = p_PACKAGE_name
            AND api_name = p_api_name
            AND execute_flag = 'Y'
            AND processing_type = p_processing_type
          ORDER BY execution_order;

Line: 142

      SELECT group_id
      FROM jtf_rs_groups_b
      WHERE group_id = p_group_id;

Line: 147

      SELECT group_id
      FROM jtf_rs_groups_b
      WHERE group_number = p_group_number;

Line: 224

      SELECT resource_id
      FROM jtf_rs_resource_extns
      WHERE resource_id = p_resource_id
        AND ( end_date_active is null OR
		    trunc(end_date_active) >= trunc(sysdate) );

Line: 231

      SELECT resource_id
      FROM jtf_rs_resource_extns
      WHERE resource_number = p_resource_number
        AND ( end_date_active is null OR
		    trunc(end_date_active) >= trunc(sysdate) );

Line: 357

      SELECT lookup_code
      FROM fnd_lookups
      WHERE lookup_type = p_lookup_type
        AND upper(lookup_code) = upper(p_usage)
        AND trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)
	   AND enabled_flag = p_enabled_flag;

Line: 420

      SELECT jo.object_code
      FROM jtf_objects_b jo,
	   jtf_object_usages jou
      WHERE jo.object_code = jou.object_code
        AND jou.object_user_code = 'RESOURCE_CATEGORIES'
	   AND upper(jo.object_code) = upper(p_category)
        AND trunc(nvl(jo.end_date_active, sysdate)) >= trunc(sysdate);

Line: 478

     SELECT 1
     FROM jtf_rs_resource_extns
     WHERE source_id = p_source_id
       AND category = 'EMPLOYEE';

Line: 485

     SELECT 1
     FROM jtf_rs_resource_extns
     WHERE source_id = p_source_id
       AND category = 'WORKER';

Line: 491

     SELECT 1
     FROM jtf_rs_resource_extns
     WHERE source_id = p_source_id
       AND category = 'VENUE';

Line: 497

     SELECT 1
     FROM jtf_rs_resource_extns
     WHERE source_id = p_source_id
       AND category = 'PARTY';

Line: 503

     SELECT 1
     FROM jtf_rs_resource_extns
     WHERE source_id = p_source_id
       AND category = 'SUPPLIER_CONTACT';

Line: 509

     SELECT 1
     FROM jtf_rs_resource_extns
     WHERE source_id = p_source_id
AND nvl(address_id,-99) = nvl(p_address_id,-99)  --uncommented this to accomodate migr 09/25
AND category = 'PARTNER';

Line: 608

      SELECT person_id
      FROM per_people_f
      WHERE person_id = p_emp_resource_id;

Line: 660

      SELECT timezone_id
      FROM hz_timezones
      WHERE timezone_id = p_time_zone_id;

Line: 664

      SELECT upgrade_tz_id
      FROM   fnd_timezones_vl
      WHERE  upgrade_tz_id = p_time_zone_id;

Line: 719

      SELECT nls_language
      FROM fnd_languages
      WHERE nls_language = p_nls_language;

Line: 774

      SELECT hps.party_site_id
	 FROM hz_party_sites hps,
	      hz_party_site_uses hpsu
      WHERE hpsu.site_use_type = 'SUPPORT_SITE'
	   AND hpsu.party_site_id = hps.party_site_id
	   AND hps.party_site_id = p_support_site_id;

Line: 832

      SELECT server_group_id
      FROM ieo_svr_groups
      WHERE server_group_id = p_server_group_id;

Line: 837

      SELECT server_group_id
      FROM ieo_svr_groups
      WHERE group_name = p_server_group_name;

Line: 900

      SELECT currency_code
      FROM fnd_currencies_active_monet_v
      WHERE currency_code = p_currency_code;

Line: 955

      SELECT lookup_code
      FROM fnd_lookups
      WHERE lookup_type = 'JTF_RS_HOLD_REASON_TYPE'
	   AND lookup_code = p_hold_reason_code;

Line: 1011

      SELECT team_id
      FROM jtf_rs_teams_b
      WHERE team_id = p_team_id;

Line: 1016

      SELECT team_id
      FROM jtf_rs_teams_b
      WHERE team_number = p_team_number;

Line: 1096

      SELECT user_id
      FROM fnd_user
      WHERE decode(p_category, 'EMPLOYEE', EMPLOYEE_ID, 'PARTY', CUSTOMER_ID, 'SUPPLIER_CONTACT', SUPPLIER_ID, null) = p_source_id
	   AND user_id = p_user_id;

Line: 1154

      SELECT salesrep_id
      FROM jtf_rs_salesreps
      WHERE salesrep_id = p_salesrep_id
-- NVL function for ORG_ID should be removed, as Multi-Org is mandatory for Release 11i.11.(MOAC changes)
--      AND nvl (org_id,-99) = nvl (p_org_id,-99);

Line: 1205

	SELECT a.start_date_active, nvl(a.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))
	FROM   jtf_rs_resource_extns a
	      , jtf_rs_salesreps b
	WHERE a.resource_id = b.resource_id(+)
	AND   a.resource_id = l_resource_id
	AND   b.org_id(+)      = l_org_id
	;

Line: 1214

	SELECT a.start_date_active, nvl(a.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))
	FROM   jtf_rs_resource_extns a
	      , jtf_rs_salesreps b
	WHERE a.resource_id = b.resource_id
	AND   b.salesrep_id = l_salesrep_id
	AND   b.org_id      = l_org_id
	;

Line: 1223

	SELECT b.start_date_active
	FROM   jtf_rs_salesreps b
	WHERE b.salesrep_id = l_salesrep_id
	AND   b.org_id      = l_org_id
	;

Line: 1230

	SELECT NVL(b.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))
	FROM   jtf_rs_salesreps b
	WHERE b.salesrep_id = l_salesrep_id
	AND   b.org_id      = l_org_id
	;

Line: 1305

      SELECT territory_id
      FROM ra_territories
      WHERE territory_id = p_territory_id;

Line: 1340

      SELECT 'X'
      FROM   jtf_rs_salesreps
      WHERE  salesrep_number = p_salesrep_number
-- NVL function for ORG_ID should be removed, as Multi-Org is mandatory for Release 11i.11.(MOAC changes)
--      AND    nvl(org_id,-99) = nvl(p_org_id,-99);

Line: 1356

    /* Record is being inserted, check that salesrep number does not already exist */
    IF (p_salesrep_number IS NOT NULL) THEN

      OPEN c_salesrep_number;

Line: 1397

      SELECT 'X'
      FROM   oe_sales_credit_types
      WHERE  quota_flag = 'Y'
      AND    enabled_flag = 'Y'
      AND    sales_credit_type_id = p_sales_credit_type_id;

Line: 1442

   P_SELECT_ID                IN   VARCHAR2,
   P_OBJECT_USER_CODE     IN   VARCHAR2,
   X_FOUND                    OUT NOCOPY  BOOLEAN ,
   X_RETURN_STATUS        OUT NOCOPY VARCHAR2
  ) AS

  CURSOR  object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,
                          l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
      IS
  SELECT a.select_id
        ,a.from_table
        ,a.where_clause
   FROM jtf_objects_B a,
        jtf_object_usages b
  WHERE b.OBJECT_USER_CODE  = l_object_user_code
    AND b.object_code = a.object_code
    and A.object_code = l_object_code;

Line: 1464

  SELECT 'x'
   FROM jtf_object_usages b
  WHERE b.OBJECT_USER_CODE  = l_object_user_code;

Line: 1472

  SELECT  'X'
  FROM   jtf_rs_resource_extns
  WHERE  resource_id = c_resource_id;

Line: 1479

  l_select_id      number;

Line: 1482

  l_select_clause  VARCHAR2(4000);

Line: 1496

    l_select_id         := to_number(p_select_id);

Line: 1523

           OPEN c_res_existence(l_select_id);

Line: 1541

          l_select_clause := 'SELECT  '|| object_dtls_rec.select_id ||' '
                      ||' FROM  '||object_dtls_rec.from_table ||' '
                      ||' WHERE ( '||object_dtls_rec.where_clause ||')'
                      ||' AND   '|| object_dtls_rec.select_id ||' = :x';

Line: 1547

          l_select_clause := 'SELECT  '|| object_dtls_rec.select_id ||' '
                      ||' FROM  '||object_dtls_rec.from_table ||' '
                      ||' WHERE   '|| object_dtls_rec.select_id ||' =  :x';

Line: 1556

        DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);

Line: 1557

	DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);

Line: 1631

   P_SELECT_ID		IN   VARCHAR2,
   P_OBJECT_USER_CODE   IN   VARCHAR2,
   P_RS_ID_PUB_FLAG	IN   VARCHAR2,
   X_FOUND		OUT NOCOPY BOOLEAN,
   X_RETURN_STATUS      OUT NOCOPY VARCHAR2
  ) AS

  CURSOR  object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,
                          l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
      IS
  SELECT a.select_id
        ,a.from_table
        ,a.where_clause
   FROM jtf_objects_B a,
        jtf_object_usages b
  WHERE b.OBJECT_USER_CODE  = l_object_user_code
    AND b.object_code = a.object_code
    and A.object_code = l_object_code;

Line: 1654

  SELECT 'x'
   FROM jtf_object_usages b
  WHERE b.OBJECT_USER_CODE  = l_object_user_code;

Line: 1660

  SELECT 'x',full_name
   FROM per_all_people_f
  WHERE person_id  = p_person_id;

Line: 1665

  SELECT hz.party_id
  FROM   hz_parties hz
  WHERE  party_type  not in ('ORGANIZATION', 'GROUP')
  AND    hz.party_id  = c_party_id
  AND not exists ( select person_id
                   from per_all_people_f per
                   where per.party_id = hz.party_id);

Line: 1676

  l_select_id      number;

Line: 1679

  l_select_clause  VARCHAR2(4000);

Line: 1695

    l_select_id         := to_number(p_select_id);

Line: 1724

              l_select_clause := 'SELECT  '|| object_dtls_rec.select_id ||' '
                      ||' FROM  '||object_dtls_rec.from_table ||' '
                      ||' WHERE ( '||object_dtls_rec.where_clause ||')'
                      ||' AND   '|| object_dtls_rec.select_id ||' = :x';

Line: 1730

              l_select_clause := 'SELECT  '|| object_dtls_rec.select_id ||' '
                      ||' FROM  '||object_dtls_rec.from_table ||' '
                      ||' WHERE   '|| object_dtls_rec.select_id ||' = :x';

Line: 1738

              l_select_clause := 'SELECT  '|| object_dtls_rec.select_id ||' '
                      ||' FROM  '||object_dtls_rec.from_table ||' '
                      ||' WHERE ( '||object_dtls_rec.where_clause ||')'
                      ||' AND   '|| object_dtls_rec.select_id ||' = :x';

Line: 1745

	     OPEN emp_existence(l_select_id);

Line: 1759

           OPEN c_party_existence(l_select_id);

Line: 1777

        DBMS_SQL.PARSE(l_cursorid, l_select_clause, DBMS_SQL.V7);

Line: 1779

	DBMS_SQL.BIND_VARIABLE(l_cursorid,':x',l_select_id);

Line: 1864

      SELECT resource_param_id
      FROM jtf_rs_resource_params
      WHERE resource_param_id = p_resource_param_id;

Line: 1909

      SELECT value_type
      FROM jtf_rs_cct_middlewares_v cctmv, jtf_rs_resource_params jrspm
      WHERE cctmv.value_type = p_value_type
         AND jrspm.application_id = l_application_id;

Line: 1916

      SELECT value_type
      FROM jtf_rs_email_accounts_v iemac, jtf_rs_resource_params jtrpm
      WHERE iemac.value_type = p_value_type
         AND jtrpm.application_id = l_application_id;

Line: 1923

     SELECT email_account_id
     FROM   iem_email_accounts
     WHERE  email_account_id = p_value_type;

Line: 1935

        SELECT application_id
         INTO c_application_id
	 FROM jtf_rs_resource_params
    	 WHERE resource_param_id = p_resource_param_id;

Line: 2003

      SELECT lookup_code
      FROM fnd_lookups fnl, jtf_rs_resource_params jrp
      WHERE fnl.lookup_type           	= jrp.domain_lookup_type
         AND jrp.resource_param_id    	= p_resource_param_id
         AND lookup_code		= p_value;

Line: 2013

      SELECT type , length into v_type ,v_length
      FROM jtf_rs_resource_params
      WHERE resource_param_id 	= p_resource_param_id;

Line: 2061

      SELECT role_id
      FROM jtf_rs_roles_vl
      WHERE role_id = p_role_id;

Line: 2066

      SELECT role_id
      FROM jtf_rs_roles_vl
      WHERE role_code = p_role_code;

Line: 2164

     Select EXECUTE_FLAG
      into  l_execute
      from  JTF_USER_HOOKS
      Where
 	pkg_name = p_pkg_name	and
	api_name = p_api_name	and
	processing_type = p_process_type and
	user_hook_type = p_user_hook_type;

Line: 2198

      SELECT obj.owner,
             obj.object_name
       FROM  all_objects obj
      WHERE  obj.object_name = 'XMLGEN'
      AND    obj.owner IN ('APPS', 'PUBLIC');

Line: 2209

    SELECT obj.status,
           obj.object_type
      FROM all_objects obj
     WHERE obj.object_name = 'JTF_USR_HKS'
      AND  obj.object_type = 'PACKAGE BODY'
      AND  obj.owner in ('APPS', 'PUBLIC');