APPS.HZ_POPULATE_BOT_PKG SQL Statements

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

Line: 6

    p_lud            IN DATE,        -- last update date
    p_centity_name   IN VARCHAR2,    -- child entity name
    p_cbo_code       IN VARCHAR2,    -- child business object code
    p_parent_id      IN NUMBER,      -- parent Id
    p_pentity_name   IN VARCHAR2,    -- parent entity name
    p_pbo_code       IN VARCHAR2     -- parent business object code
  );

Line: 47

      SELECT child_id INTO  l_child_rec_exists_no
      FROM  HZ_BUS_OBJ_TRACKING
      WHERE event_id IS NULL
      AND CHILD_ENTITY_NAME = p_centity_name
      AND CHILD_BO_CODE = p_cbo_code
      AND CHILD_ID = p_child_id
      AND nvl(PARENT_ID,-99) = nvl(p_parent_id,-99)
      AND nvl(PARENT_BO_CODE,'X') = nvl(p_pbo_code,'X')
      AND rownum = 1;

Line: 65

        INSERT INTO HZ_BUS_OBJ_TRACKING
        ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
          LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
        ) VALUES (
          'Y', 'U', p_child_id, p_centity_name, p_cbo_code,
          p_lud, p_lud, p_pentity_name, p_parent_id, p_pbo_code);

Line: 100

      SELECT wc.LAST_UPDATE_DATE lud, wc.EMPLOYMENT_HISTORY_ID parent_id, eh.party_id party_id,
             wc.WORK_CLASS_ID child_id
      FROM HZ_WORK_CLASS wc, HZ_EMPLOYMENT_HISTORY eh, HZ_PARTIES p
      WHERE wc.WORK_CLASS_ID = P_WORK_CLASS_ID
      AND wc.employment_history_id = eh.employment_history_id
      AND eh.party_id = p.party_id
      AND p.party_type = 'PERSON';

Line: 114

    l_lud                     DATE;         -- used to store the child last update date

Line: 143

        SELECT child_id INTO l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 158

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_WORK_CLASS', NULL,
            l_lud, l_lud, 'HZ_EMPLOYMENT_HISTORY', l_parent_id, 'EMP_HIST');

Line: 216

      SELECT rr.LAST_UPDATE_DATE lud, rr.CUST_ACCOUNT_ROLE_ID parent_id, rr.RESPONSIBILITY_ID child_id,
             nvl(car.cust_acct_site_id, car.cust_account_id) car_parent_id,
             decode(car.cust_acct_site_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_ACCT_SITES_ALL') car_parent_entity,
             decode(car.cust_acct_site_id, null, 'CUST_ACCT', 'CUST_ACCT_SITE') car_parent_bo
      FROM HZ_ROLE_RESPONSIBILITY rr, HZ_CUST_ACCOUNT_ROLES car
      WHERE rr.RESPONSIBILITY_ID = P_RESPONSIBILITY_ID
      AND rr.cust_account_role_id = car.cust_account_role_id
      AND car.cust_account_id > 0;

Line: 229

    l_lud                     DATE; -- used to store the child last update date

Line: 262

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 277

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_ROLE_RESPONSIBILITY', NULL,
            l_lud, l_lud, 'HZ_CUST_ACCOUNT_ROLES', l_parent_id, 'CUST_ACCT_CONTACT');

Line: 327

      SELECT pp.LAST_UPDATE_DATE lud, pp.subject_id sparent_id, pp.object_id oparent_id,
             pp.RELATIONSHIP_ID child_id,
             decode(pp.subject_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) sbo_code,
             decode(pp.object_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) obo_code
      FROM HZ_RELATIONSHIPS pp
      WHERE pp.RELATIONSHIP_ID = p_RELATIONSHIP_ID
      AND subject_type in ('ORGANIZATION','PERSON')
      AND object_type in ('ORGANIZATION','PERSON');

Line: 337

      SELECT org_contact_id
      FROM HZ_ORG_CONTACTS
      WHERE party_relationship_id = p_relationship_id;

Line: 348

    l_lud             DATE; -- used to store the child last update date

Line: 378

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 394

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_RELATIONSHIPS', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_subj_id, l_sbo_code);

Line: 402

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_RELATIONSHIPS', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_obj_id, l_obo_code);

