APPS.PAY_ELEMENT_TYPE_RULES_PKG SQL Statements

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

Line: 48

     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  not exists
	      (select null
	       from   pay_element_type_rules etr
	       where  etr.element_set_id = ecr.element_set_id
		 and  etr.element_type_id = p_element_type_id
		 and  etr.include_or_exclude = 'E');

Line: 91

   insert into pay_element_type_rules
   (element_type_id,
    element_set_id,
    include_or_exclude,
    last_update_date,
    last_updated_by,
    last_update_login,
    created_by,
    creation_date)
   select
    p_element_type_id,
    p_element_set_id,
    'I',
    trunc(sysdate),
    0,
    0,
    0,
    trunc(sysdate)
   from  sys.dual
   where not exists
          (select null
           from   pay_element_type_rules etr
           where  etr.element_set_id = p_element_set_id
             and  etr.element_type_id = p_element_type_id);

Line: 121

     delete from pay_element_type_rules etr
     where  etr.element_set_id = p_element_set_id
       and  etr.element_type_id = p_element_type_id
       and  etr.include_or_exclude = 'E';

Line: 163

   insert into pay_element_type_rules
   (element_type_id,
    element_set_id,
    include_or_exclude,
    last_update_date,
    last_updated_by,
    last_update_login,
    created_by,
    creation_date)
   select
    p_element_type_id,
    p_element_set_id,
    'E',
    trunc(sysdate),
    0,
    0,
    0,
    trunc(sysdate)
   from  sys.dual
   where not exists
          (select null
           from   pay_element_type_rules etr
           where  etr.element_set_id = p_element_set_id
             and  etr.element_type_id = p_element_type_id);

Line: 193

     delete from pay_element_type_rules etr
     where  etr.element_set_id = p_element_set_id
       and  etr.element_type_id = p_element_type_id
       and  etr.include_or_exclude = 'I';

Line: 214

 PROCEDURE Insert_Row(X_Rowid                        IN OUT VARCHAR2,
                      X_Element_Type_Id                     NUMBER,
                      X_Element_Set_Id                      NUMBER,
                      X_Include_Or_Exclude                  VARCHAR2,
                      X_Last_Update_Date                    DATE,
                      X_Last_Updated_By                     NUMBER,
                      X_Last_Update_Login                   NUMBER,
                      X_Created_By                          NUMBER,
                      X_Creation_Date                       DATE) IS
--
   CURSOR C IS SELECT rowid FROM pay_element_type_rules
               WHERE  element_set_id = X_Element_Set_Id
                 AND  element_type_id = X_Element_Type_Id;

Line: 230

   INSERT INTO pay_element_type_rules
   (element_type_id,
    element_set_id,
    include_or_exclude,
    last_update_date,
    last_updated_by,
    last_update_login,
    created_by,
    creation_date)
   VALUES
   (X_Element_Type_Id,
    X_Element_Set_Id,
    X_Include_Or_Exclude,
    X_Last_Update_Date,
    X_Last_Updated_By,
    X_Last_Update_Login,
    X_Created_By,
    X_Creation_Date);

Line: 255

                                  'pay_element_type_rules_pkg.insert_row');

Line: 261

 END Insert_Row;

Line: 280

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

Line: 332

 PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                      X_Element_Type_Id                     NUMBER,
                      X_Element_Set_Id                      NUMBER,
                      X_Include_Or_Exclude                  VARCHAR2,
                      X_Last_Update_Date                    DATE,
                      X_Last_Updated_By                     NUMBER,
                      X_Last_Update_Login                   NUMBER) IS
 BEGIN
--
   UPDATE pay_element_type_rules
   SET element_type_id        =    X_Element_Type_Id,
       element_set_id         =    X_Element_Set_Id,
       include_or_exclude     =    X_Include_Or_Exclude,
       last_update_date       =    X_Last_Update_Date,
       last_updated_by        =    X_Last_Updated_By,
       last_update_login      =    X_Last_Update_Login
   WHERE rowid = X_rowid;

Line: 353

                                  'pay_element_type_rules_pkg.update_row');

Line: 358

 END Update_Row;

Line: 372

 PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
 BEGIN
--
   DELETE FROM pay_element_type_rules
   WHERE  rowid = X_Rowid;

Line: 381

                                  'pay_element_type_rules_pkg.delete_row');

Line: 386

 END Delete_Row;