APPS.BEN_BENEFICIARIES_PKG SQL Statements

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

Line: 6

  PROCEDURE Insert_Row(P_Rowid                   IN OUT VARCHAR2,
                       P_Beneficiary_Id          IN OUT NUMBER,
                       P_Source_Type                    VARCHAR2,
                       P_Source_Id                      NUMBER,
                       P_Element_Entry_Id               NUMBER,
                       P_Effective_Start_Date           DATE,
                       P_Effective_End_Date             DATE,
                       P_Benefit_Level                  VARCHAR2,
                       P_Proportion                     NUMBER  ) IS
   --
   CURSOR C IS
	SELECT rowid FROM ben_beneficiaries_f
        WHERE  beneficiary_id   = P_Beneficiary_Id
	AND    element_entry_id = P_Element_Entry_Id;

Line: 22

	SELECT ben_beneficiaries_s.nextval
	FROM   sys.dual;

Line: 37

       INSERT INTO ben_beneficiaries_f(
              beneficiary_id,
              source_type,
              source_id,
              element_entry_id,
              effective_start_date,
              effective_end_date,
              benefit_level,
              proportion
             )
       VALUES (
              P_Beneficiary_Id,
              P_Source_Type,
              P_Source_Id,
              P_Element_Entry_Id,
              P_Effective_Start_Date,
              P_Effective_End_Date,
              P_Benefit_Level,
              P_Proportion
             );

Line: 66

      hr_utility.set_message_token('PROCEDURE','INSERT_ROW');

Line: 73

  END Insert_Row;

Line: 88

        SELECT *
        FROM   ben_beneficiaries_f
        WHERE  rowid = P_Rowid
        FOR UPDATE of Beneficiary_Id NOWAIT;

Line: 151

  PROCEDURE Update_Row(P_Rowid                          VARCHAR2,
                       P_Beneficiary_Id                 NUMBER,
                       P_Source_Type                    VARCHAR2,
                       P_Source_Id                      NUMBER,
                       P_Element_Entry_Id               NUMBER,
                       P_Effective_Start_Date           DATE,
                       P_Effective_End_Date             DATE,
                       P_Benefit_Level                  VARCHAR2,
                       P_Proportion                     NUMBER
  ) IS
  BEGIN
    --
    UPDATE ben_beneficiaries_f
    SET
       beneficiary_id                  =     P_Beneficiary_Id,
       source_type                     =     P_Source_Type,
       source_id                       =     P_Source_Id,
       element_entry_id                =     P_Element_Entry_Id,
       effective_start_date            =     P_Effective_Start_Date,
       effective_end_date              =     P_Effective_End_Date,
       benefit_level                   =     P_Benefit_Level,
       proportion                      =     P_Proportion
    WHERE rowid = P_Rowid;

Line: 179

        hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');

Line: 185

  END Update_Row;

Line: 189

  PROCEDURE Delete_Row(P_Rowid VARCHAR2) IS
  BEGIN
    DELETE FROM ben_beneficiaries_f
    WHERE rowid = P_Rowid;

Line: 196

        hr_utility.set_message_token('PROCEDURE','DELETE_ROW');

Line: 200

  END Delete_Row;

Line: 206

   select 'OK'
   from
	  ben_benefit_classifications	ben,
	  pay_element_types_f		ele,
	  fnd_sessions			fnd,
 	  per_assignments_f		asg,
	  pay_element_links_f		link,
	  pay_element_entries_f 	ent
   where
	  ent.element_entry_id		= P_element_entry_id
   and    ent.assignment_id		= asg.assignment_id
   and    asg.primary_flag		= 'Y'
   and	  ent.element_link_id   	= link.element_link_id
   and	  link.element_type_id  	= ele.element_type_id
   and    ele.benefit_classification_id = ben.benefit_classification_id
   and    ben.beneficiary_allowed_flag 	= 'Y'
   and    fnd.session_id		= userenv('sessionid')
   and
	  fnd.effective_date between	ent.effective_start_date
			     and	ent.effective_end_date
   and    fnd.effective_date between	ele.effective_start_date
			     and	ele.effective_end_date
   and    fnd.effective_date between	link.effective_start_date
			     and	link.effective_end_date
   and    fnd.effective_date between	asg.effective_start_date
			     and	asg.effective_end_date;