Line: 471

      SELECT LAST_UPDATE_DATE lud, PARTY_ID parent_id, PERSON_PROFILE_ID child_id
      FROM HZ_PERSON_PROFILES
      WHERE PERSON_PROFILE_ID = P_PERSON_PROFILE_ID;

Line: 479

    l_lud             DATE; -- used to store the child last update date

Line: 507

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 522

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_PERSON_PROFILES', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');

Line: 571

      SELECT pl.LAST_UPDATE_DATE lud, pl.PARTY_ID parent_id, pl.LANGUAGE_USE_REFERENCE_ID child_id
      FROM HZ_PERSON_LANGUAGE pl, HZ_PARTIES p
      WHERE pl.LANGUAGE_USE_REFERENCE_ID = P_LANGUAGE_USE_REFERENCE_ID
      AND pl.party_id = p.party_id
      AND p.party_type = 'PERSON';

Line: 581

    l_lud                     DATE; -- used to store the child last update date

Line: 608

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 623

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_PERSON_LANGUAGE', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');

Line: 672

      SELECT pi.LAST_UPDATE_DATE lud, pi.PARTY_ID parent_id, pi.PERSON_INTEREST_ID child_id
      FROM HZ_PERSON_INTEREST pi, HZ_PARTIES p
      WHERE pi.PERSON_INTEREST_ID = P_PERSON_INTEREST_ID
      AND pi.party_id = p.party_id
      AND p.party_type = 'PERSON';

Line: 682

    l_lud                     DATE; -- used to store the child last update date

Line: 709

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 724

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_PERSON_INTEREST', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');

Line: 773

      SELECT psu.LAST_UPDATE_DATE lud, psu.PARTY_SITE_ID parent_id, psu.PARTY_SITE_USE_ID child_id,
             p.party_type, p.party_id
      FROM HZ_PARTY_SITE_USES psu, HZ_PARTY_SITES ps, HZ_PARTIES p
      WHERE psu.PARTY_SITE_USE_ID = P_PARTY_SITE_USE_ID
      AND psu.party_site_id = ps.party_site_id
      AND ps.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');

Line: 782

      SELECT oc.org_contact_id
      FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
      WHERE oc.party_relationship_id = pr.relationship_id
      AND pr.party_id = l_party_id
      AND pr.subject_type = 'PERSON'
      AND pr.object_type = 'ORGANIZATION'
      AND rownum = 1;

Line: 794

    l_lud                     DATE; -- used to store the child last update date

Line: 836

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 851

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_PARTY_SITE_USES', NULL,
            l_lud, l_lud, 'HZ_PARTY_SITES', l_parent_id, 'PARTY_SITE');

Line: 893

      SELECT ps.LAST_UPDATE_DATE lud, ps.PARTY_ID parent_id,
             decode(p.party_type, 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', 'HZ_PARTIES') parent_tbl_name,
             ps.PARTY_SITE_ID child_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', null) bo_code,
             ps.location_id location_id
      FROM HZ_PARTY_SITES ps, HZ_PARTIES p
      WHERE ps.PARTY_SITE_ID = P_PARTY_SITE_ID
      AND ps.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION','PERSON','PARTY_RELATIONSHIP');

Line: 904

      SELECT oc.org_contact_id
      FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
      WHERE oc.party_relationship_id = pr.relationship_id
      AND pr.party_id = l_party_id
      AND pr.subject_type = 'PERSON'
      AND pr.object_type = 'ORGANIZATION'
      AND rownum = 1;

Line: 919

    l_lud                     DATE; -- used to store the child last update date

Line: 962

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 978

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_PARTY_SITES', 'PARTY_SITE',
            l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);

Line: 1018

      SELECT pp.LAST_UPDATE_DATE lud,  pp.PARTY_ID parent_id,
             'HZ_PARTIES' parent_tbl_name, pp.PARTY_PREFERENCE_ID child_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
      FROM HZ_PARTY_PREFERENCES pp, HZ_PARTIES p
      WHERE pp.PARTY_PREFERENCE_ID = p_party_preference_id
      AND pp.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON');

Line: 1033

    l_lud                     DATE; -- used to store the child last update date

Line: 1062

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1077

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_PARTY_PREFERENCES', NULL,
            l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);

