APPS.HR_NO_VALIDATE_PKG SQL Statements

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

Line: 14

    SELECT 'Y'
    FROM   per_person_types ppt
    WHERE  ppt.system_person_type like 'EMP%'
    AND    ppt.person_type_Id = p_person_type_id;

Line: 209

 SELECT 'Y'
 FROM   hr_organization_information hoi
 WHERE  hoi.organization_id             = p_organization_id
 AND    hoi.org_information_context     = 'NO_EOY_REPORTING_RULE_OVERRIDE'
 AND    hoi.org_information3            = p_org_information3
 AND    (to_number(hoi.org_information1) BETWEEN to_number(p_org_information1)
                                         AND to_number(nvl(p_org_information2,'4712'))
  OR    to_number(p_org_information1)    BETWEEN to_number(hoi.org_information1)
                                         AND to_number(nvl(hoi.org_information2,'4712')));

Line: 220

	select business_group_id
		from hr_organization_units
		where organization_id = p_organization_id;

Line: 226

      	     select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou
	     where  ( orgif.org_information_context = 'NO_LOCAL_UNIT_DETAILS' or orgif.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS')
             and ou.organization_id = orgif.organization_id
	     and ou.business_group_id = l_business_group_id
             and orgif.org_information1 = p_org_information1
             and s_eff_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 235

		select o.organization_id
		from hr_organization_units o , hr_organization_information hoi
		where o.organization_id = hoi.organization_id
		and o.business_group_id = l_business_group_id
		and hoi.org_information_context = 'CLASS'
		and hoi.org_information1 = 'NO_LOCAL_UNIT'
		and to_char(o.organization_id) in (
				select hoinf.org_information1
				from hr_organization_units org, hr_organization_information hoinf
				where org.business_group_id = l_business_group_id
				and org.organization_id = hoinf.organization_id
				and hoinf.org_information_context = 'NO_LOCAL_UNITS'
			)
		and o.organization_id = to_number(p_org_information1)
		and s_eff_date between o.date_from and nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY'))
		order by o.name;

Line: 255

	SELECT  hoi.ORG_INFORMATION1	p_org_info1
		,hoi.ORG_INFORMATION2	p_org_info2
		,hoi.ORG_INFORMATION3	p_org_info3
	FROM	hr_organization_information	hoi
	WHERE	hoi.ORGANIZATION_ID = p_organization_id
	AND	hoi.ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT';

Line: 264

	SELECT
		hoi.org_information5 hourly_salaried
	FROM
		hr_organization_information hoi
	WHERE
		hoi.organization_id = p_organization_id
		AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';

Line: 273

	SELECT
		hoi.org_information5 pay_to_be_adjusted
	FROM
		hr_organization_information hoi
	WHERE
		hoi.organization_id = p_organization_id
		AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';

Line: 283

	SELECT	hoi.ORG_INFORMATION1 pension_types
	FROM	hr_organization_information hoi
	WHERE	hoi.organization_id = p_organization_id
		AND hoi.org_information_context = 'NO_PENSION_DETAILS';

Line: 290

	SELECT	hoi.ORG_INFORMATION2 org_number
	FROM	hr_organization_information hoi
	WHERE	hoi.organization_id = p_organization_id
		AND hoi.org_information_context = 'NO_PENSION_DETAILS';

Line: 296

	SELECT	hoi.org_information1,
    		hoi.org_information2
	FROM	hr_organization_information hoi
	WHERE	hoi.organization_id = p_organization_id
		AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
		AND hoi.org_information3 = p_org_information3
    		AND ( 	(fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
    		         AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
    		        )
        	 	OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
        		OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
        		OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
        		    AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
        		    )
        	    );

Line: 329

	     SELECT effective_date INTO s_effective_date FROM fnd_sessions
	     WHERE session_id = userenv('sessionid');

Line: 357

		select organization_id,org_information_context,org_information1 into l_org_id, l_org_info_type_code,l_org_information1
		from hr_organization_information
		where org_information_id = l_org_information_id;

Line: 387

		SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;

Line: 388

		SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;

Line: 405

				SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;

Line: 406

				SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;

Line: 608

 PROCEDURE validate_update_org_inf
  (p_org_info_type_code			in	 varchar2
  ,p_org_information_id		in number
  ,p_org_information1		in	varchar2
  ) IS

