eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_STAT_TYPE_USAGES_PKG SQL Statements

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

Line: 73


PROCEDURE Insert_Row
( p_rowid           IN OUT  NOCOPY VARCHAR2
, p_legal_entity_id         NUMBER
, p_zone_code               VARCHAR2
, p_usage_type              VARCHAR2
, p_stat_type               VARCHAR2
, p_period_set_name         VARCHAR2
, p_period_type             VARCHAR2
, p_start_period_name       VARCHAR2
, p_end_period_name         VARCHAR2
, p_weight_uom_code         VARCHAR2
, p_entity_branch_reference VARCHAR2
, p_conversion_type         VARCHAR2
, p_conversion_option       VARCHAR2
, p_category_set_id         NUMBER
, p_tax_office_code         VARCHAR2
, p_tax_office_name         VARCHAR2
, p_tax_office_location_id  NUMBER
, p_attribute_rule_set_code VARCHAR2
, p_alt_uom_rule_set_code   VARCHAR2
, p_triangulation_mode      VARCHAR2
, p_reference_period_rule   VARCHAR2
, p_pending_invoice_days    NUMBER
, p_prior_invoice_days      NUMBER
, p_returns_processing      VARCHAR2
, p_kit_method              VARCHAR2
, p_weight_precision        NUMBER
, p_reporting_rounding      VARCHAR2
, p_include_establishments  VARCHAR2
, p_last_update_date        DATE
, p_last_updated_by         NUMBER
, p_last_update_login       NUMBER
, p_created_by              NUMBER
, p_creation_date           DATE
)
IS
l_period_type VARCHAR2(200);

Line: 112


  SELECT
    rowid
  FROM
    MTL_STAT_TYPE_USAGES
  WHERE Legal_Entity_ID = p_legal_entity_id
    AND Zone_Code       = p_zone_code
    AND Usage_Type      = p_usage_type
    AND Stat_Type       = p_stat_type;

Line: 131


  INSERT INTO MTL_STAT_TYPE_USAGES(
    Legal_Entity_ID
  , Zone_Code
  , Usage_Type
  , Stat_Type
  , Start_Period_Name
  , Period_Type
  , End_Period_Name
  , Period_Set_Name
  , Weight_UOM_Code
  , Entity_Branch_Reference
  , Conversion_Type
  , Conversion_Option
  , Category_Set_ID
  , Tax_Office_Code
  , Tax_Office_Name
  , Tax_Office_Location_ID
  , Attribute_Rule_Set_Code
  , Alt_Uom_Rule_Set_Code
  , Triangulation_Mode
  , reference_period_rule
  , pending_invoice_days
  , prior_invoice_days
  , returns_processing
  , kit_method
  , weight_precision
  , reporting_rounding
  , include_establishments
  , Last_Update_Date
  , Last_Updated_By
  , Last_Update_Login
  , Created_By
  , Creation_Date
  )
  VALUES(
    p_legal_entity_id
  , p_zone_code
  , p_usage_type
  , p_stat_type
  , p_start_period_name
  , l_period_type
  , p_end_period_name
  , p_period_set_name
  , p_weight_uom_code
  , p_entity_branch_reference
  , p_conversion_type
  , p_conversion_option
  , p_category_set_id
  , p_tax_office_code
  , p_tax_office_name
  , p_tax_office_location_id
  , p_attribute_rule_set_code
  , p_alt_uom_rule_set_code
  , p_triangulation_mode
  , p_reference_period_rule
  , p_pending_invoice_days
  , p_prior_invoice_days
  , p_returns_processing
  , p_kit_method
  , p_weight_precision
  , p_reporting_rounding
  , p_include_establishments
  , p_last_update_date
  , p_last_updated_by
  , p_last_update_login
  , p_created_by
  , p_creation_date
  );

Line: 208


END Insert_Row;

Line: 263


  SELECT *
    FROM MTL_STAT_TYPE_USAGES
   WHERE ROWID = p_rowid
   FOR UPDATE OF Legal_Entity_ID NOWAIT;

Line: 281


    FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 406


PROCEDURE Update_Row
( p_rowid           IN OUT NOCOPY VARCHAR2
, p_legal_entity_id         NUMBER
, p_zone_code               VARCHAR2
, p_usage_type              VARCHAR2
, p_stat_type               VARCHAR2
, p_period_set_name         VARCHAR2
, p_period_type             VARCHAR2
, p_start_period_name       VARCHAR2
, p_end_period_name         VARCHAR2
, p_weight_uom_code         VARCHAR2
, p_entity_branch_reference VARCHAR2
, p_conversion_type         VARCHAR2
, p_conversion_option       VARCHAR2
, p_category_set_id         NUMBER
, p_tax_office_code         VARCHAR2
, p_tax_office_name         VARCHAR2
, p_tax_office_location_id  NUMBER
, p_attribute_rule_set_code VARCHAR2
, p_alt_uom_rule_set_code   VARCHAR2
, p_triangulation_mode      VARCHAR2
, p_reference_period_rule   VARCHAR2
, p_pending_invoice_days    NUMBER
, p_prior_invoice_days      NUMBER
, p_returns_processing      VARCHAR2
, p_kit_method              VARCHAR2
, p_weight_precision        NUMBER
, p_reporting_rounding      VARCHAR2
, p_include_establishments  VARCHAR2
, p_last_update_date        DATE
, p_last_updated_by         NUMBER
, p_last_update_login       NUMBER
, p_created_by              NUMBER
, p_creation_date           DATE
)
IS
l_period_type VARCHAR2(200);

Line: 453


  UPDATE MTL_STAT_TYPE_USAGES
    SET
      Legal_Entity_ID         = p_legal_entity_id
    , zone_code               = p_zone_code
    , usage_type              = p_usage_type
    , stat_type               = p_stat_type
    , start_period_name       = p_start_period_name
    , end_period_name         = p_end_period_name
    , period_set_name         = p_period_set_name
    , period_type             = l_period_type
    , weight_uom_code         = p_weight_uom_code
    , entity_branch_reference = p_entity_branch_reference
    , conversion_type         = p_conversion_type
    , conversion_option       = p_conversion_option
    , category_set_id         = p_category_set_id
    , tax_office_code         = p_tax_office_code
    , tax_office_name         = p_tax_office_name
    , tax_office_location_id  = p_tax_office_location_id
    , attribute_rule_set_code = p_attribute_rule_set_code
    , alt_uom_rule_set_code   = p_alt_uom_rule_set_code
    , triangulation_mode      = p_triangulation_mode
    , reference_period_rule   = p_reference_period_rule
    , pending_invoice_days    = p_pending_invoice_days
    , prior_invoice_days      = p_prior_invoice_days
    , returns_processing      = p_returns_processing
    , kit_method              = p_kit_method
    , weight_precision        = p_weight_precision
    , reporting_rounding      = p_reporting_rounding
    , include_establishments  = p_include_establishments
    , last_update_date        = p_last_update_date
    , last_updated_by         = p_last_updated_by
    , last_update_login       = p_last_update_login
    , created_by              = p_created_by
    , creation_date           = p_creation_date
  WHERE ROWID = p_rowid;

Line: 493


END Update_Row;

Line: 505


PROCEDURE Delete_Row
( p_rowid IN OUT NOCOPY VARCHAR2
)
IS
BEGIN

  DELETE FROM MTL_STAT_TYPE_USAGES
  WHERE ROWID = p_rowid;

Line: 518


END Delete_Row;