Line: 1126

      SELECT ocr.LAST_UPDATE_DATE lud, ocr.ORG_CONTACT_ID parent_id,
             ocr.ORG_CONTACT_ROLE_ID child_id, pr.object_id object_id
      FROM HZ_ORG_CONTACT_ROLES ocr, HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
      WHERE ORG_CONTACT_ROLE_ID = P_ORG_CONTACT_ROLE_ID
      AND ocr.org_contact_id = oc.org_contact_id
      AND oc.party_relationship_id = pr.relationship_id
      AND pr.object_type = 'ORGANIZATION'
      AND pr.subject_type = 'PERSON'
      AND rownum = 1;

Line: 1140

    l_lud                     DATE; -- used to store the child last update date

Line: 1169

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1184

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_ORG_CONTACT_ROLES', NULL,
            l_lud, l_lud, 'HZ_ORG_CONTACTS', l_parent_id, 'ORG_CONTACT');

Line: 1233

      SELECT oc.LAST_UPDATE_DATE lud, oc.ORG_CONTACT_ID child_id,
             pr.object_id parent_id, pr.subject_id person_id, pr.relationship_id rel_id
      FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
      WHERE oc.ORG_CONTACT_ID = P_ORG_CONTACT_ID
      AND oc.party_relationship_id = pr.relationship_id
      AND pr.object_type = 'ORGANIZATION'
      AND pr.subject_type = 'PERSON'
      AND rownum = 1;

Line: 1246

    l_lud                     DATE; -- used to store the child last update date

Line: 1278

        SELECT child_id, populated_flag INTO  l_child_rec_exists_no, l_pop_flag
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1287

            UPDATE HZ_BUS_OBJ_TRACKING
            SET populated_flag = 'N'
            WHERE event_id IS NULL
            AND CHILD_ENTITY_NAME = l_cen
            AND CHILD_ID = l_child_id;

Line: 1301

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_ORG_CONTACTS', 'ORG_CONTACT',
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');

Line: 1359

      SELECT LAST_UPDATE_DATE lud, PARTY_ID parent_id, ORGANIZATION_PROFILE_ID child_id
      FROM HZ_ORGANIZATION_PROFILES
      WHERE ORGANIZATION_PROFILE_ID = P_ORGANIZATION_PROFILE_ID;

Line: 1367

    l_lud                     DATE; -- used to store the child last update date

Line: 1394

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1409

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_ORGANIZATION_PROFILES', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');

Line: 1457

      SELECT LAST_UPDATE_DATE lud, LOCATION_ID child_id
      FROM HZ_LOCATIONS
      WHERE location_id = p_location_id;

Line: 1462

      SELECT party_site_id
      FROM HZ_PARTY_SITES ps, HZ_PARTIES p
      WHERE ps.location_id = l_loc_id
      AND ps.party_id = p.party_id;

Line: 1474

    l_lud             DATE; -- used to store the child last update date

Line: 1499

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1519

            INSERT INTO HZ_BUS_OBJ_TRACKING
            ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
              LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
            ) VALUES (
              'N', p_operation, l_child_id, 'HZ_LOCATIONS', 'LOCATION',
              l_lud, l_lud, 'HZ_PARTY_SITES', l_parent_id, 'PARTY_SITE');

Line: 1561

      SELECT fr.LAST_UPDATE_DATE lud, fr.PARTY_ID parent_id, fr.FINANCIAL_REPORT_ID child_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG', null) bo_code
      FROM HZ_FINANCIAL_REPORTS fr, HZ_PARTIES p
      WHERE fr.FINANCIAL_REPORT_ID = P_FINANCIAL_REPORT_ID
      AND fr.party_id = p.party_id
      AND p.party_type = 'ORGANIZATION';

Line: 1574

    l_lud             DATE; -- used to store the child last update date

Line: 1603

        SELECT child_id, populated_flag INTO  l_child_rec_exists_no, l_pop_flag
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1612

            UPDATE HZ_BUS_OBJ_TRACKING
            SET populated_flag = 'N'
            WHERE event_id IS NULL
            AND CHILD_ENTITY_NAME = l_cen
            AND CHILD_ID = l_child_id;

Line: 1626

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_FINANCIAL_REPORTS', 'FIN_REPORT',
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);

