APPS.PAY_ELE_CLASS_RULES_PKG SQL Statements

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

Line: 44

     select ecl_tl.classification_name
     from   pay_element_classifications_tl ecl_tl,
            pay_element_classifications ecl
     where  ecl.classification_id = ecl_tl.classification_id
     and    ecl.classification_id = p_classification_id
     and    userenv('LANG') = ecl_tl.language;

Line: 86

 procedure chk_insert_ele_classification
 (
  p_rowid               varchar2,
  p_element_set_id      number,
  p_classification_id   number
 ) is
--
   cursor csr_ele_class_rule is
     select ecr.classification_id
     from   pay_ele_classification_rules ecr
     where  ecr.element_set_id = p_element_set_id
       and  ecr.classification_id = p_classification_id
       and  (p_rowid is null or
            (p_rowid is not null and chartorowid(p_rowid) <> ecr.rowid));

Line: 102

     select etr.element_type_id
     from   pay_element_type_rules etr,
	    pay_element_types_f et
     where  etr.element_set_id = p_element_set_id
       and  et.element_type_id = etr.element_type_id
       and  et.classification_id = p_classification_id;

Line: 128

     hr_utility.set_message_token('INS_OR_DEL', 'insert');

Line: 137

 end chk_insert_ele_classification;

Line: 151

 procedure chk_delete_ele_classification
 (
  p_element_set_id      number,
  p_classification_id   number
 ) is
--
   cursor csr_ele_type_rule is
     select etr.element_type_id
     from   pay_element_type_rules etr,
	    pay_element_types_f et
     where  etr.element_set_id = p_element_set_id
       and  et.element_type_id = etr.element_type_id
       and  et.classification_id = p_classification_id;

Line: 174

     hr_utility.set_message_token('INS_OR_DEL', 'delete');

Line: 183

 end chk_delete_ele_classification;

Line: 196

 PROCEDURE Insert_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
                      X_Element_Set_Id               IN OUT NOCOPY NUMBER,
                      X_Classification_Id                          NUMBER,
                      -- Extra Columns
                      X_Element_Set_Type                    VARCHAR2) IS
--
   CURSOR C IS SELECT rowid FROM pay_ele_classification_rules
               WHERE  element_set_id = X_Element_Set_Id
                 AND  classification_id = X_Classification_Id;

Line: 212

   chk_insert_ele_classification
     (X_Rowid,
      X_Element_Set_Id,
      X_Classification_Id);

Line: 227

   INSERT INTO pay_ele_classification_rules
   (element_set_id,
    classification_id)
   VALUES
   (X_Element_Set_Id,
    X_Classification_Id);

Line: 240

                                  'pay_ele_class_rules_pkg.insert_row');

Line: 246

 END Insert_Row;

Line: 265

   CURSOR C IS SELECT * FROM  pay_ele_classification_rules
               WHERE  rowid = X_Rowid FOR UPDATE of Element_Set_Id NOWAIT;

Line: 310

 PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                      X_Element_Set_Id                      NUMBER,
                      X_Classification_Id                   NUMBER) IS
 BEGIN
--
   UPDATE pay_ele_classification_rules
   SET element_set_id      =    X_Element_Set_Id,
       classification_id   =    X_Classification_Id
   WHERE rowid = X_rowid;

Line: 323

                                  'pay_ele_class_rules_pkg.update_row');

Line: 328

 END Update_Row;

Line: 341

 PROCEDURE Delete_Row(X_Rowid                               VARCHAR2,
		      -- Extra Columns
                      X_Element_Set_Id                      NUMBER,
                      X_Classification_Id                   NUMBER) IS
 BEGIN
--
   -- Lock element set to preserve the current definition.
   pay_element_sets_pkg.lock_element_set
     (X_Element_Set_Id);

Line: 351

   chk_delete_ele_classification
     (X_Element_Set_Id,
      X_Classification_Id);

Line: 355

   DELETE FROM pay_ele_classification_rules
   WHERE  rowid = X_Rowid;

Line: 361

                                  'pay_ele_class_rules_pkg.delete_row');

Line: 366

 END Delete_Row;