*/

 PROCEDURE validate_update_org_inf
  (p_org_info_type_code			in	varchar2
  ,p_org_information_id			in	number
  ,p_org_information1			in	varchar2
  ,p_org_information2			in	varchar2
  ,p_org_information3			in	varchar2
  ,p_org_information4			in	varchar2
  ,p_org_information5			in	varchar2
  ,p_org_information6			in	varchar2
  ,p_org_information7			in	varchar2
  ,p_org_information8			in	varchar2
  ,p_org_information9			in	varchar2
  ,p_org_information10			in	varchar2
  ,p_org_information11			in	varchar2
  ,p_org_information12			in	varchar2
  ,p_org_information13			in	varchar2
  ,p_org_information14			in	varchar2
  ,p_org_information15			in	varchar2
  ,p_org_information16			in	varchar2
  ,p_org_information17			in	varchar2
  ,p_org_information18			in	varchar2
  ,p_org_information19			in	varchar2
  ,p_org_information20			in	varchar2
  ) IS


 l_org_information1  hr_organization_information.org_information1%TYPE;

Line: 658

 SELECT 'Y'
 FROM   hr_organization_information hoi
 WHERE  hoi.organization_id             = l_organization_id
 AND    hoi.org_information_context     = 'NO_EOY_REPORTING_RULE_OVERRIDE'
 AND    hoi.org_information3            = p_org_information3
 AND    hoi.org_information_id          <> p_org_information_id
 AND    (to_number(hoi.org_information1) BETWEEN to_number(p_org_information1)
                                         AND to_number(nvl(p_org_information2,'4712'))
  OR    to_number(p_org_information1)    BETWEEN to_number(hoi.org_information1)
                                         AND to_number(nvl(hoi.org_information2,'4712')));

Line: 670

	select business_group_id
		from hr_organization_units
		where organization_id = l_organization_id;

Line: 675

	select organization_id
		from hr_organization_information
		where org_information_id = p_org_information_id;

Line: 680

    	     select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou
	     where  ( orgif.org_information_context = 'NO_LOCAL_UNIT_DETAILS' or orgif.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS')
             and ou.organization_id = orgif.organization_id
	     and ou.business_group_id = l_business_group_id
             and orgif.org_information1 = p_org_information1
             and s_eff_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 689

		select o.organization_id
		from hr_organization_units o , hr_organization_information hoi
		where o.organization_id = hoi.organization_id
		and o.business_group_id = l_business_group_id
		and hoi.org_information_context = 'CLASS'
		and hoi.org_information1 = 'NO_LOCAL_UNIT'
		and to_char(o.organization_id) in (
				select hoinf.org_information1
				from hr_organization_units org, hr_organization_information hoinf
				where org.business_group_id = l_business_group_id
				and org.organization_id = hoinf.organization_id
				and org.organization_id <> l_organization_id
				and hoinf.org_information_context = 'NO_LOCAL_UNITS'
			)
		and o.organization_id = to_number(p_org_information1)
		and s_eff_date between o.date_from and nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY'))
		order by o.name;

Line: 710

	SELECT  hoi.ORG_INFORMATION1	p_org_info1
		,hoi.ORG_INFORMATION2	p_org_info2
		,hoi.ORG_INFORMATION3	p_org_info3
	FROM	hr_organization_information	hoi
	WHERE	hoi.ORGANIZATION_ID = p_organization_id
	AND	hoi.ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
	AND	hoi.ORG_INFORMATION_ID <> p_org_information_id;

Line: 720

	SELECT
		hoi.org_information5 hourly_salaried
	FROM
		hr_organization_information hoi
	WHERE
		hoi.organization_id = p_organization_id
		AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';

Line: 729

	SELECT
		hoi.org_information5 pay_to_be_adjusted
	FROM
		hr_organization_information hoi
	WHERE
		hoi.organization_id = p_organization_id
		AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';

Line: 739

	SELECT	hoi.ORG_INFORMATION1 pension_types
	FROM	hr_organization_information hoi
	WHERE	hoi.ORG_INFORMATION_ID = p_org_information_id
		AND hoi.org_information_context = 'NO_PENSION_DETAILS';

Line: 746

	SELECT	hoi.ORG_INFORMATION2 org_number
	FROM	hr_organization_information hoi
	WHERE	hoi.ORG_INFORMATION_ID = p_org_information_id
		AND hoi.org_information_context = 'NO_PENSION_DETAILS';

Line: 752

	SELECT	hoi.org_information1,
    		hoi.org_information2
	FROM	hr_organization_information hoi
	WHERE	hoi.org_information_id = p_org_information_id
		AND hoi.org_information_context = 'NO_PENSION_PROVIDER';

Line: 759

	SELECT	hoi.org_information1,
    		hoi.org_information2,
    		hoi.org_information_id
	FROM	hr_organization_information hoi
	WHERE	hoi.organization_id = (   SELECT hoi1.organization_id
                                         FROM   hr_organization_information hoi1
                                         WHERE  hoi1.org_information_id = p_org_information_id
                                      )
		AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
		AND hoi.org_information3 = p_org_information3
        AND ( 	(fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
    		         AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
    		        )
        	 	OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
        		OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
        		OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
        		    AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
        		    )
     	    )
        AND (   fnd_date.canonical_to_date(hoi.org_information1) <> fnd_date.canonical_to_date(p_org_information1)
                OR  fnd_date.canonical_to_date(hoi.org_information2) <> fnd_date.canonical_to_date(p_org_information2)
            );