Line: 1676

      SELECT fp.LAST_UPDATE_DATE lud, fp.PARTY_ID parent_id,
             fp.FINANCIAL_PROFILE_ID child_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
      FROM HZ_FINANCIAL_PROFILE fp, HZ_PARTIES p
      WHERE fp.FINANCIAL_PROFILE_ID = P_FINANCIAL_PROFILE_ID
      AND fp.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON');

Line: 1689

    l_lud             DATE; -- used to store the child last update date

Line: 1717

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1732

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_FINANCIAL_PROFILE', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);

Line: 1781

      SELECT fn.LAST_UPDATE_DATE lud, fn.FINANCIAL_REPORT_ID parent_id,
             fn.FINANCIAL_NUMBER_ID child_id, fr.party_id party_id
      FROM HZ_FINANCIAL_NUMBERS fn, HZ_FINANCIAL_REPORTS fr, HZ_PARTIES p
      WHERE fn.FINANCIAL_NUMBER_ID = P_FINANCIAL_NUMBER_ID
      AND fn.financial_report_id = fr.financial_report_id
      AND fr.party_id = p.party_id
      AND p.party_type = 'ORGANIZATION';

Line: 1793

    l_lud                     DATE; -- used to store the child last update date

Line: 1822

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1837

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_FINANCIAL_NUMBERS', NULL,
            l_lud, l_lud, 'HZ_FINANCIAL_REPORTS', l_parent_id, 'FIN_REPORT');

Line: 1895

      SELECT eh.LAST_UPDATE_DATE lud, eh.PARTY_ID parent_id,
             eh.EMPLOYMENT_HISTORY_ID child_id
      FROM HZ_EMPLOYMENT_HISTORY eh, HZ_PARTIES p
      WHERE eh.EMPLOYMENT_HISTORY_ID = P_EMPLOYMENT_HISTORY_ID
      AND eh.party_id = p.party_id
      AND p.party_type = 'PERSON';

Line: 1906

    l_lud             DATE; -- used to store the child last update date

Line: 1934

        SELECT child_id, populated_flag INTO  l_child_rec_exists_no, l_pop_flag
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = 'HZ_EMPLOYMENT_HISTORY'
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 1943

            UPDATE HZ_BUS_OBJ_TRACKING
            SET populated_flag = 'N'
            WHERE event_id IS NULL
            AND CHILD_ENTITY_NAME = l_cen
            AND CHILD_ID = l_child_id;

Line: 1957

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_EMPLOYMENT_HISTORY', 'EMP_HIST',
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');

Line: 2006

      SELECT edu.LAST_UPDATE_DATE lud, edu.PARTY_ID parent_id, edu.EDUCATION_ID child_id
      FROM HZ_EDUCATION edu, HZ_PARTIES p
      WHERE edu.EDUCATION_ID = P_EDUCATION_ID
      AND edu.party_id = p.party_id
      AND p.party_type = 'PERSON';

Line: 2016

    l_lud             DATE; -- used to store the child last update date

Line: 2043

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2058

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_EDUCATION', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');

Line: 2107

      SELECT casu.LAST_UPDATE_DATE lud, casu.CUST_ACCT_SITE_ID parent_id,
             casu.SITE_USE_ID child_id, cas.cust_account_id cust_acct_id
      FROM HZ_CUST_SITE_USES_ALL casu, HZ_CUST_ACCT_SITES_ALL cas
      WHERE casu.SITE_USE_ID = P_SITE_USE_ID
      AND casu.cust_acct_site_id = cas.cust_acct_site_id
      AND cas.cust_account_id > 0;

Line: 2118

    l_lud             DATE; -- used to store the child last update date

Line: 2147

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2163

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CUST_SITE_USES_ALL', 'CUST_ACCT_SITE_USE',
            l_lud, l_lud, 'HZ_CUST_ACCT_SITES_ALL', l_parent_id, 'CUST_ACCT_SITE');

