APPS.HRI_APL_DIAGNOSTICS SQL Statements

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

Line: 30

SELECT 1
FROM hri_adm_dgnstc_setup
WHERE object_name = p_object_name
AND   object_type = p_object_type;

Line: 117

SELECT 1
FROM hr_lookups
WHERE lookup_type = 'HRI_FUNCTIONAL_AREA'
AND lookup_code = p_functional_area_cd;

Line: 157

SELECT 1
FROM fnd_profile_options
WHERE profile_option_name = p_object_name;

Line: 196

SELECT 1
FROM bis_bucket
WHERE short_name = p_object_name;

Line: 225

SELECT 1
FROM pay_trigger_events
WHERE short_name = p_object_name;

Line: 253

SELECT 1
FROM all_tables
WHERE table_name = p_object_name
AND owner = p_object_owner;

Line: 283

SELECT 1
FROM ff_formulas_f
WHERE formula_name = p_object_name;

Line: 327

SELECT 1
FROM hri_adm_dgnstc_sbscrb
WHERE object_name = p_object_name
AND  object_type = p_object_type
AND functional_area_cd = p_functional_area_cd;

Line: 357

  INSERT INTO hri_adm_dgnstc_sbscrb
    (object_name,
    object_type,
    functional_area_cd)
  VALUES
    (p_object_name,
    p_object_type,
    p_functional_area_cd);

Line: 375

PROCEDURE delete_subscription
  (p_object_name IN VARCHAR2,
  p_object_type IN VARCHAR2,
  p_functional_area_cd IN VARCHAR2)
IS
BEGIN
  --
  DELETE FROM hri_adm_dgnstc_sbscrb
  WHERE object_name = p_object_name
  AND object_type = p_object_type
  AND functional_area_cd = p_functional_area_cd;

Line: 387

  output(SQL%ROWCOUNT || ' row deleted.');

Line: 397

END delete_subscription;

Line: 435

  INSERT INTO hri_adm_dgnstc_setup
    (object_name,
    object_type,
    dynamic_sql,
    dynamic_sql_type,
    exception_value,
    impact_msg_name,
    add_info_URL,
    enabled_flag,
    foundation_HR_FLAG,
    null_impact_msg_name,
    report_type,
    functional_area_cd
    )
  VALUES
    (p_object_name,
    'PROFILE',
    p_dynamic_sql,
    p_dynamic_sql_type,
    p_exception_value,
    p_impact_msg_name,
    p_add_info_URL,
    p_enabled_flag,
    p_foundation_HR_FLAG,
    p_null_impact_msg_name,
    'SYSTEM',
    p_functional_area_cd);

Line: 503

  INSERT INTO hri_adm_dgnstc_setup
    (object_name,
    object_type,
    exception_status_msg_cd,
    valid_status_msg_cd,
    enabled_flag,
    foundation_hr_flag,
    report_type,
    functional_area_cd)
  VALUES
    (p_object_name,
    'TRIGGER',
    p_exception_status_msg_cd,
    p_valid_status_msg_cd,
    p_enabled_flag,
    p_foundation_hr_flag,
    'SYSTEM',
    p_functional_area_cd);

Line: 565

  INSERT INTO hri_adm_dgnstc_setup
    (object_name,
    object_type,
    exception_status_msg_cd,
    valid_status_msg_cd,
    enabled_flag,
    foundation_hr_flag,
    report_type,
    functional_area_cd)
  VALUES
    (p_object_name,
    'TABLE',
    p_exception_status_msg_cd,
    p_valid_status_msg_cd,
    p_enabled_flag,
    p_foundation_hr_flag,
    'SYSTEM',
    p_functional_area_cd);

Line: 625

  INSERT INTO hri_adm_dgnstc_setup
    (object_name,
    object_type,
    exception_status_msg_cd,
    valid_status_msg_cd,
    add_info_url,
    enabled_flag,
    foundation_hr_flag,
    report_type,
    functional_area_cd)
  VALUES
    (p_object_name,
    'SEEDED_FAST_FORMULA',
     p_exception_status_msg_cd,
     p_valid_status_msg_cd,
     p_add_info_url,
     p_enabled_flag,
     p_foundation_hr_flag,
     'SYSTEM',
     p_functional_area_cd);

