APPS.PA_CI_MERGE_PKG SQL Statements

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

Line: 19

    UPDATE pa_control_items
    SET owner_id = p_to_fk_id
    WHERE owner_id = p_from_fk_id;

Line: 43

    UPDATE pa_control_items
    SET last_modified_by_id = p_to_fk_id
    WHERE last_modified_by_id = p_from_fk_id;

Line: 67

    UPDATE pa_control_items
    SET closed_by_id = p_to_fk_id
    WHERE closed_by_id = p_from_fk_id;

Line: 91

    UPDATE pa_ci_actions
    SET assigned_to = p_to_fk_id
    WHERE assigned_to = p_from_fk_id;

Line: 115

    UPDATE pa_ci_impacts
    SET implemented_by = p_to_fk_id
    WHERE implemented_by = p_from_fk_id;

Line: 139

    SELECT project_party_id,
           object_id,
           object_type,
           project_role_id,
           start_date_active,
           end_date_active
    FROM pa_project_parties
    WHERE resource_source_id=p_from_fk_id
      AND resource_type_id=112;

Line: 157

      SELECT 1
      INTO l_dummy
      FROM fnd_grants g, fnd_objects o
      WHERE o.application_id = 275
        AND g.object_id = o.object_id
        AND g.grantee_type = 'USER'
        AND g.grantee_key = 'HZ_PARTY:'||p_from_fk_id
        AND ROWNUM = 1;

Line: 174

        SELECT party_type
        INTO l_party_type
        FROM hz_parties
        WHERE party_id = p_to_fk_id;

Line: 184

              SELECT project_party_id
              INTO l_dummy
              FROM pa_project_parties
              WHERE object_id = cp_party.object_id
                AND object_type = cp_party.object_type
                AND project_role_id = cp_party.project_role_id
                AND resource_type_id = 112
                AND resource_source_id = p_to_fk_id
                AND ROWNUM = 1;

Line: 195

              UPDATE pa_project_customers
              SET project_party_id = l_dummy
              WHERE project_party_id = cp_party.project_party_id;

Line: 199

              DELETE FROM pa_project_parties
              WHERE project_party_id = cp_party.project_party_id;

Line: 205

                UPDATE pa_project_parties
                SET resource_source_id = p_to_fk_id
                WHERE project_party_id = cp_party.project_party_id;

Line: 213

          UPDATE pa_project_parties
          SET resource_source_id = p_to_fk_id
          WHERE resource_type_id = 112
            AND resource_source_id = p_from_fk_id;

Line: 224

PROCEDURE update_project_parties_res_id(
  p_from_resource_id IN NUMBER,
  p_to_resource_id IN NUMBER,
  x_return_status OUT NOCOPY VARCHAR2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 233

    UPDATE pa_project_parties
    SET resource_id = p_to_resource_id
    WHERE resource_id = p_from_resource_id;

Line: 237

END update_project_parties_res_id;