APPS.PER_IN_CON_LEG_HOOK SQL Statements

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

Line: 62

PROCEDURE nomination_share_insert_check
        (p_CEI_INFORMATION2        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
        ,p_CEI_INFORMATION3        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
        ,p_effective_date          IN DATE
        ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
        )IS

BEGIN
NULL ;

Line: 71

END  nomination_share_insert_check ;

Line: 100

PROCEDURE nomination_share_update_check
        (p_CEI_INFORMATION2        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
        ,p_CEI_INFORMATION3        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
        ,p_effective_date          IN DATE
        ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
        ,p_contact_extra_info_id    IN  PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE)IS
BEGIN
NULL ;

Line: 108

END nomination_share_update_check;

Line: 161

         SELECT pbg.legislation_code
           FROM per_business_groups pbg,
                per_contact_relationships pcr
          WHERE pcr.contact_relationship_id = p_contact_relationship_id
            AND pcr.business_group_id = pbg.business_group_id;

Line: 169

          SELECT DATE_OF_BIRTH from per_all_people_f
           WHERE PERSON_ID = l_contact_person_id ;

Line: 174

         SELECT contact_person_id from PER_CONTACT_RELATIONSHIPS
          WHERE contact_relationship_id = p_contact_relationship_id;

Line: 178

         SELECT 1 from per_contact_relationships
          WHERE contact_relationship_id = p_contact_relationship_id
            AND cont_information13 is not null
            AND cont_information14 is not null
            AND cont_information15 is not null
            AND cont_information17 is not null;

Line: 227

        SELECT effective_date into l_current_date from fnd_sessions
         WHERE session_id = userenv('SESSIONID');

Line: 315

PROCEDURE get_essential_insert_value
        (p_CEI_INFORMATION2        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
        ,p_CEI_INFORMATION3        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
        ,p_effective_date          IN DATE
        ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
        ,p_message_name            OUT NOCOPY VARCHAR2
        ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
        ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type)
IS
l_nomination_share            NUMBER;

Line: 336

         SELECT pbg.legislation_code
         FROM   per_business_groups pbg,
                per_contact_relationships pcr
          WHERE pcr.contact_relationship_id = p_contact_relationship_id
          AND  pcr.business_group_id = pbg.business_group_id;

Line: 344

         SELECT contact_relationship_id from PER_CONTACT_RELATIONSHIPS
         WHERE person_id = l_person_id
         AND   contact_relationship_id <> p_contact_relationship_id;

Line: 349

          SELECT person_id from PER_CONTACT_RELATIONSHIPS
          WHERE  contact_relationship_id = p_contact_relationship_id;

Line: 353

         SELECT 1 from PER_CONTACT_EXTRA_INFO_F
         WHERE contact_relationship_id = p_contact_relationship_id
         AND   CEI_INFORMATION3 = p_CEI_INFORMATION3
         AND   p_effective_date between effective_start_date and effective_end_date;

Line: 361

  l_procedure := g_package ||'get_essential_insert_value';

Line: 438

END get_essential_insert_value;

Line: 473

PROCEDURE get_essential_update_value
        (p_CEI_INFORMATION2        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
        ,p_CEI_INFORMATION3        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
        ,p_effective_date          IN DATE
        ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
        ,p_contact_extra_info_id   IN  PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE
        ,p_message_name            OUT NOCOPY VARCHAR2
        ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
        ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type)
IS
  l_nomination_share            NUMBER;

Line: 492

         SELECT 1 from PER_CONTACT_EXTRA_INFO_F
         WHERE  contact_relationship_id = p_contact_relationship_id
         AND    contact_extra_info_id <> p_contact_extra_info_id
         AND    CEI_INFORMATION3 = p_CEI_INFORMATION3
         AND    p_effective_date between effective_start_date and effective_end_date;

Line: 500

         SELECT pbg.legislation_code
         FROM   per_business_groups pbg,
                per_contact_relationships pcr
         WHERE  pcr.contact_relationship_id = p_contact_relationship_id
         AND    pcr.business_group_id = pbg.business_group_id;

Line: 508

         SELECT contact_relationship_id from PER_CONTACT_RELATIONSHIPS
         WHERE person_id = l_person_id
         AND contact_relationship_id <> p_contact_relationship_id;

Line: 513

         SELECT person_id from PER_CONTACT_RELATIONSHIPS
         WHERE contact_relationship_id = p_contact_relationship_id;

Line: 520

  l_procedure := g_package ||'get_essential_update_value';

Line: 598

END get_essential_update_value;

Line: 670

get_essential_insert_value
        (p_CEI_INFORMATION2        => p_CEI_INFORMATION2
        ,p_CEI_INFORMATION3        => p_CEI_INFORMATION3
        ,p_effective_date          => p_effective_date
        ,p_contact_relationship_id => p_contact_relationship_id
        ,p_message_name            =>p_message_name
        ,p_token_name              => p_token_name
        ,p_token_value             =>p_token_value);

Line: 689

get_essential_update_value
        (p_CEI_INFORMATION2        => p_CEI_INFORMATION2
        ,p_CEI_INFORMATION3        => p_CEI_INFORMATION3
        ,p_effective_date          => p_effective_date
        ,p_contact_relationship_id => p_contact_relationship_id
        ,p_contact_extra_info_id   => p_contact_extra_info_id
        ,p_message_name            => p_message_name
        ,p_token_name              => p_token_name
        ,p_token_value             => p_token_value);

Line: 745

PROCEDURE check_in_con_insert
        (p_CEI_INFORMATION2        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
        ,p_CEI_INFORMATION3        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
        ,p_effective_date          IN DATE
        ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
        )
IS
l_procedure VARCHAR2(100);

Line: 758

  l_procedure := g_package ||'check_in_con_insert';

Line: 785

END  check_in_con_insert ;

Line: 817

PROCEDURE check_in_con_update
        (p_CEI_INFORMATION2        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
        ,p_CEI_INFORMATION3        IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
        ,p_effective_date          IN DATE
        ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
        ,p_contact_extra_info_id    IN  PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE)
IS

CURSOR c_nom_id IS
      SELECT
         CEI_INFORMATION2
        ,CEI_INFORMATION3
        ,contact_relationship_id
        FROM  PER_CONTACT_EXTRA_INFO_F
        WHERE contact_extra_info_id =p_contact_extra_info_id;

Line: 844

   l_procedure := g_package ||'check_in_con_update';

Line: 890

END check_in_con_update ;

Line: 925

   SELECT CEI_INFORMATION2
    FROM PER_CONTACT_EXTRA_INFO_F
   WHERE contact_relationship_id = p_contact_relationship_id
     AND CEI_INFORMATION3 = p_CEI_INFORMATION3
     AND  effective_end_date >= p_effective_date;