APPS.ARH_DQM_TREE_HELPER SQL Statements

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

Line: 8

 SELECT MAX(search_context_id)
   FROM hz_matched_parties_gt;

Line: 21

PROCEDURE insert_add_party_site
(p_party_id IN NUMBER,
 p_ctx_id   IN NUMBER,
 p_ps_id   IN NUMBER)
IS
BEGIN
  IF party_site_in_match (p_party_id , p_ctx_id , p_ps_id) = 'N' THEN
    INSERT INTO hz_matched_party_sites_gt
    (PARTY_ID  ,PARTY_SITE_ID,SEARCH_CONTEXT_ID ,SCORE)  VALUES
    (p_party_id,p_ps_id      ,p_ctx_id, 0);

Line: 34

PROCEDURE insert_add_contact
(p_party_id   IN NUMBER,
 p_ctx_id     IN NUMBER,
 p_contact_id IN NUMBER)
IS
BEGIN
  IF contact_in_match (p_party_id , p_ctx_id , p_contact_id) = 'N' THEN
    INSERT INTO hz_matched_contacts_gt
    (PARTY_ID  , ORG_CONTACT_ID, SEARCH_CONTEXT_ID, SCORE )  VALUES
    (p_party_id, p_contact_id  ,p_ctx_id, 0);

Line: 47

PROCEDURE insert_add_cpt
(p_party_id   IN NUMBER,
 p_ctx_id     IN NUMBER,
 p_cpt_id     IN NUMBER)
IS
BEGIN
  IF cpt_in_match (p_party_id , p_ctx_id , p_cpt_id) = 'N' THEN
    INSERT INTO hz_matched_cpts_gt
    (PARTY_ID  , CONTACT_POINT_ID, SEARCH_CONTEXT_ID , SCORE)  VALUES
    (p_party_id, p_cpt_id        , p_ctx_id, 0);

Line: 66

  SELECT 'Y'
    FROM hz_relationships
   WHERE relationship_id   = p_rel_id
     AND object_table_name = 'HZ_PARTIES'
     AND object_id         = p_party_id
     AND directional_flag  = 'F';

Line: 89

  SELECT 'Y'
    FROM hz_party_sites
   WHERE party_site_id  = p_ps_id
     AND party_id       = p_party_id;

Line: 116

  SELECT 'Y'
    FROM hz_matched_cpts_gt
   WHERE party_id          = p_party_id
     AND search_context_id = p_ctx_id
     AND contact_point_id  = p_cpt_id;

Line: 143

  SELECT 'Y'
    FROM hz_matched_contacts_gt
   WHERE party_id          = p_party_id
     AND search_context_id = p_ctx_id
     AND org_contact_id    = p_contact_id;

Line: 170

  SELECT 'Y'
    FROM hz_matched_party_sites_gt
   WHERE party_id          = p_party_id
     AND search_context_id = p_ctx_id
     AND party_site_id     = p_ps_id;

Line: 197

  SELECT 'Y'
    FROM hz_matched_parties_gt
   WHERE party_id          = p_party_id
     AND search_context_id = p_ctx_id;

Line: 224

  SELECT org_contact_id,
         party_site_id
    FROM hz_org_contacts
   WHERE party_relationship_id = p_rel_id;

Line: 254

  SELECT relationship_id,
         relationship_code
    FROM hz_relationships
   WHERE subject_type      = 'PERSON'
     AND subject_table_name= 'HZ_PARTIES'
     AND subject_id        = p_pers_id
     AND object_type       = 'ORGANIZATION'
     AND object_table_name = 'HZ_PARTIES'
     AND object_id         = p_party_id
     AND directional_flag  = 'F';

Line: 279

  SELECT party_type
    FROM hz_parties
   WHERE party_id = p_party_id;

Line: 304

  SELECT owner_table_name,
         owner_table_id
    FROM hz_contact_points
   WHERE contact_point_id = p_contact_point_id;

Line: 344

  insert_add_contact(p_party_id  => p_pty_id,
                     p_ctx_id    => p_ctx_id,
                     p_contact_id=> l_org_contact_id);

Line: 349

    insert_add_party_site(p_party_id => p_pty_id,
                          p_ctx_id   => p_ctx_id,
                          p_ps_id    => l_ps_id);

Line: 388

  insert_add_party_site(p_party_id => p_pty_id,
                        p_ctx_id   => p_ctx_id,
                        p_ps_id    => p_ps_id);

Line: 493

  SELECT NVL(party_site_id,-9999)
    FROM hz_org_contacts
   WHERE org_contact_id = p_contact_id;