Line: 686

  INSERT INTO hri_adm_dgnstc_setup
    (object_name,
    object_type,
    dynamic_sql,
    dynamic_sql_type,
    exception_status_msg_cd,
    valid_status_msg_cd,
    impact_msg_name,
    add_info_url,
    enabled_flag,
    foundation_hr_flag,
    report_type,
    functional_area_cd)
  VALUES
    (p_object_name,
    'USER_DEFN_FAST_FORMULA',
    p_dynamic_sql,
    p_dynamic_sql_type,
    p_exception_status_msg_cd,
    p_valid_status_msg_cd,
    p_impact_msg_name,
    p_add_info_url,
    p_enabled_flag,
    p_foundation_hr_flag,
    'SYSTEM',
    p_functional_area_cd);

Line: 760

  INSERT INTO hri_adm_dgnstc_setup
    (object_name,
    object_type,
    dynamic_sql,
    dynamic_sql_type,
    exception_status_msg_cd,
    valid_status_msg_cd,
    impact_msg_name,
    enabled_flag,
    foundation_hr_flag,
    report_type,
    functional_area_cd)
  VALUES
    (p_object_name,
    'BUCKET',
    p_dynamic_sql,
    p_dynamic_sql_type,
    p_exception_status_msg_cd,
    p_valid_status_msg_cd,
    p_impact_msg_name,
    p_enabled_flag,
    p_foundation_hr_flag,
    'SYSTEM',
    p_functional_area_cd);

Line: 860

SELECT object_type_msg_name
FROM hri_adm_dgnstc_setup
WHERE seq_num = (
SELECT max(seq_num)
FROM hri_adm_dgnstc_setup
WHERE report_type = 'DATA'
AND seq_num < p_seq_num);

Line: 907

  INSERT INTO hri_adm_dgnstc_setup
    (object_name,
    object_type,
    dynamic_sql,
    dynamic_sql_type,
    impact_msg_name,
    enabled_flag,
    foundation_hr_flag,
    --
    -- Section heading
    --
    object_type_msg_name,
    --
    -- Description for COUNT section
    --
    object_type_desc,
    --
    -- Description for DETAIL section
    --
    object_type_dtl_desc_msg_name,
    --
    -- Sub section heading
    --
    object_name_msg_name,
    --
    -- Description for COUNT sub section
    --
    object_name_desc,
    --
    -- Description for DETAIL sub section
    --
    object_name_dtl_desc_msg_name,
    --
    -- Heading for count column
    --
    count_heading,
    --
    -- Heading of columns in detail mode as ordered in the dynamic SQL
    --
    col_heading1,
    col_heading2,
    col_heading3,
    col_heading4,
    col_heading5,
    --
    default_mode,
    seq_num,
    report_type,
    functional_area_cd
    )
  VALUES
    (p_object_name,
    p_object_type,
    p_dynamic_sql,
    p_dynamic_sql_type,
    p_impact_msg_name,
    p_enabled_flag,
    p_foundation_hr_flag,
    p_section_heading,
    p_section_count_desc,
    p_section_detail_desc,
    p_sub_section_heading,
    p_sub_section_count_desc,
    p_sub_section_detail_desc,
    p_heading_for_count,
    p_heading_for_column1,
    p_heading_for_column2,
    p_heading_for_column3,
    p_heading_for_column4,
    p_heading_for_column5,
    p_default_sql_mode,
    p_seq_num,
    'DATA',
    p_functional_area_cd
    );

Line: 998

PROCEDURE delete_object
  (p_object_name IN VARCHAR2,
  p_object_type IN VARCHAR2,
  p_report_type IN VARCHAR2,
  p_functional_area_cd IN VARCHAR2)
IS
--
BEGIN
  --
  DELETE FROM hri_adm_dgnstc_setup
  WHERE object_name = p_object_name
  AND object_type = p_object_type
  AND report_type = p_report_type
  AND functional_area_cd = p_functional_area_cd;

Line: 1013

  output(SQL%ROWCOUNT || ' row deleted.');

Line: 1023

END delete_object;