Line: 801

	     SELECT effective_date INTO s_effective_date FROM fnd_sessions
	     WHERE session_id = userenv('sessionid');

Line: 833

		select organization_id,org_information_context,org_information1
		into l_org_id, l_org_info_type_code,l_org_information1
		from hr_organization_information
		where org_information_id = l_org_information_id;

Line: 843

			-- Bug Fix 5370311 Start : ignore if same record is being updated
			ELSIF ( l_org_information_id = p_org_information_id ) THEN
			   NULL ;

Line: 869

		SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;

Line: 870

		SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;

Line: 887

				SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;

Line: 888

				SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;

Line: 1093

 END validate_update_org_inf;

Line: 1096

PROCEDURE qual_insert_validate
  (p_business_group_id              in      number
  ,p_qualification_type_id          in      number
  ,p_qua_information_category       in      varchar2 default null
  ,p_person_id                      in      number
  ,p_qua_information1               in      varchar2 default null
  ,p_qua_information2               in      varchar2 default null
  ) IS
      l_count 	    NUMBER;

Line: 1114

      select information1 into l_nus2000_code
      from per_qualification_types
      where qualification_type_id = p_qualification_type_id;

Line: 1127

	select count(*)
	into l_count
	from  per_qualifications pq
        where pq.business_group_id   = p_business_group_id
	and pq.person_id    =   p_person_id
	and pq.qua_information_category='NO'
	and pq.qua_information2='Y';

Line: 1140

  END qual_insert_validate;

Line: 1143

PROCEDURE qual_update_validate
  (p_qua_information_category       in      varchar2 default null
  ,p_qualification_id               in      number
  ,p_qualification_type_id          in      number
  ,p_qua_information1               in      varchar2 default null
  ,p_qua_information2               in      varchar2 default null
  ) IS
      l_count		        NUMBER;

Line: 1156

    SELECT person_id,business_group_id
    FROM   per_qualifications
    WHERE  qualification_id = p_qualification_id;

Line: 1160

/*Bug fix 4950606 : Rewrote the select statement using cursor in qual_update_validate procedure.*/
CURSOR  c_information1 IS
SELECT
	information1
FROM
	per_qualification_types
WHERE
	qualification_type_id = p_qualification_type_id;

Line: 1192

	select count(*)
	into l_count
	from  per_qualifications pq
        where pq.business_group_id   = l_business_group_id
	and pq.person_id    =   l_person_id
        and pq.qualification_id <> p_qualification_id
	and pq.qua_information_category='NO'
	and pq.qua_information2='Y';

Line: 1208

END qual_update_validate ;

Line: 1222

	select business_group_id
		from hr_organization_units
		where organization_id = p_organization_id;

Line: 1227

      	     select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s
	     where ou.organization_id= p_organization_id
	     and s.session_id = userenv('sessionid')
             and s.effective_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 1291

 PROCEDURE update_contract_validate
   (p_contract_id		     in      number   default null
   ,p_status                         in      varchar2
   ,p_effective_date		     in      date
   ,p_ctr_information_category       in      varchar2 default null
   ,p_ctr_information1               in      varchar2 default null
    )  IS

   l_active_start_date  date;

