APPS.PAY_NET_CALCULATION_RULES_PKG SQL Statements

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

Line: 5

PROCEDURE Insert_Row(X_Rowid                        IN OUT VARCHAR2,
                     X_Net_Calculation_Rule_Id             IN OUT NUMBER,
                     X_Accrual_Plan_Id                     NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Input_Value_Id                      NUMBER,
                     X_Add_Or_Subtract                     VARCHAR2
 ) IS
   CURSOR C IS SELECT rowid FROM PAY_NET_CALCULATION_RULES

             WHERE net_calculation_rule_id = X_Net_Calculation_Rule_Id;

Line: 20

    CURSOR C2 IS SELECT pay_net_calculation_rules_s.nextval FROM sys.dual;

Line: 28

  INSERT INTO PAY_NET_CALCULATION_RULES(
          net_calculation_rule_id,
          accrual_plan_id,
          business_group_id,
          input_value_id,
          add_or_subtract
         ) VALUES (
          X_Net_Calculation_Rule_Id,
          X_Accrual_Plan_Id,
          X_Business_Group_Id,
          X_Input_Value_Id,
          X_Add_Or_Subtract
  );

Line: 49

END Insert_Row;

Line: 58

      SELECT *
      FROM   PAY_NET_CALCULATION_RULES
      WHERE  rowid = X_Rowid
      FOR UPDATE of Net_Calculation_Rule_Id NOWAIT;

Line: 95

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Net_Calculation_Rule_Id             NUMBER,
                     X_Accrual_Plan_Id                     NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Input_Value_Id                      NUMBER,
                     X_Add_Or_Subtract                     VARCHAR2
) IS
BEGIN
  UPDATE PAY_NET_CALCULATION_RULES
  SET
    net_calculation_rule_id                   =    X_Net_Calculation_Rule_Id,
    accrual_plan_id                           =    X_Accrual_Plan_Id,
    business_group_id                         =    X_Business_Group_Id,
    input_value_id                            =    X_Input_Value_Id,
    add_or_subtract                           =    X_Add_Or_Subtract
  WHERE rowid = X_rowid;

Line: 116

END Update_Row;

Line: 118

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

Line: 126

END Delete_Row;

Line: 135

   select 'Y'
   from   pay_net_calculation_rules
   where
        ((p_net_calculation_rule_id is null)
     or  (p_net_calculation_rule_id is not null
      and net_calculation_rule_id <>  p_net_calculation_rule_id))
   and    accrual_plan_id = p_accrual_plan_id
   and    input_value_id = p_input_value_id;