Line: 2203

      SELECT cpa.LAST_UPDATE_DATE lud, cpa.CUST_ACCOUNT_PROFILE_ID parent_id,
             cpa.CUST_ACCT_PROFILE_AMT_ID child_id,
             nvl(cp.site_use_id, cp.cust_account_id) cp_parent_id,
             decode(cp.site_use_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') cp_parent_entity,
             decode(cp.site_use_id, null, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') cp_parent_bo
      FROM HZ_CUST_PROFILE_AMTS cpa, HZ_CUSTOMER_PROFILES cp
      WHERE cpa.CUST_ACCT_PROFILE_AMT_ID = P_CUST_ACCT_PROFILE_AMT_ID
      AND cpa.cust_account_profile_id = cp.cust_account_profile_id
      AND cp.cust_account_id > 0;

Line: 2217

    l_lud             DATE; -- used to store the child last update date

Line: 2250

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2265

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CUST_PROFILE_AMTS', NULL,
            l_lud, l_lud, 'HZ_CUSTOMER_PROFILES', l_parent_id, 'CUST_PROFILE');

Line: 2314

      SELECT cas.LAST_UPDATE_DATE lud, cas.CUST_ACCOUNT_ID parent_id, cas.CUST_ACCT_SITE_ID child_id,
             ca.party_id ca_parent_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) ca_parent_bo
      FROM HZ_CUST_ACCT_SITES_ALL cas, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
      WHERE cas.CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID
      AND cas.cust_account_id = ca.cust_account_id
      AND ca.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON')
      AND cas.cust_account_id > 0;

Line: 2328

    l_lud             DATE; -- used to store the child last update date

Line: 2360

        SELECT child_id, populated_flag INTO  l_child_rec_exists_no, l_pop_flag
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2369

            UPDATE HZ_BUS_OBJ_TRACKING
            SET populated_flag = 'N'
            WHERE event_id IS NULL
            AND CHILD_ENTITY_NAME = l_cen
            AND CHILD_ID = l_child_id;

Line: 2383

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CUST_ACCT_SITES_ALL', 'CUST_ACCT_SITE',
            l_lud, l_lud, 'HZ_CUST_ACCOUNTS', l_parent_id, 'CUST_ACCT');

Line: 2425

      SELECT car.LAST_UPDATE_DATE lud,
             car.cust_acct_relate_id child_id,
             car.cust_account_id cap_id,
             car.related_cust_account_id rcap_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL) pbo,
             decode(rel_p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL) rel_pbo,
             p.party_id pid, rel_p.party_id rel_pid
      FROM HZ_CUST_ACCT_RELATE_ALL car, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS rel_ca,
           HZ_PARTIES p, HZ_PARTIES rel_p
      WHERE car.cust_acct_relate_id = p_cust_acct_relate_id
      AND car.cust_account_id = ca.cust_account_id
      AND car.related_cust_account_id = rel_ca.cust_account_id
      AND ca.party_id = p.party_id
      AND rel_ca.party_id = rel_p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON')
      AND rel_p.party_type in ('ORGANIZATION', 'PERSON');

Line: 2445

    l_lud             DATE; -- used to store the child last update date

Line: 2483

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2498

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CUST_ACCT_RELATE_ALL', NULL,
            l_lud, l_lud, 'HZ_CUST_ACCOUNTS', l_cap_id, 'CUST_ACCT');

Line: 2521

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CUST_ACCT_RELATE_ALL', NULL,
            l_lud, l_lud, 'HZ_CUST_ACCOUNTS', l_rcap_id, 'CUST_ACCT');

Line: 2579

      SELECT car.LAST_UPDATE_DATE lud, car.CUST_ACCOUNT_ROLE_ID child_id,
             nvl(car.cust_acct_site_id, car.cust_account_id) parent_id,
             decode(car.cust_acct_site_id, null, 'CUST_ACCT', 'CUST_ACCT_SITE') parent_bo,
             decode(car.cust_acct_site_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_ACCT_SITES_ALL') parent_entity,
             ca.cust_account_id ca_id
      FROM HZ_CUST_ACCOUNT_ROLES car, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
      WHERE car.CUST_ACCOUNT_ROLE_ID = P_CUST_ACCOUNT_ROLE_ID
      AND car.cust_account_id = ca.cust_account_id
      AND ca.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON')
      AND car.cust_account_id > 0;

Line: 2597

    l_lud             DATE; -- used to store the child last update date

Line: 2627

        SELECT child_id, populated_flag INTO  l_child_rec_exists_no, l_pop_flag
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2636

            UPDATE HZ_BUS_OBJ_TRACKING
            SET populated_flag = 'N'
            WHERE event_id IS NULL
            AND CHILD_ENTITY_NAME = l_cen
            AND CHILD_ID = l_child_id;

Line: 2650

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CUST_ACCOUNT_ROLES', 'CUST_ACCT_CONTACT',
            l_lud, l_lud, l_parent_entity, l_parent_id, l_parent_bo);

