APPS.BEN_COVERED_DEPENDENTS_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row(P_Rowid                   	IN OUT nocopy VARCHAR2,
                     P_Covered_Dependent_Id     IN OUT nocopy NUMBER,
                     P_Contact_Relationship_Id         NUMBER,
                     P_Element_Entry_Id                NUMBER,
                     P_Effective_Start_Date            DATE,
                     P_Effective_End_Date              DATE ) IS
    --
    CURSOR C IS SELECT rowid
		FROM   ben_covered_dependents_f
                WHERE  covered_dependent_id = P_Covered_Dependent_Id
		AND    element_entry_id     = P_Element_Entry_ID
		;

Line: 17

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

Line: 28

       INSERT INTO ben_covered_dependents_f (
              covered_dependent_id,
              contact_relationship_id,
              element_entry_id,
              effective_start_date,
              effective_end_date)
        VALUES
	    ( P_Covered_Dependent_Id,
              P_Contact_Relationship_Id,
              P_Element_Entry_Id,
              P_Effective_Start_Date,
              P_Effective_End_Date
             );

Line: 50

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

Line: 57

END Insert_Row;

Line: 70

        SELECT *
        FROM   ben_covered_dependents_f
        WHERE  rowid = P_Rowid
        FOR UPDATE of Covered_Dependent_Id NOWAIT;

Line: 129

PROCEDURE Update_Row (P_Rowid				VARCHAR2,
		       P_Covered_Dependent_Id		NUMBER,
		       P_Contact_Relationship_Id	NUMBER,
		       P_Element_Entry_Id		NUMBER,
		       P_Effective_Start_Date		DATE,
		       P_Effective_End_Date		DATE
		      ) IS
BEGIN
 --
 UPDATE ben_covered_dependents_f
 SET
	covered_dependent_id	= P_Covered_Dependent_Id,
	contact_relationship_id = P_Contact_Relationship_Id,
	element_entry_id	= P_Element_Entry_Id,
	effective_start_date	= P_Effective_Start_Date,
	effective_end_date	= P_Effective_End_Date
 WHERE
	rowid = P_Rowid;

Line: 151

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

Line: 157

END Update_Row;

Line: 161

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

Line: 170

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

Line: 175

END Delete_Row;

Line: 182

   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'     -- BUG3300263
   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.dependents_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;