APPS.CSM_PARTY_DOWNLOAD_PUB SQL Statements

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

Line: 26

      SELECT au.owner_id
      FROM   asg_user au
      WHERE  au.user_id = p_user_id
      AND    au.enabled = 'Y';

Line: 62

  IF p_operation = 'INSERT'

  THEN

    --calling the package to insert records into CSM_PARTY_ASSIGNMENT table

    csm_party_assignment_pkg.insert_party_assg
      ( P_USER_ID           => p_user_id,
        P_PARTY_ID          => p_party_id,
        P_OWNER_ID          => l_owner_id,
        P_PARTY_SITE_ID     => l_party_site_id,
        X_RETURN_STATUS     => l_return_status,
        X_ERROR_MESSAGE     => l_error_message);

Line: 76

  ELSIF p_operation = 'DELETE'

  THEN

    --calling the package to delete records from CSM_PARTY_ASSIGNMENT table

    csm_party_assignment_pkg.delete_party_assg
      ( P_USER_ID           => p_user_id,
        P_PARTY_ID          => p_party_id,
        P_OWNER_ID          => l_owner_id,
        P_PARTY_SITE_ID     => l_party_site_id,
        X_RETURN_STATUS     => l_return_status,
        X_ERROR_MESSAGE     => l_error_message);

Line: 179

     SELECT au.owner_id
     FROM   asg_user au
     WHERE  au.user_id = p_user_id
     AND    au.enabled = 'Y';

Line: 200

    l_party_id_tbl.DELETE;

Line: 208

    l_user_id_tbl.DELETE;

Line: 243

  IF p_operation = 'INSERT'

  THEN

    --calling the package to insert records into CSM_PARTY_ASSIGNMENT table

    csm_party_assignment_pkg.insert_party_assg
      ( P_USER_ID           => l_user_id,
        P_PARTY_ID          => l_party_id,
        P_OWNER_ID          => l_owner_id,
        P_PARTY_SITE_ID     => l_party_site_id,
        X_RETURN_STATUS     => l_return_status,
        X_ERROR_MESSAGE     => l_error_message);

Line: 257

  ELSIF p_operation = 'DELETE'

  THEN

    --calling the package to delete records from CSM_PARTY_ASSIGNMENT table

    csm_party_assignment_pkg.delete_party_assg
      ( P_USER_ID           => l_user_id,
        P_PARTY_ID          => l_party_id,
        P_OWNER_ID          => l_owner_id,
        P_PARTY_SITE_ID     => l_party_site_id,
        X_RETURN_STATUS     => l_return_status,
        X_ERROR_MESSAGE     => l_error_message);

Line: 362

    SELECT au.owner_id
    FROM   asg_user au
    WHERE  au.user_id = p_user_id
    AND    au.enabled = 'Y';

Line: 398

  IF p_operation = 'INSERT'

  THEN

    --calling the package to insert records into CSM_PARTY_ASSIGNMENT table

    csm_party_assignment_pkg.insert_party_assg
      ( P_USER_ID           => p_user_id,
        P_PARTY_ID          => p_party_id,
        P_OWNER_ID          => l_owner_id,
        P_PARTY_SITE_ID     => p_location_id,
        X_RETURN_STATUS     => l_return_status,
        X_ERROR_MESSAGE     => l_error_message);

Line: 412

  ELSIF p_operation = 'DELETE'

  THEN

    --calling the package to delete records from CSM_PARTY_ASSIGNMENT table

    csm_party_assignment_pkg.delete_party_assg
      ( P_USER_ID           => p_user_id,
        P_PARTY_ID          => p_party_id,
        P_OWNER_ID          => l_owner_id,
        P_PARTY_SITE_ID     => p_location_id,
        X_RETURN_STATUS     => l_return_status,
        X_ERROR_MESSAGE     => l_error_message);

Line: 518

    SELECT au.owner_id
    FROM   asg_user au
    WHERE  au.user_id = p_user_id
    AND    au.enabled = 'Y';

Line: 539

    l_party_site_id_tbl.DELETE;

Line: 547

    l_user_id_tbl.DELETE;

Line: 584

  IF p_operation = 'INSERT'

  THEN

    --calling the package to insert records into CSM_PARTY_ASSIGNMENT table

    csm_party_assignment_pkg.insert_party_assg
      ( P_USER_ID           => l_user_id,
        P_PARTY_ID          => l_party_id,
        P_OWNER_ID          => l_owner_id,
        P_PARTY_SITE_ID     => l_party_site_id,
        X_RETURN_STATUS     => l_return_status,
        X_ERROR_MESSAGE     => l_error_message);

Line: 598

  ELSIF p_operation = 'DELETE'

  THEN

    --calling the package to delete records from CSM_PARTY_ASSIGNMENT table

    csm_party_assignment_pkg.delete_party_assg
      ( P_USER_ID           => l_user_id,
        P_PARTY_ID          => l_party_id,
        P_OWNER_ID          => l_owner_id,
        P_PARTY_SITE_ID     => l_party_site_id,
        X_RETURN_STATUS     => l_return_status,
        X_ERROR_MESSAGE     => l_error_message);

Line: 703

    SELECT cpa.party_id
    FROM   csm_party_assignment cpa
    WHERE  cpa.user_id = p_user_id
    AND    cpa.party_site_id in (-1,-2)
    AND    cpa.deleted_flag = 'N';

Line: 727

  l_party_id_tbl.DELETE;

Line: 821

    SELECT cpa.party_site_id
    FROM   csm_party_assignment cpa
    WHERE  cpa.user_id  = p_user_id
    AND    cpa.party_id = p_party_id
    AND    cpa.party_site_id not in (-1,-2)
    AND    cpa.deleted_flag = 'N';

Line: 846

    l_party_site_id_tbl.DELETE;