Line: 2691

      SELECT ca.LAST_UPDATE_DATE lud, ca.PARTY_ID parent_id, ca.CUST_ACCOUNT_ID child_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL) bo_code
      FROM HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
      WHERE ca.CUST_ACCOUNT_ID = P_CUST_ACCOUNT_ID
      AND ca.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON')
      AND ca.cust_account_id > 0;

Line: 2704

    l_lud             DATE; -- used to store the child last update date

Line: 2733

        SELECT child_id, populated_flag INTO  l_child_rec_exists_no, l_pop_flag
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2742

            UPDATE HZ_BUS_OBJ_TRACKING
            SET populated_flag = 'N'
            WHERE event_id IS NULL
            AND CHILD_ENTITY_NAME = l_cen
            AND CHILD_ID = l_child_id;

Line: 2756

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
           'N', p_operation, l_child_id, 'HZ_CUST_ACCOUNTS', 'CUST_ACCT',
           l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);

Line: 2797

      SELECT cp.LAST_UPDATE_DATE lud,
             nvl(cp.site_use_id, cp.cust_account_id) parent_id,
             decode(cp.site_use_id, NULL, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') parent_entity,
             decode(cp.site_use_id, NULL, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') parent_bo,
             cp.CUST_ACCOUNT_PROFILE_ID child_id
      FROM HZ_CUSTOMER_PROFILES cp
      WHERE cp.CUST_ACCOUNT_PROFILE_ID = P_CUST_ACCOUNT_PROFILE_ID
      AND cp.cust_account_id > 0;

Line: 2812

    l_lud             DATE; -- used to store the child last update date

Line: 2845

        SELECT child_id, populated_flag INTO  l_child_rec_exists_no, l_pop_flag
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2854

            UPDATE HZ_BUS_OBJ_TRACKING
            SET populated_flag = 'N'
            WHERE event_id IS NULL
            AND CHILD_ENTITY_NAME = l_cen
            AND CHILD_ID = l_child_id;

Line: 2868

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CUSTOMER_PROFILES', 'CUST_PROFILE',
            l_lud, l_lud, l_parent_entity, l_parent_id, l_parent_bo);

Line: 2909

      SELECT cr.LAST_UPDATE_DATE lud, cr.PARTY_ID parent_id, cr.CREDIT_RATING_ID child_id
      FROM HZ_CREDIT_RATINGS cr, HZ_PARTIES p
      WHERE cr.CREDIT_RATING_ID = P_CREDIT_RATING_ID
      AND cr.party_id = p.party_id
      AND p.party_type = 'ORGANIZATION';

Line: 2919

    l_lud             DATE; -- used to store the child last update date

Line: 2946

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 2961

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CREDIT_RATINGS', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');

Line: 3018

      SELECT cpp.LAST_UPDATE_DATE lud, cpp.CONTACT_LEVEL_TABLE_ID parent_id,
             cpp.CONTACT_LEVEL_TABLE parent_tbl_name, cpp.CONTACT_PREFERENCE_ID child_id
      FROM HZ_CONTACT_PREFERENCES cpp
      WHERE cpp.CONTACT_PREFERENCE_ID = P_CONTACT_PREFERENCE_ID;

Line: 3024

      SELECT decode(contact_point_type, 'PHONE', 'PHONE', 'EMAIL', 'EMAIL', 'WEB', 'WEB', 'EFT', 'EFT', 'SMS', 'SMS', 'TLX', 'TLX', 'EDI', 'EDI', NULL), owner_table_name, owner_table_id
      FROM HZ_CONTACT_POINTS
      WHERE contact_point_id = p_parent_id
      AND contact_point_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EFT', 'EDI', 'SMS');

Line: 3030

      SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
             decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)
      FROM HZ_PARTIES
      WHERE party_id = p_parent_id
      AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');