Line: 1323

   END update_contract_validate;

Line: 1385

  select papf.date_of_birth, papf.start_date
  from per_all_people_f papf
  where papf.per_information_category ='NO'
  and papf.PERSON_ID = p_person_id
  and p_effective_date BETWEEN  papf.EFFECTIVE_START_DATE and  papf.EFFECTIVE_END_DATE;

Line: 1442

 PROCEDURE update_asg_validate
 ( p_segment12                IN      VARCHAR2  DEFAULT  NULL
  ,p_segment13                IN      VARCHAR2  DEFAULT  NULL
  ,p_segment14                IN      VARCHAR2  DEFAULT  NULL
  ,p_effective_date	      IN      DATE
  ,p_assignment_id	      IN      NUMBER
   )  IS

  CURSOR get_person_details (p_assignment_id NUMBER) IS
  select papf.date_of_birth, papf.start_date
  from per_all_people_f papf, per_all_assignments_f paaf
  where papf.per_information_category ='NO'
  and paaf.PERSON_ID = papf.PERSON_ID
  and paaf.ASSIGNMENT_ID = p_assignment_id
  and p_effective_date BETWEEN  paaf.EFFECTIVE_START_DATE and  paaf.EFFECTIVE_END_DATE
  and p_effective_date BETWEEN  papf.EFFECTIVE_START_DATE and  papf.EFFECTIVE_END_DATE;

Line: 1506

 END update_asg_validate;

Line: 1569

     SELECT eei_information1, eei_information2
     FROM pay_element_type_extra_info petei
     WHERE petei.information_type='NO_ELEMENT_CODES'
     AND petei.element_type_id = p_ele_type_id ;

Line: 1575

     SELECT  hou.name  NAME
     FROM hr_organization_units   hou
         ,hr_organization_information   hoi
     WHERE hoi.organization_id = hou.organization_id
     AND   hoi.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS'
     AND   hou.organization_id = p_le_id;

Line: 1583

     SELECT 'Y', etei.eei_information3
     FROM  pay_element_type_extra_info etei
     WHERE etei.element_type_id          = p_element_type_id
     AND   etei.eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING'
     AND   ((to_number(etei.eei_information1)
           between  to_number(p_eei_information1) and to_number(nvl(p_eei_information2,'4712')))
     OR    (to_number(p_eei_information1)
           between  to_number(etei.eei_information1) and to_number(nvl(etei.eei_information2,'4712')))) ;

Line: 1709