Line: 3037

      SELECT oc.org_contact_id
      FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc
      WHERE r.relationship_id = oc.party_relationship_id
      AND r.subject_type = 'PERSON'
      AND r.object_type = 'ORGANIZATION'
      AND r.party_id = p_parent_id
      AND rownum = 1;

Line: 3054

    l_lud                     DATE; -- used to store the child last update date

Line: 3129

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 3144

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CONTACT_PREFERENCES', NULL,
            l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);

Line: 3202

      SELECT LAST_UPDATE_DATE lud, OWNER_TABLE_ID parent_id, CONTACT_POINT_ID child_id,
             OWNER_TABLE_NAME parent_entity, CONTACT_POINT_TYPE child_bo_code
      FROM HZ_CONTACT_POINTS
      WHERE CONTACT_POINT_ID = P_CONTACT_POINT_ID
      AND OWNER_TABLE_NAME in ('HZ_PARTY_SITES', 'HZ_PARTIES');

Line: 3210

      SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
             decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)
      FROM  HZ_PARTIES
      WHERE PARTY_ID = p_parent_id
      AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');

Line: 3217

      SELECT oc.org_contact_id
      FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc
      WHERE r.relationship_id = oc.party_relationship_id
      AND r.subject_type = 'PERSON'
      AND r.object_type = 'ORGANIZATION'
      AND r.party_id = p_parent_id
      AND rownum = 1;

Line: 3232

    l_lud                     DATE; -- used to store the child last update date

Line: 3305

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 3321

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CONTACT_POINTS', l_child_bo_code,
            l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);

Line: 3359

      SELECT pp.LAST_UPDATE_DATE lud,  pp.OWNER_TABLE_ID parent_id, pp.CODE_ASSIGNMENT_ID child_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
      FROM HZ_CODE_ASSIGNMENTS pp, HZ_PARTIES p
      WHERE pp.code_assignment_id = p_code_assignment_id
      AND pp.OWNER_TABLE_ID = p.party_id
      AND pp.OWNER_TABLE_NAME = 'HZ_PARTIES'
      AND p.party_type in ('ORGANIZATION', 'PERSON');

Line: 3371

    l_lud             DATE; -- used to store the child last update date

Line: 3400

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 3415

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CODE_ASSIGNMENTS', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);

Line: 3463

      SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.CITIZENSHIP_ID child_id
      FROM HZ_CITIZENSHIP c, HZ_PARTIES p
      WHERE c.CITIZENSHIP_ID = P_CITIZENSHIP_ID
      AND c.party_id = p.party_id
      AND p.party_type = 'PERSON';

Line: 3473

    l_lud             DATE; -- used to store the child last update date

Line: 3500

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 3515

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CITIZENSHIP', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');

Line: 3564

      SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.CERTIFICATION_ID child_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
      FROM HZ_CERTIFICATIONS c, HZ_PARTIES p
      WHERE c.CERTIFICATION_ID = P_CERTIFICATION_ID
      AND c.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON');

Line: 3576

    l_lud             DATE; -- used to store the child last update date

Line: 3603

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 3618

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_CERTIFICATIONS', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);

Line: 3668

      SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.PARTY_USG_ASSIGNMENT_ID child_id,
             decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
      FROM HZ_PARTY_USG_ASSIGNMENTS c, HZ_PARTIES p
      WHERE c.PARTY_USG_ASSIGNMENT_ID = P_PARTY_USG_ASSIGNMENT_ID
      AND c.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON');

Line: 3680

    l_lud             DATE; -- used to store the child last update date

Line: 3707

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 3722

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'HZ_PARTY_USG_ASSIGNMENTS', NULL,
            l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);

Line: 3773

      SELECT c.LAST_UPDATE_DATE lud, p.PARTY_ID parent_id, c.extension_id child_id, 'ORG' bo_code, 'HZ_PARTIES' parent_entity
      FROM HZ_ORG_PROFILES_EXT_B c, HZ_ORGANIZATION_PROFILES p
      WHERE c.EXTENSION_ID = P_EXTENSION_ID
      AND c.ORGANIZATION_PROFILE_ID = p.ORGANIZATION_PROFILE_ID
      AND rownum = 1;