PROCEDURE UPDATE_ELEMENT_ELE_CODE
  (p_element_type_extra_info_id IN NUMBER
  ,p_eei_attribute_category     IN VARCHAR2
  ,p_eei_attribute1             IN VARCHAR2
  ,p_eei_attribute2             IN VARCHAR2
  ,p_eei_attribute3             IN VARCHAR2
  ,p_eei_attribute4             IN VARCHAR2
  ,p_eei_attribute5             IN VARCHAR2
  ,p_eei_attribute6             IN VARCHAR2
  ,p_eei_attribute7             IN VARCHAR2
  ,p_eei_attribute8             IN VARCHAR2
  ,p_eei_attribute9             IN VARCHAR2
  ,p_eei_attribute10            IN VARCHAR2
  ,p_eei_attribute11            IN VARCHAR2
  ,p_eei_attribute12            IN VARCHAR2
  ,p_eei_attribute13            IN VARCHAR2
  ,p_eei_attribute14            IN VARCHAR2
  ,p_eei_attribute15            IN VARCHAR2
  ,p_eei_attribute16            IN VARCHAR2
  ,p_eei_attribute17            IN VARCHAR2
  ,p_eei_attribute18            IN VARCHAR2
  ,p_eei_attribute19            IN VARCHAR2
  ,p_eei_attribute20            IN VARCHAR2
  ,p_eei_information_category   IN VARCHAR2
  ,p_eei_information1           IN VARCHAR2
  ,p_eei_information2           IN VARCHAR2
  ,p_eei_information3           IN VARCHAR2
  ,p_eei_information4           IN VARCHAR2
  ,p_eei_information5           IN VARCHAR2
  ,p_eei_information6           IN VARCHAR2
  ,p_eei_information7           IN VARCHAR2
  ,p_eei_information8           IN VARCHAR2
  ,p_eei_information9           IN VARCHAR2
  ,p_eei_information10          IN VARCHAR2
  ,p_eei_information11          IN VARCHAR2
  ,p_eei_information12          IN VARCHAR2
  ,p_eei_information13          IN VARCHAR2
  ,p_eei_information14          IN VARCHAR2
  ,p_eei_information15          IN VARCHAR2
  ,p_eei_information16          IN VARCHAR2
  ,p_eei_information17          IN VARCHAR2
  ,p_eei_information18          IN VARCHAR2
  ,p_eei_information19          IN VARCHAR2
  ,p_eei_information20          IN VARCHAR2
  ,p_eei_information21          IN VARCHAR2
  ,p_eei_information22          IN VARCHAR2
  ,p_eei_information23          IN VARCHAR2
  ,p_eei_information24          IN VARCHAR2
  ,p_eei_information25          IN VARCHAR2
  ,p_eei_information26          IN VARCHAR2
  ,p_eei_information27          IN VARCHAR2
  ,p_eei_information28          IN VARCHAR2
  ,p_eei_information29          IN VARCHAR2
  ,p_eei_information30          IN VARCHAR2
  ,p_object_version_number      IN NUMBER
  ) is

     CURSOR csr_get_element_type_id ( p_element_type_extra_info_id NUMBER )IS
     SELECT element_type_id
     FROM pay_element_type_extra_info petei
     WHERE petei.information_type='NO_ELEMENT_CODES'
     AND petei.element_type_extra_info_id = p_element_type_extra_info_id;

Line: 1774

     SELECT eei_information1 , eei_information2
     FROM pay_element_type_extra_info petei
     WHERE petei.information_type='NO_ELEMENT_CODES'
     AND petei.element_type_id = p_ele_type_id
     AND petei.eei_information1 = p_ele_code;

Line: 1781

     SELECT  hou.name  NAME
     FROM hr_organization_units   hou
         ,hr_organization_information   hoi
     WHERE hoi.organization_id = hou.organization_id
     AND   hoi.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS'
     AND   hou.organization_id = p_le_id;

Line: 1789

     SELECT element_type_id
     FROM  pay_element_type_extra_info etei
     WHERE etei.information_type          ='NO_EOY_REPORTING_CODE_MAPPING'
     AND   etei.element_type_extra_info_id = p_element_type_extra_info_id;

Line: 1795

     SELECT 'Y', etei.eei_information3
     FROM  pay_element_type_extra_info etei
     WHERE etei.element_type_id            = l_element_type_id
     AND   etei.eei_information_category   = 'NO_EOY_REPORTING_CODE_MAPPING'
     AND   etei.element_type_extra_info_id <> p_element_type_extra_info_id
     AND   ((to_number(etei.eei_information1)
           between  to_number(p_eei_information1) and to_number(nvl(p_eei_information2,'4712')))
     OR    (to_number(p_eei_information1)
           between  to_number(etei.eei_information1) and to_number(nvl(etei.eei_information2,'4712')))) ;

Line: 1925

END UPDATE_ELEMENT_ELE_CODE;

Line: 1929

PROCEDURE update_ele_entry_bp
  ( p_effective_date		  IN	  DATE
   ) IS
   --
   CURSOR csr_get_session_id IS
   SELECT 1
   FROM fnd_sessions
   WHERE session_id = userenv('sessionid');

Line: 1944

        INSERT INTO fnd_sessions (session_id, effective_date)
        VALUES (userenv('sessionid'), trunc(p_effective_date));

Line: 1957

   SELECT 1
   FROM fnd_sessions
   WHERE session_id = userenv('sessionid');

Line: 1967

        INSERT INTO fnd_sessions (session_id, effective_date)
        VALUES (userenv('sessionid'), trunc(p_effective_date));

Line: 1974

PROCEDURE update_ele_entry_ap
 ( p_effective_date		  IN	  DATE
   ) IS
BEGIN
  DELETE FROM fnd_sessions WHERE session_id = userenv('sessionid');

Line: 1985

  DELETE FROM fnd_sessions WHERE session_id = userenv('sessionid');