Line: 3780

      SELECT c.LAST_UPDATE_DATE lud, p.PARTY_ID parent_id, c.extension_id child_id, 'PERSON' bo_code, 'HZ_PARTIES' parent_entity
      FROM HZ_PER_PROFILES_EXT_B c, HZ_PERSON_PROFILES p
      WHERE c.EXTENSION_ID = P_EXTENSION_ID
      AND c.PERSON_PROFILE_ID = p.PERSON_PROFILE_ID
      AND rownum = 1;

Line: 3787

      SELECT c.LAST_UPDATE_DATE lud, c.LOCATION_ID parent_id, c.extension_id child_id, 'LOCATION' bo_code, 'HZ_LOCATIONS' parent_entity
      FROM HZ_LOCATIONS_EXT_B c
      WHERE c.EXTENSION_ID = P_EXTENSION_ID
      AND rownum = 1;

Line: 3793

      SELECT c.LAST_UPDATE_DATE lud, c.PARTY_SITE_ID parent_id, c.extension_id child_id, 'PARTY_SITE' bo_code, 'HZ_PARTY_SITES' parent_entity
      FROM HZ_PARTY_SITES_EXT_B c
      WHERE c.EXTENSION_ID = P_EXTENSION_ID
      AND rownum = 1;

Line: 3805

    l_lud             DATE; -- used to store the child last update date

Line: 3849

      SELECT child_id INTO  l_child_rec_exists_no
      FROM  HZ_BUS_OBJ_TRACKING
      WHERE event_id IS NULL
      AND CHILD_ENTITY_NAME = l_child_entity
      AND CHILD_ID = l_child_id
      AND rownum = 1;

Line: 3864

        INSERT INTO HZ_BUS_OBJ_TRACKING
        ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
          LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
        ) VALUES (
          'N', p_operation, l_child_id, l_child_entity, NULL,
          l_lud, l_lud, l_parent_entity, l_parent_id, l_bo_code);

Line: 3914

      SELECT rcrm.last_update_date lud, rcrm.cust_receipt_method_id child_id,
             nvl(rcrm.site_use_id, rcrm.customer_id) parent_id,
             decode(rcrm.site_use_id, NULL, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') parent_tbl_name,
             decode(rcrm.site_use_id, NULL, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') parent_bo_code,
             decode(rcrm.site_use_id, NULL, p.party_id, rcrm.customer_id) grand_parent_id,
             decode(rcrm.site_use_id, NULL, 'HZ_PARTIES', 'HZ_CUST_ACCOUNTS') grand_parent_tbl_name,
             decode(rcrm.site_use_id, NULL, decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL), 'CUST_ACCT') grand_parent_bo_code
      FROM RA_CUST_RECEIPT_METHODS rcrm, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
      WHERE rcrm.cust_receipt_method_id = p_cust_receipt_method_id
      AND rcrm.customer_id = ca.cust_account_id
      AND ca.party_id = p.party_id
      AND p.party_type in ('ORGANIZATION', 'PERSON')
      AND rcrm.customer_id > 0;

Line: 3933

    l_lud                     DATE; -- used to store the child last update date

Line: 3969

        SELECT child_id INTO  l_child_rec_exists_no
        FROM  HZ_BUS_OBJ_TRACKING
        WHERE event_id IS NULL
        AND CHILD_ENTITY_NAME = l_cen
        AND CHILD_ID = l_child_id
        AND rownum = 1;

Line: 3984

          INSERT INTO HZ_BUS_OBJ_TRACKING
          ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
            LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
          ) VALUES (
            'N', p_operation, l_child_id, 'RA_CUST_RECEIPT_METHODS', NULL,
            l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_parent_bo_code);

Line: 4016

    SELECT p.party_type, p.party_id
    FROM HZ_PARTY_SITES ps, HZ_PARTIES p
    WHERE ps.party_site_id = p_party_site_id
    AND ps.party_id = p.party_id
    AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');

Line: 4023

    SELECT 1
    FROM HZ_PARTIES p, HZ_RELATIONSHIPS r
    WHERE p.party_id = l_party_id
    AND p.party_id = r.party_id
    AND r.subject_type = 'PERSON'
    AND r.object_type = 'ORGANIZATION'
    AND rownum = 1;